[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