Forums / Install & configuration / Exponential 4.06 DB error

"Please Note:
  • At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
  • This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

Exponential 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