Forums / Install & configuration / Setup wizard unable to complete the site creation

Setup wizard unable to complete the site creation

« 
Previous topic
|
Install & configuration
|
Next topic
 »
Author Message

Jozef Zvonar

Friday 26 January 2007 12:34:05 am

This is what I can read in my browser right before the installation creates the site:
-------------------------------------------------------------------------------------
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
Unknown table 'ezapprove_items' in information_schema

EZSW-040
Failed to initialize site package 'ezwebin_site'

If you think you have fixed the errors you can try and click the "Retry" button.
-------------------------------------------------------------------------------------
I checked everything known to me. Anyhow, I was anable to fix the problem. Could somebody help and explain what's going wrong?

Łukasz Serwatka

Friday 26 January 2007 12:38:01 am

Hi,

For some reason your installation stopped. You can either enable debug output in settings/site.ini or check var/log/error.log for possible errors.

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

Jozef Zvonar

Friday 26 January 2007 2:03:11 am

Lukasz,

many thanks for your advice. This was found in the error.log file:

[ Jan 26 2007 10:53:05 ] [192.168.0.10] eZMySQLDB:
Query error: Unknown table 'ezapprove_items' in information_schema. 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
[ Jan 26 2007 10:53:05 ] [192.168.0.10] :
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
[ Jan 26 2007 10:53:09 ] [192.168.0.10] eZMySQLDB:
Query error: Unknown table 'ezapprove_items' in information_schema. 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
[ Jan 26 2007 10:53:09 ] [192.168.0.10] :
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

In fact it's the same what my browser says in a shortly version of the error.log file. I was trying to create the table(s) manually, but my MySQL - 5.0.22-community-nt server responded with Error #1109 - Unknown table 'ezapprove_items' in information_schema, and etc. for the other tables shown in the error.log file. It looks somehow strange. I connect as root with super priviliges to my SQL server. The installation is made locally.

Any other idea? I would appreciate all klind of help/support very much.

Jozef Zvonar

Friday 26 January 2007 3:13:15 am

I finally succeeded to create the site. Thanks!

Łukasz Serwatka

Friday 26 January 2007 3:33:24 am

Great, how did you solve it?

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

Kristof Coomans

Friday 26 January 2007 4:16:03 am

The information_schema database is a special schema used by MySQL (5+) to provide access to database metadata ( http://dev.mysql.com/doc/refman/5.0/en/information-schema.html ). It should not be used for any other purposes.

Also see this bug report: http://issues.ez.no/9043

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Anthony Oh

Sunday 28 January 2007 6:29:14 am

i am having this problem

EZSW-004
Failed inserting data to mysql
BLOB column 'path_identification_string' can't be used in key specification with the used table type
EZSW-040
Failed to initialize site package 'ezwebin_site'

i cant find my error.log on /var/log

please help!

Kristof Coomans

Sunday 28 January 2007 12:00:22 pm

Hi Anthony

Have a look at this bug report: http://issues.ez.no/7580

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Anthony Oh

Sunday 28 January 2007 3:56:53 pm

so what is the resolution?

I tried to upload the DB manually and this error occurs

Fatal error: eZ publish did not finish its request

The execution of eZ publish was abruptly ended, the debug output is present below.

AND I am not using MySQL 5 Cluster ...

my eviroment is PHP4.3.11 and MySQL 3.2.X

Kristof Coomans

Sunday 28 January 2007 10:57:49 pm

Which storage engine are you using for your tables?

Note that there's no support anymore for the eZ publish versions that were compatible with PHP 4.3.x. MySQL 3 is also quite old, you'll miss some advanced features without MySQL 4.

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Anthony Oh

Monday 29 January 2007 1:58:12 am

i am not quite good at this .. what is storage engine? and where can i find out?

Anthony Oh

Monday 29 January 2007 5:00:41 am

now i can install version 3.8.6 but not 3.9.0

this is weird ..

Kristof Coomans

Monday 29 January 2007 6:27:56 am

Hi Anthony,

eZ publish 3.8 and 3.9 are only supported on PHP 4.4. For PHP 4.3, use eZ publish 3.6 (but this branch is no longer supported).

To know the storage engines used by the tables of your eZ publish database, run the following SQL ( http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html ):

SHOW TABLE STATUS FROM db_name;

You will find the storage engine name in the Engine column.

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Anthony Oh

Monday 29 January 2007 4:03:41 pm

currently is MyISAM

and i can run ez on php 4.3.11 for version 3.8.6

this is the site .. http://vps.sg/ez

anthony

Ricardo Goldberger

Tuesday 13 November 2007 11:49:59 am

At last I had the same error than the first poster and didn't know how to solve it,
Please, something?
Thanks in advance

Cori Roberts

Wednesday 08 April 2009 1:47:43 pm

I'm getting this error with the current install of EZ publish. I've checked the MySQL version and it is 5.

Any tips on how to fix this and please explain it to me like I'm a 5 year old. My PHP and MySQL knowledge is very rudimentary, so when explaining how to fix, please provide step by step instructions, not like I'm a veteran developer.

Thanks in advance!

C

Cori Roberts

Wednesday 08 April 2009 1:49:29 pm

OH!

And just so I give you all the info I have this is the error I get:

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

And this is the debugging output:

>>>eZ debug
Timing: Apr 08 2009 11:31:49

Script start

Timing: Apr 08 2009 11:31:49

Module start 'setup'

Debug: ezi18n Apr 08 2009 11:31:49

No translation for file(translation.ts) in context(lib/template): 'The maximum nesting level of %max has been reached. The execution is stopped to avoid infinite recursion.' with comment()

Error: eZMySQLiDB Apr 08 2009 11:31:49

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 )
) ENGINE=InnoDB

