Time  Nick           Message
11:21 Fallor         which table should i clear to get rid or the reservoir?
11:24 Fallor         what's this then: 080227  5:08:07 [Warning] /usr/libexec/mysqld: ignoring option '--character-set-client-handshake' due to invalid value 'utf8'
11:53 frederic       Fallor: Take a look on tables begining whith 'import_'... Not sure.
12:21 Fallor         well, i ended up dropping/re-creating the whole koha-database
12:21 Fallor         still without luch
12:21 Fallor         luck, even :D
12:21 Fallor         this time i followed the wikipage about setting the encodings very carefully
12:21 Fallor         the result is the same
12:22 Fallor         imported records still have iso-characterset
12:26 Fallor         could this be a bug in breeding.pl?
12:26 Fallor         or one of the perl-modules that deal with marc-data?
12:39 Fallor         actually it's not iso anymore
12:39 Fallor         it's something very odd
12:40 Fallor         for example a with umlauts displays as ? if i set the encoding of the browser to utf8
12:40 Fallor         if i set it to iso-8859-1 it's gibberish
12:40 Fallor         there is i with umlauts, questionmark upside down and 1/2 character
12:41 Fallor         it _used_ to be iso before i re-created the database and redid the import
12:41 Fallor         not so anymore, it seems...
13:36 owen           Hi #koha
15:44 MatthewMetzger Apologies to the channel for bugging you all for the past couple weeks.
15:44 MatthewMetzger Thanks for the gracious help that was given.
15:46 MatthewMetzger testing...
15:46 MatthewMetzger Apologies to the channel for how much I've bugged everyone here for the past couple weeks.
15:46 MatthewMetzger Thanks for the gracious help that was given.
15:47 MatthewMetzger I finally got my 3.0 install to work properly (mostly)
15:48 MatthewMetzger The problem was with the database itself. It was somehow damaged on January 16 and any sql dump after that point did not allow a good upgrade.
15:48 MatthewMetzger I'm not sure how that happened, but I'm glad I make a daily sqldump of my koha database.
15:49 MatthewMetzger gmcharlt: are there any tools to check koha's database integrity? I'm good now, but I'd hate to have it happen again.
15:52 paul           MatthewMetzger: do you mean an automatic checking or a manual one ?
15:53 paul           an automatic checking, no.
15:53 MatthewMetzger something manual would be okay, too.
15:53 paul           a manual one : dump your DB structure and compare it with kohastrtucture.sql
15:53 paul           they should be the same
15:58 fbcit          g'morning || evening koha
16:00 fbcit          hi paul
16:01 paul           hi fbcit
16:03 MatthewMetzger paul: thanks. I'll make note of that and attempt a test soon. Will (is) there any documentation on the sql compare?
16:03 fbcit          paul: atz had another *odd* error updatedatabase.pl with the fkey on printers_profile
16:03 fbcit          yet everything was correct in kohastructure.sql
16:04 fbcit          so I wonder if maybe some installations are out of sync a bit?
16:06 fbcit          labels_templates was already in existence when I added printers_profile
16:14 paul           (on phone)
16:15 fbcit          brb
16:26 fbcit          owen: thanks for polishing up my very rough javascript :-)
16:27 fbcit          actually it was a poor hack of some I found in the internet
16:33 owen           I'm a jquery fan, fbcit, so I try to use it where I see the opportunity
17:04 atrus132       Hi all.. I have a quick question...
17:06 atrus132       For some reason, Net::Z3950 fails a large portion of the tests when installing from CPAN...  is this a known problem, or do you think there's something wrong with my particular install?
17:07 atrus132       The prospect of forcing the install makes me a little nervous.  I'm using Ubuntu Gutsy.
17:09 atz            atrus132: you can try looking for an ubuntu binary
17:10 atrus132       ah, that's a good idea.  just did a search and it is, indeed, in the repositories.  thanks!
17:15 atz            no problem
17:52 paul           fbcit: about labels_template.
17:52 paul           they are NOT a part of Koha 2.2, i'm 100% sure.
17:52 paul           so the table must be created by the upgrade process, and it's not the case, unless i'm missing something, and I don't think I am
17:53 paul           I tried to update another DB from 2.2 to 3.0, and got the same problem.
17:54 paul           I also tried to search dev_week, and find the table here. So maybe it's a problem that occured a long time ago.
17:54 paul           kados around ?
17:59 fbcit          paul:k
17:59 fbcit          I'm not familiar with 2.2 nor the upgrade process in place, so we may need to add the creation of labels_template to it
18:00 fbcit          I know printers_profile is
18:01 fbcit          yup
18:01 fbcit          that's where it should probably be added: upgrade22to30.pl
18:01 paul           yep. i'm writing a mail to kados about that atm
18:03 fbcit          paul: a quick look at that script seems to indicate that it gets you to ver. 3.00.00.000 and then updatedatabase.pl should take over from there maybe?
18:03 paul           yep
18:03 paul           it's the previous updatedatabase script we used (before the new system)
18:04 fbcit          so the labels_template table needs to fall somewhere in the current updatedatabase.pl
18:04 fbcit          perhaps at the 001 point
19:34 owen           fbcit, you still around?
19:34 fbcit          yep
19:36 owen           I was going to ask you about an item type image thing, but I wonder if I should even bother, if there is going to be a big overhaul anyway
19:36 fbcit          from the discussion yesterday w/ kados, I'd say an overhaul is probably in the making
19:37 owen           I was just noticing a few glitches with the display of admin/itemtypes.pl
19:37 fbcit          what's happening?
19:38 fbcit          maybe we can fix it :)
19:44 fbcit          owen: bbiab
19:45 owen           Sorry fbcit, I got called away from my desk
19:45 owen           I was looking at this bug: http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1775
19:47 owen           I noticed that if I specify a remote image (with a full URL), that image doesn't display in the item type list
19:48 owen           The problem reported in the bug is a strange one... I don't think that's really a template issue
20:02 fbcit          owen: I noticed that when I went to change a custom image a moment ago
20:03 fbcit          I'll take a quick look
20:03 owen           It's not urgent, but I was going through bugs assigned to me and wanted to see about getting the right person on the job
20:09 fbcit          owen: its because the conditional in the script defines a "remote image" as one beginning with 'http'
20:09 fbcit          so it does not allow for the thought of a "custom" local image
20:10 fbcit          we probably need to specify a local location for "custom" images
20:10 owen           Perhaps on the assumption that if you have access to the filesystem you might as well put your custom image with the standard ones
20:10 fbcit          I agree
20:11 fbcit          hence "remote"
20:11 fbcit          maybe a note to clarify and close the bug would do?
20:12 fbcit          also an additional line to the screen help file might help as well
20:13 owen           The most complete solution would involve a server-side check for 'http' and an error message returned to the user, but a javascript check is a good interim workaround
20:13 owen           I'll do that
20:13 fbcit          additionally, we could add a note on the screen itself specifying "Enter the complete URI."
20:13 owen           Yes
20:31 chris          morning
20:31 owen           Hi chris
20:34 chris          heya owen .. molars all thru?
20:34 masonj         hiya guys
20:34 owen           No, but we're in a lull I think
20:35 chris          hey mason
20:35 chris          ahh yeah, us too owen
20:44 owen           chris: I'm looking forward to talking next. Right now he's got a few variations of "uh" that we can recognize as words, but that's about it
20:44 chris          have you got 'no' yet?
20:45 owen           No, not yet
20:45 chris          we have "no no no no no" while struggling to pull toys away from other kids
20:45 fbcit          hi chris
20:45 chris          hi chris*2 :)
20:46 chris          owen: we are working on the sharing thing .. getting there slowly :)
20:46 chris          heh
20:46 fbcit          my oldest (12 yrs) had two teeth pulled today for braces... so now I have two with tooth issues :-(
20:47 chris          ouch
20:53 chris          hi tina
21:05 chris          wow 8 trillion patches from owen
21:06 owen           Yeah, I've been saving them up. I know I shouldn't, but I got caught on a tangent.
21:06 chris          no worries
21:07 chris          i expect they'll apply ok, there hasnt been many other fingers on the templates
23:03 chris          you about kados?
23:03 chris           if ( $item->{C4::Context->preference("HomeOrHoldingbranch")} ne $userenv->{branch} )
00:20 atz            kados is about 4 rows behind me
00:22 chris          :)
00:24 chris          galens talk eh?
00:24 kados          coming up in a few
00:24 chris          sweet
01:14 atz            nicely done galen
01:16 gmcharlt       atz: thanks
04:23 CGI676         what u mean by the routing lists