chineseboy Posted February 23, 2010 Share Posted February 23, 2010 Hi. I'm trying to import 3000 products into my shop. I keep getting this error whether I import 3000 or 500, yet I managed to import a single item earlier without any problems. Does anyone know what this error means?"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 ') GROUP BY `id_category`' at line 3SELECT IFNULL(MAX(`position`), 0) + 1 AS max, `id_category` FROM `ps_category_product` WHERE `id_category` IN() GROUP BY `id_category`" Link to comment Share on other sites More sharing options...
chineseboy Posted February 24, 2010 Author Share Posted February 24, 2010 well, i think i've solved it. i think i was getting the error because a few of the items i was importing had their category id missing. so if you get this error check that first. Link to comment Share on other sites More sharing options...
Recommended Posts