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

«

Previous topic

|

Install & configuration

|

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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing:	Jan 31 2025 07:20:19
Script start
Timing:	Jan 31 2025 07:20:19
Module start 'layout'
Timing:	Jan 31 2025 07:20:19
Module start 'content'
Timing:	Jan 31 2025 07:20:19
Module end 'content'
Timing:	Jan 31 2025 07:20:19
Script end

Main resources:

Total runtime	0.0165 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0050	588.3672	151.2266
Module start 'layout'	0.0050	0.0024	739.5938	36.6797
Module start 'content'	0.0073	0.0076	776.2734	98.2188
Module end 'content'	0.0150	0.0015	874.4922	37.9922
Script end	0.0165		912.4844

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0023	14.2108	14	0.0002
Check MTime	0.0010	6.2911	14	0.0001
Mysql Total
Database connection	0.0006	3.6762	1	0.0006
Mysqli_queries	0.0025	15.1595	3	0.0008
Looping result	0.0000	0.0722	1	0.0000
Template Total	0.0011	6.6	1	0.0011
Template load	0.0008	4.5541	1	0.0008
Template processing	0.0003	2.0359	1	0.0003
Override
Cache load	0.0005	3.1361	1	0.0005
General
dbfile	0.0033	20.0817	8	0.0004
String conversion	0.0000	0.0419	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs