[ic] Loading of SQL table failing

Ed LaFrance interchange-users@icdevgroup.org
Sun Sep 15 11:59:01 2002


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
>

MySQL is definitely gaging on the import data step here. Perhaps you a 
trying to import empty data into a field which is defined as NOT NULL, or 
maybe there is an errant carriage return somewhere in the file, breaking a 
single row into two pieces.

One thing you could do is remove all data from the text file except the 
header row, and let IC build an empty table. Then use the UI to import 
chunks of the table at a time. When you get an error message, examine that 
chunk for problems.

- Ed L.


===============================================================
Increase profits from your Interchange store...
http://www.newmediaems.com/cgi-bin/nm/software_fus.html
===============================================================
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================