IRC log for #koha, 2004-09-16

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

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 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 My problem is usually because I get stuck on how I think things should work instead of how they really work.
13:24 About an hour and 15 minutes ago :)
13:24 rach ah so you're still about?
13:24 where abouts are you tim?
13:24 tim Sometimes
13:25 Yup.  Southeast Iowa
13:26 rach is there anything someone else - like us? could help you with in getting your data migrated?
13:27 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 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 or so
13:32 I think actually chris will be there a lot longer
13:33 mapping marc isn't probably our strong suite
13:33 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 DELETE FROM issues WHERE returndate IS NOT NULL AND itemnumber=? LIMIT?
23:05 in the script
23:05 chris oh right
23:05 LIMIT ?
23:06 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 dumping means u can port it to whatever version
23:07 whatever OS etc
23:08 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 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 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 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 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 huh
23:15 how would one find out?
23:15 actually ... it works when I do it from the sql command line
23:16 if that means anything ...
23:17 chris how odd
23:18 oh
23:18 ''13'' double ''
23:18 perhaps its making it limit '13'
23:19 instead of limit 13
23:19 kados hmmm
23:19 chris for some reason
23:19 kados lemme check
23:20 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 while (my $items=$count_items_sth->fetchrow_arrayref) {
23:20 my $count=$items->[0];
23:20 is how it arrives at $count
23:21 my $del_issues_sth=$dbh->prepare("DELETE FROM issues WHERE returndate IS NOT NULL AND itemnumber=? LIMIT ?");
23:21 $del_issues_sth->execute($itemnumber, $count);
23:21 (totally out of order of course :-))
23:21 chris hmm that oughta work
23:21 weird
23:22 could try
23:22 my $del_issues_sth=$dbh->prepare("DELETE FROM issues WHERE
23:22   returndate IS NOT NULL AND itemnumber=? LIMIT $count");
23:22 and  $del_issues_sth->execute($itemnumber);
23:23 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 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 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 itemnumber=276476 count=20 at issuesclean.pl line 47.
23:27 chris thats mental
23:27 kados :-)
23:27 chris could go
23:28 ah no
23:28 weird
23:29 DELETE FROM issues WHERE returndate IS NOT NULL AND itemnumber=276476 limit 20
23:30 works fine from the command line ?
23:31 kados yep
23:31 chris how odd
23:31 kados maybe a DBD bug?
23:31 DBI?
23:31 chris seems weird
23:32 how about doing
23:32 my $query="DELETE FROM issues WHERE returndate IS NOT NULL AND itemnumber=$itemnumber limit $count";
23:32 my $sth=$dbh->prepare($query);
23:33 $sth->execute || die $query;
23:33 at least we will get to see the actual query its executing that way
23:33 kados ok ...
23:38 well it might be working
23:38 chris somethign weird was happening
23:39 i think and it was thinking the count was a string
23:39 kados mysql> select count(*) from issues;
23:39 +----------+
23:39 | count(*) |
23:39 +----------+
23:39 |   304415 |
23:39 +----------+
23:39 chris so was escaping it with '
23:39 kados 1 row in set (0.00 sec)
23:39
23:39 mysql> select count(*) from issues;
23:39 +----------+
23:39 | count(*) |
23:39 +----------+
23:39 |   298531 |
23:39 +----------+
23:39 1 row in set (0.00 sec)
23:39
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 and deleting all the issues again :-)
23:40 maybe not ... it finally stopped
23:41 well everything looks fine
23:42 wow ... thanks chris
23:42 chris cool
23:42 so somehow it was thinking count was a string
23:43 kados so I ran the script again
23:43 and got:
23:43 koha:/build/npl_custom_scripts# perl -I /build/koha issuesclean.pl
23:43 Use of uninitialized value in string at issuesclean.pl line 68.
23:43 is that because there's nothing to do?
23:44 chris yep, ull be using $count when its empty
23:44 or itemnumber
23:44 kados right
23:45 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 :-)
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 for patriots act reasons
23:47 chris u could move to oldissues (so they dont slow stuff done) and anonymise them
23:47 done=down
23:47 kados ahh
23:47 chris ie make all borrower numbers=1
23:47 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 mind you
23:48 thats all in statistics anyway
23:48 kados yea I know
23:48 chris hmm
23:48 could be a 2 step process
23:48 move to old issues
23:48 then, delete from old issues
23:48 so move .. check its all ok
23:48 move back if not
23:49 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 :-)
23:49 chris :)
23:50 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 zero the borrowernumbers for issues
23:53 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 there's this weird apache thing
00:10 try it now
00:10 chris ahh thats more like it
00:11 kados its creeping along on my old Pentium 1
00:11 hehe
00:11 I've gotta get some better hardware
00:11 chris :)
00:12 kados I really like blosxom
00:12 chris what rss agro do you use?
00:12 see if you can get my rss stuff to work for you
00:13 http://kados.org/cgi-bin/blosxom.cgi/index.rss
00:13 chris i use bloglines .. so it wont :)
00:13 kados bummer
00:13 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 BTW: have you seen the self-checkout yet?
00:14 chris oh hey
00:14 it does work in bloglines
00:14 kados 66.213.78.60/sco.html
00:14 really? ... /me tries again
00:15 cool!
00:16 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 31000000000061
00:17 (no idea what these items are)
00:17 :-)
00:18 chris hmm im already logged in it says
00:19 ahh firefox is blocking the pop up
00:19 hehe
00:19 kados did you get the javascript popup?
00:19 right
00:19 check the x
00:19 :-)
00:19 I always forget about that and wonder why a site isn't working
00:19 chris very cool
00:20 you guys should do some screen shots
00:20 kados well it's not live yet
00:20 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 its pretty neat
00:21 kados yea ... will do
00:21 I'm working on my sysadmin manual lately
00:21 chris cool
00:22 kados here's the index:
00:22 Part I: Installation and Migration
00:22 1: Installing Koha on Debian (jferraro)
00:22 2: Installing Koha on Redhat AS (shedges)
00:22 3: Installing Koha on Fedora (jferraro)
00:22 4: Migrating to Koha (shedges)
00:22 5: Customizing Koha's Template System (oleonard)
00:22                                                                            
00:22 chris woo
00:22 kados Part II: Maintenance and Troubleshooting
00:22 6: Updating Koha (jferraro)
00:22        setting up a testing environment
00:22        setting up CVS symlinks
00:22 7: Backups (jferraro)
00:22        backing up and restoring the database
00:22                role of replication as backup
00:22        backing up and restoring the filesystem
00:22 8: Optimization (jferraro)
00:22        optimizing MySQL
00:22        load balancing with replication
00:22 9: Troubleshooting (jferraro)
00:22        Koha's error reporting
00:22        database corruption
00:22        worst-case scenario: utilizing the statistics table
00:22 Part III: Participating in the Koha Community
00:22 10: Communicating with the developers(jferraro)
00:23        mailing lists
00:23        IRC
00:23        Wiki
00:23 chris heh worst case scenario :-)
00:23 kados 11: Reporting Bugs (jferraro)
00:23 12: Submitting Code (jferraro)
00:23 Appendix:
00:23 Installing the Z3950 Server (jferraro)
00:23 Cleaning up the issues data (shedges)
00:23 Renewals (shedges)
00:23 Reserves (shedges)
00:23 Handling Overdue Items (shedges)
00:23 :-)
00:23 well it's a start
00:23 chris excellent
00:24 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 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 that's be sweet
00:24 but so much is changing so fast ...
00:24 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 (besides writing Koha that is :-)
00:25 chris will do
00:26 rosalie might want to add something
00:26 kados well I've gotta get to bed
00:27 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 should be a koha irc meeting next week
00:28 so ill cya there if not before :)
00:28 kados right:-)
00:28 nite
00:28 chris night
02:01 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 ;-)

← Previous day | Today | Next day → | Search | Index

koha1