Re: [Koha-devel] Acquisition errors

[Roger Buck]

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?