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

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

版主: shaning

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

帖子zhixinyan » 2010-06-23 2:22

批量上传数据总是会出现这个错误,论坛上提出的办法都试过了,还是没办法解决。。。请大家帮帮忙啊,,,急死了。。。

如果还是有错误,先卸载:http://www.yourdomain.com/admin/easypopulate.php?langer=remove
然后页面最上方会提示点击安装 这个也试过了。还是不行。。。。

下面这个方法也试了。还是不行,
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;
}

拜托拜托大家帮帮忙,快急死了。
zhixinyan
新手上路
新手上路
 
帖子: 11
注册: 2010-06-11 21:44
QQ 帐号: 83714316

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

帖子Jack » 2010-06-23 9:29

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

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

帖子zhixinyan » 2010-06-23 14:29

v_products_model,v_products_image,v_products_name_1,v_products_description_1,v_products_url_1,v_specials_price,v_specials_last_modified,v_specials_expires_date,v_products_price,v_products_weight,v_last_modified,v_date_added,v_products_quantity,v_manufacturers_name,v_categories_name_1,v_categories_name_2,v_categories_name_3,v_categories_name_4,v_categories_name_5,v_categories_name_6,v_categories_name_7,v_tax_class_title,v_status,v_metatags_products_name_status,v_metatags_title_status,v_metatags_model_status,v_metatags_price_status,v_metatags_title_tagline_status,v_metatags_title_1,v_metatags_keywords_1,v_metatags_description_1
MBT Chapa GTX Birch Mens Shoes,MBT Chapa GTX Birch Mens Shoes.jpg,MBT Chapa GTX Birch Mens Shoes,"MBT Men's Chapa Shoes With this MBT shoes you are ideally equipped for bad weather. The MBT Men's Chapa are not your normal kind of walking footwear. Given a title of physiological footwear, These shoes activate your body's support and postural muscles. This means that your muscles will work more, you will have less strain on your joints, and you will feel better. The MBT Men's Chapa feature extreme breathability, with a single layer mesh upper, a antimicrobial dry&cool mesh and a foam sock lining. These shoes also feature a TPU and glass fiber shank which adds firmness to the sole and provides even weight distribution. Support and traction can be found with the inclusion of a durable rubber outsole construction. The PU midsole provides a balancing section and promotes an active rolling movement. Clinical studies suggest that regular use improves balance, posture and circulation. They let our flat everyday surface become naturally uneven. You walk as if you were walking in sand, as MBT Men's Chapa neither support, guide nor absorb shock; rather it stretches, increases power and coordination of the muscles.
",,79.8,,,259.99,1.7,,,1000,,MBT Mens Shoes ,MBT Chapa Men's shoes ,,,,,,,1,,,,,,,,
MBT Chapa GTX Black Mens Shoes,MBT Chapa GTX Black Mens Shoes.jpg,MBT Chapa GTX Black Mens Shoes,"MBT Men's Chapa Shoes With this MBT shoes you are ideally equipped for bad weather. The MBT Men's Chapa are not your normal kind of walking footwear. Given a title of physiological footwear, These shoes activate your body's support and postural muscles. This means that your muscles will work more, you will have less strain on your joints, and you will feel better. The MBT Men's Chapa feature extreme breathability, with a single layer mesh upper, a antimicrobial dry&cool mesh and a foam sock lining. These shoes also feature a TPU and glass fiber shank which adds firmness to the sole and provides even weight distribution. Support and traction can be found with the inclusion of a durable rubber outsole construction. The PU midsole provides a balancing section and promotes an active rolling movement. Clinical studies suggest that regular use improves balance, posture and circulation. They let our flat everyday surface become naturally uneven. You walk as if you were walking in sand, as MBT Men's Chapa neither support, guide nor absorb shock; rather it stretches, increases power and coordination of the muscles.
",,79.8,,,259.99,1.7,,,1000,,MBT Mens Shoes ,MBT Chapa Men's shoes ,,,,,,,1,,,,,,,,
MBT Chapa GTX Ebony-2 Mens Shoes,MBT Chapa GTX Ebony-2 Mens Shoes.jpg,MBT Chapa GTX Ebony-2 Mens Shoes,"MBT Men's Chapa Shoes With this MBT shoes you are ideally equipped for bad weather. The MBT Men's Chapa are not your normal kind of walking footwear. Given a title of physiological footwear, These shoes activate your body's support and postural muscles. This means that your muscles will work more, you will have less strain on your joints, and you will feel better. The MBT Men's Chapa feature extreme breathability, with a single layer mesh upper, a antimicrobial dry&cool mesh and a foam sock lining. These shoes also feature a TPU and glass fiber shank which adds firmness to the sole and provides even weight distribution. Support and traction can be found with the inclusion of a durable rubber outsole construction. The PU midsole provides a balancing section and promotes an active rolling movement. Clinical studies suggest that regular use improves balance, posture and circulation. They let our flat everyday surface become naturally uneven. You walk as if you were walking in sand, as MBT Men's Chapa neither support, guide nor absorb shock; rather it stretches, increases power and coordination of the muscles.
",,79.8,,,259.99,1.7,,,1000,,MBT Mens Shoes ,MBT Chapa Men's shoes ,,,,,,,1,,,,,,,,
MBT Chapa GTX Ebony Mens Shoes,MBT Chapa GTX Ebony Mens Shoes.jpg,MBT Chapa GTX Ebony Mens Shoes,"MBT Men's Chapa Shoes With this MBT shoes you are ideally equipped for bad weather. The MBT Men's Chapa are not your normal kind of walking footwear. Given a title of physiological footwear, These shoes activate your body's support and postural muscles. This means that your muscles will work more, you will have less strain on your joints, and you will feel better. The MBT Men's Chapa feature extreme breathability, with a single layer mesh upper, a antimicrobial dry&cool mesh and a foam sock lining. These shoes also feature a TPU and glass fiber shank which adds firmness to the sole and provides even weight distribution. Support and traction can be found with the inclusion of a durable rubber outsole construction. The PU midsole provides a balancing section and promotes an active rolling movement. Clinical studies suggest that regular use improves balance, posture and circulation. They let our flat everyday surface become naturally uneven. You walk as if you were walking in sand, as MBT Men's Chapa neither support, guide nor absorb shock; rather it stretches, increases power and coordination of the muscles.
",,79.8,,,259.99,1.7,,,1000,,MBT Mens Shoes ,MBT Chapa Men's shoes ,,,,,,,1,,,,,,,,
MBT Chapa GTX Pumpkin Mens Shoes,MBT Chapa GTX Pumpkin Mens Shoes.jpg,MBT Chapa GTX Pumpkin Mens Shoes,"MBT Men's Chapa Shoes With this MBT shoes you are ideally equipped for bad weather. The MBT Men's Chapa are not your normal kind of walking footwear. Given a title of physiological footwear, These shoes activate your body's support and postural muscles. This means that your muscles will work more, you will have less strain on your joints, and you will feel better. The MBT Men's Chapa feature extreme breathability, with a single layer mesh upper, a antimicrobial dry&cool mesh and a foam sock lining. These shoes also feature a TPU and glass fiber shank which adds firmness to the sole and provides even weight distribution. Support and traction can be found with the inclusion of a durable rubber outsole construction. The PU midsole provides a balancing section and promotes an active rolling movement. Clinical studies suggest that regular use improves balance, posture and circulation. They let our flat everyday surface become naturally uneven. You walk as if you were walking in sand, as MBT Men's Chapa neither support, guide nor absorb shock; rather it stretches, increases power and coordination of the muscles.
",,79.8,,,259.99,1.7,,,1000,,MBT Mens Shoes ,MBT Chapa Men's shoes ,,,,,,,1,,,,,,,,
MBT Chapa GTX Stone Mens Shoes,MBT Chapa GTX Stone Mens Shoes.jpg,MBT Chapa GTX Stone Mens Shoes,"MBT Men's Chapa Shoes With this MBT shoes you are ideally equipped for bad weather. The MBT Men's Chapa are not your normal kind of walking footwear. Given a title of physiological footwear, These shoes activate your body's support and postural muscles. This means that your muscles will work more, you will have less strain on your joints, and you will feel better. The MBT Men's Chapa feature extreme breathability, with a single layer mesh upper, a antimicrobial dry&cool mesh and a foam sock lining. These shoes also feature a TPU and glass fiber shank which adds firmness to the sole and provides even weight distribution. Support and traction can be found with the inclusion of a durable rubber outsole construction. The PU midsole provides a balancing section and promotes an active rolling movement. Clinical studies suggest that regular use improves balance, posture and circulation. They let our flat everyday surface become naturally uneven. You walk as if you were walking in sand, as MBT Men's Chapa neither support, guide nor absorb shock; rather it stretches, increases power and coordination of the muscles.
",,79.8,,,259.99,1.7,,,1000,,MBT Mens Shoes ,MBT Chapa Men's shoes ,,,,,,,1,,,,,,,,
zhixinyan
新手上路
新手上路
 
帖子: 11
注册: 2010-06-11 21:44
QQ 帐号: 83714316

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

帖子zhixinyan » 2010-06-23 14:34

Jack 大哥,帮帮忙了。不甚感激。
zhixinyan
新手上路
新手上路
 
帖子: 11
注册: 2010-06-11 21:44
QQ 帐号: 83714316

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

帖子Jack » 2010-06-24 10:52

products_tax_class_id 这个栏目要填内容,可以手工建个商品,导出csv看看怎么填写
还有就是分类如果不是很多,最好先手工建立
Zen Cart - 让每个人拥有自己生意的梦想成真
加入Zen Cart地图 | 恕不回复站内短信提问 | QQ: 3171061
头像
Jack
论坛版主
论坛版主
 
帖子: 12265
注册: 2004-12-16 10:04


回到 安装设置



在线用户

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