|
Friday 19 May 2006 2:05:29 am
OS: Windows XP Proffessional, SP2
PHP: 4.4.0, 4.4.1, 4.4.3.060519 ( tried all these for this problem)
DB: MySql 5.0
Http server: Apache 1.3.3.5
Running the installer:
Tried 2 packages during install, corporate and intranet: Both had the same problem:
"Fatal error: A database transaction in eZ publish failed." etc
The error log:
[ May 19 2006 10:41:26 ] [127.0.0.1] eZMySQLDB:
Query error: Out of range value adjusted for column 'data_int' at row 1. Query: UPDATE ezcontentobject_attribute
SET language_id='2', contentclassattribute_id='4',
attribute_original_id='0', sort_key_int='0', sort_key_string='latest news',
data_type_string='ezstring', data_text='Latest news', data_int='', data_float='0.000000'
WHERE id='186' AND contentobject_id='57' AND version='1' AND language_code='eng-GB'
[ May 19 2006 10:41:26 ] [127.0.0.1] eZDBInterface::commit TRANSID-ed1e96b60a17b57033ab4a29a2bba25f:
Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-ed1e96b60a17b57033ab4a29a2bba25f.
Tried to run the statement in SQL : same error, the data_int='' will not fly with MySql
-- should probably be data_int=null because that works in SQL.... NB: also set the my.ini::innodb_table_locks=0 on suggestion for problems with Transactions on this forum Hope someone can help - still have not gotten through the pearly gates of eZ..
|