Installer: content pack:Out of range value...

Next topic

Author	Message
Gunnar Skogen	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..
Łukasz Serwatka	Friday 19 May 2006 2:14:59 am It looks that you experiencing this problem: http://ez.no/community/bugs/installation_problem_on_mysql_5 Which exactly version of MySQL 5 do you have? Try with latest 5, if still no luck then use latest 4.1. Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Gunnar Skogen	Friday 19 May 2006 2:23:08 am Saw that bug report - (but it is old and did not have a resolution) Version is 5.0.18-win32 which is consistent with : >mysql -V mysql Ver 14.12 Distrib 5.0.18, for Win32 (ia32) Will see if there is a newer and eventually try 4.1
Kristof Coomans	Friday 19 May 2006 3:50:44 am I've also reported this in April: http://ez.no/bugs/view/8163 (sorry for the duplicate, I must have missed the other one). Take a look at my report for a solution. independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org
Łukasz Serwatka	Friday 19 May 2006 3:55:35 am Ah, nice! I haven't seen that you have posted solution as well. I haven't time to look deeper in that issue. Good to know :) Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Gunnar Skogen	Friday 19 May 2006 4:00:59 am Finally: MySql 5.0.21 : No Cigar :( MySql 4.1.19 : Cigar :) Thanks for all hjelp. Comment: I am also new to MySql - used to Oracle - but it seems to me that : data_int = '' in update or insert where '' is supposed to give null and column is an INT is not a good practice - would not even use it if the column was a STRING : null is null. Have not checked on MySql site if they have tightened up this but that seems logical to me... STRICT_TRANS ... sorta confirms my comment - so with that I can try 5.0.21 again (?) Will wait with that ( tired of installing - now to the business at hand :)