25 replies to this topic

[Tobias]

Hi!
I have encountered as the title said: an error occurred while creating object product when i try to add a new product in backoffice.

Its possible to add new categories but not new product, im also Not able to duplicate products?

Been reading around here, and found no good answers unfortunatly appreciate all help, can also offer a small amount if a working solution is found. Also tried all kinds of different product names so this cant be the matter.

Please do get back if you can offer some kind of help, getting desperate here!

Thanks

[Tobias]

someone with a little knowledge please?

[Tobias]

daily bump and well.... as i said before i can offer a small amount if someone can give me a solution to it! Really need to get it working asap.

[rocky]

What version of PHP are you using? There are certain versions that cause problems in Prestashop.

[Tobias]

Thnx for the reply, problem solved. It was ps_product and ps_product_lang tables that didnt match wich caused the problem. Manually corrected all entries then everything works fine.

[JJBYPC]

From 1268119451:

Thnx for the reply, problem solved. It was ps_product and ps_product_lang tables that didnt match wich caused the problem. Manually corrected all entries then everything works fine.

Hi Tobias,

Could you please explain to me what you did to solve this problem?

Please.

Thanks

[ihackpro]

From 1268533500:

From 1268119451:

Thnx for the reply, problem solved. It was ps_product and ps_product_lang tables that didnt match wich caused the problem. Manually corrected all entries then everything works fine.

Hi Tobias,

Could you please explain to me what you did to solve this problem?

Please.

Thanks

Yes please.
I have a similar problem.I uploaded the shop to my hosting and I cannot duplicate items.
But I could duplicate them working "locally"...
Any help is welcome.
Thanks

[Geunix]

Hi,
this is not solved. At least not clear. what is ps_product and ps_product_lang?

Thanks for the help!

[ihackpro]

From 1271873106:

Hi,
this is not solved. At least not clear. what is ps_product and ps_product_lang?

Thanks for the help!

Hey,
they are some tables from the database!

[armadillo]

Hi, what we have to do with these tables to solve the problem.

Thanks

[brandonc503]

yea im having same issue. i was able to jsut refresh page and start item entry again, but does not seem to work now.
what changes did you make to those tables to make them match?

[shopgirl]

I'm having this issue too. Version 1.3.1.

[brandonc503]

ive moved on to using 1.3.1 but realy dont remember this problem. sorry.

[brandonc503]

oh yea. i remember, product entry.. yea happens with 1.3.1 also sometimes. i just refresh the page or go back into catalog and create again and it works fine. havent had time to track down issue.

[shopgirl]

I'm not having trouble creating a new product from scratch. The problem is with using that "duplicate" little green button. All the time. Would be nice to be able to use.

[mageberg]

Hi, I have the same problem as Tobias described at the beginning. I have 67 products in various categories and I can't add new product or duplicate it (I can add categories for instance). I get the same error: "Error occurred while creating object product". I use prestashop v.1.2.2 and I wonder if the update into 1.3.1 would solve the problem. As shopgirl wrote above the problem still exists, even in 1.3.1 So, I don't know what to do. Tobias suggests to fix the problem with 'product' and 'product_lang' tables. I don't know what is the problem with these tables and what is more I wonder if this fix solves the problem for good or not. If the fix has to be repeated from time to time because the relation between tables is spoiled by certain operation in the shop, such solution is useless. Does somebody know where is the problem and how to solve it ?
Thanks in advance.

[shopgirl]

Someone knowlegeable said it is because of our MySQL version being too low. Mine is below 5.2 like he said. So if I want the duplication ability, I would need to upgrade it.

[mageberg]

From prestashop page:

-------------------------------------------
System requirements:
* - Linux, Unix, or Windows
* - Web Server (Apache 1.3 or later, IIS 6 or later)
* - PHP 5.0* or later
* - MySQL 5** or later

** PrestaShop is working from MySQL 4.1.14 to 5.0 too but some features are not working (e.g., product duplication) or have strange behaviors
------------------------------------------

I use MySQL 5.0.9. In my case there is also problem with common adding new products to the category not only with duplication. Moreover, the duplication and creating new product have worked till now and has stopped to work suddenly.

[mageberg]

I've found following changes in CHANGELOG between 1.2.2 and 1.3.1

Classes : Fixed bug #2988 - Added several methods in order to better clean the DB while deleting a product
BO : fixed bug duplicating product with image (#2862)
Classes : fixed bug while duplicating product without tags (#2860). Thanks to Victor Berchet !

That's interesting what problems could happen wihtout these correction. Maybe badly performed duplication hasn't copied all relations correctly what has caused my problem. Has somebody met similar problem ?

shopgirl, thanks for quick and useful response! Maybe it's really problem with database and mysql 5.0 isn't good enough and we really need to use 5.2 (it would mean mistake on http://www.prestashop.com/en/downloads). It's a next issue to check.

[mysterion]

I've the same error duplicating products with v1.3.1.1 and MYSQL 5.0.77
Is there no solution? Why is thread marked "solved"?