[SOLVED] An error occurred while creating an object. product

[marjanbajc]

Hi,

 

I'm having a really weird problem.

 

When I try to add or edit a product i get An error occurred while creating an object. product

 

I've narrowed it down to a single product. I tried to delete it which it did but when I try to add new product it repeats the error and puts the product with the same id back. I tried to delete it from DB an it does the same. Like it's stuck on that particular product id.

 

Some info:

product id = 4294967295

PS version = 1.5.4.0

 

Can anyone help me?

[marjanbajc]

Nobody had a problem like this?

[vekia]

4294967295 it's a highest number you can get using with INT field.

you've got 4294967295 products in database? :|

[marjanbajc]

No no, of course not. But the product has that ID. And when I try to modify it, it gives me that error. But when I try to delete it from admin, it deletes it but when I try to add new product then it reappears.

[vekia]

you need to change auto increnement value for this table probably, have you got an access to phpmyadmin ?

[marjanbajc]

Thanks vekia for pointing me in right direction.

 

If anyone has this problem just delete the ID in the database then export the database and import it again.

[vekia]

thank you for posting solution for this

i marked whole topic as [solved]

 

with regards,

Milos