Error: Apr 08 2009 11:31:49

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 )
) ENGINE=InnoDB

Debug: eZTSTranslator::loadTranslationFile: tried paths Apr 08 2009 11:31:49

share/translations/eng-US/utf-8/translation.ts
share/translations/eng-US/translation.ts
share/translations/eng-GB/utf-8/translation.ts
share/translations/eng-GB/translation.ts

Debug: eZTSTranslator::loadTranslationFile: loaded paths Apr 08 2009 11:31:49

Warning: eZTranslationCache::setContextCache Apr 08 2009 11:31:49

Translation cache for context 'cachecontexts' already exists

Debug: ezi18n Apr 08 2009 11:31:49

No translation for file(translation.ts) in context(design/standard/setup/init): 'Creating sites' with comment()

Timing: Apr 08 2009 11:31:49

End

Timing: Apr 08 2009 11:31:49

Module end 'setup'

Debug: eZTSTranslator::loadTranslationFile: tried paths Apr 08 2009 11:31:49

share/translations/eng-US/utf-8/translation.ts
share/translations/eng-US/translation.ts
share/translations/eng-GB/utf-8/translation.ts
share/translations/eng-GB/translation.ts

Debug: eZTSTranslator::loadTranslationFile: loaded paths Apr 08 2009 11:31:49

Warning: eZTranslationCache::setContextCache Apr 08 2009 11:31:49

Translation cache for context 'cachecontexts' already exists

Debug: ezi18n Apr 08 2009 11:31:49

No translation for file(translation.ts) in context(kernel/navigationpart): 'Content structure' with comment(Navigation part)

Debug: eZTSTranslator::loadTranslationFile: tried paths Apr 08 2009 11:31:49

share/translations/eng-US/utf-8/translation.ts
share/translations/eng-US/translation.ts
share/translations/eng-GB/utf-8/translation.ts
share/translations/eng-GB/translation.ts

Debug: eZTSTranslator::loadTranslationFile: loaded paths Apr 08 2009 11:31:49

Warning: eZTranslationCache::setContextCache Apr 08 2009 11:31:49

Translation cache for context 'cachecontexts' already exists

Debug: ezi18n Apr 08 2009 11:31:49

No translation for file(translation.ts) in context(kernel/navigationpart): 'Media library' with comment(Navigation part)

Debug: eZTSTranslator::loadTranslationFile: tried paths Apr 08 2009 11:31:49

share/translations/eng-US/utf-8/translation.ts
share/translations/eng-US/translation.ts
share/translations/eng-GB/utf-8/translation.ts
share/translations/eng-GB/translation.ts

Debug: eZTSTranslator::loadTranslationFile: loaded paths Apr 08 2009 11:31:49

Warning: eZTranslationCache::setContextCache Apr 08 2009 11:31:49

Translation cache for context 'cachecontexts' already exists

Debug: ezi18n Apr 08 2009 11:31:49

No translation for file(translation.ts) in context(kernel/navigationpart): 'User accounts' with comment(Navigation part)

Debug: eZTSTranslator::loadTranslationFile: tried paths Apr 08 2009 11:31:49

share/translations/eng-US/utf-8/translation.ts
share/translations/eng-US/translation.ts
share/translations/eng-GB/utf-8/translation.ts
share/translations/eng-GB/translation.ts

Debug: eZTSTranslator::loadTranslationFile: loaded paths Apr 08 2009 11:31:49

