<!-- 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 > 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&trackerId=5&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&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->query($query); <br> this will give an error <br> "SELECT * FROM `gains_facilities` WHERE `owner` = ?" <br> $values[] = "someone" <br> $result = $this->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->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->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&trackerId=5&show=view <br> and there is a patch here: http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki/branches/proposed/lib/userslib.php?r1=19222&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&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=&comments_parentId=34172 <br> New Forum Posts: How do I? Change the Upper Banner - http://tikiwiki.org/tiki-view_forum_thread.php?forumId=&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->profiles ... is it working there? Bandari: Admin -> 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 <sylvieg> : 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->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&status=o&sort_mode=f_41_desc&filterfield=54&&&&&&filtervalue[56]=Accepted&&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