dinohaven Posted August 4, 2005 Share Posted August 4, 2005 I am trying to import a database to my backup site, but even though it says, "File uploaded.", it seems to stop at the first entry. Anyone have any suggestions as to what I should do to fix the following error???? =============================================== File uploaded. Temporary filename: /www/tmp/phpf08mTr User filename: EP2005Aug03-2008.txt Size: 700090 | DHD-NAVYRE | DINO_navy_ | Dino (Navy | test' | | 17.99 | 0.00 | | 2004-08-24 | 994 | 2 | Size | 1 | X Small | +0.0000 | 2 | Small | +0.0000 | 3 | Medium | +0.0000 | 4 | Large | +9.0000 | 5 | Adult | | 6 | XL | | 3 | Coat Size | 7 | 2 Years | | 8 | 4 Years | | 9 | 6 Years | | 10 | 8 Years | | 4 | Mitten Siz | 11 | Small Chil | | 12 | Medium Chi | | 13 | Female Adu | | 14 | Male Adult | | 5 | Headband | 15 | Adult | | 16 | Child | | | All Hats | Dino | | --none-- | Active Updated 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 flagship product comes in a classy and elegant navy blue base, cherry red trim' at line 11 INSERT INTO products_description (products_id, language_id, products_name, products_description, products_url) VALUES ( '35', 1, 'Dino (Navy and Red, Child)', 'Our flagship product comes in a classy and elegant navy blue base, cherry red trim, and cherry red spikes. Quote Link to comment Share on other sites More sharing options...
dinohaven Posted August 4, 2005 Author Share Posted August 4, 2005 This was figured out. A possessive " ' " was messing it up. I still have one outstanding issue regarding Easy Populate. Any help would be greatly appreciated. I am trying to import a database to my backup site, but even though it says, "File uploaded.", it seems to stop at the first entry. Anyone have any suggestions as to what I should do to fix the following error???? =============================================== File uploaded. Temporary filename: /www/tmp/phpf08mTr User filename: EP2005Aug03-2008.txt Size: 700090 | DHD-NAVYRE | DINO_navy_ | Dino (Navy | test' | | 17.99 | 0.00 | | 2004-08-24 | 994 | 2 | Size | 1 | X Small | +0.0000 | 2 | Small | +0.0000 | 3 | Medium | +0.0000 | 4 | Large | +9.0000 | 5 | Adult | | 6 | XL | | 3 | Coat Size | 7 | 2 Years | | 8 | 4 Years | | 9 | 6 Years | | 10 | 8 Years | | 4 | Mitten Siz | 11 | Small Chil | | 12 | Medium Chi | | 13 | Female Adu | | 14 | Male Adult | | 5 | Headband | 15 | Adult | | 16 | Child | | | All Hats | Dino | | --none-- | Active Updated 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 flagship product comes in a classy and elegant navy blue base, cherry red trim' at line 11 INSERT INTO products_description (products_id, language_id, products_name, products_description, products_url) VALUES ( '35', 1, 'Dino (Navy and Red, Child)', 'Our flagship product comes in a classy and elegant navy blue base, cherry red trim, and cherry red spikes. <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
fender101 Posted August 4, 2005 Share Posted August 4, 2005 This was figured out. A possessive " ' " was messing it up. I still have one outstanding issue regarding Easy Populate. Any help would be greatly appreciated. <{POST_SNAPBACK}> I had this problem, I found that I had to remove " ' " from the name and descriptions then it worked like a dream. simply open up excel and do a find replace. Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.