[00:02] *** wookienz has joined #tikiwiki [00:08] *** luminoso has quit IRC (Connection timed out) [01:09] *** marclaporte has joined #tikiwiki [01:11] *** Kissaki is now known as Kissaki^0ff [01:13] polom polom from late night Barcelona :) [01:13] *** rux__ has joined #tikiwiki [01:13] hi everybody [01:14] any italian here ? [01:14] i'm looking for an adjurned language file [01:15] up to date? [01:15] yes [01:15] the official one is of 2004 [01:16] http://tikiwiki.org/LanguageItalian For Tikiwiki (version): 1.9 rc3 (CVS) [01:17] i suppose others have my same problem [01:18] then i have also another question about drop down menu [01:18] http://www.reteviva.org [01:19] rux_: it's easy to update the language.php file and contribute back ;) [01:19] unless i removed some functions they still appear in the upper menu and i wonder how to remove them... [01:19] *** SEWilco2 has quit IRC ("Leaving.") [01:20] I know is easy but if someone has already done it is unesefulll ;) [01:20] yep, i don't know any italian user actually [01:30] rux_: disable top menu on Admin > Look and Feel ? [01:33] yes it was [01:33] thank's [01:43] *** franck has quit IRC () [01:47] *** Caarrie|away is now known as Caarrie [01:53] rux_: latest language file is the one in source (not on wiki page) [01:56] *** SEWilco2 has joined #tikiwiki [02:09] tikiwiki: 03sylvieg * r20434 10/trunk/ (4 files in 4 dirs): [MOD]newsletter: new perm tiki_p_list_newsletters [02:10] *** franck has joined #tikiwiki [02:11] tikiwiki: 03sylvieg * r20435 10/trunk/db/ (6 files): sync [02:23] tikiwiki: 03sylvieg * r20436 10/trunk/installer/schema/20090730_p_list_newsletters_tiki.sql: typo [02:26] *** franck_ has joined #tikiwiki [02:27] *** franck_ has quit IRC (Remote closed the connection) [02:27] *** franck_ has joined #tikiwiki [02:27] *** franck has quit IRC (Read error: 104 (Connection reset by peer)) [02:42] *** luminoso has joined #tikiwiki [03:29] Info: Follow @TikiWiki_org on Twitter - http://info.tikiwiki.org/tiki-read_article.php?articleId=69 [04:00] *** eric91 has joined #tikiwiki [04:10] *** eric91 has quit IRC ("Page closed") [04:23] *** Caarrie is now known as Caarrie|sleeping [04:48] *** marclaporte has quit IRC (Read error: 110 (Connection timed out)) [05:31] *** MartinCleaver has joined #tikiwiki [05:34] *** franck_ has quit IRC () [05:42] *** franck has joined #tikiwiki [06:08] *** MartinCleaver has quit IRC () [06:35] can someone with more knowledge than me advise on this. It would appear this ismy bug - http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=2467&trackerId=5&show=view [06:35] which says there is a patch to userslib.php adn is documented here: http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki/branches/proposed/lib/userslib.php?r1=19222&r2=19413 [06:36] can i go and change this by itself or is a whoe new downlaod required/ [06:54] ANYONE ON LINE THAT CAN DO SOME MYSQL cli TROUBLESHOOTIGN FOR ME [06:54] ? [06:54] opps sorry about that [07:23] must be sleeping! [08:57] *** rlopez_ has joined #tikiwiki [08:57] *** rlopez_ has quit IRC (Client Quit) [09:20] *** Natrhon has joined #tikiwiki [09:22] *** luminoso has quit IRC ("Leaving") [09:23] Greetings everyone. I'm very new to twiki and I'm trying my first steps into it. I have figured out how to do an SQl query, all working, except the simpliest one... [09:24] how can I do a "SELECT *" query? [09:24] I need all the fields of all the rows on a table... [09:25] *** Wilkins has joined #tikiwiki [09:33] you logged into the CLI? [09:33] SELECT * FROM tablename [09:37] $query = "SELECT * FROM `gains_facilities` ORDER BY `facilityID` DESC"; [09:37] $result = $this->query($query); [09:38] this will give an error [09:45] "SELECT * FROM `gains_facilities` WHERE `owner` = ?" [09:45] $values[] = "someone" [09:46] $result = $this->query($query,$values); [09:46] this work perfectly... [10:20] *** floh1111 has joined #tikiwiki [10:22] *** Wilkins has quit IRC (farmer.freenode.net irc.freenode.net) [10:28] *** Wilkins has joined #tikiwiki [10:49] is there someone who can answer my question ? :D [11:21] there is a question in there? [11:21] -? +! [11:23] I am able to invoke the query function with [11:23] "SELECT * FROM `gains_facilities` WHERE `owner` = ?" [11:23] *** marclaporte has joined #tikiwiki [11:23] $values[] = "someone"; [11:24] $result = $this->query($query,$values); [11:24] this works [11:24] why this cannot work? : [11:24] $query = "SELECT * FROM `gains_facilities` ORDER BY `facilityID` DESC"; [11:24] ? [11:25] I need to select all the rows of a table [11:25] *** Lucymoz has quit IRC (Read error: 110 (Connection timed out)) [11:27] *** Floh1111_ has joined #tikiwiki [11:36] tikiwiki: 03lphuberdeau * r20437 10/branches/experimental/perms-take2/ (61 files in 28 dirs): [MRG] Automatic merge, trunk 20387 to 20436 [11:51] *** lphuberdeau has joined #tikiwiki [11:55] SELECT * FROM tablename will give you all row [11:55] s [11:55] but you want it ordered/ [11:55] ? [12:02] no at the moment, but if I make $query="SELECT * FROM tablename" and then $result=$this->query($query); [12:02] it gives me an error message [12:03] I've tried many combinations, and the ordered oone above was one of them... [12:05] hmm well beats me should work. [12:12] well, I don't really know where I was mistaking... now it works... a typo by me probably... sorry for bothering... :) my fault [12:19] another totally different problem. The javascript popup on my tiki is showing almost on the bottom of the page... where can I set the Y offset? thanks [12:50] *** rlopez_ has joined #tikiwiki [12:51] *** rlopez_ has quit IRC (Client Quit) [12:57] polom polom [12:57] *** Caarrie|sleeping is now known as Caarrie [13:45] *** marclaporte has quit IRC (Read error: 110 (Connection timed out)) [14:02] *** MartinCleaver has joined #tikiwiki [14:13] *** lphuberdeau has quit IRC (Read error: 110 (Connection timed out)) [14:15] *** rux_ has quit IRC (Ping timeout: 180 seconds) [14:16] *** rux__ has quit IRC (Ping timeout: 180 seconds) [14:21] Where can I find some documentation about trees (filegallerie tree)? I have link_var and link_id, but now I neet to define a link ahead link_var and link_id [14:25] *** Natrhon has left [14:32] *** MacLeod has joined #tikiwiki [14:36] *** lphuberdeau1 has joined #tikiwiki [14:36] *** chealer has joined #tikiwiki [14:38] *** MartinCleaver has quit IRC () [14:39] *** franck has quit IRC (Read error: 113 (No route to host)) [14:42] *** ricks99 has joined #tikiwiki [14:50] *** nkoth3 has joined #tikiwiki [14:52] *** chealer_ has joined #tikiwiki [14:57] tikiwiki: 03floh1111 * r20438 10/trunk/ (3 files in 3 dirs): removed code duplication on file_galleries module and fixed issues with prefs [15:01] *** lphuberdeau1 has quit IRC (Read error: 110 (Connection timed out)) [15:02] *** chealer has quit IRC (Read error: 110 (Connection timed out)) [15:06] *** chealer_ is now known as chealer [15:06] *** Caarrie is now known as Caarrie|away [15:16] anyone know... when including one wiki page inside another (with INCLUDE plugin, will tiki combine the categories together when displaying catpath? [15:16] *** lphuberdeau has joined #tikiwiki [15:17] hm... i guess not [15:29] no [15:29] but the perm will be checked [15:30] tikiwiki: 03sylvieg * r20439 10/trunk/templates/tiki-admin-include-wysiwyg.tpl: [FIX]layout: enlarge the textarea [15:41] right but tiki will only show the "main"page's cateogory in the catpath [15:50] *** pascalstjean has joined #tikiwiki [15:57] ricks99: still around? [15:58] yup [15:59] hiya, i see you name throughout variouis places on tikiwiki project so i assume yo uare in the know! [15:59] i am getting a db error whn i try amd make per page "perms" similar to this - http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=2467&trackerId=5&show=view [16:00] and there is a patch here: http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki/branches/proposed/lib/userslib.php?r1=19222&r2=19413 [16:01] can i just apply the code changes by editing it by hand that particular file? I read from other places that it might be a function of mysql mode being "strict". Got any insight into this? [16:01] sorry, i don't. what is ur mysql version? [16:02] fwiw, i haven't had issues creating groups in my 3.x tikis [16:02] 5.2.8 [16:02] *** Caarrie|away is now known as Caarrie [16:02] not sure. bug says fixed in 3.1? [16:02] i dont have root access, im relying on some other turkeys setting it up right. so they might have screwed up install. [16:03] yeah similar bug - ie there is an error but it iwhen i use the "perms" function [16:03] is this a new install? or upgrade from 2.x? [16:04] i think an upgrade from 2.x - here is the error [16:04] http://pastey.net/119283 [16:05] and there were no errors during the upgrade sql, right? [16:05] well thats what i dont know. [16:06] i'm not much help on this, sorry [16:06] someone else upgraded it... can i do a db update or the like? [16:06] rerun the tiki-install.php and re-update the db, if needed [16:07] if you have a phpMyadmin - we can know more about the error [16:07] sylvieg can probably help more than i can [16:07] it can be eitheir your table need to be repear .. or the perm exists already [16:08] will an [16:08] update" wipe the databse? [16:08] * sylvieg needs to fix why the error message does not show up anymore [16:08] phpmyadmin isnt installed so i can run it manually [16:09] yeh run the same query manually to see the error [16:09] i wish icould...but cant. [16:10] does running install.php jut re run and correct db options or does it start again, ie wipe DB? [16:10] running the upgrade shouldn't mess with your data -- only table structure [16:10] ok [16:11] make sure you select UPGRADE and not INSTALL (which *will* wipe your data) [16:11] ok great... [16:14] got to run! [16:14] *** wookienz has quit IRC ("ChatZilla 0.9.85 [Firefox 3.5.1/20090715094852]") [16:18] tikiwiki: 03sylvieg * r20440 10/trunk/ (2 files in 2 dirs): [MOD]newsletter: can use the wysiwyg editor [16:18] *** ricks99 has quit IRC (Read error: 104 (Connection reset by peer)) [16:21] *** rlopez_ has joined #tikiwiki [16:29] What tools do y'all use to probe and edit the MySQL database directly? [16:31] i use Mysql Administrator and Mysql Query Browser [14:28] *** pascalstjean has quit IRC (Read error: 104 (Connection reset by peer)) [14:29] Landon: thx [14:31] *** rlopez_ has quit IRC ("Leaving") [14:32] *** Floh1111_ has quit IRC (Remote closed the connection) [14:40] *** SEWilco2 has quit IRC ("Leaving.") [14:41] *** Kissaki^0ff is now known as Kissaki [14:52] *** xavi1 has joined #tikiwiki [14:53] toctoc... [14:54] toc [14:55] trying the last minute (hour, in fact) things for the kick off meeting at the http://tikiwiki.org/TikiFestBarcelona [14:55] video streaming is on, already, even if not good audio yet :-/ [15:00] ohoo [15:04] kissaki marc here are you coming [15:05] bring a mattress [15:05] ^^ no [15:05] pretty far away here, in Germany... [15:06] *** marclaporte has joined #tikiwiki [15:07] *** MacLeod has quit IRC (Ping timeout: 180 seconds) [15:07] *** Wilkins has quit IRC (Remote closed the connection) [15:07] polom [15:07] * marclaporte is no longer squatting xavi1's computer [15:07] Kissaki: Europeans don't know what "far" means! [15:08] ask Russians or Canadians :-) [15:09] marclaporte: yes driving 6 hours for going out to lunch isn't that possible with 1,40 euros per liter gas. [15:09] ^^ [15:09] true [15:09] esp. me [15:09] (doesn't know what far is) [15:09] *means [15:10] sound good for me [15:12] *** pascalstjean has joined #tikiwiki [15:17] *** Caarrie is now known as Caarrie|away [15:29] *** matwho has joined #tikiwiki [15:29] hi from Portugal [15:31] *** MatWho_ has joined #tikiwiki [15:32] *** matwho has left [15:33] *** MatWho_ has quit IRC (Client Quit) [15:34] *** SEWilco2 has joined #tikiwiki [15:34] *** xavi1 has quit IRC (Read error: 104 (Connection reset by peer)) [15:34] *** chealer has quit IRC (Read error: 104 (Connection reset by peer)) [15:34] *** lphuberdeau has quit IRC (Read error: 104 (Connection reset by peer)) [15:35] *** marclaporte has quit IRC (Read error: 104 (Connection reset by peer)) [15:38] *** chealer has joined #tikiwiki [15:39] *** marclaporte has joined #tikiwiki [15:53] *** shawn-ffbh has joined #tikiwiki [15:53] *** marclaporte has quit IRC (Read error: 104 (Connection reset by peer)) [15:53] *** shawn-ffbh has quit IRC (Client Quit) [15:54] *** shawn-ffbh has joined #tikiwiki [15:57] *** lphuberdeau has joined #tikiwiki [15:58] *** xavi has joined #tikiwiki [15:58] polom :) [15:58] could it be that the video is stuck? [15:59] *** Caarrie|away is now known as Caarrie [15:59] sound works - good horn outside... ;) [16:00] same observation - sound good, video stuck [16:00] *** rodrigo_sampaio has joined #tikiwiki [16:01] I need food, back soon :) [16:01] ;) [16:02] xavi: assuming you are at the place of the meeting - can you do anything about the video? [16:04] oh well - bbl... [16:04] *** tobi_h is now known as tobi_h|away [16:06] *** rlopez_ has joined #tikiwiki [16:15] tobi_h|away: it's stuck, indeed [16:16] tobi_h|away: we're still working on streaming. there are a few issues. [16:24] *** rlopez_ has quit IRC ("Leaving") [16:41] mmmm, still fighting with the audio and video, but things seem to improve... [16:41] soon, we should have somme stream on, live... [16:41] let's cross fingers :-) [16:41] stay tuned :-) [16:42] k [16:42] tikiwiki: 03chealer * r20441 10/trunk/lib/modules/modlib.php: [FIX] array_fill_keys typo [16:53] *** pascalstjean has quit IRC (Read error: 104 (Connection reset by peer)) [17:00] *** lphuberdeau has quit IRC (Read error: 104 (Connection reset by peer)) [17:00] *** xavi has quit IRC (Read error: 104 (Connection reset by peer)) [17:00] *** lphuberdeau1 has joined #tikiwiki [17:00] *** rodrigo_sampaio1 has joined #tikiwiki [17:00] *** cheal has joined #tikiwiki [17:08] *** rodrigo_sampaio has quit IRC (Read error: 104 (Connection reset by peer)) [17:09] *** chealer has quit IRC (Read error: 104 (Connection reset by peer)) [17:17] *** xavi has joined #tikiwiki [17:17] hello again [17:18] we are starting now, with or without streaming [17:18] k [17:18] *** Redhatter has quit IRC (Read error: 113 (No route to host)) [17:18] streaming works for me [17:19] and audio, nkoth? [17:19] nkoth3: ^ [17:20] seems ok, say somethig [17:20] i hear a lot of background talking (can't make out the words) [17:20] yes [17:20] yes, that's the problem [17:20] but we start anyway [17:21] *** MacLeod has joined #tikiwiki [17:21] we couldn't plug the good mattbic mic on a powerful computer in time [17:21] so we start without it [17:21] ah, i see [17:21] the sound is bad (my own old webcam) on my old laptop, but at least we can have some video out [17:22] and if nobody is able to have the audio from mattbic working, fine. else we have some video at least [17:22] SEWilco2: it was indeed a comments bug (2611) [17:22] and some off line good video and audio recording also [17:28] *** jonnyb has joined #tikiwiki [17:40] *** jonnyb has quit IRC () [18:03] I do not see how perspectives can work only on prefs and not on categ and groups too... [18:04] ok if it is freedom [18:04] if you stand in front of the camera (whoever is it), it blocks LP and also messes up the auto-aperture light detection of the webcam :) [18:05] xavi move a little bit [18:05] why not put the white board at the other end of the room, xavi? [18:10] cheal: Bug not found. http://dev.tikiwiki.org/tiki-searchresults.php?highlight=2611&search=Go [18:23] Where is the link to streaming? TW.o directs one to a nonexistent anchor in the URL http://tikiwiki.org/TikiFest+Workspaces+and+Social+Networking#Video_streaming_chat_twitter_about_the_event [18:26] Oh, there it is. Streaming is above the table of contents, in a section which has to be expanded to be visible. [18:29] Inaudible. Stream is only useful for images of a white shirt and action shots of a fan. [18:30] +1 for xavi move [18:34] :-) [18:34] it took a while to able to come to my computer (out of the room), and read the irc messages [18:35] SEWilco2: mic quality is a known issue (matbic's high quality mic not working with this pc) Bu I can make out the audio when I tuen it up [18:35] anyway, you can't read the whiteboard [18:36] I wish that somebody else was able to have better video and audioi in time in the room, but it was not the case... [18:37] nkothen3: You have a more powerful audio amp than I do. Inaudible with my laptop at full volume. In a few hours I can plug it into two amps and headphones. Maybe it will work when I turn it up to 20. [18:37] you'll probably have to wait for the videos uploaded (from separated and better camera) to get better audio and image quality [18:38] Separated cameras? 3D TikiFest? :-) [18:38] and without my the back of my t-shirt in front [18:38] *** Caarrie is now known as Caarrie|away [18:38] It was not planed to be done like this... [18:38] Yes, I see there is no plane. [18:38] but the palns didn't work as expexcted, unluckily [18:38] Wait, I can sketch a plane on the shirt. [18:39] My sketching skills are good enough to make a plane with a Samantha Carter in it. [18:49] *** MacLeod has quit IRC (Ping timeout: 180 seconds) [18:52] *** RLJII has quit IRC ("Page closed") [18:56] mömömömöp [19:12] I made a test on my local trunk versus perms-take2 [19:12] list pages : trunK [ Temps d'exécution: 1.00 secs ]   [ Mémoire utilisée: 27.73MB ]   [ 736 requête à la base de données utilisés dans 0.3 secs ]   [ Charge du serveur: 0.65 ] [19:13] perms [ Execution time: 1.18 secs ]   [ Memory usage: 22.27MB ]   [ 749 database queries used in 0.2 secs ]   [ Server load: 0.37 ] [19:13] New Forum Posts: How do I? Remove the "Homepage" title from my homepage? - http://tikiwiki.org/tiki-view_forum_thread.php?forumId=&comments_parentId=34172 [19:13] New Forum Posts: How do I? Change the Upper Banner - http://tikiwiki.org/tiki-view_forum_thread.php?forumId=&comments_parentId=34171 [19:14] *** Bandari has joined #tikiwiki [19:14] hello guys [19:15] I have a problem with tikiwiki installations - I would appreciate your help [19:15] Here is my problem: [19:15] Profiles are not showing right after the DB configuration [19:16] I have finished installation with defult profile installation. [19:16] *** rodrigo_sampaio1 has quit IRC ("Leaving.") [19:17] 1/ do you have a connection with internet 2/in you have fedora - you nee to reboot the server in you have some DNS config... [19:17] Using Admin (tikiwiki's) console - I tried creating profiles. - no success. [19:17] loui philippe? in whick list something did you imopletement your fetchall I think... the global perms check? [19:17] Yes - I do have internet [19:17] my system got connected to internet - [19:18] I am on windows environment. [19:19] Please do suggest me - where I went wrong? [19:19] sorry windows no idea..... [19:19] what do you mean "not showing"? [19:19] in my acse it is a system bug - it took me months to find it out.. [19:19] list of profiles are not showing [19:19] you need to have the getsocket function working [19:20] firewall? (wild guess) [19:20] getsocket function - means? [19:20] no firewalls [19:20] I can browse internet from the same system [19:21] it does not prove anything - a browser is not like a server [19:21] sylvieg: lph doesn't understaned your question [19:22] he did some query - where all the perms are checked on all the objects of a list [19:22] right? [19:22] (Total 2 system - I have installed - one with proxy setup and other one no proxy) in another system - I have a proxy setup - tikiwiki admin console (enabled the proxy setup too) but no success. [19:22] yes [19:22] sylvieg: he says yes [19:22] in which list did he implement that? [19:23] list_pages? [19:23] profiles [19:23] grep for Perms::filter [19:23] thx cheal [19:23] sylvieg: yeah, that was all from lph [19:24] Kindly suggest me [19:25] Bandari: did you get to admin->profiles ... is it working there? [19:25] Admin -> Profiles - page came [19:25] *** MartinCleaver has joined #tikiwiki [19:25] so it is only a problem in the installer? [19:26] and trying to install profile...it is not showing the profiles listed [19:27] repository = http://profiles.tikiwiki.org/profiles [19:27] My tikiwiki installation is unable to pick the profiles from the repository [19:28] I have another clarification - LDAP integration with tikiwiki - I have explored every link in admin console of tikiwiki - I haven't find - Please do suggest me. [19:29] tiki-admin.php?page=login [19:29] *** FrankP_german has joined #tikiwiki [19:38] Please help me on profiles [19:38] finished for today [19:38] at the tikifest [19:38] people went for food [19:38] we'll upload some pictures from today, and go also [19:38] Repository URLs:http://profiles.tikiwiki.org/profiles [19:39] we hope that during the weekend we can solve the issues with the audio and video [19:40] Bandari: I am pretty sure it is a problem with your system [19:42] *** floh1111 has quit IRC (Remote closed the connection) [19:42] Please do suggest me - which areas I have to look / check [19:44] Bandari: is a simple progrm like $url = 'http://profiles.tikiwiki.org/profiles';var_dump(file_get_contents( $url )); [19:47] do you want me to check this url? [19:47] can you do a php program that checks this? [19:48] need to check also if in your php.ini there is allow_url_fopen on too (if I remember well the var name) [19:49] let me try [19:55] *** xavi has left [19:58] Warning: file_get_contents(http://profiles.tikiwiki.org/profiles): failed to open stream: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. in C:\websites\tikiwiki\test-connection.php on line 3 bool(false) [19:59] Hello : here is the error [19:59] Warning: file_get_contents(http://profiles.tikiwiki.org/profiles): failed to open stream: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond. in C:\websites\tikiwiki\test-connection.php on line 3 bool(false) [20:02] allow_url_fopen = On -- in my php.in file [20:03] do we require any configurations with php for proxy authentication? [20:03] So you have to fix this problem to have tikiwiki working ... for me it is reboot my server for your windows ... no idea... [20:09] Thank you so much 'sylvieg' - Please let me know if you have any suggestions...here is my email address - bandari.kumar@gmail.com [20:21] *** Lucymoz has joined #tikiwiki [20:25] *** MatWho has joined #tikiwiki [20:26] How is Barcelona? [20:32] *** Bandari has quit IRC ("Page closed") [20:40] tikiwiki: 03kissaki * r20442 10/trunk/db/tiki.sql: add `s to CREATE TABLE and DROP TABLE statements [20:45] wth [20:48] *** FrankP_german has quit IRC ("Nettalk6 - www.ntalk.de") [20:48] svn is so damn fucking slow... [20:50] hahaha [20:50] sylvieg? [20:51] uh, he's in this chan, nice! [20:52] sylvieg: are you familiar with primary keys in dbs and it was just an oversight? [20:56] *** arrowsama has joined #tikiwiki [20:57] *** arrowsama has quit IRC (Client Quit) [21:00] tikiwiki: 03kissaki * r20443 10/trunk/db/tiki.sql: [FIX] rev 20434 did specify a primary key twice in a table [21:02] *** cheal has quit IRC (Read error: 110 (Connection timed out)) [21:10] *** MartinCleaver_ has joined #tikiwiki [21:16] *** MartinCleaver_ has quit IRC () [21:27] tikiwiki: 03kissaki * r20444 10/trunk/db/tiki.sql: quote table names in PRIMARY KEY definitions with ` [21:27] *** MartinCleaver has quit IRC (Read error: 110 (Connection timed out)) [21:29] *** Redhatter has joined #tikiwiki [21:31] *** nkoth3 has quit IRC () [21:31] *** danopia` has joined #tikiwiki [21:33] *** MatWho has quit IRC () [21:39] *** danopia has quit IRC (Network is unreachable) [21:39] *** danopia has joined #tikiwiki [21:43] euh.. primary key is for unicity [21:44] uniqueness? [21:44] Kissaki: not to put the `` was a choice at thebeginning as everybody was forgetting... [21:44] *** idle- has quit IRC (Remote closed the connection) [21:45] is there a reason for that? [21:45] SEWilco2: perhaps.. my ENglish is bad [21:45] *** idle- has joined #tikiwiki [21:45] Actually, it is English that is bad. :-) [21:45] sylvieg: in your last commit you used an already in use pk, I changed it [21:46] thx Kissaki (I am always bad in commit db because I test by copy . paste ) [21:46] :) [21:46] I just tested my changed sql script and became an error... so I wondered [21:46] and found there was another commit :P [21:47] so primary key ... I suppose it is to be sure thatn unique row that should have been test in php is really unique [21:47] primary key = unique + index (key in mysql terms as well) [21:48] well, using a unique key you don't even have to check for uniqieness in php... that's one of the good things. But normally you INSERT without specifying a primary key anyway, and let the db handle it... [21:48] *** danopia` has quit IRC (Connection timed out) [21:49] somehow my local phpmyadmin is fucked up now... [21:49] shit [21:50] *** danopia` has joined #tikiwiki [21:51] Kissaki: but we do not want to see a db error - because not friendly + security [21:51] yeah, that's why you don't insert with pk anyway... and probably you/tiki doesn't even now :) [21:51] (outside that sql script) [21:53] but is primary key more efficient than other index? [21:58] *** danopia has quit IRC (Network is unreachable) [22:01] for me it makes sense to use primary key for id ... and to use index for others - but I am not an expert [22:10] tikiwiki: 03lphuberdeau * r20445 10/branches/experimental/perms-take2/ (33 files in 20 dirs): [MRG] Automatic merge, trunk 20436 to 20444 [22:12] *** cheal has joined #tikiwiki [22:19] lph: can you activate the php error - I have the notice lib/core/Perms.php lien 157 undefined index permName .... very often [22:19] I have also a list_pages as anonymous Input Array does not match ?: SELECT categId, itemId FROM tiki_category_objects INNER JOIN tiki_objects ON catObjectId = objectId WHERE type = 'wiki page' AND itemId IN( ':/ [22:23] hum... permName is not anywhere in that file [22:25] it is 2 notice for each page [22:25] * sylvieg goes in the trace (since I have xdebug :-)) [22:27] polom :) [22:27] sylvieg: congrats ! :) [22:27] tikiwiki: 03lphuberdeau * r20446 10/branches/experimental/perms-take2/lib/tikilib.php: [FIX] Typo [22:27] * sylvieg still has to setup the debugger but trace and profiling are great [22:27] should be fixed [22:28] * sylvieg looking for this since 20mn and lph arrives .. 2 secs ... thx [22:29] working thx lphuberdeau1 :-) [22:31] sylvieg: there's no difference between primary key and index, index-wise [22:31] but speed in a search? [22:31] no [22:32] pk = index + unique [22:32] searching only for one can be faster than searching for n of the same kind.. no? [22:32] the theory says the primary key is the physical ordering [22:32] that may depend on database engine, but shouldn't really make a difference [22:33] also impacts the default ordering [22:34] your point Kissaki - was to change primary key to index? [22:34] no ^^ [22:34] that would really make no sense [22:35] it was only because I ... 3 letter one of my commit - and you wanted to tease me ? :-) [22:37] * sylvieg needs to refresh database theory [22:38] ^^ [22:38] well, I just wanted to check if you did not know what to do or just oversaw it [22:38] and all that came after that... was some talking... [22:39] :-) [22:44] lphuberdeau1: I understood the problem I have a pagename with a ' and it is not \ somewehre in buulk [22:44] *** SEWilco2 has quit IRC ("Leaving.") [22:44] I destroyed my local mysql :( [22:44] lph soory [22:44] hmm... escaping should have been done [22:44] ' in page name should not cause problems [22:44] no I was wrong [22:45] yes I was wrong [22:46] this is the messy query http://pastey.net/119316 [22:54] tikiwiki: 03kissaki * r20448 10/trunk/db/tiki.sql: column-quotes on keys [22:56] *** Lucymoz has quit IRC (Read error: 110 (Connection timed out)) [22:57] tikiwiki: 03kissaki * r20449 10/trunk/db/ (4 files): converted scripts [23:00] almost got it lphuberdeau1 I have a pagename with a ? and the $db->in does not escape ? [23:00] it is why we have bindvars... [23:01] ultimately, ? is not part of sql [23:01] the query in bulkLoadCategories [23:01] one page name with ? and ... [23:02] little too late to fix this, but send me a reminder email [23:02] ok [23:02] (late as in 1 AM) [23:02] good night - thx for the help [23:05] * sylvieg thinks we should have a video - would like to see all the beds in a small plce and hot weather... [23:10] *** marclaporte has joined #tikiwiki [23:12] polom [23:18] good night all [23:24] tikiwiki: 03kissaki * r20450 10/trunk/db/ (6 files in 2 dirs): updated pgsql convert script [23:26] *** MartinCleaver has joined #tikiwiki [23:28] Kissaki: : ping [23:29] Kissaki: you seem to be progressing really well on tiki.sql did you have any thought yet on the upgrade scripts? [23:29] yo [23:29] yes [23:29] I'm doing that on tiki.sql especially to ease conversion :) [23:29] seems good right now, I'm currently on indices [23:30] I am ready to test on http://demo.tikiwiki.org/postgresql/tiki-install.php as soon as you say so [23:34] Kissaki: marclaporte is one of the dev.tw.o admins [23:34] *** cheal is now known as chealer [23:36] :) [23:36] how did you know I wanted to ask him? [23:36] (in qry) [23:39] so.... [23:39] Registered users can't edit tracker items on dev.tw.o [23:40] :) [23:40] not all [23:40] Is this a feature or a bug? [23:40] as I said, those having ppl associated by "submitted by", I can't edit [23:40] but you can comment? [23:41] yes [23:41] wrote about that some days ago here... hmm [23:41] wait, I'll get you 2 items [23:41] Kissaki: I saw your public query in logs [23:41] my what? [23:42] Kissaki: when you asked in public [23:42] what? when? [23:42] you mean about that? [23:42] now my ff crashed... [23:42] Kissaki: yes [23:42] are you admin as well? [23:43] Kissaki: no [23:44] oO [23:44] http://dev.tikiwiki.org/tiki-view_tracker.php?trackerId=5&status=o&sort_mode=f_41_desc&filterfield=54&&&&&&filtervalue[56]=Accepted&&offset=1300 [23:44] * marclaporte just made chealer Admin on tikiwiki.org and dev.tw.o [23:44] haha [23:44] oO [23:44] so he lied to me! [23:44] this I can't edit: http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=2559 [23:45] marclaporte: I guess it's a bad idea to grant everyone the permission to edit trackers as there's no history. in theory anyway, for security. [23:45] Kissaki: sorry about that, I can't control marclaporte [23:45] chealer: : perhaps kissaki can be added to dev group? [23:46] tracker definitely needs a rework... [23:48] *** SEWilco2 has joined #tikiwiki [23:53] he doesn't want me :) [23:53] Kissaki: you're now in the Developers group [23:53] oh, thank you :) [23:53] what changes for me? [23:53] is that on dev.tw.o? [23:53] Kissaki: you should be able to edit trackers [23:53] k [23:53] Kissaki: it applies on dev.tw.o, yes [23:57] so, do we use open/pending/closed? [23:57] or just resolution status? [23:58] Kissaki: both [23:59] hm [23:59] why not hide status then? ^^ [23:59] and just use resolution status