Time Nick Message 11:56 kados morning owen 11:56 owen Hi kados 11:57 paul hi owen & kados 11:57 paul (even if with zebra 2.0.8, that seem not to solve the problem) 11:57 kados paul: likely the index needs to be re-built 11:57 paul it has been rebuilded 11:57 kados ahh 11:58 kados very strange 11:58 paul but I could check once again 11:58 kados paul: did you post a message to koha-zebra? /me didn't see it 11:58 paul nope, i send a message on zebra-list 12:15 pupung hi guys 12:15 pupung anybody awake? 12:20 pupung hello? 12:20 paul hi pupung. Some of us are awake, but we all are busy, for sure ! 12:21 pupung ok 12:21 pupung i backed up my db using phpmyadmin im using mysql 4 on a windows 2000 server machine 12:21 pupung when i restore my backup... it says: error 1064 You have an error in you SQL syntax 12:22 pupung it seems that phpmyadmin dumped my db as a mysql5 db 12:22 paul for sure. 12:22 pupung what shall i do now? i have no other backups,, 12:22 paul there is a parameter in mysqldump to tell that you want mysql 4 dump. 12:22 paul if you can't access your mySQL5 DB anymore, I'm afraid you'll have to install a mySQL 5. 12:23 paul otherwise : 12:23 paul ยท --compatible=name 12:23 paul Produce output that is more compatible with other database systems 12:23 pupung oohh.. but how is my poor koha installation... 12:23 paul or with older MySQL servers. The value of name can be ansi, 12:23 paul mysql323, mysql40, postgresql, oracle, mssql, db2, maxdb, 12:23 paul no_key_options, no_table_options, or no_field_options. To use 12:23 paul several values, separate them by commas. These values have the same 12:23 paul meaning as the corresponding options for setting the server SQL 12:23 paul mode. See the section called "THE SERVER SQL MODE". 12:23 paul This option does not guarantee compatibility with other servers. It 12:23 paul only enables those SQL mode values that are currently available for 12:23 paul making dump output more compatible. For example, --compatible=oracle 12:23 paul does not map data types to Oracle types or use Oracle comment 12:23 paul syntax. 12:28 pupung hmm.. 12:31 pupung can i just restore it to a mysql 5 server 12:32 pupung then backup it again using compatibility mode? 12:32 paul yep, i'm afraid 12:32 paul that's the only possibility 18:00 slef hi 18:00 dewey hola, slef 19:05 hdl hi slef. Happy New Year. 20:04 pupung does anybody know if the pdf creation tool works on koha 2.2.7 for windows? 21:07 slef as in the barcode generator 21:07 slef ? 21:08 slef It didn't work for me on GNU/Linux until I hacked it a bit. kohabug 1241 has my patch. 21:15 pupung hmm.,. 21:15 pupung well it worked for me 21:15 pupung on linux 21:15 pupung but i need to install koha on a windows machine 21:17 mason hiya pupung 21:18 mason i wrote the new barcode stuff 21:18 mason but i havent tried it at all on windows 21:19 mason but it should work ok 21:20 pupung really 21:20 pupung is it on the cvs? 21:20 mason there was a clumsy bit of code where it wrote the pdf to a temp file, before redirecting the file back to your browser 21:20 pupung i get this stuff: Premature end of script headers: barcodesGenerator.pl, referer: http://intranet/cgi-bin/koha/barcodes/barcodes.pl 21:20 pupung Unable to open /tmp/614105-127.0.0.1-(From 001 to 250)-[17.1.2007]-[7:5:11].pdf for writing at C:/usr/site/lib/PDF/API2/Basic/PDF/File.pm line 511., referer: http://intranet/cgi-bin/koha/barcodes/barcodes.pl 21:20 mason which could have been and issue, but that got fixed :) 21:20 pupung really? 21:21 pupung so.. its on cvs now? 21:21 mason yep 21:21 pupung ok will check.t 21:21 pupung thanks for the infor 21:22 mason pupung: fyi , the barcodesGenerator.pl is the old original barcode stuff 21:22 mason lemme find you the newer commits in cvs... 21:23 pupung ahh ok.. 21:23 pupung ermm one thing,, can i ask you one more favor.. 21:23 mason yep, shoot 21:24 pupung i dont know how to browse the cvs through windows.. can i just get the new files through dcc or email? 21:24 pupung if that wouldnt be to much for me to ask.. 21:24 pupung hehe 21:24 mason ah, its pretty easy 21:24 mason there is a web interface, like this -> 21:24 mason http://cvs.savannah.gnu.org/viewcvs/koha/barcodes/?root=koha&only_with_tag=dev_week#dirlist 21:24 pupung oh ok 21:26 mason if you clck on any of those files to view, there is a 'download' option for each of them... 21:26 pupung ahh alright 21:26 pupung sooo i will only replace the barcodegenerator and barcodes.pl? 21:27 mason hmmm, theres a few more steps to it :( 21:28 pupung uh ok.. 21:29 mason gimme a tick ... 21:30 mason try running this url -> http://intranet/cgi-bin/koha/barcodes/label-home.pl 21:31 mason chris mentioned that my new barcode files are probably included in 2.2.7 21:31 pupung ohhh,, im using 2.2.7 already 21:31 pupung himp... 21:31 pupung so its not running.. 21:32 mason but the updated links havent been added to the 'koha admin' page 21:33 mason u might need to check in mysql to see if the new barcode tables have been added too 21:33 pupung ok il check 21:34 mason there should be 3 new tables .... labels, labels_conf, labels_templates 21:35 mason im not sure if the 2.2.7 installer creates them 21:35 pupung ah yeah.. 21:35 pupung actually i was originally using 2.2.7 on linux 21:35 pupung then i exported my db 21:35 pupung then i restored it 21:35 pupung so no changes reallty 21:37 mason ok, so youve got those 3 labels* tables in your db? 21:37 pupung yeah 21:37 pupung already 21:37 mason cool 21:38 mason ah, but i dont think the template files have been added to 2.2.7 21:39 pupung i tried the print pdf thing in the label-home 21:39 pupung and... its not a pdf that i download after the creation 21:39 pupung its a .pl file 21:39 pupung hehehhe 21:40 mason aaaah , right 21:40 mason we just fixed that last week 21:41 chris it is really a pdf 21:41 pupung yeah 21:41 chris if you rename it, it works 21:41 mason yep 21:41 pupung i saw the header 21:41 pupung hehehe 21:41 pupung so that's the now way to create a label? 21:42 mason yep 21:42 pupung ahh alright,, i miss the old way 21:42 pupung hehehe 21:42 pupung thankssss.. 21:42 pupung thank you very much.. 21:43 mason fyi: chris fixed that bug last month here -> http://cvs.savannah.gnu.org/viewcvs/koha/barcodes/label-print-pdf.pl?cvsroot=koha&only_with_tag=dev_week&r1=1.1.2.2.2.5&r2=1.1.2.2.2.6 21:45 mason get the latest version from cvs to fix that bug 21:45 pupung oh ok. thanks 21:48 mason try this one... 21:48 mason http://cvs.savannah.gnu.org/viewcvs/koha/barcodes/label-print-pdf.pl?root=koha&only_with_tag=dev_week&view=markup 21:52 pupung ok,, ill search for bull.pm 21:56 mason woah, that line is a comment. 21:56 pupung ahh really 21:56 pupung it's not 21:56 pupung hehe 21:56 pupung doesnt have # 21:57 pupung ahh ok 21:57 pupung i get it 21:57 pupung sorry 21:57 pupung hehe 21:57 mason yep, see the 'download' and 'text' options up the top 21:57 mason click the text one, to see the file contents 21:58 pupung now its looking for serials.pm 21:59 mason i dont think it needs it, comment that lne out 22:00 pupung now its lookin for pdf report 22:00 pupung ok ill install it first 22:01 mason yep 22:04 mason and PDF::Reuse::Barcode 22:15 pupung hmm. 22:15 pupung somethings wrong 22:16 pupung hmm 22:16 mason yes, ive spotting something too 22:17 mason that updated 'label-print-opus-pdf.pl' file needs the newer Labels.pm file too 22:18 pupung wow.. 22:18 pupung wooow 22:18 pupung so i need to download the whole folder then? 22:18 mason hmmmm, yeah :) 22:20 mason basically , i would grab all the barcode files from dev-week in cvs 22:21 pupung :) 22:21 pupung thank you, thats very nice of you 22:22 mason no probs, gimme a day or two and ill test out some instructions that work 22:26 mason fyi: your original error, is probably a file permission problem with your /tmp dir 22:26 pupung anyway im no hurry 22:26 mason Unable to open /tmp/614105-127.0.0.1-(From 001 to 250)-[17.1.2007]-[7:5:11].pdf for writing at C:/usr/site/lib/PDF/API2/Basic/PDF/File.pm line 511 22:26 pupung ill have to catalogue 500 books 22:26 pupung heheh 22:27 mason where ever the hell /tmp is on a windows box... 22:28 pupung haha 22:28 pupung i tried to place it c:\tmp 22:31 mason yeah, /tmp might even be set by perl or apache 22:44 pupung ok.. 22:44 pupung i have another problem 22:44 pupung hehe.. on the opac. i couldnt see the call numbers of my items 22:45 pupung anyway ill check whats happening 22:58 pupung ohh i reinstalled koha, and the barcode thing works partly 22:58 pupung it created a pdf file 23:01 pupung however,, the pdf file has only the barcodes of the items and nothing else (i.e call number, title etc) 05:52 rach paul? 05:52 dewey hmmm... paul is preparing to issue a release while the NPL templates are not working for the record editor now. 05:52 rach erg - bots 05:52 paul yep rach, i'm here 05:52 paul hello 05:52 dewey niihau, paul 05:53 rach hi, chris says you were after me 05:53 paul yes. 05:53 paul but i don't know why anymore :'( 05:53 chris logos? 05:54 paul nope. 05:54 paul hello chris. 05:54 rach buttons? 05:54 paul I have an important question for you 2 05:54 rach babies :-) 05:54 paul it's about rel_2_2 05:55 paul babies, why not ? but no, it was not about baby ;-) 05:55 paul I've seen many commits from james mason recently. 05:55 chris mason james :) 05:55 paul that introduces new features (& thus instability probably) 05:56 chris ahh the holidays stuff? 05:56 paul yep, & some stuff on serials iirc 05:56 chris serials would have been bob 05:56 paul right. in december. 05:57 paul anyway, I was wondering what was in those commits. 05:57 paul because it's important to have a rock solid 2.2 and i'm not sure that they won't introduce some instability? 05:57 chris right, the serial ones were fixes for the serials 05:57 paul s/?/./ 05:58 chris the holidays is the holidays module backported from rel_3_0 05:58 chris rch asked him to commit that, it works well, and only makes one minor change to issuebook 05:59 btoumi hi all 05:59 chris so that you can define holidays, and koha wont issue to those dates 06:00 chris he may have also committed an export tool, which probably shouldnt be there 06:00 chris perhaps that one is better in dev_week 06:00 paul i've seen the export tools, i've nothing against it, as it strictly changes nothing in the DB or core feature. 06:00 chris cool 06:00 paul i'm more afraid by serials & holiday commits. 06:01 chris the serials one was fixes 06:01 paul i'll have to check them carefully, to be sure they don't create instability. 06:01 chris yep 06:01 paul (+ port templates things into default templates) 06:01 rach erg, off to take pain killers 06:02 rach paul if you remember what you wanted maybe mail me :-) 06:02 paul rach: ok 06:02 chris right, i think he may have just committed for the npl ones 06:02 chris you have seen the holidays module in action in 3.0 ? 06:03 paul (on phone, 1mn pls) 06:03 mason hi paul 06:10 paul hi mason. 06:10 paul chris, i'm back 06:11 paul about the holiday module in action => what kind of "action" ? 06:11 chris ahhh seen it working is what i meant? 06:11 chris it has one page that lets you set holidays 06:12 paul then you should ask btoumi, because i've not seen it directly, but if it didn't worked, the library should have seen it 06:12 paul normally, yes, it works : 06:12 paul - you can define holidays 06:12 chris and then a subroutine that when you give it a date, checks its not a holiday and if it is finds a date that isnt 06:12 paul - when a return date is a closed day, it is moved 06:12 chris right 06:12 mason yep 06:12 chris thats what we backported 06:13 paul to the next opened day. 06:13 chris so it does the same thing 06:13 paul ok, then it should work as well. 06:13 chris yes thats a good idea 06:13 paul because some libraries will not want zebra (as it's useless for them) 06:14 chris yes, overkill 06:14 paul but could like other 3.0 improvements 06:14 chris right (like holidays:)) 06:14 paul like holidays, news, and so many many things 06:14 chris and the fines work 06:14 chris that bruno did 06:14 chris yep 06:14 mason bruno++ 06:14 btoumi thanks 06:15 paul another possibility would be to fore-port the SQL marc management into 3.0 to have a 3.0 SQL only version. 06:15 paul i don't know which would be the easiest ! 06:15 chris hmmm 06:15 chris i think to backport features, one or 2 at a time might be easier 06:15 btoumi but for the automatic calcul of return date don't work in day open 06:16 mason btoumi: for fines?? 06:17 btoumi for fines yes 06:18 btoumi i work with special and repeatable holidays 06:18 btoumi but for issues the automatic calcul of date return don't work 06:21 mason btoumi: is that because of a bug in the holidays code? 06:33 btoumi mason: i don't know because i have not enough time to investigate 07:12 paul "night chris 07:13 btoumi good night chris