pberg Posted March 5, 2008 Posted March 5, 2008 I'm runing oscommerce v2.2 rc1. I just installed Easypopulate v2.76. As my inventory is huge, that is the only contribution that will help me save time. This is the message I get when I try to upload the excel file(EP File) : 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 's Shoes'' at line 8 SELECT cat.categories_id FROM categories as cat, categories_description as des WHERE cat.categories_id = des.categories_id AND des.language_id = 1 AND cat.parent_id = 0 AND des.categories_name = 'Men's Shoes' I spent a lot of time trying to find out what's wrong, but just can't find anything.
jimbob_pooley Posted March 5, 2008 Posted March 5, 2008 Just a thought, but MySQL probably doesn't like the apostrophe in "Men's". I'm not sure of the exact MySQL syntax, but you could try taking out the apostrophe or wrapping "Men's Shoes" in double quotes.
♥geoffreywalton Posted March 5, 2008 Posted March 5, 2008 This is covered in the the easy populate documentation. Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
kenyashop Posted April 10, 2008 Posted April 10, 2008 This is covered in the the easy populate documentation. Can you put in a link to the the latest version of the add-on, and the documentation please? I searched the add-ons but there were many options Thanks
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.