#tikiwiki 2009-07-31,Fri

(Click on time to select a line by its url)

Who	What	When
***	wookienz has joined #tikiwiki	[00:02]
	luminoso has quit IRC (Connection timed out)	[00:08]
............. (idle for 1h1mn)
	marclaporte has joined #tikiwiki Kissaki is now known as Kissaki^0ff	[01:09]
luciash	polom polom from late night Barcelona :)	[01:13]
***	rux__ has joined #tikiwiki	[01:13]
rux__	hi everybody any italian here ? i'm looking for an adjurned language file	[01:13]
marclaporte	up to date?	[01:15]
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	[01:15]
rux_	then i have also another question about drop down menu http://www.reteviva.org	[01:18]
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:19]
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:20]
	rux_: disable top menu on Admin > Look and Feel ?	[01:30]
rux_	yes it was thank's	[01:33]
***	franck has quit IRC () Caarrie\|away is now known as Caarrie	[01:43]
marclaporte	rux_: latest language file is the one in source (not on wiki page)	[01:53]
***	SEWilco2 has joined #tikiwiki	[01:56]
CIA-57	tikiwiki: 03sylvieg * r20434 10/trunk/ (4 files in 4 dirs): [MOD]newsletter: new perm tiki_p_list_newsletters	[02:09]
***	franck has joined #tikiwiki	[02:10]
CIA-57	tikiwiki: 03sylvieg * r20435 10/trunk/db/ (6 files): sync	[02:11]
	tikiwiki: 03sylvieg * r20436 10/trunk/installer/schema/20090730_p_list_newsletters_tiki.sql: typo	[02:23]
***	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))	[02:26]
.... (idle for 15mn)
	luminoso has joined #tikiwiki	[02:42]
.......... (idle for 47mn)
Tikiwiki\|bot	Info: Follow @TikiWiki_org on Twitter - http://info.tikiwiki.org/tiki-read_article.php?articleId=69	[03:29]
....... (idle for 31mn)
***	eric91 has joined #tikiwiki	[04:00]
	eric91 has quit IRC ("Page closed")	[04:10]
	Caarrie is now known as Caarrie\|sleeping	[04:23]
...... (idle for 25mn)
	marclaporte has quit IRC (Read error: 110 (Connection timed out))	[04:48]
......... (idle for 43mn)
	MartinCleaver has joined #tikiwiki franck_ has quit IRC ()	[05:31]
	franck has joined #tikiwiki	[05:42]
...... (idle for 26mn)
	MartinCleaver has quit IRC ()	[06:08]
...... (idle for 27mn)
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/	[06:35]
.... (idle for 18mn)
	ANYONE ON LINE THAT CAN DO SOME MYSQL cli TROUBLESHOOTIGN FOR ME ? opps sorry about that	[06:54]
...... (idle for 29mn)
	must be sleeping!	[07:23]
................... (idle for 1h34mn)
***	rlopez_ has joined #tikiwiki rlopez_ has quit IRC (Client Quit)	[08:57]
..... (idle for 23mn)
	Natrhon has joined #tikiwiki luminoso has quit IRC ("Leaving")	[09:20]
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...	[09:23]
***	Wilkins has joined #tikiwiki	[09:25]
wookienz	you logged into the CLI? SELECT * FROM tablename	[09:33]
Natrhon	$query = "SELECT * FROM `gains_facilities` ORDER BY `facilityID` DESC"; $result = $this->query($query); this will give an error	[09:37]
	"SELECT * FROM `gains_facilities` WHERE `owner` = ?" $values[] = "someone" $result = $this->query($query,$values); this work perfectly...	[09:45]
....... (idle for 34mn)
***	floh1111 has joined #tikiwiki Wilkins has quit IRC (farmer.freenode.net irc.freenode.net)	[10:20]
	Wilkins has joined #tikiwiki	[10:28]
..... (idle for 21mn)
Natrhon	is there someone who can answer my question ? :D	[10:49]
....... (idle for 32mn)
wookienz	there is a question in there? -? +!	[11:21]
Natrhon	I am able to invoke the query function with "SELECT * FROM `gains_facilities` WHERE `owner` = ?"	[11:23]
***	marclaporte has joined #tikiwiki	[11:23]
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	[11:23]
***	Lucymoz has quit IRC (Read error: 110 (Connection timed out)) Floh1111_ has joined #tikiwiki	[11:25]
CIA-57	tikiwiki: 03lphuberdeau * r20437 10/branches/experimental/perms-take2/ (61 files in 28 dirs): [MRG] Automatic merge, trunk 20387 to 20436	[11:36]
.... (idle for 15mn)
***	lphuberdeau has joined #tikiwiki	[11:51]
wookienz	SELECT * FROM tablename will give you all row s but you want it ordered/ ?	[11:55]
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...	[12:02]
wookienz	hmm well beats me should work.	[12:05]
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:12]
	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:19]
....... (idle for 31mn)
***	rlopez_ has joined #tikiwiki rlopez_ has quit IRC (Client Quit)	[12:50]
luciash	polom polom	[12:57]
***	Caarrie\|sleeping is now known as Caarrie	[12:57]
.......... (idle for 48mn)
	marclaporte has quit IRC (Read error: 110 (Connection timed out))	[13:45]
.... (idle for 17mn)
	MartinCleaver has joined #tikiwiki	[14:02]
	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)	[14:13]
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:21]
***	Natrhon has left	[14:25]
	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	[14:32]
	nkoth3 has joined #tikiwiki chealer_ has joined #tikiwiki	[14:50]
CIA-57	tikiwiki: 03floh1111 * r20438 10/trunk/ (3 files in 3 dirs): removed code duplication on file_galleries module and fixed issues with prefs	[14:57]
***	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	[15:01]
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:16]
ricks99	hm... i guess not	[15:17]
sylvieg	no but the perm will be checked	[15:29]
CIA-57	tikiwiki: 03sylvieg * r20439 10/trunk/templates/tiki-admin-include-wysiwyg.tpl: [FIX]layout: enlarge the textarea	[15:30]
ricks99	right but tiki will only show the "main"page's cateogory in the catpath	[15:41]
***	pascalstjean has joined #tikiwiki	[15:50]
wookienz	ricks99: still around?	[15:57]
ricks99	yup	[15:58]
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?	[15:59]
ricks99	sorry, i don't. what is ur mysql version? fwiw, i haven't had issues creating groups in my 3.x tikis	[16:01]
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. yeah similar bug - ie there is an error but it iwhen i use the "perms" function	[16:02]
ricks99	is this a new install? or upgrade from 2.x?	[16:03]
wookienz	i think an upgrade from 2.x - here is the error http://pastey.net/119283	[16:04]
ricks99	and there were no errors during the upgrade sql, right?	[16:05]
wookienz	well thats what i dont know.	[16:05]
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:06]
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:07]
wookienz	will an update" wipe the databse?	[16:08]
sylvieg	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:08]
sylvieg	yeh run the same query manually to see the error	[16:09]
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?	[16:09]
ricks99	running the upgrade shouldn't mess with your data -- only table structure	[16:10]
wookienz	ok	[16:10]
ricks99	make sure you select UPGRADE and not INSTALL (which will wipe your data)	[16:11]
wookienz	ok great... got to run!	[16:11]
***	wookienz has quit IRC ("ChatZilla 0.9.85 [Firefox 3.5.1/20090715094852]")	[16:14]
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)) rlopez_ has joined #tikiwiki	[16:18]
MacLeod	What tools do y'all use to probe and edit the MySQL database directly?	[16:29]
Landon	i use Mysql Administrator and Mysql Query Browser	[16:31]
***	pascalstjean has quit IRC (Read error: 104 (Connection reset by peer))	[14:28]
MacLeod	Landon: thx	[14:29]
***	rlopez_ has quit IRC ("Leaving") Floh1111_ has quit IRC (Remote closed the connection)	[14:31]
	SEWilco2 has quit IRC ("Leaving.") Kissaki^0ff is now known as Kissaki	[14:40]
	xavi1 has joined #tikiwiki	[14:52]
