Forums / Install & configuration / Error message

Error message

Author Message

Jozef Pavlik

Tuesday 08 November 2005 11:51:52 pm

The setup wizard was not able to complete the creation of your selected sites.

The following errors were detected:

EZSW-004
Failed inserting data to mysql
Unknown table 'ezapprove_items' in information_schema
EZSW-040
Failed to initialize site package corporate
If you think you have fixed the errors you can try and click the "Retry" button.

I use Apache 1.3., PHP 4.4.0, MySQL 5

Jozef Pavlik

Tuesday 08 November 2005 11:53:02 pm

..and Ezpublish 3.7.2

Łukasz Serwatka

Wednesday 09 November 2005 12:52:22 am

Hi Jozef,

Look at this topic
http://ez.no/community/forum/install_configuration/errors_ezsw_004_ezsw_040

Which package have you downloaded tar.gz or .zip?

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Jozef Pavlik

Wednesday 09 November 2005 1:16:28 am

I have downloaded zip. Thanks.

Jozef Pavlik

Wednesday 09 November 2005 1:35:05 am

Hi, Lukasz,
I get this:
Fatal error: A database transaction in eZ publish failed.

The current execution was stopped to prevent further problems.
You should contact the System Administrator of this site with the information on this page.
The current transaction ID is TRANSID-681de88cadcb34f2c66db28dcd9d30e3 and has been logged.
Please include the transaction ID and the current URL when contacting the system administrator.

---------------------------------------------------
I have created a new clean database, choosed the plain site but the problem is the same?? Thanks for any advice.

Łukasz Serwatka

Wednesday 09 November 2005 1:36:39 am

Look into var/log/error.log (from eZ publish root) to check which SQL query failed.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Jozef Pavlik

Wednesday 09 November 2005 1:51:18 am

Thanks, Lukasz: Here is the error log:
-------------------------------------------------------
[ Nov 09 2005 10:30:07 ] [127.0.0.1] Query error: Out of range value adjusted for column 'data_int' at row 1. Query: UPDATE ezcontentobject_attribute
SET contentclassattribute_id='181', attribute_original_id='0',
sort_key_int='0', sort_key_string='contact us', data_type_string='ezstring',
data_text='Contact us', data_int='', data_float='0.000000'
WHERE id='186' AND contentobject_id='57' AND version='1' AND language_code='eng-GB'
[ Nov 09 2005 10:30:07 ] [127.0.0.1] Transaction in progress failed due to DB error, transaction was rollbacked. Transaction ID is TRANSID-20bb7b63db3a17a90cb75da5ff7a187f.
-------------------------------------------------------------

Łukasz Serwatka

Wednesday 09 November 2005 2:01:25 am

This looks like incompatibility with MySQL 5, which version of MySQL do you use, exacly?

Could you fill up bug report in bug system?

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Jozef Pavlik

Wednesday 09 November 2005 2:22:22 am

Yes, I use MySQL 5. I will fill up the bug report form.

Łukasz Serwatka

Wednesday 09 November 2005 3:02:16 am

Thank you Jozef, please include SQL query too.

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Łukasz Serwatka

Friday 11 November 2005 1:23:21 am

Jozef, I reported this problem in our bug tracking system. Bug team will look on this issue.

http://ez.no/bugs/view/7394

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Dereumaux xavier

Tuesday 22 November 2005 8:23:16 am

hi,

i've got the same problem on this "normal" instalation of ez 3.7.2 package Tar.gz (i try the zip but it's allready the same)

>> The setup wizard was not able to complete the creation of your selected sites.

The following errors were detected:

* EZSW-004Failed inserting data to mysql
Table 'ezapprove_items' already exists
* EZSW-040Failed to initialize site package news

If you think you have fixed the errors you can try and click the "Retry" button

Summary
System:

OK
Image system:

ImageGD
Mail:

sendmail
Database:

MySQL
Language:

eng-GB
fre-FR
Site:

News

I try few time to made it work (rm the folder and the database for a new clean install) but always the same problem. it's the first time i try to use EZ this is what i have on the install. I have search a few on the forum for this i find nothing.

Version - Apache/1.3.33 (Debian GNU/Linux) PHP/4.3.10-15
MySQL 4.1.11-Debian

plz help
thanks.

eZ debug

Timing: Jan 31 2025 04:29:13
Script start
Timing: Jan 31 2025 04:29:13
Module start 'content'
Timing: Jan 31 2025 04:29:13
Module end 'content'
Timing: Jan 31 2025 04:29:13
Script end

Main resources:

Total runtime0.1578 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0058 587.9219180.8438
Module start 'content' 0.00580.0045 768.7656105.8672
Module end 'content' 0.01030.1475 874.6328534.4766
Script end 0.1577  1,409.1094 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00342.1523200.0002
Check MTime0.00140.9024200.0001
Mysql Total
Database connection0.00070.429110.0007
Mysqli_queries0.109169.14711410.0008
Looping result0.00150.96811390.0000
Template Total0.147193.210.1471
Template load0.00080.522710.0008
Template processing0.146392.698110.1463
Override
Cache load0.00060.372010.0006
Sytem overhead
Fetch class attribute can translate value0.00080.532310.0008
XML
Image XML parsing0.00020.158310.0002
General
dbfile0.00412.5897200.0002
String conversion0.00000.003330.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs