[00:10] *** MartinCleaver has quit IRC (Success) [00:55] *** MartinCleaver has joined #tikiwiki [01:04] *** SEWilco2 has joined #tikiwiki [01:28] *** mikew_ has joined #tikiwiki [01:28] *** mikew_ is now known as Guest59027 [01:29] oops. lost my nic [01:29] hello [01:31] I was updating from 2.1 to 3.2 [01:32] but I didn't get the lock file in updating from 2.4 to 3.2 [01:35] nor can I run tiki-install.php [01:38] ok. i see the install disable file. I'll try again [01:47] still not running [01:52] *** Guest59027 has quit IRC ("Page closed") [01:53] *** mike has joined #tikiwiki [01:53] hi [01:53] *** mike is now known as Guest58832 [01:56] >help [01:56] (help [] []) -- This command gives a useful description of what does. is only necessary if the command is in more than one plugin. [01:56] help update [01:56] 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:58] i'm the one with the update problem [02:14] does it matter when i deleted the outdated theme files? [02:20] it looks like i get a zend optimizer error when calling up the code [02:57] ok. the webhost helped me. the problem was in my file permissions. [03:00] Guest58832: sorry, wasn't here... good you figured out [03:14] tikiwiki: 03chealer * r22096 10/trunk/templates/tiki-admin_categories.tpl: [03:14] tikiwiki: [FIX] HTML special chars escaping [03:14] tikiwiki: [FIX] colons inside tr blocks [03:14] tikiwiki: [FIX] Directory categorization [03:15] *** MartinCleaver has quit IRC () [03:15] tikiwiki: 03chealer * r22097 10/trunk/ (2 files in 2 dirs): [03:15] tikiwiki: [FIX] HTML special chars encoding [03:15] tikiwiki: remove template comment (assuming that's a leftover from copy-paste) [03:16] *** MartinCleaver has joined #tikiwiki [03:16] i got the zip file for the 3.2 version. The useful file permissions must not have been preserved in all that i did. [03:19] i was running ver 2.1 since 2007 and then saw I needed to make sure I was able to run on php5 [03:40] *** MartinCleaver has quit IRC (Read error: 110 (Connection timed out)) [03:55] *** franck has quit IRC () [03:58] now I think I have a themes problem. The sidebar is below the wiki content -- instead of at the side [03:59] *** franck has joined #tikiwiki [04:02] *** franck has quit IRC (Client Quit) [04:07] *** Caarrie is now known as Caarrie|sleeping [04:08] *** franck has joined #tikiwiki [04:16] *** SEWilco2 has quit IRC ("Leaving.") [04:53] *** chibaguy has joined #tikiwiki [04:53] k. I just am forcing the thenews theme to the admin account [04:53] polom [04:54] hi [04:54] Guest58832, did you update from an earlier version of Tiki? [04:54] yes. I had 2.1 [04:56] See http://doc.tikiwiki.org/Upgrade+2.x+to+3.x . Step 5 talks about themes. [04:56] yes. I have it working now [04:57] columns are all in the right place, etc.? [04:57] yes [04:57] ok [04:58] on another topic, it seems file gallery permissions are screwed up in Tiki 3. [04:58] There've been user reports in the tw.o forum about this so I did a test. [04:59] are you new to ver 3? [04:59] or a gurur? [04:59] No, I work on the project. [05:00] maybe a gurur, not a guru yet tho. ;-) [05:00] haha [05:01] i mainly only used the wiki [05:01] since 2007 [05:01] i loaded this originally with fantastico setup scripts [05:02] 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] which, for updates, would mess up add-ins and optional features [05:03] I've always installed and updated with ftp, so am not very familiar with the fantastico route. [05:04] It helped me get started. Now i just did ftp [05:06] 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:08] Is it easy to figure out a fix? [05:09] For one of our php gurus, yes, I hope. :-) [05:10] what speicialty to you contribute on the project? [05:12] mainly themes [05:16] so you have made some tiki 3 themes? [05:17] yes, pretty much all that are available. [05:18] Strasa and Coelesce were designed by someone else, and the other bundled themes in tiki 3 have been worked on collaboratively. [05:18] ah. i see. thanks [05:24] 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:25] that's good. [05:26] uh oh. that feature may be a plugin [05:29] what feature? [05:29] structures? [05:29] where I could navigate based on a structure or outline [05:30] 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:32] good. i'm a bit in panic mode until I find out if everything works [05:34] :-) [05:39] there are no features options listed for wiki [05:39] nvm. it wasn't expanded [05:42] *** chibaguy has quit IRC (Read error: 110 (Connection timed out)) [05:46] *** Guest58832 has quit IRC ("Page closed") [05:52] *** chibaguytoo is now known as chibaguy [06:45] *** c_schmitz has quit IRC (Nick collision from services.) [06:45] *** c_schmitz has joined #tikiwiki [07:08] polompolom [07:16] *** Wilkins has joined #tikiwiki [07:48] half-polom [08:05] tikiwiki: 03chealer * r22098 10/trunk/lib/tikilib.php: [08:05] tikiwiki: [FIX] rollback r21822: [08:05] tikiwiki: [MOD] please refer to dev note 1.1 http://doc.tikiwiki.org/Tiki4#Anonymous_group_not_included_by_default_in_Registered_ [08:05] 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:57] *** kiilo has joined #tikiwiki [08:58] *** kiilo has quit IRC (Client Quit) [09:00] *** kiilo has joined #tikiwiki [09:06] 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 [10:50] *** kiilo1 has joined #tikiwiki [11:05] *** Caarrie|sleeping is now known as Caarrie [11:07] *** kiilo has quit IRC (Read error: 110 (Connection timed out)) [11:12] luciash: you must be right in your last mail, I think both me and redflo were confused by Stéphane's mail [11:27] *** c_schmitz has quit IRC (Read error: 110 (Connection timed out)) [11:41] chealer: no prob :) [11:41] *** kiilo1 has quit IRC ("Leaving.") [11:44] 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] Other calendars don't have this complication, afaik. [11:49] not a big problem, but maybe can be improved later on [12:13] *** grobda24 has joined #tikiwiki [12:13] * grobda24 says hi [12:14] 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:18] In trunk/tiki4 it's easy, with new custom center column header box :-) [12:19] Maybe in tiki 3, you need to edit the articles template. [12:19] Or you can use the shadow divs feature, come to think of it. [12:20] ah, interesting :) [12:21] template or, shadow divs ... is that a plugin ? [12:22] it's a look and feel admin feature, courtesy of luciash :-) [12:23] when you activate it, new div tags are added in tiki.tpl. [12:23] k [12:24] and a textarea for each, on admin look and feel. [12:24] you can add your html (i think it's ok) in the one for centercolumn top [12:27] is it the "shadow layer" ? [12:27] 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. [12:27] yeah, shadow layer. [12:27] k [12:28] 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 [12:31] chibaguy, yeah that's it. Nice, thanks. See "Fred" here http://mindfreedom.org.uk/ [12:32] ok, but fred turns up on other pages, too. Is that ok? [12:33] hmm, what's the filter for limiting scope to one file? [12:33] ah [12:33] it might be the template then [12:33] *** luminoso has quit IRC (Read error: 54 (Connection reset by peer)) [12:35] *** luminoso has joined #tikiwiki [12:37] {if $smarty.server.SCRIPT_NAME eq 'tiki-view_articles.php}Fred{/if} [12:38] er.. ...php'} [12:38] testing [12:40] was that for the shadow layer box ? [12:41] it just shows the code ... http://mindfreedom.org.uk/ [12:45] ah, duh ... it's Plugin Articles that I need. Thanks for the help ! [12:55] ok. [13:11] 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:12] *** goj has quit IRC ("enough idleing") [13:24] tikiwiki: 03jonnybradley * r22100 10/trunk/ (3 files in 2 dirs): [13:24] tikiwiki: [ENH] Added rudimentary colour pickers and new background colour icon. [13:24] tikiwiki: Also JS fixes for Firefox/AJAX [13:24] *** Caarrie is now known as Caarrie|away [13:50] *** gezza has joined #tikiwiki [13:54] chibaguy: +1 [13:55] really? [13:55] I mean, I wasn't sure if people would like that. [13:56] 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] bbl [13:56] 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." [13:57] can someone tell me what is the bottleneck? why is it not displaying? [13:57] *** chibaguy has quit IRC (Read error: 104 (Connection reset by peer)) [14:04] *** jonnyb has joined #tikiwiki [14:06] tikiwiki: 03jonnybradley * r22101 10/trunk/ (3 files in 3 dirs): [14:06] tikiwiki: [MOD] Remove hard coded inclusion of Anonymous group in Registered (again - see r21822 and r22098). [14:06] tikiwiki: Added schema script to preserve existing behaviour and changed tikilib and objectperms. [14:06] tikiwiki: Other files need fixing (modlib, wikiplugin_group, userslib, tiki-emulate_groups_switch and mod-func-groups_emulation - possibly others) [14:06] tikiwiki: Profiles that assumed this inclusion will also need amending. [14:07] *** danopia has quit IRC (Connection timed out) [14:17] *** rodrigo_sampaio has joined #tikiwiki [14:18] 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:33] *** chibaguy has joined #tikiwiki [14:33] *** MacLeod has joined #tikiwiki [14:53] 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) [15:08] *** Caarrie|away is now known as Caarrie [15:10] gezza: i don't get the note... it should work with every MODULE [15:10] at least it worked some weeks ago [15:10] in 3.x [15:15] 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:16] *** Yenzelle has joined #tikiwiki [15:17] *** SEWilco2 has joined #tikiwiki [15:17] chibaguy: (actually i draw them from scratch) [15:18] *** Yenzelle has quit IRC (Client Quit) [15:24] *** clemente has joined #tikiwiki [15:28] luciash, do you mean the "configure modules" icons? [15:28] I was just talking about the open|close icons. [15:29] So far I just took the color out of the current icons (reduced saturation to zero). [15:29] Also the previous, next, first, etc. last pagination arrows. [15:29] which are also that blue color. [15:30] 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:31] tikiwiki: 03Jyhem * r22104 10/trunk/lib/userslib.php: [MOD] Part of removal of hard coded inclusion of Anonymous group in Registered (see 22101) [15:32] Sometimes one does want a red, white, and blue theme. :-) [15:33] :-) true [15:34] 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:36] that's a significant commit ^^ [15:44] luciash: thanks, seems like the note is true, it was added by sylvie according to the page history [15:45] 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 [15:46] for which i created "category_item_list_i18n" module that you can find among the modules [15:48] chibaguy: wow, this mollio theme is really nice [15:48] congrats [15:50] thanks, gezza. a lot of credit goes to the original designers (http://mollio.org) [15:50] but it was fun and a challenge to implement the design for tiki. [15:52] *** Wilkins has quit IRC (Remote closed the connection) [15:53] good idea to make icon for the show/hide columns and put the test to pop-up [15:53] text I mean [15:54] hehe, seems like it is the same for other themes, great [15:56] well, mollio will be available soon, before tiki 4 is out, actually. [16:10] tikiwiki: 03nkoth * r22106 10/trunk/lib/tikilib.php: [FIX] Wiki page links in menus should support best language [16:11] Upgrading from v2.0 to v3.1 appears to have broken the FCK image upload function. "Browse server" results in "Error creating folder..." [16:15] *** c_schmitz has joined #tikiwiki [16:18] hmm, anonymous still can't change themes in trunk. [16:23] *** kiilo has quit IRC ("Leaving.") [16:38] 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:42] *** iannhigginson has joined #tikiwiki [16:44] chibaguy: are you doing something with this? did you open a bug report? [16:44] 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:49] chealer, no, I didn't. I'll do that now. [16:55] 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:59] iannhigginson, what tiki version is that? [17:01] polom [17:01] *** rodrigo_sampaio has quit IRC ("Leaving.") [17:15] tiki 3.2 [17:19] are you using the normal editor or the wysiwyg editor? [17:22] wysiwyg [17:26] iannhigginson: does that happen with experimental features off and several usersT? [17:27] chibaguy: yep, these icons i meant [17:27] gezza: but i have created custom module and assigned with no problem via MODULE plugin, weird [17:30] New Forum Posts: Create and use Wiki Page Variables - http://tikiwiki.org/tiki-view_forum_thread.php?forumId=4&comments_parentId=34882 [17:30] 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] 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:31] 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] what kind of module did you create? maybe it is category listing specific..i have ticked in "must be wiki parsed" [17:31] iannhigginson: it is the ajax, switch it off [17:32] i had duplication before too, it helped me [17:32] Thank you [17:32] gezza: i created custom module containing {tabs}One|Two|Three{/tabs}... [17:32] hope it helps [17:32] 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:33] *** chibaguy has quit IRC (Read error: 104 (Connection reset by peer)) [17:33] gezza: maybe it doesn't work with plugins inside which need plugin approval ? [17:33] Ajax disabled [17:33] luciash: maybe, but why does it need approval [17:33] ? [17:34] maybe it can be changed [17:36] gezza: i mean why you put plugin CATEGORY in plugin MODULE ? [17:37] gezza: why not directly in wiki page ? [17:37] the CATEGORY plugin [17:37] 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:38] 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] ok, then you can create Plugin Alias [17:39] but maybe I want to add some links or text too [17:39] and put just {I18N()}{/I18N} [17:39] you can edit all that on Plugin Alias Admin page [17:39] chealer: whos redflo [17:40] Kissaki: Florian Gleixner [17:40] 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] well, he was pointing out that mysql reserved words were an issue, not what you said, right? [17:41] ah, you're right [17:41] now I get your point [17:41] and his with PHP single strings [17:41] but doesn't really make sense... [17:42] having more reserved keywords with other databases and then using mysql only ` for that reason [17:42] but.... eh [17:42] not really.. [17:42] gezza: i am not sure about that but is it possible with category plugin ? [17:44] gezza: ah, you mean _before_ or _after_ the category plugin like in module, right ? [17:44] yes, in a module you can add many things [17:45] and it is great, you can have standard on content on many pages [17:45] gezza: maybe create the plugin alias for category plugin and then on Admin > Edit Area set the plugin needs no approval if that works [17:45] then maybe it will work in the custom module too [17:45] good idea, i try it out, thanks [17:46] *** xavi has joined #tikiwiki [17:48] *** iannhigginson has left [17:52] 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:53] *** kiilo has joined #tikiwiki [17:53] Kissaki & chealer : maybe if $this->query() was modified in simmilar manner, we could keep using backticks [17:53] luciash: right. you know, we're *supposed* to have DB abstraction... [17:54] i mean if the query function was done like convertSortMode() [17:54] (to be honest, I'm surprised redflo wouldn't know a better reason why backticks were used) [17:55] luciash: you mean changing the calls to query()? [17:55] luciash: or changing query()? [17:55] well, there already is convertQuery() but hardly used if at all [17:56] it is called from lib/core/lib/TikiDb/Pdo.php [17:56] changing query if it's good idea [17:56] *** gezza has quit IRC ("Page closed") [17:56] query() [17:58] luciash: hum. you're damn right [17:58] chealer: see line 120 of lib/core/lib/TikiDb.php [17:58] luciash: yeah, I red it [17:58] dunno why it is not used [17:58] I was assuming we had something like that in place too [17:59] (before I red redflo's mail) [18:00] there is also the convertSortMode() function on line 174 which is used in tikilib [18:00] +1 to change the quoting in the query function [18:02] luciash: it's actually called, both from standard query(), with either adodb or PDO implementations.. [18:02] 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] luciash: it's actually called, from standard query(), with either adodb or PDO implementations.. [18:02] ah [18:03] btw which file is the main query() function in ? [18:04] and where is $user defined when we're on it ? ;) [18:04] 183 $db->setServerType( $db_tiki ); [18:05] from db/tiki-db.php [18:06] luciash: there are 2, Pdo.php and Adodb.php [18:06] i see [18:06] luciash, Kissaki: so what $dbTiki do you have? [18:07] $db_tiki [18:07] what? [18:08] luciash: well, I'd still like to use the SQL standard instead of converting each query to be only compatible to it [18:08] it uses PDO here and pgsql string is stored in my db/local.php [18:09] luciash: gah, so we just had this great discussion about nothing [18:10] * chealer sends luciash a beer [18:11] luciash: or is that too early for night owls of your kind? [18:11] luciash: are you fixing it? [18:12] 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 = ''; [18:13] chealer: nope, feel free to touch it [18:13] chealer: thanks for the beer :) [18:13] chealer: i just hope it's not too early to celebrate ;) [18:14] we'll have to add that to coding style :) [18:14] well, it's use ' ' anyway, right? ^^ [18:15] Kissaki: so you would need to take care of adding slashes in case of $query = "..." or convert them all to $query = '...'; first :-/ [18:16] yep [18:16] Kissaki: so i think sticking to backticks is much easier to handle if the conversion in query() function works [18:17] luciash: can't test it, but... coming [18:18] mh, so you're talking about not having to escape at all? [18:18] true... [18:20] is query() called every time you do a query? [18:20] yep [18:20] tikiwiki: 03sylvieg * r22108 10/trunk/lib/wiki-plugins/wikiplugin_tracker.php: [FIX]TRACKER: trim the wiki page [18:20] Kissaki: yep [18:22] 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:23] mh, is this channel pretty empty right now? or is it always like that? ^^ [18:24] 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 [18:25] empty ? sometimes less people even here ;) [18:25] we don't need regexp for that [18:25] just replace ` with " [18:25] we have to at least run a policy of always add ` to identifiers then [18:25] we need the conversions at least, which for sure doesn't add in the performance [18:25] yeah [18:26] tru [18:26] e [18:26] standard ftw [18:26] luciash: do you have any idea where this pgsql string comes from? [18:26] did you set this manually? [18:26] yeah, in TikiDb.php some preg_replaces are really not necessary [18:26] Kissaki: what do you mean by "well, it's use ' ' anyway, right? ^^" [18:27] chealer: installer ? [18:27] luciash: but Kissaki didn't use the installer IIUC [18:27] the coding style [18:27] is to prefer ' over " [18:27] yeah, didn't use the installer [18:27] the wiki page implied I'd only have to run the SQL script [18:28] Kissaki: for values, yes. but we don't have to quote values in each query anyway [18:28] Kissaki: but how did you choose to set "pgsql" as $db_tiki? [18:29] hm? I just did in that file in db folder [18:29] local.php [18:30] (so it was that name after all, just thought I would have confusied it with another CMS which also uses local.php ^^) [18:30] 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) [18:31] or did i do the change, hmmmm. i guess i will svn revert my local changes first ;) [18:32] Kissaki: but why "pgsql" and not, say "postgresql"? [18:32] ^^ [18:32] because pgsql is a common short term /setting for postgresql [18:32] and it did seem work [18:32] +to [18:35] yea, i wonder it seem to work actually :-p [18:36] have to grep where it is checked and change it there in tiki code [18:37] found stuff [18:38] tiki-db-pdo.php (and tiki-db-adodb.php) [18:38] (in db/) [18:38] which are entirely inconsistent [18:39] those two files should be diffed and synchronized [18:40] before we used only adodb and suff worked, now there's pdo and we have to fix a lot [18:40] it seems :) [18:40] s/suff/stuff/ [18:44] seems query() calls are handled with the conversion [18:44] but is it true for getOne() ? [18:50] well, i have set "postgres8" in my local.php now but the queries doesn't seem to be converted to replace backticks... [18:51] chealer: where you saw it gets converted when using $this->query() ? [18:56] chealer: which file is the main query() function in ? [18:57] chealer: i need to check whether it really gets converted from backticks there or why not [18:58] luciash: yeah, you must be right [18:59] i see private function _query() in lib/core/lib/TikiDb/Pdo.php but that is something else, right ? [18:59] luciash: as I said, there are 2, Pdo.php and Adodb.php, but these call others [18:59] my tiki is using Pdo.php now [19:00] whaz is difference between query() and _query() ? [19:00] luciash: so Pdo.php query(), which in turn calls _query() [19:00] *what [19:00] ah [19:01] i see now, tnx [19:01] what does the "private" mean ? [19:02] 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] luciash: getOne() calls query(), as you can see in TikiDb.php [19:03] so yeah, it's converted too [19:03] hmm, i think it doesn't work when i see the error with backticks\ [19:06] luciash: it's a visibility keyword (OO concept, encapsulation). by default, methods are public. http://www.php.net/manual/en/language.oop5.visibility.php [19:07] ah [19:07] luciash: the error as rendered by Tiki? I wouldn't rely on that too much [19:09] it even doesn't die when i put die; after case "sybase": on line 140 of lib/core/lib/TikiDb.php [19:11] luciash: yeah, that's to be expected for now, you can add a " case "pgsql":" while we're trying to figure things [19:11] but i changed already in db/local.php "pgsql" to "postgres8" [19:12] luciash: yeah, but tiki-db-pdo.php changed it back to pgsql [19:12] aaaaaah, damn [19:12] 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:13] so we should check against pgsql or fix in tiki-db-pdo.php ? [19:13] *** mikew_ has joined #tikiwiki [19:14] *** mikew_ is now known as Guest62215 [19:15] chealer: what do you recommend ? check against pgsql in TikiDb.php or fix in tiki-db-pdo.php ? [19:16] luciash: good question. sept_7 wrote this code, in r14129. you may want to ask him if he had reasons. [19:16] lol, in tiki-db-adodb.php it switches from pgsql to postgres7 instead :-p [19:16] toc toc... [19:16] hola xavi ! :) [19:16] I need some help with tracker configuration [19:16] hi luci! :-) [19:16] luciash: yeah, there's some stuff to fix [19:16] hi xavi [19:17] hi "Filipus" :-) [19:17] xavi: Xavier de Pedro sounds much more funny to me [19:17] :-D [19:18] luciash: if you or Kissaki wants to debug Postgres in the meanwhile, adding a case in TikiDb.php won't hurt. [19:18] oups, I thought that your real name was Philippe, and that you wrote Filipus just for fun in some of your emails [19:18] no time at all [19:19] :( [19:19] chealer: yep, i will add check for "pgsql" there too [19:19] xavi: hehe, don't worry, my real name is Philippe. http://w3.ift.ulaval.ca/~phclo16/pc_en.html [19:20] ah, ok :-) [19:21] my question about trackers: I wonder why some times a tracker is showing the page without css styling: [19:21] example: http://intercanvis.net/tracker3 [19:21] and in fact, I guess that the answer is simple, it runs out of memmory, and that's why [19:22] 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:22] chealer: YAY, it actualy seems to help a lot [19:22] ;) [19:22] 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. [19:23] 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 [19:23] I'm using tiki 3.1 for that production site, btw [19:23] xavi: Admin → General ? [19:23] any help? (where to lower the number of items to show on each page of trackers? [19:24] luci: I already searched there with no luck. [19:24] I'll search again (maybe it's me that I'm tired at this time of a teaching day) [19:24] oh, still teaching ? [19:25] not at this time of the day, but yes, tuesdays and thursdays, specially, I teach in two different univeristies [19:26] luciash, no luck in admin > general. But that type of setting was somewhere, wasn't it? [19:26] xavi: /tiki-admin.php?page=look&cookietab=2 [19:26] xavi: down there [19:26] xavi did you use soem paginations? [19:27] max=xx [19:27] argh, luci, you are right! it's tehre! [19:27] thanks! [19:28] 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:28] xavi: thought it was on Admin → Genereal, but it's there at the layout tab, yep [19:28] makes sense [19:31] ok, thanks to both. Dinner (kitchen) time here. [19:31] * xavi wished he had more time for testing and helping with tiki4 these days... [19:34] 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] chealer: can you have a quick look if getOne() does call it too ? [19:35] luciash: yes, as I said, getOne() calls query(), as you can see in TikiDb.php [19:35] nx [19:37] 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... [19:37] s/nx/tnx/ [19:37] ;) [19:37] because it is menuId [19:39] 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]