xavi1	toctoc...	[14:53]
Kissaki	toc	[14:54]
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 :-/	[14:55]
Kissaki	ohoo	[15:00]
xavi1	kissaki marc here are you coming bring a mattress	[15:04]
Kissaki	^^ no pretty far away here, in Germany...	[15:05]
***	marclaporte has joined #tikiwiki MacLeod has quit IRC (Ping timeout: 180 seconds) Wilkins has quit IRC (Remote closed the connection)	[15:06]
marclaporte	polom marclaporte is no longer squatting xavi1's computer Kissaki: Europeans don't know what "far" means! ask Russians or Canadians :-)	[15:07]
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	^^ true esp. me (doesn't know what far is) *means	[15:09]
sylvieg	sound good for me	[15:10]
***	pascalstjean has joined #tikiwiki	[15:12]
	Caarrie is now known as Caarrie\|away	[15:17]
	matwho has joined #tikiwiki	[15:29]
matwho	hi from Portugal	[15:29]
***	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	[15:31]
	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	[15:53]
tobi_h	polom :) could it be that the video is stuck?	[15:58]
***	Caarrie\|away is now known as Caarrie	[15:59]
tobi_h	sound works - good horn outside... ;)	[15:59]
nkoth3	same observation - sound good, video stuck	[16:00]
***	rodrigo_sampaio has joined #tikiwiki	[16:00]
nkoth3	I need food, back soon :)	[16:01]
tobi_h	;) xavi: assuming you are at the place of the meeting - can you do anything about the video? oh well - bbl...	[16:01]
***	tobi_h is now known as tobi_h\|away rlopez_ has joined #tikiwiki	[16:04]
chealer	tobi_h\|away: it's stuck, indeed tobi_h\|away: we're still working on streaming. there are a few issues.	[16:15]
***	rlopez_ has quit IRC ("Leaving")	[16:24]
.... (idle for 17mn)
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 :-)	[16:41]
nkoth3	k	[16:42]
CIA-57	tikiwiki: 03chealer * r20441 10/trunk/lib/modules/modlib.php: [FIX] array_fill_keys typo	[16:42]
***	pascalstjean has quit IRC (Read error: 104 (Connection reset by peer))	[16:53]
	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	[17:00]
	rodrigo_sampaio has quit IRC (Read error: 104 (Connection reset by peer)) chealer has quit IRC (Read error: 104 (Connection reset by peer))	[17:08]
	xavi has joined #tikiwiki	[17:17]
xavi	hello again we are starting now, with or without streaming	[17:17]
nkoth3	k	[17:18]
***	Redhatter has quit IRC (Read error: 113 (No route to host))	[17:18]
nkoth3	streaming works for me	[17:18]
xavi	and audio, nkoth? nkoth3: ^	[17:19]
nkoth3	seems ok, say somethig i hear a lot of background talking (can't make out the words) yes	[17:20]
xavi	yes, that's the problem but we start anyway	[17:20]
***	MacLeod has joined #tikiwiki	[17:21]
xavi	we couldn't plug the good mattbic mic on a powerful computer in time 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 and if nobody is able to have the audio from mattbic working, fine. else we have some video at least	[17:21]
cheal	SEWilco2: it was indeed a comments bug (2611)	[17:22]
xavi	and some off line good video and audio recording also	[17:22]
***	jonnyb has joined #tikiwiki	[17:28]
	jonnyb has quit IRC ()	[17:40]
..... (idle for 23mn)
sylvieg	I do not see how perspectives can work only on prefs and not on categ and groups too... ok if it is freedom	[18:03]
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:04]
sylvieg	xavi move a little bit	[18:05]
nkoth3	why not put the white board at the other end of the room, xavi?	[18:05]
SEWilco2	cheal: Bug not found. http://dev.tikiwiki.org/tiki-searchresults.php?highlight=2611&search=Go	[18:10]
	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.	[18:23]
