Forums / Install & configuration / Failure in last step of installation

Failure in last step of installation

Author Message

Anton de Waal

Wednesday 27 December 2006 8:10:02 pm

I have noticed many people experiencing the same problem as me on last step (version 3.9):

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 'ezwebin_site'

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

I have tried advice of others to no avail. Recreated a clean database, dumped tables, etc. But nothing works.
Does anybody have an idea what the problem is? My server settings are fine, that's not the problem.

Many thanks
Anton

Claudia Kosny

Friday 29 December 2006 3:48:14 pm

HI Anton

What version of MySQL/PostgreSQL do you use?
Also please enable debug output (just set DebugOutput in the main site.ini to enabled) and make a fresh install. Now check on the page directly before the error occurs and on the error page itself whether you find any interesting debug messages. If yes, please post them.

Claudia

Blazej Marcinek

Thursday 04 January 2007 4:43:25 am

I believe this error is caused by Internet Explorer - it automatically (and silently) re-submits POST data when no response is returned from server after certain time from first submission (~30 seconds).
This in turn launches new installation process of ezPublish - while the previous has already created tables - resulting in this error meessage. Solution is to use different browser for installation (i.e. Firefox).

EZ crew could perhaps also consider modifing the setup program to eliminate this problem (there are various ways, e.g. store POSTed params in some session/global vars, and redirect to some other PHP script which would process the installation)

Claudia Kosny

Thursday 04 January 2007 1:51:36 pm

Hi Blazej

Sounds interesting. I gotta have to try installing using IE over the weekend just to see whether I can recreate the problem.

Thanks for the info

Claudia

Anton de Waal

Thursday 04 January 2007 4:15:36 pm

Hi Claudia & Blazej
thanks for your suggestions.
I have tried 3 different browsers now: IE, FireFox and Opera and they all end up with the same result.
Server info:
Perl Version : v5.8.4 built for i386-linux-thread-multi
Perl Path : /usr/bin/perl
Sendmail Path : /usr/sbin/sendmail
MySQL Version : mysql Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i386)
PHP Version : 4.4.0
I have set the debug to enabled and got the error messages below:
Thanks for your help :)

Timing:
Jan 05 2007 02:06:38

Script start
Timing:
Jan 05 2007 02:06:38

Module start 'setup'
Notice: eZMySQLDB::query(0.000 ms) query number per page:0
Jan 05 2007 02:06:38

SET NAMES 'latin1'
Error: eZMySQLDB
Jan 05 2007 02:06:38

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 )
)
Error:
Jan 05 2007 02:06:38

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 )
)
Timing:
Jan 05 2007 02:06:38

End
Timing:
Jan 05 2007 02:06:38

Module end 'setup'
Timing:
Jan 05 2007 02:06:38

End
Timing points:
Checkpoint
Elapsed
Rel. Elapsed
Memory
Rel. Memory
Script start
0.0000 sec
0.0569 sec
0.0000KB
0.0000KB
Module start 'setup'
0.0569 sec
0.7403 sec
0.0000KB
0.0000KB
End
0.7972 sec
0.0002 sec
0.0000KB
0.0000KB
Module end 'setup'
0.7974 sec
0.0983 sec
0.0000KB
0.0000KB
End
0.8957 sec

0.0000KB
0.0000KB
Total runtime:
1.0081 sec
Time accumulators:
Accumulator
Elapsed
Percent
Count
Average
ini_load
Load cache
0.0273 sec
2.6918%
5
0.0055 sec
FindInputFiles
0.0019 sec
0.1826%
5
0.0004 sec
Parse
0.0187 sec
1.8425%
2
0.0093 sec
Save Cache
0.0024 sec
0.2412%
2
0.0012 sec
Template Total
0.6258 sec
61.7%
6
0.1043 sec
Template load
0.1500 sec
14.7924%
6
0.0250 sec
Template parser: create text elements
0.0260 sec
2.5648%
14
0.0019 sec
Template parser: remove whitespace
0.0069 sec
0.6764%
14
0.0005 sec
Template parser: construct tree
0.1165 sec
11.4876%
14
0.0083 sec
Template load and register function
0.0038 sec
0.3745%
9
0.0004 sec
Template processing
0.4747 sec
46.8147%
6
0.0791 sec
override
Cache load
0.0756 sec
7.4598%
14
0.0054 sec
Matching rules
0.0005 sec
0.0496%
2
0.0003 sec
Mysql Total
Mysql_queries
0.0013 sec
0.1301%
4
0.0003 sec
Looping result
0.0001 sec
0.0107%
2
0.0001 sec
General
INI string conversion
0.0010 sec
0.1035%
4
0.0003 sec
String conversion
0.0006 sec
0.0636%
4
0.0002 sec
String conversion w/ mbstring
0.0002 sec
0.0240%
4
0.0001 sec
dbfile
0.0001 sec
0.0081%
1
0.0001 sec
Total script time:
1.0141 se

Friedrich Cubigsteltig

Friday 05 January 2007 6:15:26 am

A possible solution might be changing the code of the mysql database from utf-8-unicode to <b>utf-8-general</b>

Try it. For my installation it was an easy solution.

Regards

fricus

Claudia Kosny

Sunday 07 January 2007 5:11:51 am

Hi Anton

Unfortunately I can't help you there. I had a look at the setup process and it is to complex to see what's happening unless you want to spend a few hours on it (which I don't have right now).
I am not sure whether Friedrich's suggestion will help you as your debug output indicates that you use latin1 as character set, not utf8 (Why actually? Utf8 is really nice as you do not need to worry about any non-ASCII characters in the output...). If it does help you, please post it here.

The only workaround I see right now is to try whether installing eZ 3.8 works. Then run the upgrade scripts to get to eZ 3.9.
Or try to install eZ 3.9 on a different computer (maybe witha different OS) and then copy the whole folder to your target machine. The only things you need to change are the path to the var directory in the site.ini (usually the one in the settings/override folder) and the path to imagemagick (settings/override/image.ini). Delete the content of the var/cache and the var/<whatever you specified as var directory>/cache as this will need to be recreated with the new server settings. Import the database to your target machine (easily done with phpmyadmin).
Please note that using these workarounds might be a bad idea as the core problem is not solved. Thus you might run into unfixable errors later on.

Claudia

Clive Hunt

Monday 08 January 2007 1:11:35 am

quote

"A possible solution might be changing the code of the mysql database from utf-8-unicode to utf-8-general

Try it. For my installation it was an easy solution.

Regards

fricus "

How would I change the mysql database for utf-8-general in phpMyAdmin?

Thanks.

Anton de Waal

Monday 08 January 2007 2:19:52 am

Thanks everybody who offered advice, I tried everything but to no avail. So i hate to admit that I am giving up - it has already taken so much time I cannot afford to spend more time on it, although I believe it is a great script. I just did a hassle-free installation of phpwebsite and will now use it instead of ezp.Go well you friendly people!
Anton

Clive Hunt

Monday 08 January 2007 3:14:51 am

I've installed the previous version and that appears to work fine. I will try and run the upgrade script shortly to see if it will patch to the latest version.

Watch this space.

christian bencivenni

Tuesday 16 January 2007 11:06:34 pm

I have the same problem but I'm on host server so I cannot "change" it.
I'm also trying with firefox but without success.
Anyone have a solution?
For ezcrew: are you working on a patch for 3.9.1 version?
In other case I must change CMS :-(