Forums / Install & configuration / Installer: content pack:Out of range value...

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

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 :)