dsfliu1129 2014-03-11 08:46
浏览 17
已采纳

Magmi导入SQL导入,适用于本地服务器

I have been using Magmi for a long time, and had issues with it so far, but now I'm trying to do a CSV import with Magmi, and for some reason it throws this SQL error, and have no idea how to fix it.

  • Magento: 1.8.1.0
  • PHP: 5.3.3-7+squeeze18
  • MySQL: 5.1.73
  • MySQLi: 5.1.73

The error:

1 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 - DELETE FROM catalog_product_entity_tier_price WHERE entity_id=? AND customer_group_id IN (?) AND website_id IN ()
2 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 - ERROR ON RECORD #1
  • 写回答

2条回答 默认 最新

  • duanchun6148 2014-03-12 14:04
    关注

    Found the problem!

    When I use category_ids like: 4,35,5 it gives me the error.

    But! If I just use a single number, no error!

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 乌班图ip地址配置及远程SSH
  • ¥15 怎么让点阵屏显示静态爱心,用keiluVision5写出让点阵屏显示静态爱心的代码,越快越好
  • ¥15 PSPICE制作一个加法器
  • ¥15 javaweb项目无法正常跳转
  • ¥15 VMBox虚拟机无法访问
  • ¥15 skd显示找不到头文件
  • ¥15 机器视觉中图片中长度与真实长度的关系
  • ¥15 fastreport table 怎么只让每页的最下面和最顶部有横线
  • ¥15 java 的protected权限 ,问题在注释里
  • ¥15 这个是哪里有问题啊?