[ic] 4.9.8 Nightly Build Options

Mat Jones mat at booksellersolutions.com
Thu Sep 25 00:30:02 EDT 2003


I noticed the following problem on two different nightly builds i have installed 
on 2 different servers.

4.9.8-200309180658 - DBI found (v1.38). Perl 5.8.0
4.9.8-200307240658 - DBI found (v1.37). Perl 5.6.1

I get the following error when trying to select any option type and click 'Update'.

table options: set_slice error as called by Vend::Interpolate: DBD::mysql::st 
execute failed: You have an error in your SQL syntax near 'WHERE code = 'DOG'' 
at line 1 at /home/interch/4.9.8/lib/Vend/Table/DBI.pm line 1245. query 
was:update options SET WHERE code = 'DOG' values were:''

I enabled debugging in the area around line 1245 and got the following in my 
icdebug:

Vend::Table::DBI:debug: set_slice query: update options SET  WHERE code = 'DOG'
Vend::Table::DBI:debug: set_slice key/fields/values:
key=DOG
[]
[]

Looks like the sql query is missing some information.

Any help would be greatly appreciated.

Thanks

Mat










More information about the interchange-users mailing list