[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] <luciash> polom polom from late night Barcelona :) [01:13] *** rux__ has joined #tikiwiki [01:13] <rux__> hi everybody [01:14] <rux__> any italian here ? [01:14] <rux__> i'm looking for an adjurned language file [01:15] <marclaporte> up to date? [01:15] <rux__> yes [01:15] <rux__> the official one is of 2004 [01:16] <rux__> http://tikiwiki.org/LanguageItalian For Tikiwiki (version): 1.9 rc3 (CVS) [01:17] <rux__> i suppose others have my same problem [01:18] <rux_> then i have also another question about drop down menu [01:18] <rux_> http://www.reteviva.org [01:19] <luciash> rux_: it's easy to update the language.php file and contribute back ;) [01:19] <rux_> 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] <rux_> I know is easy but if someone has already done it is unesefulll ;) [01:20] <luciash> yep, i don't know any italian user actually [01:30] <luciash> rux_: disable top menu on Admin > Look and Feel ? [01:33] <rux_> yes it was [01:33] <rux_> thank's [01:43] *** franck has quit IRC () [01:47] *** Caarrie|away is now known as Caarrie [01:53] <marclaporte> rux_: latest language file is the one in source (not on wiki page) [01:56] *** SEWilco2 has joined #tikiwiki [02:09] <CIA-57> 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] <CIA-57> tikiwiki: 03sylvieg * r20435 10/trunk/db/ (6 files): sync [02:23] <CIA-57> 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] <Tikiwiki|bot> 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] <wookienz> 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] <wookienz> 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] <wookienz> can i go and change this by itself or is a whoe new downlaod required/ [06:54] <wookienz> ANYONE ON LINE THAT CAN DO SOME MYSQL cli TROUBLESHOOTIGN FOR ME [06:54] <wookienz> ? [06:54] <wookienz> opps sorry about that [07:23] <wookienz> 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] <Natrhon> 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] <Natrhon> how can I do a "SELECT *" query? [09:24] <Natrhon> I need all the fields of all the rows on a table... [09:25] *** Wilkins has joined #tikiwiki [09:33] <wookienz> you logged into the CLI? [09:33] <wookienz> SELECT * FROM tablename [09:37] <Natrhon> $query = "SELECT * FROM `gains_facilities` ORDER BY `facilityID` DESC"; [09:37] <Natrhon> $result = $this->query($query); [09:38] <Natrhon> this will give an error [09:45] <Natrhon> "SELECT * FROM `gains_facilities` WHERE `owner` = ?" [09:45] <Natrhon> $values[] = "someone" [09:46] <Natrhon> $result = $this->query($query,$values); [09:46] <Natrhon> 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] <Natrhon> is there someone who can answer my question ? :D [11:21] <wookienz> there is a question in there? [11:21] <wookienz> -? +! [11:23] <Natrhon> I am able to invoke the query function with [11:23] <Natrhon> "SELECT * FROM `gains_facilities` WHERE `owner` = ?" [11:23] *** marclaporte has joined #tikiwiki [11:23] <Natrhon> $values[] = "someone"; [11:24] <Natrhon> $result = $this->query($query,$values); [11:24] <Natrhon> this works [11:24] <Natrhon> why this cannot work? : [11:24] <Natrhon> $query = "SELECT * FROM `gains_facilities` ORDER BY `facilityID` DESC"; [11:24] <Natrhon> ? [11:25] <Natrhon> 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] <CIA-57> 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] <wookienz> SELECT * FROM tablename will give you all row [11:55] <wookienz> s [11:55] <wookienz> but you want it ordered/ [11:55] <wookienz> ? [12:02] <Natrhon> no at the moment, but if I make $query="SELECT * FROM tablename" and then $result=$this->query($query); [12:02] <Natrhon> it gives me an error message [12:03] <Natrhon> I've tried many combinations, and the ordered oone above was one of them... [12:05] <wookienz> hmm well beats me should work. [12:12] <Natrhon> 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] <Natrhon> 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] <luciash> 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] <Floh1111_> 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] <CIA-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] <ricks99> 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] <ricks99> hm... i guess not [15:29] <sylvieg> no [15:29] <sylvieg> but the perm will be checked [15:30] <CIA-57> tikiwiki: 03sylvieg * r20439 10/trunk/templates/tiki-admin-include-wysiwyg.tpl: [FIX]layout: enlarge the textarea [15:41] <ricks99> right but tiki will only show the "main"page's cateogory in the catpath [15:50] *** pascalstjean has joined #tikiwiki [15:57] <wookienz> ricks99: still around? [15:58] <ricks99> yup [15:59] <wookienz> hiya, i see you name throughout variouis places on tikiwiki project so i assume yo uare in the know! [15:59] <wookienz> 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] <wookienz> and there is a patch here: http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki/branches/proposed/lib/userslib.php?r1=19222&r2=19413 [16:01] <wookienz> 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] <ricks99> sorry, i don't. what is ur mysql version? [16:02] <ricks99> fwiw, i haven't had issues creating groups in my 3.x tikis [16:02] <wookienz> 5.2.8 [16:02] *** Caarrie|away is now known as Caarrie [16:02] <ricks99> not sure. bug says fixed in 3.1? [16:02] <wookienz> i dont have root access, im relying on some other turkeys setting it up right. so they might have screwed up install. [16:03] <wookienz> yeah similar bug - ie there is an error but it iwhen i use the "perms" function [16:03] <ricks99> is this a new install? or upgrade from 2.x? [16:04] <wookienz> i think an upgrade from 2.x - here is the error [16:04] <wookienz> http://pastey.net/119283 [16:05] <ricks99> and there were no errors during the upgrade sql, right? [16:05] <wookienz> well thats what i dont know. [16:06] <ricks99> i'm not much help on this, sorry [16:06] <wookienz> someone else upgraded it... can i do a db update or the like? [16:06] <ricks99> rerun the tiki-install.php and re-update the db, if needed [16:07] <sylvieg> if you have a phpMyadmin - we can know more about the error [16:07] <ricks99> sylvieg can probably help more than i can [16:07] <sylvieg> it can be eitheir your table need to be repear .. or the perm exists already [16:08] <wookienz> will an [16:08] <wookienz> update" wipe the databse? [16:08] * sylvieg needs to fix why the error message does not show up anymore [16:08] <wookienz> phpmyadmin isnt installed so i can run it manually [16:09] <sylvieg> yeh run the same query manually to see the error [16:09] <wookienz> i wish icould...but cant. [16:10] <wookienz> does running install.php jut re run and correct db options or does it start again, ie wipe DB? [16:10] <ricks99> running the upgrade shouldn't mess with your data -- only table structure [16:10] <wookienz> ok [16:11] <ricks99> make sure you select UPGRADE and not INSTALL (which *will* wipe your data) [16:11] <wookienz> ok great... [16:14] <wookienz> got to run! [16:14] *** wookienz has quit IRC ("ChatZilla 0.9.85 [Firefox 3.5.1/20090715094852]") [16:18] <CIA-57> 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] <MacLeod> What tools do y'all use to probe and edit the MySQL database directly? [16:31] <Landon> i use Mysql Administrator and Mysql Query Browser [14:28] *** pascalstjean has quit IRC (Read error: 104 (Connection reset by peer)) [14:29] <MacLeod> 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] <xavi1> toctoc... [14:54] <Kissaki> toc [14:55] <xavi1> trying the last minute (hour, in fact) things for the kick off meeting at the http://tikiwiki.org/TikiFestBarcelona [14:55] <xavi1> video streaming is on, already, even if not good audio yet :-/ [15:00] <Kissaki> ohoo [15:04] <xavi1> kissaki marc here are you coming [15:05] <xavi1> bring a mattress [15:05] <Kissaki> ^^ no [15:05] <Kissaki> 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] <marclaporte> polom [15:07] * marclaporte is no longer squatting xavi1's computer [15:07] <marclaporte> Kissaki: Europeans don't know what "far" means! [15:08] <marclaporte> ask Russians or Canadians :-) [15:09] <idle-> marclaporte: yes driving 6 hours for going out to lunch isn't that possible with 1,40 euros per liter gas. [15:09] <Kissaki> ^^ [15:09] <Kissaki> true [15:09] <Kissaki> esp. me [15:09] <Kissaki> (doesn't know what far is) [15:09] <Kissaki> *means [15:10] <sylvieg> 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] <matwho> 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] <tobi_h> polom :) [15:58] <tobi_h> could it be that the video is stuck? [15:59] *** Caarrie|away is now known as Caarrie [15:59] <tobi_h> sound works - good horn outside... ;) [16:00] <nkoth3> same observation - sound good, video stuck [16:00] *** rodrigo_sampaio has joined #tikiwiki [16:01] <nkoth3> I need food, back soon :) [16:01] <tobi_h> ;) [16:02] <tobi_h> xavi: assuming you are at the place of the meeting - can you do anything about the video? [16:04] <tobi_h> oh well - bbl... [16:04] *** tobi_h is now known as tobi_h|away [16:06] *** rlopez_ has joined #tikiwiki [16:15] <chealer> tobi_h|away: it's stuck, indeed [16:16] <chealer> tobi_h|away: we're still working on streaming. there are a few issues. [16:24] *** rlopez_ has quit IRC ("Leaving") [16:41] <xavi> mmmm, still fighting with the audio and video, but things seem to improve... [16:41] <xavi> soon, we should have somme stream on, live... [16:41] <xavi> let's cross fingers :-) [16:41] <xavi> stay tuned :-) [16:42] <nkoth3> k [16:42] <CIA-57> 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] <xavi> hello again [17:18] <xavi> we are starting now, with or without streaming [17:18] <nkoth3> k [17:18] *** Redhatter has quit IRC (Read error: 113 (No route to host)) [17:18] <nkoth3> streaming works for me [17:19] <xavi> and audio, nkoth? [17:19] <xavi> nkoth3: ^ [17:20] <nkoth3> seems ok, say somethig [17:20] <nkoth3> i hear a lot of background talking (can't make out the words) [17:20] <nkoth3> yes [17:20] <xavi> yes, that's the problem [17:20] <xavi> but we start anyway [17:21] *** MacLeod has joined #tikiwiki [17:21] <xavi> we couldn't plug the good mattbic mic on a powerful computer in time [17:21] <xavi> so we start without it [17:21] <nkoth3> ah, i see [17:21] <xavi> the sound is bad (my own old webcam) on my old laptop, but at least we can have some video out [17:22] <xavi> and if nobody is able to have the audio from mattbic working, fine. else we have some video at least [17:22] <cheal> SEWilco2: it was indeed a comments bug (2611) [17:22] <xavi> and some off line good video and audio recording also [17:28] *** jonnyb has joined #tikiwiki [17:40] *** jonnyb has quit IRC () [18:03] <sylvieg> I do not see how perspectives can work only on prefs and not on categ and groups too... [18:04] <sylvieg> ok if it is freedom [18:04] <nkoth3> 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] <sylvieg> xavi move a little bit [18:05] <nkoth3> why not put the white board at the other end of the room, xavi? [18:10] <SEWilco2> cheal: Bug not found. http://dev.tikiwiki.org/tiki-searchresults.php?highlight=2611&search=Go [18:23] <SEWilco2> 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] <SEWilco2> Oh, there it is. Streaming is above the table of contents, in a section which has to be expanded to be visible. [18:29] <SEWilco2> Inaudible. Stream is only useful for images of a white shirt and action shots of a fan. [18:30] <sylvieg> +1 for xavi move [18:34] <xavi> :-) [18:34] <xavi> it took a while to able to come to my computer (out of the room), and read the irc messages [18:35] <nkoth3> 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] <xavi> anyway, you can't read the whiteboard [18:36] <xavi> 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] <SEWilco2> 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] <xavi> you'll probably have to wait for the videos uploaded (from separated and better camera) to get better audio and image quality [18:38] <SEWilco2> Separated cameras? 3D TikiFest? :-) [18:38] <xavi> and without my the back of my t-shirt in front [18:38] *** Caarrie is now known as Caarrie|away [18:38] <xavi> It was not planed to be done like this... [18:38] <SEWilco2> Yes, I see there is no plane. [18:38] <xavi> but the palns didn't work as expexcted, unluckily [18:38] <SEWilco2> Wait, I can sketch a plane on the shirt. [18:39] <SEWilco2> 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] <Kissaki> mömömömöp [19:12] <sylvieg> I made a test on my local trunk versus perms-take2 [19:12] <sylvieg> 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] <sylvieg> perms [ Execution time: 1.18 secs ] [ Memory usage: 22.27MB ] [ 749 database queries used in 0.2 secs ] [ Server load: 0.37 ] [19:13] <Tikiwiki|bot> 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] <Tikiwiki|bot> 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] <Bandari> hello guys [19:15] <Bandari> I have a problem with tikiwiki installations - I would appreciate your help [19:15] <Bandari> Here is my problem: [19:15] <Bandari> Profiles are not showing right after the DB configuration [19:16] <Bandari> I have finished installation with defult profile installation. [19:16] *** rodrigo_sampaio1 has quit IRC ("Leaving.") [19:17] <sylvieg> 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] <Bandari> Using Admin (tikiwiki's) console - I tried creating profiles. - no success. [19:17] <sylvieg> loui philippe? in whick list something did you imopletement your fetchall I think... the global perms check? [19:17] <Bandari> Yes - I do have internet [19:17] <Bandari> my system got connected to internet - [19:18] <Bandari> I am on windows environment. [19:19] <Bandari> Please do suggest me - where I went wrong? [19:19] <sylvieg> sorry windows no idea..... [19:19] <nkoth3> what do you mean "not showing"? [19:19] <sylvieg> in my acse it is a system bug - it took me months to find it out.. [19:19] <Bandari> list of profiles are not showing [19:19] <sylvieg> you need to have the getsocket function working [19:20] <nkoth3> firewall? (wild guess) [19:20] <Bandari> getsocket function - means? [19:20] <Bandari> no firewalls [19:20] <Bandari> I can browse internet from the same system [19:21] <sylvieg> it does not prove anything - a browser is not like a server [19:21] <cheal> sylvieg: lph doesn't understaned your question [19:22] <sylvieg> he did some query - where all the perms are checked on all the objects of a list [19:22] <sylvieg> right? [19:22] <Bandari> (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] <Bandari> yes [19:22] <cheal> sylvieg: he says yes [19:22] <sylvieg> in which list did he implement that? [19:23] <sylvieg> list_pages? [19:23] <Bandari> profiles [19:23] <cheal> grep for Perms::filter [19:23] <sylvieg> thx cheal [19:23] <cheal> sylvieg: yeah, that was all from lph [19:24] <Bandari> Kindly suggest me [19:25] <sylvieg> Bandari: did you get to admin->profiles ... is it working there? [19:25] <Bandari> Admin -> Profiles - page came [19:25] *** MartinCleaver has joined #tikiwiki [19:25] <sylvieg> so it is only a problem in the installer? [19:26] <Bandari> and trying to install profile...it is not showing the profiles listed [19:27] <Bandari> repository = http://profiles.tikiwiki.org/profiles [19:27] <Bandari> My tikiwiki installation is unable to pick the profiles from the repository [19:28] <Bandari> 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] <sylvieg> tiki-admin.php?page=login [19:29] *** FrankP_german has joined #tikiwiki [19:38] <Bandari> Please help me on profiles [19:38] <xavi> finished for today [19:38] <xavi> at the tikifest [19:38] <xavi> people went for food [19:38] <xavi> we'll upload some pictures from today, and go also [19:38] <Bandari> Repository URLs:http://profiles.tikiwiki.org/profiles [19:39] <xavi> we hope that during the weekend we can solve the issues with the audio and video [19:40] <sylvieg> Bandari: I am pretty sure it is a problem with your system [19:42] *** floh1111 has quit IRC (Remote closed the connection) [19:42] <Bandari> Please do suggest me - which areas I have to look / check [19:44] <sylvieg> Bandari: is a simple progrm like $url = 'http://profiles.tikiwiki.org/profiles';var_dump(file_get_contents( $url )); [19:47] <Bandari> do you want me to check this url? [19:47] <sylvieg> can you do a php program that checks this? [19:48] <sylvieg> 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] <Bandari> let me try [19:55] *** xavi has left [19:58] <Bandari> 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] <Bandari> Hello <sylvieg> : here is the error [19:59] <Bandari> 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] <Bandari> allow_url_fopen = On -- in my php.in file [20:03] <Bandari> do we require any configurations with php for proxy authentication? [20:03] <sylvieg> 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] <Bandari> 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] <MatWho> How is Barcelona? [20:32] *** Bandari has quit IRC ("Page closed") [20:40] <CIA-57> tikiwiki: 03kissaki * r20442 10/trunk/db/tiki.sql: add `s to CREATE TABLE and DROP TABLE statements [20:45] <Kissaki> wth [20:48] *** FrankP_german has quit IRC ("Nettalk6 - www.ntalk.de") [20:48] <Kissaki> svn is so damn fucking slow... [20:50] <Kissaki> hahaha [20:50] <Kissaki> sylvieg? [20:51] <Kissaki> uh, he's in this chan, nice! [20:52] <Kissaki> 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] <CIA-57> 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] <CIA-57> 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] <sylvieg> euh.. primary key is for unicity [21:44] <SEWilco2> uniqueness? [21:44] <sylvieg> 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] <Kissaki> is there a reason for that? [21:45] <sylvieg> SEWilco2: perhaps.. my ENglish is bad [21:45] *** idle- has joined #tikiwiki [21:45] <SEWilco2> Actually, it is English that is bad. :-) [21:45] <Kissaki> sylvieg: in your last commit you used an already in use pk, I changed it [21:46] <sylvieg> thx Kissaki (I am always bad in commit db because I test by copy . paste ) [21:46] <Kissaki> :) [21:46] <Kissaki> I just tested my changed sql script and became an error... so I wondered [21:46] <Kissaki> and found there was another commit :P [21:47] <sylvieg> 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] <Kissaki> primary key = unique + index (key in mysql terms as well) [21:48] <Kissaki> 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] <Kissaki> somehow my local phpmyadmin is fucked up now... [21:49] <Kissaki> shit [21:50] *** danopia` has joined #tikiwiki [21:51] <sylvieg> Kissaki: but we do not want to see a db error - because not friendly + security [21:51] <Kissaki> yeah, that's why you don't insert with pk anyway... and probably you/tiki doesn't even now :) [21:51] <Kissaki> (outside that sql script) [21:53] <sylvieg> but is primary key more efficient than other index? [21:58] *** danopia has quit IRC (Network is unreachable) [22:01] <sylvieg> 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] <CIA-57> 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] <sylvieg> lph: can you activate the php error - I have the notice lib/core/Perms.php lien 157 undefined index permName .... very often [22:19] <sylvieg> 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] <lphuberdeau1> hum... permName is not anywhere in that file [22:25] <sylvieg> it is 2 notice for each page [22:25] * sylvieg goes in the trace (since I have xdebug :-)) [22:27] <luciash> polom :) [22:27] <luciash> sylvieg: congrats ! :) [22:27] <CIA-57> 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] <lphuberdeau1> should be fixed [22:28] * sylvieg looking for this since 20mn and lph arrives .. 2 secs ... thx [22:29] <sylvieg> working thx lphuberdeau1 :-) [22:31] <Kissaki> sylvieg: there's no difference between primary key and index, index-wise [22:31] <sylvieg> but speed in a search? [22:31] <Kissaki> no [22:32] <Kissaki> pk = index + unique [22:32] <sylvieg> searching only for one can be faster than searching for n of the same kind.. no? [22:32] <lphuberdeau1> the theory says the primary key is the physical ordering [22:32] <Kissaki> that may depend on database engine, but shouldn't really make a difference [22:33] <lphuberdeau1> also impacts the default ordering [22:34] <sylvieg> your point Kissaki - was to change primary key to index? [22:34] <Kissaki> no ^^ [22:34] <Kissaki> that would really make no sense [22:35] <sylvieg> 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] <Kissaki> ^^ [22:38] <Kissaki> well, I just wanted to check if you did not know what to do or just oversaw it [22:38] <Kissaki> and all that came after that... was some talking... [22:39] <sylvieg> :-) [22:44] <sylvieg> 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] <Kissaki> I destroyed my local mysql :( [22:44] <sylvieg> lph soory [22:44] <lphuberdeau1> hmm... escaping should have been done [22:44] <lphuberdeau1> ' in page name should not cause problems [22:44] <sylvieg> no I was wrong [22:45] <sylvieg> yes I was wrong [22:46] <sylvieg> this is the messy query http://pastey.net/119316 [22:54] <CIA-57> 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] <CIA-57> tikiwiki: 03kissaki * r20449 10/trunk/db/ (4 files): converted scripts [23:00] <sylvieg> almost got it lphuberdeau1 I have a pagename with a ? and the $db->in does not escape ? [23:00] <sylvieg> it is why we have bindvars... [23:01] <lphuberdeau1> ultimately, ? is not part of sql [23:01] <sylvieg> the query in bulkLoadCategories [23:01] <sylvieg> one page name with ? and ... [23:02] <lphuberdeau1> little too late to fix this, but send me a reminder email [23:02] <sylvieg> ok [23:02] <lphuberdeau1> (late as in 1 AM) [23:02] <sylvieg> 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] <marclaporte> polom [23:18] <luciash> good night all [23:24] <CIA-57> tikiwiki: 03kissaki * r20450 10/trunk/db/ (6 files in 2 dirs): updated pgsql convert script [23:26] *** MartinCleaver has joined #tikiwiki [23:28] <marclaporte> Kissaki: : ping [23:29] <marclaporte> Kissaki: you seem to be progressing really well on tiki.sql did you have any thought yet on the upgrade scripts? [23:29] <Kissaki> yo [23:29] <Kissaki> yes [23:29] <Kissaki> I'm doing that on tiki.sql especially to ease conversion :) [23:29] <Kissaki> seems good right now, I'm currently on indices [23:30] <marclaporte> I am ready to test on http://demo.tikiwiki.org/postgresql/tiki-install.php as soon as you say so [23:34] <cheal> Kissaki: marclaporte is one of the dev.tw.o admins [23:34] *** cheal is now known as chealer [23:36] <Kissaki> :) [23:36] <Kissaki> how did you know I wanted to ask him? [23:36] <Kissaki> (in qry) [23:39] <marclaporte> so.... [23:39] <marclaporte> Registered users can't edit tracker items on dev.tw.o [23:40] <Kissaki> :) [23:40] <Kissaki> not all [23:40] <marclaporte> Is this a feature or a bug? [23:40] <Kissaki> as I said, those having ppl associated by "submitted by", I can't edit [23:40] <marclaporte> but you can comment? [23:41] <Kissaki> yes [23:41] <Kissaki> wrote about that some days ago here... hmm [23:41] <Kissaki> wait, I'll get you 2 items [23:41] <chealer> Kissaki: I saw your public query in logs [23:41] <Kissaki> my what? [23:42] <chealer> Kissaki: when you asked in public [23:42] <Kissaki> what? when? [23:42] <Kissaki> you mean about that? [23:42] <Kissaki> now my ff crashed... [23:42] <chealer> Kissaki: yes [23:42] <Kissaki> are you admin as well? [23:43] <chealer> Kissaki: no [23:44] <Kissaki> oO [23:44] <Kissaki> 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] <Kissaki> haha [23:44] <Kissaki> oO [23:44] <Kissaki> so he lied to me! [23:44] <Kissaki> this I can't edit: http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=2559 [23:45] <chealer> 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] <chealer> Kissaki: sorry about that, I can't control marclaporte [23:45] <marclaporte> chealer: : perhaps kissaki can be added to dev group? [23:46] <Kissaki> tracker definitely needs a rework... [23:48] *** SEWilco2 has joined #tikiwiki [23:53] <Kissaki> he doesn't want me :) [23:53] <chealer> Kissaki: you're now in the Developers group [23:53] <Kissaki> oh, thank you :) [23:53] <Kissaki> what changes for me? [23:53] <Kissaki> is that on dev.tw.o? [23:53] <chealer> Kissaki: you should be able to edit trackers [23:53] <Kissaki> k [23:53] <chealer> Kissaki: it applies on dev.tw.o, yes [23:57] <Kissaki> so, do we use open/pending/closed? [23:57] <Kissaki> or just resolution status? [23:58] <chealer> Kissaki: both [23:59] <Kissaki> hm [23:59] <Kissaki> why not hide status then? ^^ [23:59] <Kissaki> and just use resolution status