菜鸟求助!发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上

Zen Cart的安装、设置、升级讨论和使用技巧交流

版主: shaning

菜鸟求助!发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上

帖子stellarying » 2011-12-31 10:55

版主请问这是什么问题:
发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上提出。

用后台直接上传的那些产品是更新成功的,最后一个用批量的上传就失败了。


上传结果
文件上传成功。
临时文件名: /tmp/phprE0suu
用户文件名: CAP.csv
大小: 33687

更新成功! - 型号: test | s/201107/a | F030 Quad | Main Featu | | 6 | | 1969-12-31 | 139 |

154 | 0 | 2 | 2011-12-29 | 2011-7-12 | 1000 | | Cell Phone | Iphone | | | | | | | 1 | 0 | 0

| 0 | 0 | 0 | | | |
更新成功! - 型号: test | s/201107/a | F030 Quad | Main Featu | | 6 | | 1969-12-31 | 139 |

154 | 0 | 2 | 2011-12-29 | 2011-7-12 | 1000 | | iPhone Acc | Case for I | | | | | | | 1 | 0

| 0 | 0 | 0 | 0 | | | |
更新成功! - 型号: test | s/201107/a | F030 Quad | Main Featu | | 6 | | 1969-12-31 | 139 |

154 | 0 | 2 | 2011-12-29 | 2011-7-12 | 1000 | | iPhone Acc | Cablefor I | | | | | | | 1 | 0

| 0 | 0 | 0 | 0 | | | |
更新成功! - 型号: test | s/201107/a | F030 Quad | Main Featu | | 6 | | 1969-12-31 | 139 |

154 | 0 | 2 | 2011-12-29 | 2011-7-12 | 1000 | | Cell Phone | PDA Phone | | | | | | | 1 | 0 |

0 | 0 | 0 | 0 | | | |
更新成功! - 型号: test | s/201107/a | iPhone 3G | Wholesale | | 4.6 | | 0001-01-01 | 4.6 |

5.5 | 0 | 1 | 2011-8-21 | 2011-7-12 | 1000 | | iPhone Acc | Case for I | | | | | | | 1 | 0 |

0 | 0 | 0 | 0 | | | |
更新成功! - 型号: WBH054 | s/201107/a | WBH054 hot | cond | | | | | 158 | 188 | 0 | 2 |

2011-12-29 | 2011-7-12 | 1000 | | Wedding Dr | Beach Wedd | three-clas | | | | | | 1 | 0 | 0

| 0 | 0 | 0 | | | |
更新成功! - 型号: WBH058 | s/201107/a | WBH058 swe | cond | | | | | 328 | 400 | 0 | 2 |

2011-12-29 | 2011-7-12 | 100 | | Wedding Dr | Beach Wedd | three-clas | | | | | | 1 | 0 | 0

| 0 | 0 | 0 | | | |
更新成功! - 型号: test | s/201107/b | F073 Dual | Main Featu | | | | | 107 | 119 | 0 | 0.5 |

2011-8-21 | 2011-7-16 | 10000 | | Cell Phone | Iphone | | | | | | | 1 | 0 | 0 | 0 | 0 | 0 |

| | |
更新成功! - 型号: test | s/201107/a | Unlocked O | Product | | | | | 650 | 722 | 0 | 2 |

2011-8-21 | 2011-7-12 | 1000 | | Cell Phone | Iphone | | | | | | | 1 | 0 | 0 | 0 | 0 | 0 | |

| |
更新成功! - 型号: test | s/201107/a | Rhinestone | Wholesale | | 10.99 | | 0001-01-01 |

10.99 | 12.2 | 0 | 2 | 2011-8-21 | 2011-7-12 | 1000 | | iPhone Acc | Case for I | | | | | |

| 1 | 0 | 0 | 0 | 0 | 0 | | | |
更新成功! - 型号: test | s/201107/a | AV Cable f | Show your | | 6.9 | | 0001-01-01 | 6.9 |

