[ic] Loading of SQL table failing

[interchange-users@icdevgroup.org (Barry Treahy, Jr.)]

Barry Treahy, Jr. 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...
>>>>
>>>> [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. 
>>
> Ok, I believe I've isolated what appears to be the problem but it 
> makes no senese.  The import is choking on a field named 'phase' which 
> is not a MySQL reserved word nor it is documented as an IC reserved 
> word.  Why is this happening?   I can do the obvious, changing the 
> name, but I don't want to do a guessing game on what others 
> undocumented reserved words exist...

As what seems to be a rather typical experience for me, I shoot of my 
mouth too early when I'm tired...  After changing the name from phase to 
phaze, the first record loaded but it failed on the second...

Barry

-- 

Barry Treahy, Jr  *  Midwest Microwave  *  Vice President & CIO 

E-mail: Treahy@mmaz.com * Phone: 480/314-1320 * FAX: 480/661-7028