Forums / Developer / PostgreSQL error

PostgreSQL error

Author Message

Ken Nguyen

Tuesday 23 November 2010 3:30:06 am

Hi,

When I try to edit or create something in my site, I have this bug :

Fatal error: A database transaction in eZ Publish failed.
The current execution was stopped to prevent further problems.

And my error.log:

[ Nov 23 2010 11:55:12 ] [192.168.1.156] eZPostgreSQLDB:
Error: error executing query: INSERT INTO ezcontentobject_attribute (contentobject_id, version, language_code, language_id, contentclassattribute_id, attribute_original_id, sort_key_int, sort_key_string, data_type_string, data_text, data_int, data_float) VALUES(15, 1, 'fre-FR', 2, 378, 0, 0, '', 'ezstring', '', NULL, 0.000000) ERREUR: la valeur d'une clé dupliquée rompt la contrainte unique « ezcontentobject_attribute_pkey »
[ Nov 23 2010 11:55:12 ] [192.168.1.156] eZDBInterface::commit TRANSID-380312e0f06d9a3d0513e1207c6814d5:
Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-380312e0f06d9a3d0513e1207c6814d5.

I had a MySQL database which runs correctly but when I migrate to PostgreSQL I have problems with transaction.

If you can help me please.

Thanks.

Gaetano Giunta

Tuesday 23 November 2010 4:53:46 am

use the seytup / upgrade check / db consistency page. looks like your autoincrement sequences are not ok

Principal Consultant International Business
Member of the Community Project Board