批量上传时出现问题 发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上提出。

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

版主: shaning

zencart 发帖图标 批量上传时出现问题 发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上提出。

帖子阿江 » 2010-08-17 1:51

在批量上传物品时遇到:
商品更新失败! - 型号: 189895 - SQL错误。检查上传目录中的错误记录
商品更新失败! - 型号: 2008C - SQL错误。检查上传目录中的错误记录
添加新商品失败! - 型号: 2009C - SQL错误。检查上传目录中的错误记录。
添加新商品失败! - 型号: 2010C - SQL错误。检查上传目录中的错误记录。
添加新商品失败! - 型号: 2011C - SQL错误。检查上传目录中的错误记录。
添加新商品失败! - 型号: 2012C - SQL错误。检查上传目录中的错误记录。
添加新商品失败! - 型号: 2013C - SQL错误。检查上传目录中的错误记录。
添加新商品失败! - 型号: 2014C - SQL错误。检查上传目录中的错误记录。
添加新商品失败! - 型号: 2015C - SQL错误。检查上传目录中的错误记录。
添加新商品失败! - 型号: 2016C - SQL错误。检查上传目录中的错误记录。
添加新商品失败! - 型号: 2017C - SQL错误。检查上传目录中的错误记录。
添加新商品失败! - 型号: 2018C - SQL错误。检查上传目录中的错误记录。
添加新商品失败! - 型号: 2019C - SQL错误。检查上传目录中的错误记录。
添加新商品失败! - 型号: 2020C - SQL错误。检查上传目录中的错误记录。
上传完成
顶部提示:发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上提出。
试过方法:
1.先卸载:http://www.yourdomain.com/admin/easypopulate.php?langer=remove
然后页面最上方会提示点击安装
2.修改下面的文件
打开 \admin\easypopulate.php
找到
if (isset($v_tax_class_title)){
$v_tax_class_id = ep_get_tax_title_class_id($v_tax_class_title);
}
在其后加上
if(empty($v_tax_class_id)) {
$v_tax_class_id = 0;
}
**********************************************************************************************************
从下载的.csv文件里面瞧见手动上传的两件物品的 products_tax_class_id 里写的是 鏃?1 ,试过把此处利用excel的复制功能全拉成一样的,以及把此处留空,结果都是失败。分类早已建好,并且上传的是同一目录上的物品。

打开了tempEP里面的ep_debug_log,里面显示的是:
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
UPDATE products SET
products_price = '58' ,
products_image = 'uploads/1-3.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = '2010-08-16 18:47:00' ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''WHERE ( `products_id` = '1' )
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
UPDATE products SET
products_price = '58' ,
products_image = 'uploads/3-2.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = '2010-08-16 18:50:00' ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''WHERE ( `products_id` = '2' )
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2009C' ,
products_price = '58' ,
products_image = 'uploads/3.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2010C' ,
products_price = '58' ,
products_image = 'uploads/4.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2011C' ,
products_price = '58' ,
products_image = 'uploads/5.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2012C' ,
products_price = '58' ,
products_image = 'uploads/6.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2013C' ,
products_price = '58' ,
products_image = 'uploads/7.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2014C' ,
products_price = '58' ,
products_image = 'uploads/8.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2015C' ,
products_price = '58' ,
products_image = 'uploads/9.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2016C' ,
products_price = '58' ,
products_image = 'uploads/10.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2017C' ,
products_price = '58' ,
products_image = 'uploads/11.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2018C' ,
products_price = '58' ,
products_image = 'uploads/12.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2019C' ,
products_price = '58' ,
products_image = 'uploads/13.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2020C' ,
products_price = '58' ,
products_image = 'uploads/14.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
UPDATE products SET
products_price = '58' ,
products_image = 'uploads/1-3.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = '2010-08-16 18:47:00' ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''WHERE ( `products_id` = '1' )
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
UPDATE products SET
products_price = '58' ,
products_image = 'uploads/3-2.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = '2010-08-16 18:50:00' ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''WHERE ( `products_id` = '2' )
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2009C' ,
products_price = '58' ,
products_image = 'uploads/3.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2010C' ,
products_price = '58' ,
products_image = 'uploads/4.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2011C' ,
products_price = '58' ,
products_image = 'uploads/5.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2012C' ,
products_price = '58' ,
products_image = 'uploads/6.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2018C' ,
products_price = '58' ,
products_image = 'uploads/12.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2019C' ,
products_price = '58' ,
products_image = 'uploads/13.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2020C' ,
products_price = '58' ,
products_image = 'uploads/14.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
UPDATE products SET
products_price = '58' ,
products_image = 'uploads/1-3.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = '2010-08-16 18:47:00' ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''WHERE ( `products_id` = '1' )
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
UPDATE products SET
products_price = '58' ,
products_image = 'uploads/3-2.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = '2010-08-16 18:50:00' ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''WHERE ( `products_id` = '2' )
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2009C' ,
products_price = '58' ,
products_image = 'uploads/3.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2010C' ,
products_price = '58' ,
products_image = 'uploads/4.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2011C' ,
products_price = '58' ,
products_image = 'uploads/5.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2012C' ,
products_price = '58' ,
products_image = 'uploads/6.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2013C' ,
products_price = '58' ,
products_image = 'uploads/7.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2014C' ,
products_price = '58' ,
products_image = 'uploads/8.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2015C' ,
products_price = '58' ,
products_image = 'uploads/9.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2016C' ,
products_price = '58' ,
products_image = 'uploads/10.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2018C' ,
products_price = '58' ,
products_image = 'uploads/12.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2019C' ,
products_price = '58' ,
products_image = 'uploads/13.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
UPDATE products SET
products_price = '58' ,
products_image = 'uploads/1-3.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = '2010-08-16 18:47:00' ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''WHERE ( `products_id` = '1' )
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
UPDATE products SET
products_price = '58' ,
products_image = 'uploads/3-2.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = '2010-08-16 18:50:00' ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''WHERE ( `products_id` = '2' )
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2009C' ,
products_price = '58' ,
products_image = 'uploads/3.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2010C' ,
products_price = '58' ,
products_image = 'uploads/4.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2011C' ,
products_price = '58' ,
products_image = 'uploads/5.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2012C' ,
products_price = '58' ,
products_image = 'uploads/6.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2013C' ,
products_price = '58' ,
products_image = 'uploads/7.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2014C' ,
products_price = '58' ,
products_image = 'uploads/8.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2015C' ,
products_price = '58' ,
products_image = 'uploads/9.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2016C' ,
products_price = '58' ,
products_image = 'uploads/10.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2017C' ,
products_price = '58' ,
products_image = 'uploads/11.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2018C' ,
products_price = '58' ,
products_image = 'uploads/12.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2019C' ,
products_price = '58' ,
products_image = 'uploads/13.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
When executing:
INSERT INTO products SET
products_model = '2020C' ,
products_price = '58' ,
products_image = 'uploads/14.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO products SET
products_model = '51863' ,
products_price = '58' ,
products_image = 'uploads/3.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '0' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO products SET
products_model = '51868' ,
products_price = '58' ,
products_image = 'uploads/8.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '0' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO products SET
products_model = '51869' ,
products_price = '58' ,
products_image = 'uploads/9.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '0' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO products SET
products_model = '51870' ,
products_price = '58' ,
products_image = 'uploads/10.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '0' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO products SET
products_model = '51871' ,
products_price = '58' ,
products_image = 'uploads/11.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '0' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO products SET
products_model = '51872' ,
products_price = '58' ,
products_image = 'uploads/12.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '0' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO products SET
products_model = '51873' ,
products_price = '58' ,
products_image = 'uploads/13.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '0' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO products SET
products_model = '51874' ,
products_price = '58' ,
products_image = 'uploads/14.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '0' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO products SET
products_model = '51875' ,
products_price = '58' ,
products_image = 'uploads/15.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '0' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '1' ,
manufacturers_id = 'NULL',
products_status = '0',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = ''

************************************************************************

WinXP系统,用phpStudy构建的本地PHP环境,下载的是本网站上是的Zen Cart v1.3.9e 中文插件版 (推荐版本)和 批量商品管理 1.2.5.7.csv ,安装时提示成功,可以下载网站上的.csv文件。

请问此问题应当怎么解决呢?
谢谢!
阿江
普通会员
普通会员
 
帖子: 49
注册: 2010-06-22 0:22
QQ 帐号: 407431068

Re: 批量上传时出现问题 发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上提出。

帖子Jack » 2010-08-17 5:43

Zen Cart - 让每个人拥有自己生意的梦想成真
加入Zen Cart地图 | 恕不回复站内短信提问 | QQ: 3171061
头像
Jack
论坛版主
论坛版主
 
帖子: 12265
注册: 2004-12-16 10:04

zencart 发帖图标 Re: 批量上传时出现问题 发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上提出。

帖子阿江 » 2010-08-25 1:08

经过多天的学习,仍未解决批量上传的问题,仍是 “发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上提出。”
试过:
1,在my.ini中查找sql-mode,默认为sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION",将其修改为sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION",重启mysql
2,把制作好的xxx.csv修改成utf-8格式的,仍是一样的问题,这次遇到的提示是:
文件名: 201008246.csv

记录中没有型号字段。该行没有导入uploads/2. | Gucci hand | Descriptio | | Gucci hand | Descriptio | | | | | 59 | 1201 | | | 10000 | | Gucci Bags | | | | | | | 无 | 1 | 0 | 0 | 0 | 0 | 0 | | | | | | |
记录中没有型号字段。该行没有导入uploads/3. | Gucci hand | Descriptio | | Gucci hand | Descriptio | | | | | 60 | 1202 | | | 10000 | | Gucci Bags | | | | | | | 无 | 1 | 0 | 0 | 0 | 0 | 0 | | | | | | |
记录中没有型号字段。该行没有导入uploads/4. | Gucci hand | Descriptio | | Gucci hand | Descriptio | | | | | 61 | 1203 | | | 10000 | | Gucci Bags | | | | | | | 无 | 1 | 0 | 0 | 0 | 0 | 0 | | | | | | |
记录中没有型号字段。该行没有导入uploads/5. | Gucci hand | Descriptio | | Gucci hand | Descriptio | | | | | 62 | 1204 | | | 10000 | | Gucci Bags | | | | | | | 无 | 1 | 0 | 0 | 0 | 0 | 0 | | | | | | |
记录中没有型号字段。该行没有导入uploads/6. | Gucci hand | Descriptio | | Gucci hand | Descriptio | | | | | 63 | 1205 | | | 10000 | | Gucci Bags | | | | | | | 无 | 1 | 0 | 0 | 0 | 0 | 0 | | | | | | |
上传完成

从网站上下载下来的csv文件用Excel文件打开那个v_tax_class_title里面是乱码,然后我安装了open office,用这个打开,此处显示为 无 ,所以在重新试的里面都填写了 无 ,以及 --none-- ,然后都转换成utf-8格式的csv文件去上传,仍是不成功。型号 此栏填写了的,全部填写的是五六位的纯数字,但提示却说 记录中没有型号字段。该行没有导入 ,不知道是怎么回事呢?
阿江
普通会员
普通会员
 
帖子: 49
注册: 2010-06-22 0:22
QQ 帐号: 407431068

Re: 批量上传时出现问题 发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上提出。

帖子阿江 » 2010-08-25 1:17

那个 ep_debug_log 提示是:
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 45, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 46, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 47, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 48, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 49, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 50, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 51, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 52, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 53, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 54, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 55, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 56, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 57, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 58, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 59, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 60, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 61, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 62, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 63, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 64, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 65, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 66, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 67, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 68, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 69, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 70, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 71, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 72, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 73, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 74, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 75, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 76, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 77, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 78, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 79, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 80, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 81, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 82, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 83, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 84, '1', 'Gucci Bags' )
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO products SET
products_model = '275752753' ,
products_price = '58' ,
products_image = 'uploads/2.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '0' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '3' ,
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'
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO products SET
products_model = '734242' ,
products_price = '58' ,
products_image = 'uploads/3.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '0' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '3' ,
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'
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO products SET
products_model = '1745782' ,
products_price = '58' ,
products_image = 'uploads/4.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '0' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '3' ,
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'
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO products SET
products_model = '42752745' ,
products_price = '58' ,
products_image = 'uploads/5.jpg' ,
products_weight = '1200' ,
products_tax_class_id = '0' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '3' ,
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'
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 85, '1', 'Gucci Bags' )
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO products SET
products_model = '54752378' ,
products_price = '59' ,
products_image = 'Uploads/2.jpg' ,
products_weight = '1201' ,
products_tax_class_id = '0' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '85' ,
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'
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 86, '1', 'Gucci Bags' )
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO products SET
products_model = '575541' ,
products_price = '60' ,
products_image = 'Uploads/3.jpg' ,
products_weight = '1202' ,
products_tax_class_id = '0' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '86' ,
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'
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 87, '1', 'Gucci Bags' )
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO products SET
products_model = '576542' ,
products_price = '61' ,
products_image = 'Uploads/4.jpg' ,
products_weight = '1203' ,
products_tax_class_id = '0' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '87' ,
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'
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 88, '1', 'Gucci Bags' )
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO products SET
products_model = '5546545' ,
products_price = '62' ,
products_image = 'Uploads/5.jpg' ,
products_weight = '1204' ,
products_tax_class_id = '0' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '88' ,
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'
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 89, '1', 'Gucci Bags' )
MySQL error 1292: Incorrect datetime value: '' for column 'products_date_available' at row 1
When executing:
INSERT INTO products SET
products_model = '844574' ,
products_price = '63' ,
products_image = 'Uploads/6.jpg' ,
products_weight = '1205' ,
products_tax_class_id = '0' ,
products_date_available = '' ,
products_date_added = CURRENT_TIMESTAMP ,
products_last_modified = CURRENT_TIMESTAMP ,
products_quantity = '10000' ,
master_categories_id = '89' ,
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'
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 90, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 91, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 92, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 93, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 94, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 95, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 96, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 97, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 98, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 99, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 100, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 101, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 102, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 103, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 104, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 105, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 106, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 107, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 108, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 109, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 110, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 111, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 112, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 113, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 114, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 115, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 116, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 117, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 118, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 119, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 120, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 121, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 122, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 123, '1', 'Gucci Bags' )
MySQL error 1364: Field 'categories_description' doesn't have a default value
When executing:
INSERT INTO categories_description( categories_id, language_id, categories_name )
VALUES ( 124, '1', 'Gucci Bags' )
阿江
普通会员
普通会员
 
帖子: 49
注册: 2010-06-22 0:22
QQ 帐号: 407431068

Re: 批量上传时出现问题 发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上提出。

帖子阿江 » 2010-08-26 20:01

难道只有我遇到此类的问题,而大家的都安装没问题?
唉!
阿江
普通会员
普通会员
 
帖子: 49
注册: 2010-06-22 0:22
QQ 帐号: 407431068

Re: 批量上传时出现问题 发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上提出。

帖子阿江 » 2010-08-28 2:19

难道无人可以解答一下吗?
阿江
普通会员
普通会员
 
帖子: 49
注册: 2010-06-22 0:22
QQ 帐号: 407431068



回到 安装设置



在线用户

正在浏览此版面的用户:Google [Bot] 和 4 位游客