Easy Populate SQL Error

[RobMacAF]

I have the file laid out right for import but when I try I get...

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 (Normal, Classic, Rock, Jazz & Pop)
Upgradeable Firmware
PC and Mac Comp' at line 11

INSERT INTO products_description (products_id, language_id, products_name, products_description, products_url) VALUES ( '9', 1, 'MP3 PLAYER/USB FLASH DRIVE with BUILT-IN 256MB FLASH MEMORY', 'FEATURES:
256 MB Built-in Flash Memory
Mobile Music, Data, Documents and Pictures Storage.
Direct Connection into USB Port (No Cable Required)
Plug and Play (No Software Required for Windows ME/XP/2000 and Mac OS X)
Voice Recording Up to 16 Hours
Displays Song Title, Album and Artist
Digital Preset EQ's (Normal, Classic, Rock, Jazz & Pop)
Upgradeable Firmware
PC and Mac Compatible
Requires 1 x "AAA" Battery for MP3 Playback (Not Included)

SPECIFICATIONS:
Unit Dimensions: 3.69" x 1.18" x 0.8"(WHD)
Blister Packaging: 7.09" x 9.84" x 9.95"(WHD)

ACCESSORIES INCLUDED:
Installation CD
USB Cable
Carrying Strap
Professional Digital Neckband Stereo Headphones', '' )

[TEP STOP]


Anyone have any ideas on how to fix this? My server uses mySQL5

Thanks in advance

[ALElder]

You just need to upgrade to the new ver. you are having trouble importing with @%$%$^&**())(*;;'/. The new one works with csv

Will fix your problem

Adam

[met00]

"Digital Preset EQ's"

Single quote error. escape it. error will go away. The change is a simple one in easypop... Before you do the insert on the description line, use an addslashes() and the problem will go away.

[ALElder]

met00 is also correct

But if you would like to keep the "Digital Preset EQ's" you can upgrade and it will import correctly.

[BrandonScottishRegalia]

met00 can you explain what you mean for this? i added the new version of like ALElder suggested but i still get the 1064 error because of the single quote. Its mainly from my category names now. So do i just add the addslashes() within each category title or do you mean within each cell with a ' in it?

Thanks

[michael_s]

Escape the quote - put a backslash \ in front of it.

[met00]

before you enter anything into the database use addslashes() to normalize it for entry to the database. mysql sees a ' as a special character addslashes() will turn the ' to a \' which will allow it to be inserted.