
[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] Problem uploading Excel to IC 4.8.2 on FreeBSD 4.2/Perl 5.005_03
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
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users