[ic] Loading of SQL table failing

Barry Treahy, Jr. interchange-users@icdevgroup.org
Sat Sep 14 21:35:01 2002


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


- - - [14/September/2002:21:15:50 -0400] - - table products created: create table products (
> sku char(64) NOT NULL PRIMARY KEY,
> description VARCHAR(128) NOT NULL,
> title VARCHAR(128) DEFAULT '' NOT NULL,
> template_page VARCHAR(64),
> comment TEXT,
> thumb VARCHAR(64),
> image VARCHAR(64),
> price DECIMAL(12,2) NOT NULL,
> wholesale DECIMAL(12,2) NOT NULL,
> prod_group VARCHAR(64) NOT NULL DEFAULT '',
> category VARCHAR(64) NOT NULL DEFAULT '',
> tax_category VARCHAR(64),
> nontaxable CHAR(3),
> weight VARCHAR(12) DEFAULT '0' NOT NULL,
> size VARCHAR(96),
> color VARCHAR(96),
> gift_cert VARCHAR(3),
> related text,
> featured VARCHAR(32),
> download VARCHAR(64),
> dl_type VARCHAR(8),
> dl_location VARCHAR(64),
> inactive VARCHAR(3),
> url VARCHAR(128),
> sale_price DECIMAL(12,2) NOT NULL,
> image_large VARCHAR(64),
> delivery VARCHAR(32),
> oldsku VARCHAR(18),
> prefix VARCHAR(8),
> body VARCHAR(8),
> vswr VARCHAR(4),
> genders VARCHAR(8),
> interfaces VARCHAR(16),
> contact VARCHAR(8),
> cable VARCHAR(128),
> power decimal(5,1) NOT NULL,
> dbranges VARCHAR(8),
> freqmin decimal(8,2) NOT NULL,
> freqmax decimal(8,2) NOT NULL,
> phase char(4) NOT NULL,
> length VARCHAR(8),
> xfersku char(128),
> security VARCHAR(4) NOT NULL DEFAULT '',
> allow_us VARCHAR(1) NOT NULL DEFAULT '',
> allow_uk VARCHAR(1) NOT NULL DEFAULT '',
> allow_intl VARCHAR(1) NOT NULL DEFAULT '',
> allow_disty VARCHAR(1) NOT NULL DEFAULT '',
> wirecatpage VARCHAR(8),
> stdcatpage VARCHAR(8),
> tier VARCHAR(4)
> )
>
- - - [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
>
 


-- 

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

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