sylvieg	+1 for xavi move	[18:30]
xavi	:-) it took a while to able to come to my computer (out of the room), and read the irc messages	[18:34]
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 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:35]
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:37]
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. My sketching skills are good enough to make a plane with a Samantha Carter in it.	[18:38]
***	MacLeod has quit IRC (Ping timeout: 180 seconds) RLJII has quit IRC ("Page closed")	[18:49]
Kissaki	mömömömöp	[18:56]
.... (idle for 16mn)
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 ]	[19:12]
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	[19:13]
***	Bandari has joined #tikiwiki	[19:14]
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.	[19:14]
***	rodrigo_sampaio1 has quit IRC ("Leaving.")	[19:16]
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 my system got connected to internet - I am on windows environment. Please do suggest me - where I went wrong?	[19:17]
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:19]
nkoth3	firewall? (wild guess)	[19:20]
Bandari	getsocket function - means? no firewalls I can browse internet from the same system	[19:20]
sylvieg	it does not prove anything - a browser is not like a server	[19:21]
cheal	sylvieg: lph doesn't understaned your question	[19:21]
sylvieg	he did some query - where all the perms are checked on all the objects of a list 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. yes	[19:22]
cheal	sylvieg: he says yes	[19:22]
sylvieg	in which list did he implement that? list_pages?	[19:22]
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:23]
Bandari	Kindly suggest me	[19:24]
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:25]
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.	[19:26]
sylvieg	tiki-admin.php?page=login	[19:29]
***	FrankP_german has joined #tikiwiki	[19:29]
Bandari	Please help me on profiles	[19:38]
xavi	finished for today at the tikifest people went for food we'll upload some pictures from today, and go also	[19:38]
Bandari	Repository URLs:http://profiles.tikiwiki.org/profiles	[19:38]
xavi	we hope that during the weekend we can solve the issues with the audio and video	[19:39]
sylvieg	Bandari: I am pretty sure it is a problem with your system	[19:40]
***	floh1111 has quit IRC (Remote closed the connection)	[19:42]
Bandari	Please do suggest me - which areas I have to look / check	[19:42]
sylvieg	Bandari: is a simple progrm like $url = 'http://profiles.tikiwiki.org/profiles';var_dump(file_get_contents( $url ));	[19:44]
Bandari	do you want me to check this url?	[19:47]
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)	[19:47]
Bandari	let me try	[19:49]
***	xavi has left	[19:55]
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?	[19:58]
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:03]
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:09]
***	Lucymoz has joined #tikiwiki MatWho has joined #tikiwiki	[20:21]
MatWho	How is Barcelona?	[20:26]
***	Bandari has quit IRC ("Page closed")	[20:32]
CIA-57	tikiwiki: 03kissaki * r20442 10/trunk/db/tiki.sql: add `s to CREATE TABLE and DROP TABLE statements	[20:40]
Kissaki	wth	[20:45]
***	FrankP_german has quit IRC ("Nettalk6 - www.ntalk.de")	[20:48]
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?	[20:48]
***	arrowsama has joined #tikiwiki arrowsama has quit IRC (Client Quit)	[20:56]
CIA-57	tikiwiki: 03kissaki * r20443 10/trunk/db/tiki.sql: [FIX] rev 20434 did specify a primary key twice in a table	[21:00]
***	cheal has quit IRC (Read error: 110 (Connection timed out))	[21:02]
	MartinCleaver_ has joined #tikiwiki	[21:10]
	MartinCleaver_ has quit IRC ()	[21:16]
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)) Redhatter has joined #tikiwiki nkoth3 has quit IRC () danopia` has joined #tikiwiki MatWho has quit IRC ()	[21:27]
	danopia has quit IRC (Network is unreachable) danopia has joined #tikiwiki	[21:39]
sylvieg	euh.. primary key is for unicity	[21:43]
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:44]
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:45]
sylvieg	thx Kissaki (I am always bad in commit db because I test by copy . paste )	[21:46]
Kissaki	:) I just tested my changed sql script and became an error... so I wondered and found there was another commit :P	[21:46]
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) 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:47]
***	danopia` has quit IRC (Connection timed out)	[21:48]
Kissaki	somehow my local phpmyadmin is fucked up now... shit	[21:49]
***	danopia` has joined #tikiwiki	[21:50]
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 :) (outside that sql script)	[21:51]
sylvieg	but is primary key more efficient than other index?	[21:53]
***	danopia has quit IRC (Network is unreachable)	[21:58]
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:01]
CIA-57	tikiwiki: 03lphuberdeau * r20445 10/branches/experimental/perms-take2/ (33 files in 20 dirs): [MRG] Automatic merge, trunk 20436 to 20444	[22:10]
***	cheal has joined #tikiwiki	[22:12]
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( ':/	[22:19]
lphuberdeau1	hum... permName is not anywhere in that file	[22:23]
sylvieg	it is 2 notice for each page sylvieg goes in the trace (since I have xdebug :-))	[22:25]
luciash	polom :) sylvieg: congrats ! :)	[22:27]
CIA-57	tikiwiki: 03lphuberdeau * r20446 10/branches/experimental/perms-take2/lib/tikilib.php: [FIX] Typo	[22:27]
sylvieg	sylvieg still has to setup the debugger but trace and profiling are great	[22:27]
lphuberdeau1	should be fixed	[22:27]
sylvieg	sylvieg looking for this since 20mn and lph arrives .. 2 secs ... thx working thx lphuberdeau1 :-)	[22:28]
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 pk = index + unique	[22:31]
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:32]
lphuberdeau1	also impacts the default ordering	[22:33]
sylvieg	your point Kissaki - was to change primary key to index?	[22:34]
Kissaki	no ^^ that would really make no sense	[22:34]
sylvieg	it was only because I ... 3 letter one of my commit - and you wanted to tease me ? :-) sylvieg needs to refresh database theory	[22:35]
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...	[22:38]
sylvieg	:-)	[22:39]
	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 ' in page name should not cause problems	[22:44]
