Easy Populate Problem

[bigbuba0]

After trying to add some new products with easy populate, this is the error message I am now getting:

 

I'm not highly experienced with PHP, but i can change things in MySQL and php files

 

File uploaded.

Temporary filename: /tmp/phpt4fQnC

User filename: newNASCAR.txt

Size: 49084

| NT-GIL | NT-GIL.jpg | DAVID GILL | Want to sh | | 89.95 | 0 | 0000-00-00 | 2/27/2007 | 1 | 0 | * Official | 0 | Size | 16 | Women's | | 17 | Men's | | 18 | Normal | | 19 | Small | | | NASCAR | David Gill | | Taxable Go | 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 Limited Lifetime Warranty. Available in two sizes: Men's and Ladies'/Youth.', ' at line 11

 

INSERT INTO products_description (products_id, language_id, products_name, products_description, products_url) VALUES ( '8815', 1, 'DAVID GILLILAND GM SERIES', 'Want to show your Pro Team, College and NASCAR driver spirit but still maintain a certain level of style and elegance? There is no better watch than the Game Time GM Series. This versatile 2-tone watch features the officially licensed Pro Team, College and NASCAR driver logo laser etched in 23K gold on the dial with twelve 23K gold tick marks, all protected by a genuine glass crystal. The brushed stainless steel case includes a rotating bezel and 23K gold accents. The adjustable Stainless Steel bracelet is also accented with 23K gold. Each GM Series watch features the incredible accuracy and reliability of Citizen ® Quartz movement, water resistance to 5 ATM (165 ft), and Game Time's Limited Lifetime Warranty. Available in two sizes: Men's and Ladies'/Youth.', '' )

[Jack_mcs]

It could be your use of quotes in the text. Try enabling the quotes option in the easy populate file. If that doesn't fix it, I suggest asking your question in the Easy Populate support thread.

 

Jack

[bigbuba0]

It could be your use of quotes in the text. Try enabling the quotes option in the easy populate file. If that doesn't fix it, I suggest asking your question in the Easy Populate support thread.

 

Jack

 

 

I'm not quite sure how to "enabling the quotes option in the easy populate file"??? can you provide a little more detail for me?

[DejaVu]

Open admin/includes/easypopulate.php

 

Search through to

 

// **** Quote -> Escape character conversion ****

// If you have extensive html in your descriptions and it's getting mangled on upload, turn this off

// set to true = replace quotes with escape characters

// set to false = no quote replacement

define ('EP_REPLACE_QUOTES', false); // default is false

 

TURNING IT OFF Means set to TRUE, I think, seeing as false is default.

[bigbuba0]

Open admin/includes/easypopulate.php

 

Search through to

 

// **** Quote -> Escape character conversion ****

// If you have extensive html in your descriptions and it's getting mangled on upload, turn this off

// set to true = replace quotes with escape characters

// set to false = no quote replacement

define ('EP_REPLACE_QUOTES', false); // default is false

 

TURNING IT OFF Means set to TRUE, I think, seeing as false is default.

 

 

Thanks DejaVu! Worked great, my code looked like this:

 

// **** Quote -> Escape character conversion ****
// If you have extensive html in your descriptions and it's getting mangled on upload, turn this off
// set to 1 = replace quotes with escape characters
// set to 0 = no quote replacement
global $replace_quotes;
$replace_quotes = false;

 

And all I had to do was change the "false" to a "1"

 

Thanks again!

[DejaVu]

Welcome. ;)

[Guest]

Bump!

 

Had the same problem and it was frying my brain with frustration... Modifying the easypopulate.php file worked as suggested.. thank you!