***: luminoso has quit IRC (Connection timed out)
marclaporte has joined #tikiwiki
Kissaki is now known as Kissaki^0ff luciash: polom polom from late night Barcelona :) ***: rux__ has joined #tikiwiki rux__: hi everybody
any italian here ?
i'm looking for an adjurned language file marclaporte: up to date? rux__: yes
the official one is of 2004
http://tikiwiki.org/LanguageItalian For Tikiwiki (version): 1.9 rc3 (CVS)
i suppose others have my same problem rux_: then i have also another question about drop down menu
http://www.reteviva.org luciash: rux_: 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
rux_: disable top menu on Admin > Look and Feel ? rux_: yes it was
thank's ***: franck has quit IRC ()
Caarrie|away is now known as Caarrie marclaporte: rux_: 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
tikiwiki: 03sylvieg * r20436 10/trunk/installer/schema/20090730_p_list_newsletters_tiki.sql: typo ***: franck_ has joined #tikiwiki
franck_ has quit IRC (Remote closed the connection)
franck_ has joined #tikiwiki
franck has quit IRC (Read error: 104 (Connection reset by peer))
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
eric91 has quit IRC ("Page closed")
Caarrie is now known as Caarrie|sleeping
marclaporte has quit IRC (Read error: 110 (Connection timed out))
MartinCleaver has joined #tikiwiki
franck_ has quit IRC ()
franck has joined #tikiwiki
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
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
can i go and change this by itself or is a whoe new downlaod required/
ANYONE ON LINE THAT CAN DO SOME MYSQL cli TROUBLESHOOTIGN FOR ME
?
opps sorry about that
must be sleeping! ***: rlopez_ has joined #tikiwiki
rlopez_ has quit IRC (Client Quit)
Natrhon has joined #tikiwiki
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...
how can I do a "SELECT *" query?
I need all the fields of all the rows on a table... ***: Wilkins has joined #tikiwiki wookienz: you logged into the CLI?
SELECT * FROM tablename Natrhon: $query = "SELECT * FROM `gains_facilities` ORDER BY `facilityID` DESC";
$result = $this->query($query);
this will give an error
"SELECT * FROM `gains_facilities` WHERE `owner` = ?"
$values[] = "someone"
$result = $this->query($query,$values);
this work perfectly... ***: floh1111 has joined #tikiwiki
Wilkins has quit IRC (farmer.freenode.net irc.freenode.net)
Wilkins has joined #tikiwiki Natrhon: is there someone who can answer my question ? :D wookienz: there is a question in there?
-? +! Natrhon: I am able to invoke the query function with
"SELECT * FROM `gains_facilities` WHERE `owner` = ?" ***: marclaporte has joined #tikiwiki Natrhon: $values[] = "someone";
$result = $this->query($query,$values);
this works
why this cannot work? :
$query = "SELECT * FROM `gains_facilities` ORDER BY `facilityID` DESC";
?
I need to select all the rows of a table ***: Lucymoz has quit IRC (Read error: 110 (Connection timed out))
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
s
but you want it ordered/
? Natrhon: no at the moment, but if I make $query="SELECT * FROM tablename" and then $result=$this->query($query);
it gives me an error message
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
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
rlopez_ has quit IRC (Client Quit) luciash: polom polom ***: Caarrie|sleeping is now known as Caarrie
marclaporte has quit IRC (Read error: 110 (Connection timed out))
MartinCleaver has joined #tikiwiki
lphuberdeau has quit IRC (Read error: 110 (Connection timed out))
rux_ has quit IRC (Ping timeout: 180 seconds)
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
MacLeod has joined #tikiwiki
lphuberdeau1 has joined #tikiwiki
chealer has joined #tikiwiki
MartinCleaver has quit IRC ()
franck has quit IRC (Read error: 113 (No route to host))
ricks99 has joined #tikiwiki
nkoth3 has joined #tikiwiki
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))
chealer has quit IRC (Read error: 110 (Connection timed out))
chealer_ is now known as chealer
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
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: ricks99: still around? ricks99: yup wookienz: hiya, i see you name throughout variouis places on tikiwiki project so i assume yo uare in the know!
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
and there is a patch here: http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki/branches/proposed/lib/userslib.php?r1=19222&r2=19413
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?
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.
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
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
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.
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...
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))
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: Landon: thx ***: rlopez_ has quit IRC ("Leaving")
Floh1111_ has quit IRC (Remote closed the connection)
SEWilco2 has quit IRC ("Leaving.")
Kissaki^0ff is now known as Kissaki
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
video streaming is on, already, even if not good audio yet :-/ Kissaki: ohoo xavi1: kissaki marc here are you coming
bring a mattress Kissaki: ^^ no
pretty far away here, in Germany... ***: marclaporte has joined #tikiwiki
MacLeod has quit IRC (Ping timeout: 180 seconds)
Wilkins has quit IRC (Remote closed the connection) marclaporte: polom -: marclaporte is no longer squatting xavi1's computer marclaporte: Kissaki: Europeans don't know what "far" means!
ask Russians or Canadians :-) idle-: marclaporte: yes driving 6 hours for going out to lunch isn't that possible with 1,40 euros per liter gas. Kissaki: ^^
true
esp. me
(doesn't know what far is)
*means sylvieg: sound good for me ***: pascalstjean has joined #tikiwiki
Caarrie is now known as Caarrie|away
matwho has joined #tikiwiki matwho: hi from Portugal ***: MatWho_ has joined #tikiwiki
matwho has left
MatWho_ has quit IRC (Client Quit)
SEWilco2 has joined #tikiwiki
xavi1 has quit IRC (Read error: 104 (Connection reset by peer))
chealer has quit IRC (Read error: 104 (Connection reset by peer))
lphuberdeau has quit IRC (Read error: 104 (Connection reset by peer))
marclaporte has quit IRC (Read error: 104 (Connection reset by peer))
chealer has joined #tikiwiki
marclaporte has joined #tikiwiki
shawn-ffbh has joined #tikiwiki
marclaporte has quit IRC (Read error: 104 (Connection reset by peer))
shawn-ffbh has quit IRC (Client Quit)
shawn-ffbh has joined #tikiwiki
lphuberdeau has joined #tikiwiki
xavi has joined #tikiwiki tobi_h: polom :)
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: ;)
xavi: assuming you are at the place of the meeting - can you do anything about the video?
oh well - bbl... ***: tobi_h is now known as tobi_h|away
rlopez_ has joined #tikiwiki chealer: tobi_h|away: it's stuck, indeed
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...
soon, we should have somme stream on, live...
let's cross fingers :-)
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))
lphuberdeau has quit IRC (Read error: 104 (Connection reset by peer))
xavi has quit IRC (Read error: 104 (Connection reset by peer))
lphuberdeau1 has joined #tikiwiki
rodrigo_sampaio1 has joined #tikiwiki
cheal has joined #tikiwiki
rodrigo_sampaio has quit IRC (Read error: 104 (Connection reset by peer))
chealer has quit IRC (Read error: 104 (Connection reset by peer))
xavi has joined #tikiwiki xavi: hello again
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?
nkoth3: ^ nkoth3: seems ok, say somethig
i hear a lot of background talking (can't make out the words)
yes xavi: yes, that's the problem
but we start anyway ***: MacLeod has joined #tikiwiki xavi: we couldn't plug the good mattbic mic on a powerful computer in time
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
and if nobody is able to have the audio from mattbic working, fine. else we have some video at least cheal: SEWilco2: it was indeed a comments bug (2611) xavi: and some off line good video and audio recording also ***: jonnyb has joined #tikiwiki
jonnyb has quit IRC () sylvieg: I do not see how perspectives can work only on prefs and not on categ and groups too...
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: cheal: Bug not found. http://dev.tikiwiki.org/tiki-searchresults.php?highlight=2611&search=Go
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
Oh, there it is. Streaming is above the table of contents, in a section which has to be expanded to be visible.
Inaudible. Stream is only useful for images of a white shirt and action shots of a fan. sylvieg: +1 for xavi move xavi: :-)
it took a while to able to come to my computer (out of the room), and read the irc messages 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 xavi: anyway, you can't read the whiteboard
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: 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. 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.
My sketching skills are good enough to make a plane with a Samantha Carter in it. ***: MacLeod has quit IRC (Ping timeout: 180 seconds)
RLJII has quit IRC ("Page closed") Kissaki: mömömömöp sylvieg: I made a test on my local trunk versus perms-take2
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 ]
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
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
I have a problem with tikiwiki installations - I would appreciate your help
Here is my problem:
Profiles are not showing right after the DB configuration
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
my system got connected to internet -
I am on windows environment.
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?
no firewalls
I can browse internet from the same system sylvieg: it does not prove anything - a browser is not like a server cheal: sylvieg: lph doesn't understaned your question sylvieg: he did some query - where all the perms are checked on all the objects of a list
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.
yes cheal: sylvieg: he says yes sylvieg: in which list did he implement that?
list_pages? Bandari: profiles cheal: grep for Perms::filter sylvieg: thx cheal cheal: sylvieg: yeah, that was all from lph Bandari: Kindly suggest me sylvieg: Bandari: 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
repository = http://profiles.tikiwiki.org/profiles
My tikiwiki installation is unable to pick the profiles from the repository
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
at the tikifest
people went for food
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: Bandari: 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: Bandari: 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?
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: 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:websitestikiwikitest-connection.php on line 3 bool(false)
Hello <sylvieg> : here is the error
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:websitestikiwikitest-connection.php on line 3 bool(false)
allow_url_fopen = On -- in my php.in file
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
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...
hahaha
sylvieg?
uh, he's in this chan, nice!
sylvieg: are you familiar with primary keys in dbs and it was just an oversight? ***: arrowsama has joined #tikiwiki
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))
MartinCleaver_ has joined #tikiwiki
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))
Redhatter has joined #tikiwiki
nkoth3 has quit IRC ()
danopia` has joined #tikiwiki
MatWho has quit IRC ()
danopia has quit IRC (Network is unreachable)
danopia has joined #tikiwiki sylvieg: euh.. primary key is for unicity SEWilco2: uniqueness? sylvieg: Kissaki: 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: SEWilco2: perhaps.. my ENglish is bad ***: idle- has joined #tikiwiki SEWilco2: Actually, it is English that is bad. :-) Kissaki: sylvieg: 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: :)
I just tested my changed sql script and became an error... so I wondered
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)
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...
shit ***: danopia` has joined #tikiwiki sylvieg: Kissaki: 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 :)
(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: lph: can you activate the php error - I have the notice lib/core/Perms.php lien 157 undefined index permName .... very often
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 :)
sylvieg: 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: sylvieg: there's no difference between primary key and index, index-wise sylvieg: but speed in a search? Kissaki: no
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 ^^
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: ^^
well, I just wanted to check if you did not know what to do or just oversaw it
and all that came after that... was some talking... sylvieg: :-)
lphuberdeau1: 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
' in page name should not cause problems sylvieg: no I was wrong
yes I was wrong
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 ?
it is why we have bindvars... lphuberdeau1: ultimately, ? is not part of sql sylvieg: the query in bulkLoadCategories
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: Kissaki: : ping
Kissaki: you seem to be progressing really well on tiki.sql did you have any thought yet on the upgrade scripts? Kissaki: yo
yes
I'm doing that on tiki.sql especially to ease conversion :)
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: Kissaki: marclaporte is one of the dev.tw.o admins ***: cheal is now known as chealer Kissaki: :)
how did you know I wanted to ask him?
(in qry) marclaporte: so....
Registered users can't edit tracker items on dev.tw.o Kissaki: :)
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
wrote about that some days ago here... hmm
wait, I'll get you 2 items chealer: Kissaki: I saw your public query in logs Kissaki: my what? chealer: Kissaki: when you asked in public Kissaki: what? when?
you mean about that?
now my ff crashed... chealer: Kissaki: yes Kissaki: are you admin as well? chealer: Kissaki: no Kissaki: oO
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
oO
so he lied to me!
this I can't edit: http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=2559 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.
Kissaki: sorry about that, I can't control marclaporte marclaporte: chealer: : 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: Kissaki: you're now in the Developers group Kissaki: oh, thank you :)
what changes for me?
is that on dev.tw.o? chealer: Kissaki: you should be able to edit trackers Kissaki: k chealer: Kissaki: it applies on dev.tw.o, yes Kissaki: so, do we use open/pending/closed?
or just resolution status? chealer: Kissaki: both Kissaki: hm
why not hide status then? ^^
and just use resolution status