[ic] Loading of SQL table failing

Chaim Klar interchange-users@icdevgroup.org
Tue Sep 17 10:03:03 2002



>From: Ed LaFrance <edl@newmediaems.com>
>Reply-To: interchange-users@icdevgroup.org
>To: interchange-users@icdevgroup.org
>Subject: Re: [ic] Loading of SQL table failing
>Date: Sun, 15 Sep 2002 08:58:29 -0700
>
>At 06:34 PM 9/14/2002 -0700, you wrote:
>>I'm having roubles converting from dbm to MySQL.  I have managed to
>>bring up a smaller table without any issue, but the products table
>>will not load.  I had added the additional fields, and double
>>checked them against my original products.txt, and it is perfect.
>>Where I may be running into problems is the lack of documentation
>>on all of the fields used in the .mysql file.  Anyway, I'm stuck...
>>
>>I have the debugging enabled, if you need to see all of the
>>details...  BTW, this is 4.8.6...
>>
>>Barry
>>
>>[snip]
>>
>>- - - [14/September/2002:21:15:50 -0400] - - table 'products'
>>failed: products import failed: You have an error in your SQL
>>syntax near ' '', '', '', 'X', 'X', 'X', 'X', '', '098.pdf', 'T3')'
>>at line 1
>>

Hi:

Most of the time when I got this error, the problem was having an "empty
number field" (i.e. integer)

Thank You
Chaim Klar