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

Ez 4.0.3 - invalid input syntax for integer

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 eZ Publish, Well I too got the same error while installing eZ Publish 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