1064 - You have an error in your SQL syntax;

[rusty1001]

Hi

 

I am running a test with data the original data that everyone has...

 

I downloaded with Easy Populate then uploaded - edited in excel and kept original formatting - with a few changes and I get this error,

I then redid it, but this time did not open in excel but notepad and made a few changes, and reloaded , same error.....??? I think it may do with the product descriptions having html formating but I am not sure??

Surely it can upload this back into if there are few changes,??

 

 

--- 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 -----

 

fastest graphics chip, the Millennium G400 Series takes explosive acceleration' at line 3

 

UPDATE products_description SET products_name='Matrox G400 32MB', products_description='Dramatically Different High Performance Graphics

 

 

thanks

 

russell

[rusty1001]

Hi

 

I am running a test with data the original data that everyone has...

 

I downloaded with Easy Populate then uploaded - edited in excel and kept original formatting - with a few changes and I get this error,

I then redid it, but this time did not open in excel but notepad and made a few changes, and reloaded , same error.....??? I think it may do with the product descriptions having html formating but I am not sure??

Surely it can upload this back into if there are few changes,??

--- 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 -----

 

fastest graphics chip, the Millennium G400 Series takes explosive acceleration' at line 3

 

UPDATE products_description SET products_name='Matrox G400 32MB', products_description='Dramatically Different High Performance Graphics

thanks

 

russell

 

 

I have tried on another versionand the same problem, yesterday it was fine,

cant think of what I have done but must be a general problem

any ideas out there?? :)

thanks

russell

[rusty1001]

I have tried on another versionand the same problem, yesterday it was fine,

cant think of what I have done but must be a general problem

any ideas out there?? :)

thanks

russell

 

 

I have tried to copies of osc - one without html formating in the prod. description and the other with?

I did the same error - first then I back upp the DB and for what ever reason worked.. the second

 

I get this error below with the html formatting?

 

Can easy populate handle the HTML formating the html in excel... is this the problem?

 

thanks

russell

 

 

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 fastest graphics chip, the Millennium G400 Series takes explosive acceleration' at line 3

 

UPDATE products_description SET products_name='Matrox G400 32MB', products_description='Dramatically Different High Performance Graphics

 

Introducing the Millennium G400 Series - a dramatically different, high performance graphics experience. Armed with the industry's fastest graphics chip, the Millennium G400 Series takes explosive acceleration two steps further by adding unprecedented image quality, along with the most versatile display options for all your 3D, 2D and DVD applications. As the most powerful and innovative tools in your PC's arsenal, the Millennium G400 Series will not only change the way you see graphics, but will revolutionize the way you use your computer.

 

Key features:

 

New Matrox G400 256-bit DualBus graphics chip

Explosive 3D, 2D and DVD performance

DualHead Display

Superior DVD and TV output

3D Environment-Mapped Bump Mapping

Vibrant Color Quality rendering

UltraSharp DAC of up to 360 MHz

3D Rendering Array Processor

Support for 16 or 32 MB of memory

', products_url='www.matrox.com/mga/products/mill_g400/home.htm' WHERE products_id = '2' AND language_id = '1'

[WendellAdkins]

replace the ' with \'

[davidinottawa]

replace the ' with \'

 

 

Also - I *think* if you replace the first ' with a " and the last ' with a " it should work without you having to escape the single ' within the insert text.

 

david