Forums / Install & configuration / AArgggggghhh. Install problems on last step.

AArgggggghhh. Install problems on last step.

Author Message

Reg Charie

Saturday 21 October 2006 8:18:12 pm

After getting through the install to the last screen I keep getting:

Creating sites
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
Table 'ezapprove_items' already exists
EZSW-040
Failed to initialize site package 'complete_site'

I have dropped and made new empty databases several times.

Any suggestions?

Reg

Ɓukasz Serwatka

Tuesday 24 October 2006 12:10:14 am

Hello Reg, and welcome to eZ publish Community!

First you need to identify a problem. Turn on debug output in settings/override/site.ini.append.php. If this file does not exists create it and put inside:

[DebugSettings]
DebugOutput=enabled

Then reset your database and try again.

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

Klaus Mezger

Thursday 26 October 2006 8:51:30 am

have the same errors with EZpublish 3.4.8. And by searching for "EZSW-051 & EZSW-040", I find 26 matches, but no solution.

The same installation files were uploaded to another apache linux server, and it worked!
But I have to run it at my (shared) server.
I tried:
Changing main language(s), database table type, database collation, erasing and rebuilding databese, using plain site. I am trying since 2 days, and I found no really helpful hint in this forum.

ERROR MESSAGE:

Creating sites

The setup wizard was not able to complete the creation of your selected sites.
The following errors were detected:
* EZSW-051Unable to install package 'news': Can't install object 'News': Unable to fetch class with remoteID: a3d405b81be900468eb153d774f4f0d2.
* EZSW-040Failed to initialize site package 'corporate_site'
If you think you have fixed the errors you can try and click the "Retry" button.

------------
CONFIGURATION:

Site info:

Site package - corporate_site
Title - RFbeam
URL - http://www.rfbeam.ch/ezpublish/index.php?/rfbeam
Admin URL - http://www.rfbeam.ch/ezpublish/index.php?/rfbeam_admin
Access type - url
Access value - rfbeam

PHP info:
Version - 4.4.4

OS info
Name - Linux omega.ibone.ch 2.6.17.7 #1 SMP PREEMPT Thu Jul 27 13:41:06 CEST 2006 i686
CPU Type - Intel(R) Pentium(R) D CPU 3.20GHz
CPU Speed - 3200.155 MHz
Memory Size - 2111201280 (1.97 GB)

Database info:
Type - MySQL
Driver - ezmysql

Email info:
Transport - SMTP

Image conversion:
ImageMagick was found and used.
Path - /usr/bin
Executable - convert
ImageGD extension was found and used.

Regional info:
Primary - ger-DE
Additional - ger-DE

Critical tests

directory_permissions - Success
phpversion - Success
database_extensions - Success
image_conversion - Success
open_basedir - Success
safe_mode - Success
memory_limit - Success
execution_time - Success
magic_quotes_runtime - Success
allow_url_fopen - Success
accept_path_info - Success
php_session - Success
file_upload - Success

Other tests:

php_magicquotes - Failure
zlib_extension - Success
mbstring_extension - Success
imagegd_extension - Success
imagemagick_program - Success
database_all_extensions - Success
php_register_globals - Failure
texttoimage_functions - Success

Klaus Mezger

Thursday 26 October 2006 9:20:47 am

Excuse me, I forgot to say, that the error messages mentionned by Reg apper also:

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

They appear after getting the messages : EZSW-051 & EZSW-040,
if I retry installing without deleting the database

The file settings/override/site.ini.append.php is not yet built by the install procedure.

Maybe, these informations help finding the reason.
Thanks for any tips and hints!
Klaus

Ron Papa

Tuesday 31 October 2006 9:00:46 pm

Hi!

I'm getting the same error as Reg. I followed the advice given by Lukasz and it is still not working. Further to Reg's problem, I am getting an INTERNAL SERVER error page and I need to refresh the page in order to view the error:

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

In the eZ debug page I am getting the following error message regarding the Module start 'setup':

Error: eZMySQLDB Oct 31 2006 23:56:33
Query error: Table 'ezapprove_items' already exists. Query: CREATE TABLE ezapprove_items (
collaboration_id int(11) NOT NULL DEFAULT '0',
id int(11) NOT NULL AUTO_INCREMENT,
workflow_process_id int(11) NOT NULL DEFAULT '0',
PRIMARY KEY ( id )
) TYPE=InnoDB

Error: Oct 31 2006 23:56:33
Failed inserting the SQL:
CREATE TABLE ezapprove_items (
collaboration_id int(11) NOT NULL DEFAULT '0',
id int(11) NOT NULL AUTO_INCREMENT,
workflow_process_id int(11) NOT NULL DEFAULT '0',
PRIMARY KEY ( id )
) TYPE=InnoDB

Any advice would be appreciated by this newbie.

Thanks!

eZ debug

Timing: Jan 18 2025 19:07:58
Script start
Timing: Jan 18 2025 19:07:58
Module start 'content'
Timing: Jan 18 2025 19:07:59
Module end 'content'
Timing: Jan 18 2025 19:07:59
Script end

Main resources:

Total runtime1.0547 sec
Peak memory usage4,096.0000 KB
Database Queries204

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0098 587.9609180.8047
Module start 'content' 0.00980.8781 768.7656671.0469
Module end 'content' 0.88790.1667 1,439.8125341.0469
Script end 1.0546  1,780.8594 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00550.5200210.0003
Check MTime0.00180.1735210.0001
Mysql Total
Database connection0.00310.298410.0031
Mysqli_queries0.940289.14282040.0046
Looping result0.00220.21322020.0000
Template Total1.012796.020.5063
Template load0.00250.240720.0013
Template processing1.010195.773420.5051
Template load and register function0.00020.018310.0002
states
state_id_array0.00210.197510.0021
state_identifier_array0.00210.203520.0011
Override
Cache load0.00240.22581270.0000
Sytem overhead
Fetch class attribute can translate value0.00120.111650.0002
Fetch class attribute name0.00110.100860.0002
XML
Image XML parsing0.00210.202350.0004
class_abstraction
Instantiating content class attribute0.00000.001260.0000
General
dbfile0.00570.5409290.0002
String conversion0.00000.000530.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
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
5content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
26content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
21content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 55
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs