【紧急求助】发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上提出(在线等待)  已解决

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

版主: shaning

【紧急求助】发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上提出(在线等待)

帖子jaslong » 2008-06-18 13:24

在网站服务器上安装zen cart1.38中文版后,添加产品批量上传管理模块,上传时出现“发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上提出”。已经确认上传文件是正确无误的(在本机安装相同的zencart测试上传正常)。查看服务器上temp目录的ep_debug_log.txt文件如下:

MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
125,
'1',
'Bose?In-Ear Headphones'
)
MySQL 错误 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
运行:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'id-1001.jpg','Bose TriPort In Ear Headphones',
'96.54',
'1',
CURRENT_TIMESTAMP,
"2008-06-14 5:36",
NULL,
'',
'0',
'1000',
'NULL')

MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
126,
'1',
'Bose?In-Ear Headphones'
)
MySQL 错误 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
运行:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'bose-in-ear-pack.jpg','Bose TriPort In-Ear Headphones',
'96.54',
'1',
CURRENT_TIMESTAMP,
"2008-06-14 5:42",
NULL,
'',
'0',
'1000',
'NULL')

MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
127,
'1',
'UGG Shoppe'
)
MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
128,
'1',
'UGG Sandals - Womens'
)
MySQL 错误 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
运行:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'0003.jpg','UGG Womens Amelie Cream',
'99',
'1',
CURRENT_TIMESTAMP,
"2008-06-14 8:19",
NULL,
'',
'2',
'300',
'NULL')

MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
129,
'1',
'UGG Shoppe'
)
MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
130,
'1',
'UGG Sandals - Womens'
)
MySQL 错误 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
运行:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'0006.jpg','UGG Sandals Womens Amelie Black',
'99',
'1',
CURRENT_TIMESTAMP,
"2008-06-14 8:22",
NULL,
'',
'2',
'300',
'NULL')

MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
131,
'1',
'UGG Shoppe'
)
MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
132,
'1',
'UGG Sandals - Womens'
)
MySQL 错误 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
运行:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'0005.jpg','UGG Sandals Womens Amelie Chocol',
'99',
'1',
CURRENT_TIMESTAMP,
"2008-06-14 8:30",
NULL,
'',
'2',
'300',
'NULL')

MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
133,
'1',
'UGG Shoppe'
)
MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
134,
'1',
'UGG Sandals - Womens'
)
MySQL 错误 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
运行:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'0002.jpg','UGG Sandals Womens Amelie Pink',
'99',
'1',
CURRENT_TIMESTAMP,
"2008-06-14 8:33",
NULL,
'',
'2',
'300',
'NULL')

MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
135,
'1',
'Bose?In-Ear Headphones'
)
MySQL 错误 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
运行:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'061023_3b.jpg','Bose TriPort In-Ear Headphones',
'96.54',
'1',
CURRENT_TIMESTAMP,
"2008-06-14 17:28",
NULL,
'',
'0',
'1000',
'NULL')

MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
136,
'1',
'Bose?In-Ear Headphones'
)
MySQL 错误 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
运行:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'bose-in-ear-headphones.jpg','Bose TriPort In-Ear Headphones',
'96.54',
'1',
CURRENT_TIMESTAMP,
"2008-06-14 17:39",
NULL,
'',
'0',
'1000',
'NULL')

MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
137,
'1',
'Nike Air Jordan Shoes'
)
MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
138,
'1',
'Air Jordan Force Fusion V (5)'
)
MySQL 错误 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
运行:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'ajf5-02.jpg','ajf5',
'124.99',
'1',
CURRENT_TIMESTAMP,
"2008-06-14 17:49",
NULL,
'',
'3',
'300',
'NULL')

MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
139,
'1',
'Nike Air Jordan Shoes'
)
MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
140,
'1',
'Air Jordan Force Fusion V (5)'
)
MySQL 错误 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
运行:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'ajf5-03.jpg','ajf5',
'124.99',
'1',
CURRENT_TIMESTAMP,
"2008-06-14 17:49",
NULL,
'',
'3',
'300',
'NULL')

MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
141,
'1',
'Nike Air Jordan Shoes'
)
MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
142,
'1',
'Air Jordan Force Fusion V (5)'
)
MySQL 错误 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
运行:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'ajf5-01.jpg','ajf5',
'124.99',
'1',
CURRENT_TIMESTAMP,
"2008-06-14 17:49",
NULL,
'',
'3',
'300',
'NULL')

MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
143,
'1',
'Nike Air Jordan Shoes'
)
MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
144,
'1',
'Air Jordan Force Fusion VIII (8)'
)
MySQL 错误 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
运行:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'ajf8-01.jpg','ajf8',
'124.99',
'1',
CURRENT_TIMESTAMP,
"2008-06-14 17:58",
NULL,
'',
'3',
'300',
'NULL')

MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
145,
'1',
'Nike Air Jordan Shoes'
)
MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
146,
'1',
'Air Jordan Force Fusion VIII (8)'
)
MySQL 错误 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
运行:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'ajf8-05.jpg','ajf8',
'124.99',
'1',
CURRENT_TIMESTAMP,
"2008-06-14 17:59",
NULL,
'',
'3',
'300',
'NULL')

MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
147,
'1',
'Nike Air Jordan Shoes'
)
MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
148,
'1',
'Air Jordan Force Fusion VIII (8)'
)
MySQL 错误 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
运行:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'ajf8-02.jpg','ajf8',
'124.99',
'1',
CURRENT_TIMESTAMP,
"2008-06-14 18:01",
NULL,
'',
'3',
'300',
'NULL')

MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
149,
'1',
'Nike Air Jordan Shoes'
)
MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
150,
'1',
'Air Jordan Force Fusion VIII (8)'
)
MySQL 错误 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
运行:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'ajf8-03.jpg','ajf8',
'124.99',
'1',
CURRENT_TIMESTAMP,
"2008-06-14 18:05",
NULL,
'',
'3',
'300',
'NULL')

MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
151,
'1',
'Nike Air Jordan Shoes'
)
MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
152,
'1',
'Air Jordan Force Fusion VIII (8)'
)
MySQL 错误 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
运行:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'ajf8-04.jpg','ajf8',
'124.99',
'1',
CURRENT_TIMESTAMP,
"2008-06-14 18:13",
NULL,
'',
'3',
'300',
'NULL')

MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
153,
'1',
'UGG Shoppe'
)
MySQL 错误 1364: Field 'categories_description' doesn't have a default value
运行:
INSERT INTO zen_categories_description(
categories_id,
language_id,
categories_name
) VALUES (
154,
'1',
'UGG Sandals - Womens'
)
MySQL 错误 1366: Incorrect integer value: '' for column 'products_tax_class_id' at row 1
运行:
INSERT INTO zen_products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
manufacturers_id)
VALUES (
'0004.jpg','UGG Sandals Womens Amelie',
'99',
'1',
CURRENT_TIMESTAMP,
"2008-06-14 18:30",
NULL,
'',
'2',
'300',
'NULL')





第一次安装zencart批量上传是可以正常使用的,默认安装路径是C:/Program Files/MySQL/MySQL Server 5.1
。INNODB路径是D:\MySQL Datafiles,后来修改了mysql的my.ini datadir为"D:/Program Files/MySQL/MySQL Server 5.1/Data/",并转移DATA目录文件内容到D:/Program Files/MySQL/MySQL Server 5.1/Data/,重新启动以后就出现了上述情况。到现在C和D盘重新安装过数据库数次,并重新安装过zencart,还是上传错误。求高人解答。在线等待ing
jaslong
新手上路
新手上路
 
帖子: 16
注册: 2008-06-11 11:29

Re: 【紧急求助】发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上提出(在线等待)

帖子Jack » 2008-06-18 21:02

1. 在excel的商品说明栏目中,请填写内容 (补丁稍后发出)
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;
}

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

Re: 【紧急求助】发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上提出(在线等待)  已解决

帖子jaslong » 2008-06-19 23:20

非常感谢2楼的帮助。我用的mysql5.1,后面查询得知新版本mysql对空值插入有"bug",要在安装mysql的时候去除默认勾选的enable strict SQL mode。如果已经安装好了的,就在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后即可。
jaslong
新手上路
新手上路
 
帖子: 16
注册: 2008-06-11 11:29

Re: 【紧急求助】发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上提出(在线等待)

帖子Jack » 2008-06-20 7:17

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

Re: 【紧急求助】发现SQL错误。请检查输入数据中的制表符并删除。如果还有错误,请附错误记录并在论坛上提出(在线等待)

帖子sqdbk » 2011-07-22 17:52

联系服务器管理员修改 my.ini (Linux 下是 my.cnf ),有没有这回事儿?
sqdbk
新手上路
新手上路
 
帖子: 10
注册: 2011-04-18 12:01
QQ 帐号: 281143699


Re: 【紧急求助】easy populate 安装问题在线等

帖子dory520 » 2011-09-11 22:24

菜鸟一个。我按网上看到的方法试了3天,还是不行。zencart 1.3.9h,easy populate1.2.5.7
上传目录后,在工具点easy populate,上面有提示安装,点了之后出现错误:

1366 Incorrect integer value: '' for column 'configuration_group_id' at row 1
in:
[INSERT INTO configuration_group VALUES ('', 'Easy Populate', 'Config options for Easy Populate', '1', '1')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
dory520
 
帖子: 4
注册: 2011-09-11 21:15




回到 安装设置



在线用户

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