| ←Prev date Next date→ Show only urls | (Click on time to select a line by its url) |
| Who | What | When |
|---|---|---|
| *** | MartinCleaver has quit IRC (Success) | [00:10] |
| .......... (idle for 45mn) | ||
| MartinCleaver has joined #tikiwiki | [00:55] | |
| SEWilco2 has joined #tikiwiki | [01:04] | |
| ..... (idle for 24mn) | ||
| mikew_ has joined #tikiwiki
mikew_ is now known as Guest59027 | [01:28] | |
| Guest59027 | oops. lost my nic
hello I was updating from 2.1 to 3.2 but I didn't get the lock file in updating from 2.4 to 3.2 nor can I run tiki-install.php ok. i see the install disable file. I'll try again | [01:29] |
| still not running | [01:47] | |
| *** | Guest59027 has quit IRC ("Page closed")
mike has joined #tikiwiki | [01:52] |
| mike | hi | [01:53] |
| *** | mike is now known as Guest58832 | [01:53] |
| Guest58832 | >help | [01:56] |
| Sug4r` | (help [<plugin>] [<command>]) -- This command gives a useful description of what <command> does. <plugin> is only necessary if the command is in more than one plugin. | [01:56] |
| Guest58832 | help update | [01:56] |
| Tikiwiki|bot | Welcome to the official Tikiwiki English Irc Channel. TikiWiki or better known as TW, is your Groupware/CMS (Content Management System) solution, you can get more infomation at http://info.tikiwiki.org/ . | [01:56] |
| Guest58832 | i'm the one with the update problem | [01:58] |
| .... (idle for 16mn) | ||
| does it matter when i deleted the outdated theme files? | [02:14] | |
| it looks like i get a zend optimizer error when calling up the code | [02:20] | |
| ........ (idle for 37mn) | ||
| ok. the webhost helped me. the problem was in my file permissions. | [02:57] | |
| luciash | Guest58832: sorry, wasn't here... good you figured out | [03:00] |
| CIA-75 | tikiwiki: 03chealer * r22096 10/trunk/templates/tiki-admin_categories.tpl:
tikiwiki: [FIX] HTML special chars escaping tikiwiki: [FIX] colons inside tr blocks tikiwiki: [FIX] Directory categorization | [03:14] |
| *** | MartinCleaver has quit IRC () | [03:15] |
| CIA-75 | tikiwiki: 03chealer * r22097 10/trunk/ (2 files in 2 dirs):
tikiwiki: [FIX] HTML special chars encoding tikiwiki: remove template comment (assuming that's a leftover from copy-paste) | [03:15] |
| *** | MartinCleaver has joined #tikiwiki | [03:16] |
| Guest58832 | i got the zip file for the 3.2 version. The useful file permissions must not have been preserved in all that i did.
i was running ver 2.1 since 2007 and then saw I needed to make sure I was able to run on php5 | [03:16] |
| ..... (idle for 21mn) | ||
| *** | MartinCleaver has quit IRC (Read error: 110 (Connection timed out)) | [03:40] |
| .... (idle for 15mn) | ||
| franck has quit IRC () | [03:55] | |
| Guest58832 | now I think I have a themes problem. The sidebar is below the wiki content -- instead of at the side | [03:58] |
| *** | franck has joined #tikiwiki
franck has quit IRC (Client Quit) | [03:59] |
| Caarrie is now known as Caarrie|sleeping
franck has joined #tikiwiki | [04:07] | |
| SEWilco2 has quit IRC ("Leaving.") | [04:16] | |
| ........ (idle for 37mn) | ||
| chibaguy has joined #tikiwiki | [04:53] | |
| Guest58832 | k. I just am forcing the thenews theme to the admin account | [04:53] |
| chibaguy | polom | [04:53] |
| Guest58832 | hi | [04:54] |
| chibaguy | Guest58832, did you update from an earlier version of Tiki? | [04:54] |
| Guest58832 | yes. I had 2.1 | [04:54] |
| chibaguy | See http://doc.tikiwiki.org/Upgrade+2.x+to+3.x . Step 5 talks about themes. | [04:56] |
| Guest58832 | yes. I have it working now | [04:56] |
| chibaguy | columns are all in the right place, etc.? | [04:57] |
| Guest58832 | yes | [04:57] |
| chibaguy | ok
on another topic, it seems file gallery permissions are screwed up in Tiki 3. There've been user reports in the tw.o forum about this so I did a test. | [04:57] |
| Guest58832 | are you new to ver 3?
or a gurur? | [04:59] |
| chibaguy | No, I work on the project.
maybe a gurur, not a guru yet tho. ;-) | [04:59] |
| Guest58832 | haha
i mainly only used the wiki since 2007 i loaded this originally with fantastico setup scripts | [05:00] |
| chibaguy | well, the file gallery uploads (for 'private' galleries) worked fine before, but perms, etc. have been worked on a lot, and now seem kinda broken in places. | [05:02] |
| Guest58832 | which, for updates, would mess up add-ins and optional features | [05:02] |
| chibaguy | I've always installed and updated with ftp, so am not very familiar with the fantastico route. | [05:03] |
| Guest58832 | It helped me get started. Now i just did ftp | [05:04] |
| chibaguy | Well, in the file gallery, the user's group has the right permissions, and the user sees the upload-file button, but clicking on it brings a "Permission denied" error - a nasty shock. | [05:06] |
| Guest58832 | Is it easy to figure out a fix? | [05:08] |
| chibaguy | For one of our php gurus, yes, I hope. :-) | [05:09] |
| Guest58832 | what speicialty to you contribute on the project? | [05:10] |
| chibaguy | mainly themes | [05:12] |
| Guest58832 | so you have made some tiki 3 themes? | [05:16] |
| chibaguy | yes, pretty much all that are available.
Strasa and Coelesce were designed by someone else, and the other bundled themes in tiki 3 have been worked on collaboratively. | [05:17] |
| Guest58832 | ah. i see. thanks | [05:18] |
| tikiwiki has worked out pretty nicely for content for my site. I like the document structures/outline feature -- as distinct from other wiki and group software | [05:24] | |
| *** | chibaguytoo has joined #tikiwiki | [05:24] |
| chibaguytoo | that's good. | [05:25] |
| Guest58832 | uh oh. that feature may be a plugin | [05:26] |
| chibaguytoo | what feature?
structures? | [05:29] |
| Guest58832 | where I could navigate based on a structure or outline | [05:29] |
| chibaguytoo | structures is a standard feature, but in tiki 3 it needs to be turned on, on the admin wiki page. before, it was on by default. | [05:30] |
| Guest58832 | good. i'm a bit in panic mode until I find out if everything works | [05:32] |
| chibaguytoo | :-) | [05:34] |
| Guest58832 | there are no features options listed for wiki
nvm. it wasn't expanded | [05:39] |
| *** | chibaguy has quit IRC (Read error: 110 (Connection timed out))
Guest58832 has quit IRC ("Page closed") | [05:42] |
| chibaguytoo is now known as chibaguy | [05:52] | |
| ........... (idle for 53mn) | ||
| c_schmitz has quit IRC (Nick collision from services.)
c_schmitz has joined #tikiwiki | [06:45] | |
| ..... (idle for 23mn) | ||
| luciash | polompolom | [07:08] |
| *** | Wilkins has joined #tikiwiki | [07:16] |
| ....... (idle for 32mn) | ||
| chealer | half-polom | [07:48] |
| .... (idle for 17mn) | ||
| CIA-75 | tikiwiki: 03chealer * r22098 10/trunk/lib/tikilib.php:
tikiwiki: [FIX] rollback r21822: tikiwiki: [MOD] please refer to dev note 1.1 http://doc.tikiwiki.org/Tiki4#Anonymous_group_not_included_by_default_in_Registered_ tikiwiki: This broke permissions on most sites upgraded. See discussion at http://sourceforge.net/mailarchive/forum.php?thread_name=4ACCFC4E.5000205%40gmail.com&forum_name=tikiwiki-devel | [08:05] |
| ........... (idle for 52mn) | ||
| *** | kiilo has joined #tikiwiki
kiilo has quit IRC (Client Quit) kiilo has joined #tikiwiki | [08:57] |
| CIA-75 | tikiwiki: 03chealer * r22099 10/trunk/tests/upgrade_categperm.php: upgrade_categperm.php: rename tiki_p_view_categories to tiki_p_view_category in global permissions | [09:06] |
| ..................... (idle for 1h44mn) | ||
| *** | kiilo1 has joined #tikiwiki | [10:50] |
| .... (idle for 15mn) | ||
| Caarrie|sleeping is now known as Caarrie
kiilo has quit IRC (Read error: 110 (Connection timed out)) | [11:05] | |
| chealer | luciash: you must be right in your last mail, I think both me and redflo were confused by Stéphane's mail | [11:12] |
| .... (idle for 15mn) | ||
| *** | c_schmitz has quit IRC (Read error: 110 (Connection timed out)) | [11:27] |
| luciash | chealer: no prob :) | [11:41] |
| *** | kiilo1 has quit IRC ("Leaving.") | [11:41] |
| chibaguy | on tiki-calendar, when it says "October" at the top, why do the days say "10/08", "10/09" etc.? It looks cluttered with that redundant month indicator on every day. | [11:44] |
| *** | kiilo has joined #tikiwiki | [11:44] |
| chibaguy | Other calendars don't have this complication, afaik. | [11:44] |
| not a big problem, but maybe can be improved later on | [11:49] | |
| ..... (idle for 24mn) | ||
| *** | grobda24 has joined #tikiwiki | [12:13] |
| grobda24 | grobda24 says hi
Is it possible to have articles on the main page but add a custom html section that only appears on the front page (above articles) ? | [12:13] |
| chibaguy | In trunk/tiki4 it's easy, with new custom center column header box :-)
Maybe in tiki 3, you need to edit the articles template. Or you can use the shadow divs feature, come to think of it. | [12:18] |
| grobda24 | ah, interesting :)
template or, shadow divs ... is that a plugin ? | [12:20] |
| chibaguy | it's a look and feel admin feature, courtesy of luciash :-)
when you activate it, new div tags are added in tiki.tpl. | [12:22] |
| grobda24 | k | [12:23] |
| chibaguy | and a textarea for each, on admin look and feel.
you can add your html (i think it's ok) in the one for centercolumn top | [12:24] |
| grobda24 | is it the "shadow layer" ? | [12:27] |
| chibaguy | if you use articles as your front page. but if you use a wiki page and the articles plugin below, you can add the html (or wiki syntax equivalent) at the page top.
yeah, shadow layer. | [12:27] |
| grobda24 | k
I looked at the articles plugin but it only seems to list titles on a wiki page, I don't think it reproduces the articles front page chibaguy, yeah that's it. Nice, thanks. See "Fred" here http://mindfreedom.org.uk/ | [12:27] |
| chibaguy | ok, but fred turns up on other pages, too. Is that ok?
hmm, what's the filter for limiting scope to one file? | [12:32] |
| grobda24 | ah
it might be the template then | [12:33] |
| *** | luminoso has quit IRC (Read error: 54 (Connection reset by peer))
luminoso has joined #tikiwiki | [12:33] |
| chibaguy | {if $smarty.server.SCRIPT_NAME eq 'tiki-view_articles.php}Fred{/if}
er.. ...php'} | [12:37] |
| grobda24 | testing
was that for the shadow layer box ? it just shows the code ... http://mindfreedom.org.uk/ ah, duh ... it's Plugin Articles that I need. Thanks for the help ! | [12:38] |
| chibaguy | ok. | [12:55] |
| .... (idle for 16mn) | ||
| I wonder how people would feel if those bright blue icons for previous, next, module open|close, etc., were changed to a more neutral gray.... | [13:11] | |
| *** | goj has quit IRC ("enough idleing") | [13:12] |
| CIA-75 | tikiwiki: 03jonnybradley * r22100 10/trunk/ (3 files in 2 dirs):
tikiwiki: [ENH] Added rudimentary colour pickers and new background colour icon. tikiwiki: Also JS fixes for Firefox/AJAX | [13:24] |
| *** | Caarrie is now known as Caarrie|away | [13:24] |
| ...... (idle for 26mn) | ||
| gezza has joined #tikiwiki | [13:50] | |
| sylvieg | chibaguy: +1 | [13:54] |
| chibaguy | really?
I mean, I wasn't sure if people would like that. | [13:55] |
| gezza | hi guys! i would need some tips for something I am doing on the community site. What i did: i want to list categories on many pages, however I want to avoid that when I change something in the plugin I have to update all pages. So I made a module for it, that include this: {CATEGORY(id="22",split="y",and="n")}{CATEGORY}. Now when I preview in modules, it is fine, displays the category items. | [13:56] |
| chibaguy | bbl | [13:56] |
| gezza | When I use the MODULES plugin in the page it does not display anything. I read here http://doc.tikiwiki.org/PluginModule that "Note: This plugin works only with the basic modules, not with the user modules."
can someone tell me what is the bottleneck? why is it not displaying? | [13:56] |
| *** | chibaguy has quit IRC (Read error: 104 (Connection reset by peer)) | [13:57] |
| jonnyb has joined #tikiwiki | [14:04] | |
| CIA-75 | tikiwiki: 03jonnybradley * r22101 10/trunk/ (3 files in 3 dirs):
tikiwiki: [MOD] Remove hard coded inclusion of Anonymous group in Registered (again - see r21822 and r22098). tikiwiki: Added schema script to preserve existing behaviour and changed tikilib and objectperms. tikiwiki: Other files need fixing (modlib, wikiplugin_group, userslib, tiki-emulate_groups_switch and mod-func-groups_emulation - possibly others) tikiwiki: Profiles that assumed this inclusion will also need amending. | [14:06] |
| *** | danopia has quit IRC (Connection timed out) | [14:07] |
| rodrigo_sampaio has joined #tikiwiki | [14:17] | |
| CIA-75 | tikiwiki: 03Jyhem * r22102 10/trunk/tiki-emulate_groups_switch.php: [MOD] Part of removal of hard coded inclusion of Anonymous group in Registered (see 22101) | [14:18] |
| .... (idle for 15mn) | ||
| *** | chibaguy has joined #tikiwiki
MacLeod has joined #tikiwiki | [14:33] |
| ..... (idle for 20mn) | ||
| CIA-75 | tikiwiki: 03Jyhem * r22103 10/trunk/modules/mod-func-groups_emulation.php: [MOD] Part of removal of hard coded inclusion of Anonymous group in Registered (see 22101) | [14:53] |
| .... (idle for 15mn) | ||
| *** | Caarrie|away is now known as Caarrie | [15:08] |
| luciash | gezza: i don't get the note... it should work with every MODULE
at least it worked some weeks ago in 3.x | [15:10] |
| chibaguy: re the module icons: 1. they need to be fixed to reflect what you can do on USer Modules page to move them... 2. you could re-use the icons i used for Simple theme back in time if you dig them out | [15:15] | |
| *** | Yenzelle has joined #tikiwiki
SEWilco2 has joined #tikiwiki | [15:16] |
| luciash | chibaguy: (actually i draw them from scratch) | [15:17] |
| *** | Yenzelle has quit IRC (Client Quit) | [15:18] |
| clemente has joined #tikiwiki | [15:24] | |
| chibaguy | luciash, do you mean the "configure modules" icons?
I was just talking about the open|close icons. So far I just took the color out of the current icons (reduced saturation to zero). Also the previous, next, first, etc. last pagination arrows. which are also that blue color. Well, I was finishing up a theme called "Mollio" which is red and white, and the blue icons just didn't fit. (See http://zukakakina.com/tw4/ for what the gray icons look like.) | [15:28] |
| CIA-75 | tikiwiki: 03Jyhem * r22104 10/trunk/lib/userslib.php: [MOD] Part of removal of hard coded inclusion of Anonymous group in Registered (see 22101) | [15:31] |
| SEWilco2 | Sometimes one does want a red, white, and blue theme. :-) | [15:32] |
| chibaguy | :-) true | [15:33] |
| CIA-75 | tikiwiki: 03mangapower * r22105 10/trunk/tiki-editpage.php: [MOD] If a WS is active and a new wikipage is created, then this page will be stored in the WS | [15:34] |
| chibaguy | that's a significant commit ^^ | [15:36] |
| gezza | luciash: thanks, seems like the note is true, it was added by sylvie according to the page history
luciash: example: http://tikiwiki.org/tiki-index.php?page=LanguageHungarian On right side I added 'i18n content" which is supposed to show the content of a category for which i created "category_item_list_i18n" module that you can find among the modules chibaguy: wow, this mollio theme is really nice congrats | [15:44] |
| chibaguy | thanks, gezza. a lot of credit goes to the original designers (http://mollio.org)
but it was fun and a challenge to implement the design for tiki. | [15:50] |
| *** | Wilkins has quit IRC (Remote closed the connection) | [15:52] |
| gezza | good idea to make icon for the show/hide columns and put the test to pop-up
text I mean hehe, seems like it is the same for other themes, great | [15:53] |
| chibaguy | well, mollio will be available soon, before tiki 4 is out, actually. | [15:56] |
| CIA-75 | tikiwiki: 03nkoth * r22106 10/trunk/lib/tikilib.php: [FIX] Wiki page links in menus should support best language | [16:10] |
| MacLeod | Upgrading from v2.0 to v3.1 appears to have broken the FCK image upload function. "Browse server" results in "Error creating folder..." | [16:11] |
| *** | c_schmitz has joined #tikiwiki | [16:15] |
| chibaguy | hmm, anonymous still can't change themes in trunk. | [16:18] |
| *** | kiilo has quit IRC ("Leaving.") | [16:23] |
| .... (idle for 15mn) | ||
| Tikiwiki|bot | New Forum Posts: Reason for posting to a blog depends on created own blog before? - http://tikiwiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=34880 | [16:38] |
| *** | iannhigginson has joined #tikiwiki | [16:42] |
| chealer | chibaguy: are you doing something with this? did you open a bug report? | [16:44] |
| CIA-75 | tikiwiki: 03nkoth * r22107 10/trunk/lib/ (tikilib.php wiki/wikilib.php): [FIX] best lang suffix will have to depend on whether query string exists or not (it used to be always exist, but with SEFURL it can't be certain | [16:44] |
| chibaguy | chealer, no, I didn't. I'll do that now. | [16:49] |
| iannhigginson | Hello. I am having trouble updating wiki pages. when I press the save button it dose not save the content and the MySQL field data is empty. Sometimes it makes duplicates of the content. How would I fix this please? | [16:55] |
| chibaguy | iannhigginson, what tiki version is that? | [16:59] |
| Kissaki | polom | [17:01] |
| *** | rodrigo_sampaio has quit IRC ("Leaving.") | [17:01] |
| iannhigginson | tiki 3.2 | [17:15] |
| chibaguy | are you using the normal editor or the wysiwyg editor? | [17:19] |
| iannhigginson | wysiwyg | [17:22] |
| chealer | iannhigginson: does that happen with experimental features off and several usersT? | [17:26] |
| luciash | chibaguy: yep, these icons i meant
gezza: but i have created custom module and assigned with no problem via MODULE plugin, weird | [17:27] |
| Tikiwiki|bot | New Forum Posts: Create and use Wiki Page Variables - http://tikiwiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=34882
New Forum Posts: How can I link to a URL without using an anchor? - http://tikiwiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=34881 | [17:30] |
| gezza | luciash: assignment is no problem and even the Name of the module appears but not the content. When I assign it says plugin pending apporval, when I review before approving it says "the body of this plugin is empty" | [17:30] |
| iannhigginson | the site is http://www.calypsoushaka.co.za some experimental featurs are on Ajax HTML purifier Mobil Intertiki Search engine friendly url Webmail Mail-in Wysiwyg editor Drawings Friendship Network | [17:31] |
| gezza | what kind of module did you create? maybe it is category listing specific..i have ticked in "must be wiki parsed"
iannhigginson: it is the ajax, switch it off i had duplication before too, it helped me | [17:31] |
| iannhigginson | Thank you | [17:32] |
| luciash | gezza: i created custom module containing {tabs}One|Two|Three{/tabs}... | [17:32] |
| gezza | hope it helps | [17:32] |
| chibaguy | yeah, luciash, the configure-module icons haven't worked for a long time. I was only thinking about the open-close module icons. anyway, time to sleep. bbl. | [17:32] |
| *** | chibaguy has quit IRC (Read error: 104 (Connection reset by peer)) | [17:33] |
| luciash | gezza: maybe it doesn't work with plugins inside which need plugin approval ? | [17:33] |
| iannhigginson | Ajax disabled | [17:33] |
| gezza | luciash: maybe, but why does it need approval
? | [17:33] |
| luciash | maybe it can be changed
gezza: i mean why you put plugin CATEGORY in plugin MODULE ? gezza: why not directly in wiki page ? the CATEGORY plugin | [17:34] |
| chealer | Kissaki: what redflo was pointing out is that the single quote (and it's the same with double quotes) is more problematic than backticks in PHP due to the conflict with PHP string delimiters. as he wrote, that of course doesn't prevent a change, it just explains why backticks were used. | [17:37] |
| gezza | luciash: i want to create a generic thing for all translation related pages. it might change over the time, i dont want to update all pages manually | [17:38] |
| luciash | ok, then you can create Plugin Alias | [17:38] |
| gezza | but maybe I want to add some links or text too | [17:39] |
| luciash | and put just {I18N()}{/I18N}
you can edit all that on Plugin Alias Admin page | [17:39] |
| Kissaki | chealer: whos redflo | [17:39] |
| chealer | Kissaki: Florian Gleixner | [17:40] |
| gezza | luciash: can I also add other stuff like static text, links, etc to a plugin alias or it can contain only plugin parameters? | [17:40] |
| Kissaki | well, he was pointing out that mysql reserved words were an issue, not what you said, right?
ah, you're right now I get your point and his with PHP single strings but doesn't really make sense... having more reserved keywords with other databases and then using mysql only ` for that reason but.... eh not really.. | [17:40] |
| luciash | gezza: i am not sure about that but is it possible with category plugin ?
gezza: ah, you mean _before_ or _after_ the category plugin like in module, right ? | [17:42] |
| gezza | yes, in a module you can add many things
and it is great, you can have standard on content on many pages | [17:44] |
| luciash | gezza: maybe create the plugin alias for category plugin and then on Admin > Edit Area set the plugin needs no approval if that works
then maybe it will work in the custom module too | [17:45] |
| gezza | good idea, i try it out, thanks | [17:45] |
| *** | xavi has joined #tikiwiki
iannhigginson has left | [17:46] |
| luciash | Kissaki & chealer : i have noticed there is an approach in Tiki already to support multiple databases for sorting results using $this->convertSortMode($sort_mode) in some queries of tikilib.php | [17:52] |
| *** | kiilo has joined #tikiwiki | [17:53] |
| luciash | Kissaki & chealer : maybe if $this->query() was modified in simmilar manner, we could keep using backticks | [17:53] |
| chealer | luciash: right. you know, we're *supposed* to have DB abstraction... | [17:53] |
| luciash | i mean if the query function was done like convertSortMode() | [17:54] |
| chealer | (to be honest, I'm surprised redflo wouldn't know a better reason why backticks were used)
luciash: you mean changing the calls to query()? luciash: or changing query()? | [17:54] |
| luciash | well, there already is convertQuery() but hardly used if at all
it is called from lib/core/lib/TikiDb/Pdo.php changing query if it's good idea | [17:55] |
| *** | gezza has quit IRC ("Page closed") | [17:56] |
| luciash | query() | [17:56] |
| chealer | luciash: hum. you're damn right | [17:58] |
| luciash | chealer: see line 120 of lib/core/lib/TikiDb.php | [17:58] |
| chealer | luciash: yeah, I red it | [17:58] |
| luciash | dunno why it is not used | [17:58] |
| chealer | I was assuming we had something like that in place too
(before I red redflo's mail) | [17:58] |
| luciash | there is also the convertSortMode() function on line 174 which is used in tikilib | [18:00] |
| sylvieg | +1 to change the quoting in the query function | [18:00] |
| chealer | luciash: it's actually called, both from standard query(), with either adodb or PDO implementations.. | [18:02] |
| luciash | maybe it is because it checks for case="postgres8" and not case="pgsql" ? or is it not related with the string which is stored in db/local.php ? | [18:02] |
| chealer | luciash: it's actually called, from standard query(), with either adodb or PDO implementations..
ah | [18:02] |
| luciash | btw which file is the main query() function in ?
and where is $user defined when we're on it ? ;) | [18:03] |
| chealer | 183 $db->setServerType( $db_tiki );
from db/tiki-db.php luciash: there are 2, Pdo.php and Adodb.php | [18:04] |
| luciash | i see | [18:06] |
| chealer | luciash, Kissaki: so what $dbTiki do you have?
$db_tiki | [18:06] |
| Kissaki | what?
luciash: well, I'd still like to use the SQL standard instead of converting each query to be only compatible to it | [18:07] |
| luciash | it uses PDO here and pgsql string is stored in my db/local.php | [18:08] |
| chealer | luciash: gah, so we just had this great discussion about nothing
chealer sends luciash a beer luciash: or is that too early for night owls of your kind? luciash: are you fixing it? | [18:09] |
| luciash | Kissaki: well, we can convert all backticks to standard ANSI quotes but it would be more difficult actually because some $query variables are done as $query = "..."; and some $query = '';
chealer: nope, feel free to touch it chealer: thanks for the beer :) chealer: i just hope it's not too early to celebrate ;) | [18:12] |
| Kissaki | we'll have to add that to coding style :)
well, it's use ' ' anyway, right? ^^ | [18:14] |
| luciash | Kissaki: so you would need to take care of adding slashes in case of $query = "..." or convert them all to $query = '...'; first :-/ | [18:15] |
| Kissaki | yep | [18:16] |
| luciash | Kissaki: so i think sticking to backticks is much easier to handle if the conversion in query() function works | [18:16] |
| chealer | luciash: can't test it, but... coming | [18:17] |
| Kissaki | mh, so you're talking about not having to escape at all?
true... is query() called every time you do a query? | [18:18] |
| luciash | yep | [18:20] |
| CIA-75 | tikiwiki: 03sylvieg * r22108 10/trunk/lib/wiki-plugins/wikiplugin_tracker.php: [FIX]TRACKER: trim the wiki page | [18:20] |
| luciash | Kissaki: yep
Kissaki: actually it is true that developers should stick to using single quotes as much as possible but it's not really manageable so backticks are good that they work inside both, single quotes or double quotes | [18:20] |
| Kissaki | mh, is this channel pretty empty right now? or is it always like that? ^^ | [18:23] |
| luciash | Kissaki: but if we could force ourselves to the standard ANSI and using single quotes as much as possible in the future i believe it would gain some performance for Tiki when we could avoid these conversions regexps
empty ? sometimes less people even here ;) | [18:24] |
| Kissaki | we don't need regexp for that
just replace ` with " we have to at least run a policy of always add ` to identifiers then | [18:25] |
| luciash | we need the conversions at least, which for sure doesn't add in the performance | [18:25] |
| Kissaki | yeah
tru e standard ftw | [18:25] |
| chealer | luciash: do you have any idea where this pgsql string comes from?
did you set this manually? | [18:26] |
| luciash | yeah, in TikiDb.php some preg_replaces are really not necessary | [18:26] |
| chealer | Kissaki: what do you mean by "well, it's use ' ' anyway, right? ^^" | [18:26] |
| luciash | chealer: installer ? | [18:27] |
| chealer | luciash: but Kissaki didn't use the installer IIUC | [18:27] |
| Kissaki | the coding style
is to prefer ' over " yeah, didn't use the installer the wiki page implied I'd only have to run the SQL script | [18:27] |
| chealer | Kissaki: for values, yes. but we don't have to quote values in each query anyway
Kissaki: but how did you choose to set "pgsql" as $db_tiki? | [18:28] |
| Kissaki | hm? I just did in that file in db folder
local.php (so it was that name after all, just thought I would have confusied it with another CMS which also uses local.php ^^) | [18:29] |
| luciash | ok, i did put it there manually by some advice maybe (the wiki page ?) :-p but then putting postgres8 seems correct... the problem is some queries (e.g. in lib/userslib.php) do not use mysql backticks at all and as some column names are camelCase, postgresql fails with DB error (as it is case sensitive)
or did i do the change, hmmmm. i guess i will svn revert my local changes first ;) | [18:30] |
| chealer | Kissaki: but why "pgsql" and not, say "postgresql"? | [18:32] |
| Kissaki | ^^
because pgsql is a common short term /setting for postgresql and it did seem work +to | [18:32] |
| luciash | yea, i wonder it seem to work actually :-p
have to grep where it is checked and change it there in tiki code | [18:35] |
| chealer | found stuff
tiki-db-pdo.php (and tiki-db-adodb.php) (in db/) which are entirely inconsistent | [18:37] |
| luciash | those two files should be diffed and synchronized
before we used only adodb and suff worked, now there's pdo and we have to fix a lot it seems :) s/suff/stuff/ seems query() calls are handled with the conversion but is it true for getOne() ? | [18:39] |
| well, i have set "postgres8" in my local.php now but the queries doesn't seem to be converted to replace backticks...
chealer: where you saw it gets converted when using $this->query() ? | [18:50] | |
| chealer: which file is the main query() function in ?
chealer: i need to check whether it really gets converted from backticks there or why not | [18:56] | |
| chealer | luciash: yeah, you must be right | [18:58] |
| luciash | i see private function _query() in lib/core/lib/TikiDb/Pdo.php but that is something else, right ? | [18:59] |
| chealer | luciash: as I said, there are 2, Pdo.php and Adodb.php, but these call others | [18:59] |
| luciash | my tiki is using Pdo.php now
whaz is difference between query() and _query() ? | [18:59] |
| chealer | luciash: so Pdo.php query(), which in turn calls _query() | [19:00] |
| luciash | *what
ah i see now, tnx what does the "private" mean ? | [19:00] |
| Tikiwiki|bot | New Forum Posts: vote on a blog post a order the blog posts by total votes - http://tikiwiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=34883 | [19:02] |
| chealer | luciash: getOne() calls query(), as you can see in TikiDb.php
so yeah, it's converted too | [19:02] |
| luciash | hmm, i think it doesn't work when i see the error with backticks[19:06] <chealer> luciash: it's a visibility keyword (OO concept, encapsulation). by default, methods are public. http://www.php.net/manual/en/language.oop5.visibility.php
ah | [19:03] |
| chealer | luciash: the error as rendered by Tiki? I wouldn't rely on that too much | [19:07] |
| luciash | it even doesn't die when i put die; after case "sybase": on line 140 of lib/core/lib/TikiDb.php | [19:09] |
| chealer | luciash: yeah, that's to be expected for now, you can add a " case "pgsql":" while we're trying to figure things | [19:11] |
| luciash | but i changed already in db/local.php "pgsql" to "postgres8" | [19:11] |
| chealer | luciash: yeah, but tiki-db-pdo.php changed it back to pgsql | [19:12] |
| luciash | aaaaaah, damn | [19:12] |
| chealer | luciash: I was planning to commit that extra case, but I realize the issues are deeper, so I think I'm going to let the fix to someone which has postgres installed | [19:12] |
| luciash | so we should check against pgsql or fix in tiki-db-pdo.php ? | [19:13] |
| *** | mikew_ has joined #tikiwiki
mikew_ is now known as Guest62215 | [19:13] |
| luciash | chealer: what do you recommend ? check against pgsql in TikiDb.php or fix in tiki-db-pdo.php ? | [19:15] |
| chealer | luciash: good question. sept_7 wrote this code, in r14129. you may want to ask him if he had reasons. | [19:16] |
| luciash | lol, in tiki-db-adodb.php it switches from pgsql to postgres7 instead :-p | [19:16] |
| xavi | toc toc... | [19:16] |
| luciash | hola xavi ! :) | [19:16] |
| xavi | I need some help with tracker configuration
hi luci! :-) | [19:16] |
| chealer | luciash: yeah, there's some stuff to fix
hi xavi | [19:16] |
| xavi | hi "Filipus" :-) | [19:17] |
| chealer | xavi: Xavier de Pedro sounds much more funny to me | [19:17] |
| xavi | :-D | [19:17] |
| chealer | luciash: if you or Kissaki wants to debug Postgres in the meanwhile, adding a case in TikiDb.php won't hurt. | [19:18] |
| xavi | oups, I thought that your real name was Philippe, and that you wrote Filipus just for fun in some of your emails | [19:18] |
| Kissaki | no time at all
:( | [19:18] |
| luciash | chealer: yep, i will add check for "pgsql" there too | [19:19] |
| chealer | xavi: hehe, don't worry, my real name is Philippe. http://w3.ift.ulaval.ca/~phclo16/pc_en.html | [19:19] |
| xavi | ah, ok :-)
my question about trackers: I wonder why some times a tracker is showing the page without css styling: example: http://intercanvis.net/tracker3 and in fact, I guess that the answer is simple, it runs out of memmory, and that's why However, other times, it seems to show the page properly: example: http://intercanvis.net/tracker2 or http://intercanvis.net/Ofertes (the same tracker but shown through tracker list plugins) | [19:20] |
| luciash | chealer: YAY, it actualy seems to help a lot
;) | [19:22] |
| xavi | And I was wondering how to limit the amount of items being shown by default in the tracker list, so that not so much memory is requested to the server to start viewing the whole tracker data.
I remembered that there was some place (I think) where you could limit the number of items per page for trackers, but I don't seem to find it right now I'm using tiki 3.1 for that production site, btw | [19:22] |
| luciash | xavi: Admin → General ? | [19:23] |
| xavi | any help? (where to lower the number of items to show on each page of trackers?
luci: I already searched there with no luck. I'll search again (maybe it's me that I'm tired at this time of a teaching day) | [19:23] |
| luciash | oh, still teaching ? | [19:24] |
| xavi | not at this time of the day, but yes, tuesdays and thursdays, specially, I teach in two different univeristies
luciash, no luck in admin > general. But that type of setting was somewhere, wasn't it? | [19:25] |
| luciash | xavi: /tiki-admin.php?page=look&cookietab=2
xavi: down there | [19:26] |
| sylvieg | xavi did you use soem paginations?
max=xx | [19:26] |
| xavi | argh, luci, you are right! it's tehre!
thanks! and sylvieg, yes, I used the pagination param in trackerlist plugins, but I couldn't find a similar setting for the whole tracker, even If I remembered seing that setting somewhere (thanks luci for pointing it) | [19:27] |
| luciash | xavi: thought it was on Admin → Genereal, but it's there at the layout tab, yep
makes sense | [19:28] |
| xavi | ok, thanks to both. Dinner (kitchen) time here.
xavi wished he had more time for testing and helping with tiki4 these days... | [19:31] |
| chealer | luciash: _query() seems to be just some kind of query2(), since both fetchAll() and query() are calling it. some factorization function between these 2 | [19:34] |
| luciash | chealer: can you have a quick look if getOne() does call it too ? | [19:34] |
| chealer | luciash: yes, as I said, getOne() calls query(), as you can see in TikiDb.php | [19:35] |
| luciash | nx
chealer: i am getting further ;) now i am stuck on ERROR: column "menuid" does not exist LINE 1: select count(*) from tiki_menu_options where menuId=$1 LIMIT... s/nx/tnx/ ;) because it is menuId | [19:35] |
| chealer | luciash: great. I suppose there will be a number, as it looks like nobody tested trunk on anything non-mysql since at least 2 months | [19:39] |
| luciash | ah, my fault | [19:39] |
| CIA-75 | tikiwiki: 03jonnybradley * r22109 10/trunk/lib/jquery_tiki/tiki-jquery.js: [FIX] Changing the checked state of a checkbox doesn't fire the change event, so fire it specifically
tikiwiki: 03luciash * r22110 10/trunk/lib/core/lib/TikiDb.php: [FIX] PostgreSQL: support "pgsql" as case too because tiki-db-pdo.php and tiki-adodb-pdo.php are very inconsistent in this and when using PDO it didn't convert the MySQL specific backticks | [19:44] |
| *** | clemente has quit IRC (Read error: 110 (Connection timed out)) | [19:46] |
| CIA-75 | tikiwiki: 03jonnybradley * r22111 10/trunk/lib/smarty_tiki/function.treetable.php: [ENH] New nested heirarchical mode for treetable used by defining _sortColumnDelimiter param | [19:47] |
| tikiwiki: 03jonnybradley * r22112 10/trunk/ (2 files in 2 dirs):
tikiwiki: [ENH] Add 'select groups' tab to pick groups server-side tikiwiki: TODO: Remove the previous client-side version? | [19:52] | |
| tikiwiki: 03xavidp * r22113 10/trunk/templates/tiki-admin-include-workspaces.tpl: [FIX]Fixed wrong link to documentation page at dev.tw.o site | [20:03] | |
| chealer | luciash: that looks good. it seems ADOdb and PDO expect different DSN-s, which means tiki-db-pdo.php and tiki-db-adodb.php are not entirely wrong even if they look inconsistent. PDO expects pgsql: http://ca3.php.net/manual/en/ref.pdo-pgsql.connection.php while ADOdb seems to expect postgres: http://phplens.com/adodb/code.initialization.html | [20:05] |
| CIA-75 | tikiwiki: 03jonnybradley * r22114 10/trunk/tiki-objectpermissions.php: [FIX] Small change to the client-side group hiding code (but probably should be removed eventually) | [20:05] |
| luciash | chealer: fine, thanks for checking | [20:06] |
| chealer | luciash: so if I'd use pg8, I'd probably set $db_tiki = "postgres8"; | [20:07] |
| *** | grobda24 has quit IRC (Remote closed the connection) | [20:08] |
| rodrigo_sampaio has joined #tikiwiki
danopia has joined #tikiwiki | [20:16] | |
| CIA-75 | tikiwiki: 03sylvieg * r22115 10/trunk/lib/userslib.php: [FIX]rollback 22104 that gives a database error
tikiwiki: 03sylvieg * r22116 10/trunk/ (3 files in 3 dirs): [MOD]registration: option to send admin validation email not necessary to sender_email | [20:28] |
| luciash | Kissaki: still there ?
i am stuck on function set_lastUpdatePrefs() in tikilib there is $query = "update `tiki_preferences` set `value`=`value`+1 where `name`=?"; | [20:35] |
| Kissaki | yes
and? | [20:37] |
| luciash | pgsql doesn't like the construct "value"="value"+1 | [20:38] |
| Kissaki | well, it does look ugly after all :P
mh, that's $i++, right? | [20:38] |
| luciash | ERROR: invalid input syntax for integer: "value"
seems so | [20:38] |
| Kissaki | mmh, maybe "update `tiki_preferences` set `value`=( SELECT `value`FROM `tiki_preferences` WHERE `name`=? ) where `name`=?" does work?
you would have to duplicate the param though | [20:39] |
| CIA-75 | tikiwiki: 03chealer * r22117 10/trunk/db/ (5 files): [FIX] workspace query commented in r22024 now properly commented, assuming that was the intention | [20:40] |
| Kissaki | mh, and maybe add a LIMIT 1
you want to try that? ^^ | [20:40] |
| luciash | i will try :) | [20:40] |
| Kissaki | if it does work, maybe MySQL won't like it :P | [20:42] |
| luciash | yep
:-p | [20:42] |
| chealer | Kissaki: why a LIMIT 1? | [20:43] |
| Kissaki | to tell it "there is definitely just 1 row as a result, so give me the value already"
is name unique? or, does that query only update 1 row? | [20:44] |
| luciash | yes, lastUpdatePrefs | [20:45] |
| Kissaki | if not, then my guess definitely should not work | [20:45] |
| luciash | better i will do as two queries: select and then update | [20:46] |
| Kissaki | if that's not a problem, yeah | [20:47] |
| chealer | Kissaki: that will have to be the case for a scalar subquery anyway
Kissaki: anyway, that wouldn't modify the field's value | [20:48] |
| Kissaki | uh, true, lol
missing the +1 | [20:52] |
| CIA-75 | tikiwiki: 03xavidp * r22118 10/trunk/templates/tiki-admin-include-workspaces.tpl:
tikiwiki: [ENH]Cross link to tiki-manage-workspaces.php added from Admin > Workspaces tikiwiki: interface. Still menu option needed in install and upgrade sql's, if this is the tikiwiki: central script to manage the creation and edition of workspaces. Permissions tikiwiki: related to workspaces are still missing (to my partial understanding of how this tikiwiki: should work). | [20:52] |
| luciash | chealer, Kissaki: this seems to work →
http://paste-it.net/public/r195774/ do u see anything how to write it better before i commit ? | [21:01] |
| Kissaki | no | [21:02] |
| chealer | luciash: that's OK, but I don't see why the way it is doesn't work
luciash: did you try running that query directly on postgres? | [21:05] |
| luciash | nope, i tried change `value`=`value`+1 to `value`='value'+1 but it didn't help | [21:06] |
| chealer | luciash: no, it would need to be "value"+1
luciash: which is what convert_query should translate to luciash: or just try without quotes, they're not needed (see http://www.postgresql.org/docs/8.4/static/dml-update.html ) | [21:07] |
| luciash | yep, i see | [21:08] |
| chealer | luciash: hum, I don't think this warrants creating a new function | [21:10] |
| luciash | okay okay :) | [21:11] |
| Kissaki | oh crap... I'll finish writing this shitty report tomorrow... gonna go to bed now...
cu, n8 | [21:11] |
| luciash | Kissaki: nite
chealer: seems to work | [21:12] |
| *** | liquidape has quit IRC (Ping timeout: 180 seconds) | [21:12] |
| Kissaki | I wanna see pgsql running and installing tomorrow!
:P | [21:12] |
| luciash | `value`=value+1 | [21:12] |
| xavi | Mmm, I've been playing a bit with workspaces using current svn code in trunk
and I've sent my comment to the devel list I hope that the interface for managing workspaces can be poslished a bit in time, so that it can fit in the experimental section.... | [21:13] |
| chealer | luciash: well, I don't see why "value"+1 wouldn't work, but if that works, that's a much lesser hack than your paste :) | [21:14] |
| luciash | definitely | [21:14] |
| *** | rodrigo_sampaio has quit IRC ("Leaving.") | [21:16] |
| xavi | g'night all | [21:18] |
| *** | xavi has left | [21:18] |
| CIA-75 | tikiwiki: 03luciash * r22119 10/trunk/lib/tikilib.php:
tikiwiki: [FIX] PostgreSQL: invalid input syntax for integer: "value" tikiwiki: [ADD] switch for postgres when $query_cond is empty because resulting "SELECT FROM ... WHERE 1 AND ..." didn't work | [21:22] |
| *** | franck has quit IRC ()
MacLeod has quit IRC ("Page closed") | [21:26] |
| CIA-75 | tikiwiki: 03luciash * r22120 10/trunk/lib/core/lib/Perms/ResolverFactory/ObjectFactory.php: [FIX] ObjectFactory: adding backticks to camelCase names | [21:30] |
| *** | franck has joined #tikiwiki | [21:34] |
| Caarrie is now known as Caarrie|away | [21:41] | |
| ...... (idle for 25mn) | ||
| MartinCleaver has joined #tikiwiki | [22:06] | |
| luciash | yay ! luci has homepage running on postgre sql ;) | [22:09] |
| CIA-75 | tikiwiki: 03chealer * r22121 10/trunk/templates/tiki-adminusers.tpl: [FIX] HTML special chars encoding | [22:18] |
| chealer | luciash: without further modifications than what's in trunk? | [22:19] |
| ....... (idle for 34mn) | ||
| *** | SEWilco2 has quit IRC ("Leaving.")
c_schmitz has quit IRC (Read error: 60 (Operation timed out)) MartinCleaver has quit IRC (Read error: 60 (Operation timed out)) | [22:53] |
| ...... (idle for 28mn) | ||
| kiilo has quit IRC ("Leaving.") | [23:25] | |
| luciash | chealer: well, some, of course it is buggy still but i was able to login as admin and change password + some preferences
chealer: unfortunatelly it was false statement that your hint worked... i have it back to my extra query | [23:29] |
| *** | MartinCleaver has joined #tikiwiki | [23:31] |
| ..... (idle for 20mn) | ||
| CIA-75 | tikiwiki: 03luciash * r22122 10/trunk/lib/core/lib/Perms/ResolverFactory/GlobalFactory.php: [MOD] GlobalFactory: adding backticks to camelCase names
tikiwiki: 03luciash * r22123 10/trunk/lib/wiki/wikilib.php: [FIX] wikilib: add version to SELECT list to avoid DISTINCT error when using PostgreSQL | [23:51] |
| *** | Caarrie|away is now known as Caarrie | [23:59] |
| ←Prev date Next date→ Show only urls | (Click on time to select a line by its url) |