Time Nick Message 16:27 thd kados: I sent you a now good adaptation of the koha.org CSS for the wiki. Please take a look. 22:46 qiqo hi every body 22:47 qiqo im having some difficulties with my opac 23:03 qiqo ei 23:03 qiqo ermm i was required to install mysql5 on my machine because a there is a dependency problem 23:04 qiqo now that i installed koha.. whenever is use the opac.. the results are only blank spaces 23:07 qiqo anyone who can help? 23:18 qiqo ermm heullo 03:04 qiqo anybody awake? 03:05 qiqo :( 05:47 Strait hmm 05:47 Strait i could be wrong, but i think that mysql5 is highly problematic 05:47 Strait i haven't managed to get any koha installations to work with it 05:47 chris im not running it anywhere in production 05:48 Strait 4.1 works like a charm :) 05:48 chris yep 4.2 too 05:49 Strait they have probably changed the syntax of 5 once again 05:49 Strait or something else 05:50 chris because we are making major changes for koha 2.4 .. and 3.0 .. we probably will concentrate on making that work with 5 .. and not do to much for the 2.2 series 05:50 chris unless we get time that is 05:51 chris or someone volunteers ;) 05:52 Strait there is always that of course 05:53 chris the main thing 05:53 chris is the joins have changed in mysql 5 05:53 chris so sql that worked in 4, doesnt work 05:53 Strait beautiful... 05:53 chris yeah its not so pretty 05:54 chris i had a post on my blog about it 05:54 chris but i broke my blog the other day 05:54 Strait where is your blog? 05:54 chris so i cant look it up 05:54 Strait ah, ok 05:54 chris http://www.bigballofwax.co.nz/ 05:55 chris normally that will redirect you to the blog .. when i fix it :0 05:55 chris basically before you could do things like 05:55 chris select * from table1,table2,table3 05:56 chris left join table4 on table1.something = table4.something 05:56 chris now for it to work 05:56 chris it would have to be 05:56 chris select * from table2,table3,table1 05:56 chris left join table4 on table1.something = table4.something 05:57 Strait er...? 05:57 Strait the difference being? 05:57 Strait ah, the order 05:57 chris Beginning with MySQL 5.0.12, natural joins and joins with USING, including outer join variants, are processed according to the SQL:2003 standard. The goal was to align the syntax and semantics of MySQL with respect to NATURAL JOIN and JOIN ... USING according to SQL:2003. However, these changes in join processing can result in different output columns for some joins. Also, some queries that appeared to work correctly in older versions must be rewritten to c 05:58 chris http://mysql.com/doc/refman/5.0/en/join.html 05:58 chris lots of stuff there 05:58 chris but thats the main problem i ran into last time i played with 5 05:58 Strait (which one on the picture is you?) 05:59 chris the one on the left 05:59 Strait ok 06:00 chris can you name any of the others? :) 06:00 Strait one beside you is Linus 06:01 Strait but i don't know the other two 06:01 chris rusty russel (wrote netfilter/iptables amongst other things) 06:01 chris and then jon 'maddog' hall 06:02 chris was at the linux conference earlier this year 06:02 Strait ok :) 06:02 Strait where was it held? 06:02 chris dunedin (in the south island of nz) 06:02 chris got some good press for Koha :) 06:02 Strait i see 06:03 Strait that's a good thing 06:03 Strait i recently introduced koha to a bunch of library professionals in finland 06:04 Strait they seemed interested 06:04 Strait but a bit careful 06:04 Strait we have this holy tietoenator here 06:04 Strait with their Pallas library system 06:05 chris ahh yep 06:05 Strait we currently have 3 different MARC variants in use 06:05 chris yikes 06:05 Strait which is insane 06:05 chris way to make life difficult 06:05 Strait indeed 06:05 chris i have enough trouble with one 06:05 Strait public libraries use 06:06 Strait FINMARC mostly 06:06 Strait an old national format that is no longer maintained 06:06 Strait the there is MARC21-Fin which is almost MARC21 but with some national additions 06:06 Strait it's a format that nobody really wanted, but it had to be done 06:06 chris right 06:07 Strait and then there is pure MARC21 06:07 Strait which we are moving towards to 06:07 chris MARC , the standard that isnt 06:08 Strait currently if we want to convert records from FINMARC to MARC21 we'll have to do it through MARC21-Fin at the moment 06:08 Strait which is also insane 06:08 dewey okay, Strait. 06:08 chris which? 06:08 dewey which is really annoying or insane 06:08 chris heh 06:08 Strait ? 06:08 chris that would be quite hard double conversion, without losing anything 06:09 chris strait: dewey is a bot 06:09 Strait ah, ok 06:09 Strait :D 06:09 chris it learns things 06:09 chris chris? 06:09 dewey hmmm... chris is now too 06:09 chris kados? 06:09 dewey kados is, like, becoming a true Perl Monger 06:09 chris koha? 06:09 dewey koha is the first open-source ILS or a good free software ILS 06:09 chris plus can do things like 06:09 chris seen strait? 06:09 dewey strait was last seen on #koha 27 seconds ago, saying: :D [Sun Aug 20 23:09:22 2006] 06:09 chris which is handy 06:10 Strait ok 06:11 Strait hmm 06:11 Strait i think i'll be off to have some lunch 06:11 chris hmm, if its lunch for you 06:11 chris it must be time for sleep for me :) 06:11 Strait sleep tight 06:11 chris enjoy the rest of your day 06:12 Strait will try 09:32 toins hi 09:32 dewey hey, toins