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?