7.5 | 0 | 1 | 2011-8-21 | 2011-7-12 | 1000 | | iPhone Acc | Cablefor I | | | | | | | 1 | 0 |

0 | 0 | 0 | 0 | | | |
更新成功! - 型号: test | s/201107/a | YPhone I68 | Hot Spots: | | | | | 122 | 164 | 0 | 2 |

2011-8-21 | 2011-7-12 | 1000 | | Cell Phone | PDA Phone | | | | | | | 1 | 0 | 0 | 0 | 0 | 0

| | | |
更新成功! - 型号: test | s/201107/a | F030 Quad | Main Featu | | | | | 139 | 154 | 0 | 2 |

2011-8-21 | 2011-7-12 | 1000 | | Cell Phone | PDA Phone | | | | | | | 1 | 0 | 0 | 0 | 0 | 0

| | | |
更新成功! - 型号: 10001 | s/201112/b | New York Y | | | | | | 16 | 16 | 16 | 0.2 | 2011-12-

29 | 2011-12-28 | 92 | | CAP | MLB | New York Y | | | | | | 1 | 0 | 0 | 0 | 0 | 0 | | | |
添加新商品失败! - 型号: 10002 - SQL错误。检查上传目录中的错误记录。

用后台直接上传的那些产品是更新成功的,最后一个用批量的上传就失败了。


打开了temp里面的ep_debug_log,里面显示的是:
MySQL error 1110: Column 'products_price_sample' specified twice
When executing:
INSERT INTO products SET

products_model

= '1111' ,

products_price

= '139' ,

products_price_retail =

'154' ,

products_price_sample =

'0' ,

products_image

= '111111' ,

products_weight

= '2' ,

products_tax_class_id =

'' ,

products_date_available =

'' ,

products_date_added

= '2011-07-12 23:38:00' ,

products_last_modified =

CURRENT_TIMESTAMP ,

products_quantity

= '1000' ,

master_categories_id =

'14' ,

manufacturers_id

= 'NULL',

products_status

= '1',

metatags_title_status =

'0',

metatags_products_name_status = '0',

metatags_model_status =

'0',

metatags_price_status =

'0',

metatags_title_tagline_status = '0'

, products_price_retail='154' , products_price_sample='0'
MySQL error 1110: Column 'products_price_sample' specified twice
When executing:
INSERT INTO products SET

products_model

= 'S1111' ,

products_price

= '139' ,

products_price_retail =

'154' ,

products_price_sample =

'0' ,

products_image

= '111111' ,

products_weight

= '2' ,

products_tax_class_id =

'' ,

products_date_available =

'' ,

products_date_added

= '2011-07-12 23:38:00' ,

products_last_modified =

CURRENT_TIMESTAMP ,

products_quantity

= '1000' ,

master_categories_id =

'14' ,

manufacturers_id

= 'NULL',

products_status

= '1',

metatags_title_status =

'0',

metatags_products_name_status = '0',

metatags_model_status =

'0',

metatags_price_status =

'0',

metatags_title_tagline_status = '0'

, products_price_retail='154' , products_price_sample='0'
MySQL error 1110: Column 'products_price_sample' specified twice
When executing:
INSERT INTO products SET

products_model

= 'S1111' ,

products_price

= '139' ,

products_price_retail =

'154' ,

products_price_sample =

'0' ,

products_image

= '111111' ,

products_weight

= '2' ,

products_tax_class_id =

'' ,

products_date_available =

'' ,

products_date_added

= '2011-07-12 23:38:00' ,

products_last_modified =

CURRENT_TIMESTAMP ,

products_quantity

= '1000' ,

master_categories_id =

'14' ,

manufacturers_id

= 'NULL',

products_status

= '1',

metatags_title_status =

'0',

metatags_products_name_status = '0',

metatags_model_status =

'0',

metatags_price_status =

'0',

metatags_title_tagline_status = '0'

, products_price_retail='154' , products_price_sample='0'
MySQL error 1110: Column 'products_price_sample' specified twice
When executing:
INSERT INTO products SET

products_model

= '10002' ,

products_price

= '16' ,

products_price_retail =

'16' ,

products_price_sample =

'16' ,

products_image

= 's/201112/b/13250847462.jpg' ,

products_weight

= '0.2' ,

products_tax_class_id =

'' ,

products_date_available =

'' ,

products_date_added

= '2011-12-29 07:05:00' ,

products_last_modified =

CURRENT_TIMESTAMP ,

products_quantity

= '100' ,

master_categories_id =

'17' ,

manufacturers_id

= 'NULL',

products_status

= '1',

metatags_title_status =

'0',

metatags_products_name_status = '0',

metatags_model_status =

'0',

metatags_price_status =

'0',

metatags_title_tagline_status = '0'

, products_price_retail='16' , products_price_sample='16'
MySQL error 1110: Column 'products_price_sample' specified twice
When executing:
INSERT INTO products SET

products_model

= '10003' ,

products_price

= '16' ,

products_price_retail =

'16' ,

products_price_sample =

'16' ,

products_image

= 's/201112/b/13250847463.jpg' ,

products_weight

= '0.2' ,

products_tax_class_id =

'' ,

products_date_available =

'' ,

products_date_added

= '2011-12-30 07:05:00' ,

products_last_modified =

CURRENT_TIMESTAMP ,

products_quantity

= '100' ,

master_categories_id =

'17' ,

manufacturers_id

= 'NULL',

products_status

= '1',

metatags_title_status =

'0',

metatags_products_name_status = '0',

metatags_model_status =

'0',

metatags_price_status =

'0',

metatags_title_tagline_status = '0'

, products_price_retail='16' , products_price_sample='16'
MySQL error 1110: Column 'products_price_sample' specified twice
When executing:
INSERT INTO products SET

products_model

= '10004' ,

products_price

= '16' ,

products_price_retail =

'16' ,

products_price_sample =

'16' ,

products_image

= 's/201112/b/13250847464.jpg' ,

products_weight

= '0.2' ,

products_tax_class_id =

'' ,

products_date_available =

'' ,

products_date_added

= '2011-12-31 07:05:00' ,

products_last_modified =

CURRENT_TIMESTAMP ,

products_quantity

= '100' ,

master_categories_id =

'17' ,

manufacturers_id

= 'NULL',

products_status

= '1',

metatags_title_status =

'0',

metatags_products_name_status = '0',

metatags_model_status =

'0',

metatags_price_status =

'0',

metatags_title_tagline_status = '0'

, products_price_retail='16' , products_price_sample='16'
MySQL error 1110: Column 'products_price_sample' specified twice
When executing:
INSERT INTO products SET

products_model

= '10002' ,

products_price

= '16' ,

products_price_retail =

'16' ,

products_price_sample =

'16' ,

products_image

= 's/201112/b/13250847460.jpg' ,

products_weight

= '0.2' ,

products_tax_class_id =

'' ,

products_date_available =

'1969-12-31 16:00:00' ,

products_date_added

= '2011-12-28 07:05:00' ,

products_last_modified =

CURRENT_TIMESTAMP ,

products_quantity

= '92' ,

master_categories_id =

'20' ,

manufacturers_id

= 'NULL',

products_status

= '1',

metatags_title_status =

'0',

metatags_products_name_status = '0',

metatags_model_status =

'0',

metatags_price_status =

'0',

metatags_title_tagline_status = '0'

, products_price_retail='16' , products_price_sample='16'
MySQL error 1110: Column 'products_price_sample' specified twice
When executing:
INSERT INTO products SET

products_model

= '10002' ,

products_price

= '16' ,

products_price_retail =

'16' ,

products_price_sample =

'16' ,

products_image

= 's/201112/b/13250847460.jpg' ,

products_weight

= '0.2' ,

products_tax_class_id =

'' ,

products_date_available =

'1969-12-31 16:00:00' ,

products_date_added

= '2011-12-28 07:05:00' ,

products_last_modified =

CURRENT_TIMESTAMP ,

products_quantity

= '92' ,

master_categories_id =

'20' ,

manufacturers_id

= 'NULL',

products_status

= '1',

metatags_title_status =

'0',

metatags_products_name_status = '0',

metatags_model_status =

'0',

metatags_price_status =

'0',

metatags_title_tagline_status = '0'

, products_price_retail='16' , products_price_sample='16'
MySQL error 1110: Column 'products_price_sample' specified twice
When executing:
INSERT INTO products SET

products_model

= '10002' ,

products_price

= '16' ,

products_price_retail =

'16' ,

products_price_sample =

'16' ,

products_image

= 's/201112/b/13250847460.jpg' ,

products_weight

= '0.2' ,

products_tax_class_id =

'' ,

products_date_available =

'1969-12-31 16:00:00' ,

products_date_added

= '2011-12-28 07:05:00' ,

products_last_modified =

CURRENT_TIMESTAMP ,

products_quantity

= '92' ,

master_categories_id =

'20' ,

manufacturers_id

= 'NULL',

products_status

= '1',

metatags_title_status =

'0',

metatags_products_name_status = '0',

metatags_model_status =

'0',

metatags_price_status =

'0',

metatags_title_tagline_status = '0'

, products_price_retail='16' , products_price_sample='16'
MySQL error 1110: Column 'products_price_sample' specified twice
When executing:
INSERT INTO products SET

products_model

= '10002' ,

products_price

= '16' ,

products_price_retail =

'16' ,

products_price_sample =

'16' ,

products_image

= 's/201112/b/13250847460.jpg' ,

products_weight

= '0.2' ,

products_tax_class_id =

'' ,

products_date_available =

'1969-12-31 16:00:00' ,

products_date_added

= '2011-12-28 07:05:00' ,

products_last_modified =

CURRENT_TIMESTAMP ,

products_quantity

= '92' ,

master_categories_id =

'22' ,

manufacturers_id

= '1',

products_status

= '1',

metatags_title_status =

'0',

metatags_products_name_status = '0',

metatags_model_status =

'0',

metatags_price_status =

'0',

metatags_title_tagline_status = '0'

, products_price_retail='16' , products_price_sample='16'
MySQL error 1110: Column 'products_price_sample' specified twice
When executing:
INSERT INTO products SET

products_model

= '10002' ,

products_price

= '16' ,

products_price_retail =

'16' ,

products_price_sample =

'16' ,

products_image

= 's/201112/b/13250847460.jpg' ,

products_weight

= '0.2' ,

products_tax_class_id =

'' ,

products_date_available =

'1969-12-31 16:00:00' ,

products_date_added

= '2011-12-28 07:05:00' ,

products_last_modified =

CURRENT_TIMESTAMP ,

products_quantity

= '92' ,

master_categories_id =

'20' ,

manufacturers_id

= 'NULL',

products_status

= '1',

metatags_title_status =

'0',

metatags_products_name_status = '0',

metatags_model_status =

'0',

metatags_price_status =

'0',

metatags_title_tagline_status = '0'

, products_price_retail='16' , products_price_sample='16'


请问这个具体要怎么解决?
stellarying
 
帖子: 1
注册: 2011-12-30 23:16

Re: 菜鸟求助!发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上

帖子Jack » 2012-01-02 9:55

如果后台没增加过自定义的栏目,应该是批量管理模块有问题吧?是本站下载的吗?
头像
Jack
论坛版主
论坛版主
 
帖子: 12265
注册: 2004-12-16 10:04


回到 安装设置



在线用户

正在浏览此版面的用户:没有注册用户 和 3 位游客