[ic] Problem uploading Excel to IC 4.8.2 on FreeBSD 4.2/Perl 5.005_03

George Entenman interchange-users@interchange.redhat.com
Fri Nov 2 15:13:01 2001


After uploading an excel file (the one I 
downloaded with one change), IC showed me a
Preview page.  I told it to rebuild products data
(and answered 'no' to the other 3 questions)
and hit "Finish".

Here's what I got:

    FATAL error

    DBD::mysql::db do failed: You have an error in your SQL syntax near 
'where sku = 'os28070'' at line 1 at /interchange/lib/Vend/Table/DBI.pm line 
1129,  chunk 21.

    Progress to date:

    table inventory: Using fields from file: 'sku quantity stock_message 
account cogs_account'


I removed the item os28070, and got a similar 
error for another sku, so I doubt that the data
is the problem.

This is line 1129 from DBI.pm:

    $s->[$DBI]->do("update $s->[$TABLE] SET $column=$value where $s->[$KEY] = 
$key");

This is Interchange 4.8.2 on FreeBSD 4.2. using 
Perl 5.005_03.  (The same file uploads fine on
Interchange 4.8.2 on our Redhat linux box).

Any help will be greatly appreciated!

-- George Entenman