← 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