On Sun, Mar 31, 2002 at 01:35:50PM +1000, Roger Buck said:
Chris Cormack wrote:
Update of /cvsroot/koha/koha/acqui.simple
There seem to be some lingering addbooks.pl problems with my implementation:
When I click on "Enter book with no ISBN" I get this in http error log:
DBD::mysql::st execute failed: You have an error in your SQL syntax near '' at line 2 at /var/www/cgi-bin/koha/acqui.simple/addbooks.pl line 280. DBD::mysql::st fetchrow failed: fetch() without execute() at /var/www/cgi-bin/koha/acqui.simple/addbooks.pl line 281.
If I change this from:
biblioitems where bibiloitemnumber=$biblioitemnumber
(around line number 275)
...to a valid hard-coded value, say:
biblioitems where bibiloitemnumber=8
then I get no error... and an extra table:
"Existing Items with ISBN NULL"
appears in the web page (which I assume signifies correct completion - I have not previously seen that table appear :-)
I was wondering if someone (who understands perl better than I do) could have a look at the logic there and see if it's suspect?
Looks suspect to me. Im the problem is $biblioitemnumber is empty ... im not sure what is supposed to happen but that query is never going to work from that link. Chris -- Chris Cormack Programmer 025 500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz