Forums / Install & configuration / EzPublish 4.06 DB error

EzPublish 4.06 DB error

Author Message

Piotr Dabrowski

Tuesday 21 July 2009 7:24:16 am

[ Jul 21 2009 23:52:45 ] [58.172.155.152] eZPostgreSQLDB:
Hi,
I coming across of this error during editing or creating folders and articles.
Usually this happen at random like playing lottery. I was getting this error with previous versions to. It is very annoying and ending up with some unfinish work.
My DB is postgres 7.4.17 and php 5.2.9 in hosting environment.

Thanks
Peter

Error: error executing query: INSERT INTO
ezsearch_object_word_link
( word_id,
contentobject_id,
frequency,
placement,
next_word_id,
prev_word_id,
contentclass_id,
contentclass_attribute_id,
published,
section_id,
identifier,
integer_value )
VALUES ( '9500', '376', '0', '1053', '', '9499', '36', '282', '1248179582', '1', 'body', '0' ) ERROR: invalid input syntax for integer: ""
[ Jul 21 2009 23:52:45 ] [58.172.155.152] eZDBInterface::commit TRANSID-d7a54eda6ebc52ccaaa7dcaba6378170:
Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-d7a54eda6ebc52ccaaa7dcaba6378170.

André R.

Tuesday 21 July 2009 8:54:08 am

php 5.2.9 has a bug in array_unique, update to 5.2.10 to solve the issue.

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom