eSShop not adding new products... but then works other times!

[jongrant]

Hi all,

I've currently got CMSMS 1.2.3 installed, with the eSShop 1.0.1 module installed, and its been working great but then yesterday I couldnt add anymore products

I tried adding a new product to one of the categories but it just didnt add to the database. Didnt show any errors or anything..

It did the same thing the other day, but then I transferred the "includes" folder over incase something was corrupt, and that seemed to fix it, but when it happened the second time, I transferred the "includes" folder again and no change... its really annoying cause the module is doing everything great as I need it to (and I've edited the template to make it blend in the design etc) and now its just not working

Anyone else had the same problem?

[jongrant]

Just thought I'd also note, when I try to add the new products, the images ARE being uploaded - but no entry being written to the DB...

Hope someone can help.. its driving me insane! haha

[Slewey]

Don't know if you found a solution yet, but I had a similar problem.
The Esshop module doesn't allow to add special characters to the description field!
I did some minor changes with a mysql_escape_string to the $_POST['description'] in both includes/admin/category.php and includes/admin/products.php
And I also changed al the content-types to UTF-8, in my pages and in de database!

Hope this can help you out!

[jongrant]

Thanks for your reply mate.

What special characters were you trying to put into yours?

Cause my esshop wasnt working, I have to manually add them in via myPHPadmin which sucked alot... very slow task, but for some strange reason my esshop is now working fine again. Its strange that its intermitting like it is.. I tried with a few characters in the description but the product was still added - only tried with "!" and "$" though, so not sure what you meant by special characters though.

Hope someone can help me with this, cause I dont know which is worse, the fact that I cant add products, or the fact that it works only sometimes :S

[Slewey]

I had problems with using quotes.
Because there was no escape_string the single quotes (like ') I used got inside the query and ended the query,
wich produced an error!
I editted my source code to use a mysql_escape_string on all values wich are inserted to the database.

[reset]

Hi guys, I've the same problem.
When in the filed description of the products you insert the character ' the query don't work and you receive an email of error.

Have you try a solution?
I've try to change the query string but without result.

Regards

Jac