<!-- Some styling for better description lists --><style type='text/css'>dt { font-weight: bold;float: left;display:inline;margin-right: 1em} dd { display:block; margin-left: 2em}</style>

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