← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| 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 | im having some difficulties with my opac | |
| 23:03 | ei | |
| 23:03 | ermm i was required to install mysql5 on my machine because a there is a dependency problem | |
| 23:04 | now that i installed koha.. whenever is use the opac.. the results are only blank spaces | |
| 23:07 | anyone who can help? | |
| 23:18 | ermm heullo | |
| 03:04 | anybody awake? | |
| 03:05 | :( | |
| 05:47 | Strait | hmm |
| 05:47 | i could be wrong, but i think that mysql5 is highly problematic | |
| 05:47 | 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 | 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 | unless we get time that is | |
| 05:51 | or someone volunteers ;) | |
| 05:52 | Strait | there is always that of course |
| 05:53 | chris | the main thing |
| 05:53 | is the joins have changed in mysql 5 | |
| 05:53 | so sql that worked in 4, doesnt work | |
| 05:53 | Strait | beautiful... |
| 05:53 | chris | yeah its not so pretty |
| 05:54 | i had a post on my blog about it | |
| 05:54 | 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 | normally that will redirect you to the blog .. when i fix it :0 | |
| 05:55 | basically before you could do things like | |
| 05:55 | select * from table1,table2,table3 | |
| 05:56 | left join table4 on table1.something = table4.something | |
| 05:56 | now for it to work | |
| 05:56 | it would have to be | |
| 05:56 | select * from table2,table3,table1 | |
| 05:56 | left join table4 on table1.something = table4.something | |
| 05:57 | Strait | er...? |
| 05:57 | the difference being? | |
| 05:57 | 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 | http://mysql.com/doc/refman/5.0/en/join.html | |
| 05:58 | lots of stuff there | |
| 05:58 | 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 | but i don't know the other two | |
| 06:01 | chris | rusty russel (wrote netfilter/iptables amongst other things) |
| 06:01 | and then jon 'maddog' hall | |
| 06:02 | was at the linux conference earlier this year | |
| 06:02 | Strait | ok :) |
| 06:02 | where was it held? | |
| 06:02 | chris | dunedin (in the south island of nz) |
| 06:02 | got some good press for Koha :) | |
| 06:02 | Strait | i see |
| 06:03 | that's a good thing | |
| 06:03 | i recently introduced koha to a bunch of library professionals in finland | |
| 06:04 | they seemed interested | |
| 06:04 | but a bit careful | |
| 06:04 | we have this holy tietoenator here | |
| 06:04 | 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 | FINMARC mostly | |
| 06:06 | an old national format that is no longer maintained | |
| 06:06 | the there is MARC21-Fin which is almost MARC21 but with some national additions | |
| 06:06 | 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 | 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 | 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 | strait: dewey is a bot | |
| 06:09 | Strait | ah, ok |
| 06:09 | :D | |
| 06:09 | chris | it learns things |
| 06:09 | 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 | 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 | hmm | |
| 06:11 | i think i'll be off to have some lunch | |
| 06:11 | chris | hmm, if its lunch for you |
| 06:11 | 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 |
← Previous day | Today | Next day → | Search | Index