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

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

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: Exponential did not finish its request The execution of Exponential 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 Exponential 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, Exponential 3.8 and 3.9 are only supported on PHP 4.4. For PHP 4.3, use Exponential 3.6 (but this branch is no longer supported). To know the storage engines used by the tables of your Exponential 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 Exponential. 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