|
Shawn Xie
|
Monday 04 May 2009 1:52:49 pm
I am installing ezpublish-4.1.0 with the setup wizard onto my Windows XP laptop. I select Website Interface in the site selection step (I have no any setup problem if Plain site is selected). Everything seems fine until the last step "Finish". I got a Fatal error: A database transaction in eZ Publish failed. The error.log of at \var\log\ shows following message (only the problem data line is copied here):
Query error: Incorrect integer value: '' for column 'next_word_id' at row 128.
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 (
( '295', '144', '0', '127', '', '1286', '16', '187', '1241453677', '1', 'body', '0' ) ,
You can the fifth param which correspond to next_word_id is an empty string. I check both cleandata.sql files in \kernel\sql\mysql\ and kernel\sql\common\ but cannot find the original source of the error insert data. Also manually importing kernel_schema.sql and one of the cleandata.sql files ro mysql works fine. Why 4.1.0 setup wizard does not work for website interface and how to correct the error? Please help! Thanks in advance, -Shawn
|