ez3.9 on php 5

Author Message

Erland Flaten

Friday 15 June 2007 10:13:32 am

I would like to try out EZ Publish on PHP5 on OS X.

Installation with the setup wizard worked almost.

My system can be read at:
http://www.nuna.no/sitereginfo.txt

First I created a databse with the MySQL Administrator tool. This database couldent be used because the setupwiz said it had to be a UTF-8 one. I cant find a way with the MySQL Administrator to make the database be a UTF-8. So I tried with phpmyadmin which worked and it made the database according to this SQL instructions.

" CREATE DATABASE `ez` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; "

When the setupwizard started up I got:
«Missed some directories
eZ publish cannot create some important directories, without this the setup cannot finish and parts of eZ publish will fail.
The nonexistent directories are: var/cache/codepages var/cache/content var/cache/ini var/cache/override var/cache/template var/cache/template/process var/cache/template/tree var/cache/texttoimage var/cache/translation var/log var/storage/original var/storage/reference var/storage/variations »

Then I got the permission error one the newly added folders and had to re-run:

chmod -R ug+rwx (worked)
chown -R www:www (dident work)

so I did:
chmod -R a+rwx (worked)

Then the setupwiz worked nice some pages ahead.

After clicking "next" on the «Site Registration» page, the setupwizard just stops. It is 92% finished. The browser stops after 3-4 minutes asking what to do with a index.php file. I download the file and it is blank.

When I click Next another time The wizard says:
* EZSW-004Failed inserting data to mysql
Table 'ezapprove_items' already exists
* EZSW-040Failed to initialize site package 'ezwebin_site'

If I try to go to the site URL ( http://macerland.local/ez39/index.php/ezwebin_site)
it starts up the setup process from start.

If you need more information to help me on this, please ask. Thanks for any help.

-- Erland

Erland Flaten
Lilllehammer, Norway

André R.

Friday 15 June 2007 11:44:15 am

What is your environment? ( is php a apache modul or running in fastcgi?)
I guess you are using the php5 community port? http://pubsvn.ez.no/nextgen_php5
Why have you choosen to install nor-NO as both primary and secondary language ?

Try to install with eng-GB as primary and nor-No as secondary.

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Erland Flaten

Friday 15 June 2007 3:27:43 pm

The installed PHP is a php module. Its the one from this site:
http://www.entropy.ch/software/macosx/php/

Communityport? Yes its http://pubsvn.ez.no/nextgen_php5/stable/3.9/

Why nor-NO all over ..good question. A mistake. I will try eng as primary and Norwegian as secondary next.

Erland Flaten
Lilllehammer, Norway

Erland Flaten

Friday 15 June 2007 4:25:11 pm

I have now run the setupwizard again with increasing memory_limit to 256M and max_execution_time to 340 seconds. (was 12meg and 60 sec)

I also selcted eng. as primary lanuage and norwegian as secondary.

The setupwiz says:

Creating sites
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.

If I delete the table ezapprove_items setupwiz says the table ezbasket is there. When I delete that and ezapprove_items is back again the database.

Erland Flaten
Lilllehammer, Norway

André R.

Friday 15 June 2007 4:33:04 pm

Create a new empty db / cleare the one tou are using.
It's corrupted anyway since it stopped half way the first time.
btw 12mb is to little to, so might have been that causing you trouble also. Even though eZ Publish will force it up to 42 if it is beneath that.

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Erland Flaten

Friday 15 June 2007 5:17:59 pm

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

I created a new database and but it doesent help.

There are 103 tables and 8173 rows if that matter.

thanks for helping with this man !

Erland Flaten
Lilllehammer, Norway

André R.

Saturday 16 June 2007 11:23:05 am

http://ez.no/content/advancedsearch?&SearchText=EZSW-004Failed&SubTreeArray%5B%5D=2

This might give you some hints. Like: What table type are you using, if it's mysql5 turn of strict mode, are you using the correct mysql credentials and so on..

eZ Online Editor 5: http://projects.ez.no/ezoe || eZJSCore (Ajax): http://projects.ez.no/ezjscore || eZ Publish EE http://ez.no/eZPublish/eZ-Publish-Enterprise-Subscription
@: http://twitter.com/andrerom

Erland Flaten

Saturday 16 June 2007 4:47:45 pm

hmm. This is difficult for me.

I can understand that there might be some kind of settings that are preferd of the mysql, but I should like to know <b>which</b> settings and especially which settings apart from the default settings. Then I could probably change those with phpmyadmin or MySQL Administrator.

The best would have been, of cource, that the wizard worked and I could focus on using ez and not to install it. I have a feeling that the instal instructions mus be more specific. Yes, I know this is a beta or worse, but I cant use anything but php5

I cant find any settings recuirement for mysql. Are they diffrent from the default ( as installed)?

Erland Flaten
Lilllehammer, Norway

Kristof Coomans

Sunday 17 June 2007 12:50:42 am

Hi Erland

Can you tell me which revision of the PHP 5 port you are using? And which site package are you installing? Did you try with plain too?

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

Erland Flaten

Sunday 17 June 2007 4:53:20 am

Its 5.2.2 Here's a copy of the infopage: http://www.nuna.no/phpinfo.html

I only tried the site package Website Interface (ver. 1.2-0)

Just tried the plain site pacage and the setup is now finished :)

Would be nice with other sitepackages aswell. Is there anything with the mysql settings or maybe its an error not on my side.

Thanks Kristof and André for helping me up with this.

Erland Flaten
Lilllehammer, Norway

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.