Time Nick Message 12:01 tim I know I won't get it done before this years deadline, but each time I finally do make some progress it's pretty bit at least. 12:02 tim There's just a lot of time between 12:03 owen Is there something you'd say is your biggest hurdle? 12:11 tim MARC mapping so far. 12:14 tim My problem is usually because I get stuck on how I think things should work instead of how they really work. 13:24 tim About an hour and 15 minutes ago :) 13:24 rach ah so you're still about? 13:24 rach where abouts are you tim? 13:24 tim Sometimes 13:25 tim Yup. Southeast Iowa 13:26 rach is there anything someone else - like us? could help you with in getting your data migrated? 13:27 rach or in general? 13:28 tim It's a general 'Idunoo what I'm doing' thing I guess. I'm stumped on some of the marc mapping. 13:28 tim Mostly tab #10 and I want to see call numbers in the search results. 13:30 rach ah huh 13:31 tim I'm digging out the 'Migrating to Koha" document that Owen mentioned a while back. 13:32 rach there will be 3 of us from Katipo in the USA in the next 4 weeks 13:32 rach or so 13:32 rach I think actually chris will be there a lot longer 13:33 rach mapping marc isn't probably our strong suite 13:33 rach but changing the search results I'd expect would be 14:15 tim Starting to have owens problems staying connected. 23:04 kados chris around? 23:04 chris yo 23:04 kados hiya 23:04 chris hey there 23:05 kados did you see my question a while back about the issues script not working? 23:05 chris hmm nope dont think so 23:05 kados for some reason this sql: 23:05 kados DELETE FROM issues WHERE returndate IS NOT NULL AND itemnumber=? LIMIT? 23:05 kados in the script 23:05 chris oh right 23:05 chris LIMIT ? 23:06 chris missing a space 23:06 kados tried that 23:07 chris righto 23:07 kados btw: is there any advantage to using mysqldump over just targzipping up the /Koha dir in /var/lib/mysql? 23:07 chris yes and no 23:07 chris dumping means u can port it to whatever version 23:07 chris whatever OS etc 23:08 chris if u gzip the binary data files 23:08 kados ahh ... that's actually important if there's a crash 23:08 chris yup 23:08 kados glad I asked 23:08 chris so gzipping the files is faster and will restore faster 23:08 kados you're not kidding 23:08 kados 1 min vs 3 hrs 23:09 chris but u might run into problems if u try to use it on different mysql version etc 23:13 kados okidoki ... here are those errors: 23:13 kados DBD::mysql::st execute failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''13'' at line 1 at issuesclean.pl line 47. 23:13 kados so these happen for each time the query is run and nothing is actually changed in the database -- I've been Ctr-Cing out when they start flying by 23:14 chris it used to work tho? 23:14 kados yea ... remember it f**cked up the issues that time :-) 23:14 chris so i wonder whats changed 23:14 kados and you had to do a thingy with stats 23:14 chris new mysql version? 23:14 kados yea 23:14 kados 4.020 23:14 chris right 23:14 kados 4.0.20 23:14 chris perhaps the syntax has changed 23:14 kados actually 23:15 kados huh 23:15 kados how would one find out? 23:15 kados actually ... it works when I do it from the sql command line 23:16 kados if that means anything ... 23:17 chris how odd 23:18 chris oh 23:18 chris ''13'' double '' 23:18 chris perhaps its making it limit '13' 23:19 chris instead of limit 13 23:19 kados hmmm 23:19 chris for some reason 23:19 kados lemme check 23:20 kados my $count_items_sth=$dbh->prepare("SELECT COUNT(*) AS issuecount,itemnumber FROM issues WHERE returndate IS NOT NULL GROUP BY itemnumber ORDER BY issuecount DESC"); 23:20 kados while (my $items=$count_items_sth->fetchrow_arrayref) { 23:20 kados my $count=$items->[0]; 23:20 kados is how it arrives at $count 23:21 kados my $del_issues_sth=$dbh->prepare("DELETE FROM issues WHERE returndate IS NOT NULL AND itemnumber=? LIMIT ?"); 23:21 kados $del_issues_sth->execute($itemnumber, $count); 23:21 kados (totally out of order of course :-)) 23:21 chris hmm that oughta work 23:21 chris weird 23:22 chris could try 23:22 chris my $del_issues_sth=$dbh->prepare("DELETE FROM issues WHERE 23:22 chris returndate IS NOT NULL AND itemnumber=? LIMIT $count"); 23:22 chris and $del_issues_sth->execute($itemnumber); 23:23 chris or leave it as it is and do 23:24 kados well I got some kind of init error and then: 23:24 chris $del_issues_sth->execute($itemnumber, $count) || die "itemnumber=$itemnumber count=$count"; 23:24 kados D::mysql::st execute failed: You have an error in your SQL syntax. Check themanual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at issuesclean.pl line 47. 23:25 kados ok I'll try that 23:26 chris it should stop on the first error 23:27 kados koha:/build/npl_custom_scripts# perl -I /build/koha issuesclean.pl 23:27 kados DBD::mysql::st execute failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''20'' at line 1 at issuesclean.pl line 47. 23:27 kados itemnumber=276476 count=20 at issuesclean.pl line 47. 23:27 chris thats mental 23:27 kados :-) 23:27 chris could go 23:28 chris ah no 23:28 chris weird 23:29 chris DELETE FROM issues WHERE returndate IS NOT NULL AND itemnumber=276476 limit 20 23:30 chris works fine from the command line ? 23:31 kados yep 23:31 chris how odd 23:31 kados maybe a DBD bug? 23:31 kados DBI? 23:31 chris seems weird 23:32 chris how about doing 23:32 chris my $query="DELETE FROM issues WHERE returndate IS NOT NULL AND itemnumber=$itemnumber limit $count"; 23:32 chris my $sth=$dbh->prepare($query); 23:33 chris $sth->execute || die $query; 23:33 chris at least we will get to see the actual query its executing that way 23:33 kados ok ... 23:38 kados well it might be working 23:38 chris somethign weird was happening 23:39 chris i think and it was thinking the count was a string 23:39 kados mysql> select count(*) from issues; 23:39 kados +----------+ 23:39 kados | count(*) | 23:39 kados +----------+ 23:39 kados | 304415 | 23:39 kados +----------+ 23:39 chris so was escaping it with ' 23:39 kados 1 row in set (0.00 sec) 23:39 kados 23:39 kados mysql> select count(*) from issues; 23:39 kados +----------+ 23:39 kados | count(*) | 23:39 kados +----------+ 23:39 kados | 298531 | 23:39 kados +----------+ 23:39 kados 1 row in set (0.00 sec) 23:39 kados 23:39 chris and mysql was going oi .. u dont put strings in limit clauses 23:39 kados I think it's working a bit too well 23:39 kados and deleting all the issues again :-) 23:40 kados maybe not ... it finally stopped 23:41 kados well everything looks fine 23:42 kados wow ... thanks chris 23:42 chris cool 23:42 chris so somehow it was thinking count was a string 23:43 kados so I ran the script again 23:43 kados and got: 23:43 kados koha:/build/npl_custom_scripts# perl -I /build/koha issuesclean.pl 23:43 kados Use of uninitialized value in string at issuesclean.pl line 68. 23:43 kados is that because there's nothing to do? 23:44 chris yep, ull be using $count when its empty 23:44 chris or itemnumber 23:44 kados right 23:45 kados I always get nervous playing directly with the data in bulk 23:45 chris yeah a little paranoia is healthy 23:45 kados seeing 15000 issues disapear gives me the heebyjeebies 23:45 chris saves a lot of heartache in the long run 23:45 chris :-) 23:45 kados or in this case 150000 23:45 chris what we should really do 23:45 kados :-) 23:46 chris is make and oldissues table 23:46 kados that'd be ideal 23:46 chris and move them to that 23:46 kados then I could just do delete from oldissues 23:46 chris well i was thinking 23:46 kados (we actually need to get rid of them 23:46 kados for patriots act reasons 23:47 chris u could move to oldissues (so they dont slow stuff done) and anonymise them 23:47 chris done=down 23:47 kados ahh 23:47 chris ie make all borrower numbers=1 23:47 chris or smething 23:47 kados yea that'd work 23:47 chris but so ud still have the data of when items where issued etc 23:47 chris mind you 23:48 chris thats all in statistics anyway 23:48 kados yea I know 23:48 chris hmm 23:48 chris could be a 2 step process 23:48 chris move to old issues 23:48 chris then, delete from old issues 23:48 chris so move .. check its all ok 23:48 chris move back if not 23:49 chris if it is, delete from old issues 23:49 kados right 23:49 chris just would make for a faster recover process 23:49 kados well copying the issues.MYI is pretty fast 23:49 chris true 23:49 kados which is what I did 23:49 kados :-) 23:49 chris :) 23:50 chris for the patriot act, u might want to anonymise the old stats 23:50 kados yea I've been thinking about that 23:50 chris at least the issues 23:50 chris zero the borrowernumbers for issues 23:53 chris hmm kados.org still down? 00:09 kados it should be up now 00:10 chris i get a document contains no data 00:10 kados ahh ... 00:10 kados there's this weird apache thing 00:10 kados try it now 00:10 chris ahh thats more like it 00:11 kados its creeping along on my old Pentium 1 00:11 kados hehe 00:11 kados I've gotta get some better hardware 00:11 chris :) 00:12 kados I really like blosxom 00:12 kados chris what rss agro do you use? 00:12 kados see if you can get my rss stuff to work for you 00:13 kados http://kados.org/cgi-bin/blosxom.cgi/index.rss 00:13 chris i use bloglines .. so it wont :) 00:13 kados bummer 00:13 kados I wonder why 00:13 chris its odd cos the rss from mine bloglines doesnt mind 00:13 kados well I've emailed them ... 00:14 kados BTW: have you seen the self-checkout yet? 00:14 chris oh hey 00:14 chris it does work in bloglines 00:14 kados 66.213.78.60/sco.html 00:14 kados really? ... /me tries again 00:15 kados cool! 00:16 kados let's see if I can round up some books for you to issue to me 00:16 chris heh cool 00:17 kados 31000000000045 00:17 kados 31000000000061 00:17 kados (no idea what these items are) 00:17 kados :-) 00:18 chris hmm im already logged in it says 00:19 chris ahh firefox is blocking the pop up 00:19 chris hehe 00:19 kados did you get the javascript popup? 00:19 kados right 00:19 kados check the x 00:19 kados :-) 00:19 kados I always forget about that and wonder why a site isn't working 00:19 chris very cool 00:20 chris you guys should do some screen shots 00:20 kados well it's not live yet 00:20 kados we've still got a couple of bugs to work out 00:20 chris cool when it goes live, should pop up some screenshots for people to have a look at 00:20 chris its pretty neat 00:21 kados yea ... will do 00:21 kados I'm working on my sysadmin manual lately 00:21 chris cool 00:22 kados here's the index: 00:22 kados Part I: Installation and Migration 00:22 kados 1: Installing Koha on Debian (jferraro) 00:22 kados 2: Installing Koha on Redhat AS (shedges) 00:22 kados 3: Installing Koha on Fedora (jferraro) 00:22 kados 4: Migrating to Koha (shedges) 00:22 kados 5: Customizing Koha's Template System (oleonard) 00:22 kados 00:22 chris woo 00:22 kados Part II: Maintenance and Troubleshooting 00:22 kados 6: Updating Koha (jferraro) 00:22 kados setting up a testing environment 00:22 kados setting up CVS symlinks 00:22 kados 7: Backups (jferraro) 00:22 kados backing up and restoring the database 00:22 kados role of replication as backup 00:22 kados backing up and restoring the filesystem 00:22 kados 8: Optimization (jferraro) 00:22 kados optimizing MySQL 00:22 kados load balancing with replication 00:22 kados 9: Troubleshooting (jferraro) 00:22 kados Koha's error reporting 00:22 kados database corruption 00:22 kados worst-case scenario: utilizing the statistics table 00:22 kados Part III: Participating in the Koha Community 00:22 kados 10: Communicating with the developers(jferraro) 00:23 kados mailing lists 00:23 kados IRC 00:23 kados Wiki 00:23 chris heh worst case scenario :-) 00:23 kados 11: Reporting Bugs (jferraro) 00:23 kados 12: Submitting Code (jferraro) 00:23 kados Appendix: 00:23 kados Installing the Z3950 Server (jferraro) 00:23 kados Cleaning up the issues data (shedges) 00:23 kados Renewals (shedges) 00:23 kados Reserves (shedges) 00:23 kados Handling Overdue Items (shedges) 00:23 kados :-) 00:23 kados well it's a start 00:23 chris excellent 00:24 chris sounds like its on the way to having an actual book too 00:24 kados I'm hoping to have the above sections done in time for the OLC annual at the end of this month 00:24 kados we'll see ... 00:24 chris mind you, if we pdf it, its easy to print off into a book 00:24 kados yea 00:24 chris imagine an oreilly koha book :-) 00:24 kados I don't know if Koha's solidified enough to warrent a book 00:24 kados that's be sweet 00:24 kados but so much is changing so fast ... 00:24 kados maybe after 2.2 ... 00:25 chris yeah 00:25 kados if you think of any additions or want to write something and have me add it let me know 00:25 kados (besides writing Koha that is :-) 00:25 chris will do 00:26 chris rosalie might want to add something 00:26 kados well I've gotta get to bed 00:27 kados we've got a meeting at 8:00 with Dr. Chang's new class ... more student programmers ready to work on stuff 00:27 chris right :-) 00:27 chris should be a koha irc meeting next week 00:28 chris so ill cya there if not before :) 00:28 kados right:-) 00:28 kados nite 00:28 chris night 02:01 chris evening paul and russ 02:02 russ evening 02:09 paul hi chris & russ 02:10 russ i guess it isnt evening where you are paul 02:10 paul no, it's 9AM ;-)