PDA

View Full Version : EP 2.72 => 2.76



Klusmakelaar
06-23-2005, 02:25 AM
hello,

I.m testing te new version. I have a shop up and running with 9400 products. the EP splitfiles(v 2.72) in my running shop does not work in the trailversion(v2.0) with EP (v2.76).

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 'CHROOM 10.100.970.00', '10.100.970.00', ''

INSERT INTO products_description (products_id, language_id, products_name, products_description, products_url) VALUES ( '326', 1, 'DORNBRACHT SIMPLEXPLUG 1 1/4' CHROOM 10.100.970.00', '10.100.970.00', '' )

[TEP STOP]


I did not put this in the bug report because, I have the feeling this is not a bug but stupidety of my self :oops:

michael_s
06-23-2005, 07:16 AM
Yep. Your problem is:


1/4'

You must escape the single quote, as single quotes are reserved by php/mysql. So it should look like:


1/4\'

Klusmakelaar
06-23-2005, 07:26 AM
tnx :D

brough3
06-24-2005, 05:47 AM
Where can I find basic instructions on how to use Easy Populate to import an xls file into the database?