Running "updatedatabase" script from the command line: "perl updatedatabase -I /pathtoC4folder" solved all these problems Thanks Chris R. Roger Buck wrote:
Using koha CVS
I have MySQL-3-23-44-1, perl-500503-12 and have just installed latest DBD::mysql fron cpan on RH6.2 (with all RH ERRATA installed).
When adding new item to library inventory I get DBD errors - /var/log/messages says:
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 275.
If I change the '' to "" all is well....
DBD::mysql::st fetchrow failed: fetch() without execute() at /var/www/cgi-bin/koha/acqui.simple/addbooks.pl line 276.
... I dunno about this one.
I assume that the final error (below) is because 'lccn' is missing from one or more tables - If so, should lccn be added to "newitems" and/or others?
DBD::mysql::st execute failed: Unknown column 'lccn' in 'field list' at /var/www/cgi-bin/koha/acqui.simple/addbooks.pl line 207.
Any hints on where to look to solve one or more of the above?