Warning: eZTranslationCache::setContextCache Apr 08 2009 11:31:49

Translation cache for context 'cachecontexts' already exists

Debug: ezi18n Apr 08 2009 11:31:49

No translation for file(translation.ts) in context(kernel/navigationpart): 'Webshop' with comment(Navigation part)

Debug: eZTSTranslator::loadTranslationFile: tried paths Apr 08 2009 11:31:49

share/translations/eng-US/utf-8/translation.ts
share/translations/eng-US/translation.ts
share/translations/eng-GB/utf-8/translation.ts
share/translations/eng-GB/translation.ts

Debug: eZTSTranslator::loadTranslationFile: loaded paths Apr 08 2009 11:31:49

Warning: eZTranslationCache::setContextCache Apr 08 2009 11:31:49

Translation cache for context 'cachecontexts' already exists

Debug: ezi18n Apr 08 2009 11:31:49

No translation for file(translation.ts) in context(kernel/navigationpart): 'Design' with comment(Navigation part)

Debug: eZTSTranslator::loadTranslationFile: tried paths Apr 08 2009 11:31:49

share/translations/eng-US/utf-8/translation.ts
share/translations/eng-US/translation.ts
share/translations/eng-GB/utf-8/translation.ts
share/translations/eng-GB/translation.ts

Debug: eZTSTranslator::loadTranslationFile: loaded paths Apr 08 2009 11:31:49

Warning: eZTranslationCache::setContextCache Apr 08 2009 11:31:49

Translation cache for context 'cachecontexts' already exists

Debug: ezi18n Apr 08 2009 11:31:49

No translation for file(translation.ts) in context(kernel/navigationpart): 'Setup' with comment(Navigation part)

Debug: eZTSTranslator::loadTranslationFile: tried paths Apr 08 2009 11:31:49

share/translations/eng-US/utf-8/translation.ts
share/translations/eng-US/translation.ts
share/translations/eng-GB/utf-8/translation.ts
share/translations/eng-GB/translation.ts

Debug: eZTSTranslator::loadTranslationFile: loaded paths Apr 08 2009 11:31:49

Warning: eZTranslationCache::setContextCache Apr 08 2009 11:31:49

Translation cache for context 'cachecontexts' already exists

Debug: ezi18n Apr 08 2009 11:31:49

No translation for file(translation.ts) in context(kernel/navigationpart): 'My account' with comment(Navigation part)

Timing: Apr 08 2009 11:31:49

End

Timing points:
Checkpoint Elapsed Rel. Elapsed Memory Rel. Memory
Script start 0.0000 sec 0.0581 sec 2,732.5000 KB 2,180.1797 KB
Module start 'setup' 0.0581 sec 0.2022 sec 4,912.6797 KB 5,665.3125 KB
End 0.2603 sec 0.0001 sec 10,577.9922 KB -47.4453 KB
Module end 'setup' 0.2604 sec 0.0241 sec 10,530.5469 KB 198.3828 KB
End 0.2845 sec 10,728.9297 KB
Total runtime: 0.2891 sec
Peak memory usage: 13,317.7422 KB
Time accumulators:
Accumulator Elapsed Percent Count Average
ini_load
Load cache 0.0216 sec 6.4804% 12 0.0018 sec
FindInputFiles 0.0017 sec 0.4991% 12 0.0001 sec
Parse 0.0130 sec 3.9079% 3 0.0043 sec
Save Cache 0.0022 sec 0.6645% 3 0.0007 sec
TS translator
TS init 0.0169 sec 5.0558% 9 0.0019 sec
TS cache load 0.0005 sec 0.1361% 1 0.0005 sec
TS context load 0.0000 sec 0.0093% 1 0.0000 sec
TS store cache 0.0068 sec 2.0438% 8 0.0009 sec
Template Total 0.0511 sec 15.3% 4 0.0128 sec
Template load 0.0274 sec 8.2049% 4 0.0068 sec
Template processing 0.0236 sec 7.0639% 4 0.0059 sec
Mysql Total
Mysqli_queries 0.0227 sec 6.7888% 3 0.0076 sec
Looping result 0.0000 sec 0.0111% 1 0.0000 sec
override
Cache load 0.0149 sec 4.4680% 4 0.0037 sec
General
String conversion 0.0018 sec 0.5494% 9 0.0002 sec
INI string conversion 0.0019 sec 0.5805% 7 0.0003 sec
String conversion w/ mbstring 0.0017 sec 0.5082% 4 0.0004 sec
Total script time: 0.3336 sec <<<

Once again thanks for your help in advance!

C