sylvieg	no I was wrong yes I was wrong this is the messy query http://pastey.net/119316	[22:44]
CIA-57	tikiwiki: 03kissaki * r20448 10/trunk/db/tiki.sql: column-quotes on keys	[22:54]
***	Lucymoz has quit IRC (Read error: 110 (Connection timed out))	[22:56]
CIA-57	tikiwiki: 03kissaki * r20449 10/trunk/db/ (4 files): converted scripts	[22:57]
sylvieg	almost got it lphuberdeau1 I have a pagename with a ? and the $db->in does not escape ? it is why we have bindvars...	[23:00]
lphuberdeau1	ultimately, ? is not part of sql	[23:01]
sylvieg	the query in bulkLoadCategories one page name with ? and ...	[23:01]
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 sylvieg thinks we should have a video - would like to see all the beds in a small plce and hot weather...	[23:02]
***	marclaporte has joined #tikiwiki	[23:10]
marclaporte	polom	[23:12]
luciash	good night all	[23:18]
CIA-57	tikiwiki: 03kissaki * r20450 10/trunk/db/ (6 files in 2 dirs): updated pgsql convert script	[23:24]
***	MartinCleaver has joined #tikiwiki	[23:26]
marclaporte	Kissaki: : ping Kissaki: you seem to be progressing really well on tiki.sql did you have any thought yet on the upgrade scripts?	[23:28]
Kissaki	yo yes I'm doing that on tiki.sql especially to ease conversion :) seems good right now, I'm currently on indices	[23:29]
marclaporte	I am ready to test on http://demo.tikiwiki.org/postgresql/tiki-install.php as soon as you say so	[23:30]
cheal	Kissaki: marclaporte is one of the dev.tw.o admins	[23:34]
***	cheal is now known as chealer	[23:34]
Kissaki	:) how did you know I wanted to ask him? (in qry)	[23:36]
marclaporte	so.... Registered users can't edit tracker items on dev.tw.o	[23:39]
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:40]
Kissaki	yes wrote about that some days ago here... hmm wait, I'll get you 2 items	[23:41]
chealer	Kissaki: I saw your public query in logs	[23:41]
Kissaki	my what?	[23:41]
chealer	Kissaki: when you asked in public	[23:42]
Kissaki	what? when? you mean about that? now my ff crashed...	[23:42]
chealer	Kissaki: yes	[23:42]
Kissaki	are you admin as well?	[23:42]
chealer	Kissaki: no	[23:43]
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	[23:44]
marclaporte	marclaporte just made chealer Admin on tikiwiki.org and dev.tw.o	[23:44]
Kissaki	haha oO so he lied to me! this I can't edit: http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=2559	[23:44]
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	[23:45]
marclaporte	chealer: : perhaps kissaki can be added to dev group?	[23:45]
Kissaki	tracker definitely needs a rework...	[23:46]
***	SEWilco2 has joined #tikiwiki	[23:48]
Kissaki	he doesn't want me :)	[23:53]
chealer	Kissaki: you're now in the Developers group	[23:53]
Kissaki	oh, thank you :) what changes for me? 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:53]
Kissaki	so, do we use open/pending/closed? or just resolution status?	[23:57]
chealer	Kissaki: both	[23:58]
Kissaki	hm why not hide status then? ^^ and just use resolution status	[23:59]

←Prev date Next date→ Show only urls

(Click on time to select a line by its url)