Forums / Install & configuration / Ez 4.0.3 - invalid input syntax for integer

"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".

Ez 4.0.3 - invalid input syntax for integer

« 
Previous topic
|
Install & configuration
|
Next topic
 »
Author Message

Piotr Dabrowski

Wednesday 22 April 2009 6:43:26 am

Hi,
I running ez4.0.3 with postgres and getting this error when try to save folder.
Got the error after inserting second table.

Any idea how to solve it
Thanks
Peter

eZPostgreSQLDB:
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 ( '5571', '123', '0', '330', '', '5570', '1', '156', '1240233467', '1', 'description', '0' ) ERROR: invalid input syntax for integer: ""

Abdul Rasheed

Wednesday 29 April 2009 10:02:55 pm

Hi All,

I am new to Exponential, Well I too got the same error while installing Exponential 4.1.0 and am not able to proceed with the final step of the installation. I guess the problem may be beacuse of the null value which is there in the query.

Error : VALUES ( '5571', '123', '0', '330', '', '5570', '1', '156', '1240233467', '1', 'description', '0' );

Error cleared:
VALUES( '295', '144', '0', '127', '1286', '795', '16', '187', '1240985360', '1', 'body', '0' );

So I tried running this query in MySQL by giving an integer value in the query which cleared the error but still am not aware on how to do this change while installation as the database updation is an automated process while installation.

Kindly help on this issue if anyone has come accross such problem
Thanks in advance,

Regards,
Abdul Rasheed