This site has been archived and you can no longer log in or post new messages. For up-to-date community resources please visit ezplatform.com

eZ Community » Forums » Install & configuration » Create site problem
expandshrink

Create site problem

Create site problem

Tuesday 26 May 2015 6:55:47 pm - 11 replies

Dear all,

i am not an expert to ez publish, but i try to install in my localhost. I am using Windows XAMPP with PHP Version 5.5.15 and i try to install the ezpublish_community_project-2011.5-with_ezc. So i downloaded packages from the repository http://packages.ez.no/ezpublish/4.5/4.5.0/ and make all the steps according to this tutorial https://www.siteground.com/tutorials/ezpublish/ezpublish_installation.htm In the final step, i am getting this error

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

i don't understand because, during the process, the system create the database, and try to recreate, according var\log\error.log (i enabled the debug) i have these

[ May 26 2015 18:10:16 ] [::1] eZModuleOperationInfo::execute:
No call method defined for operation 'publish' in module 'content'
[ May 26 2015 18:10:25 ] [::1] eZMySQLiDB:
Query error (1050): 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 )
)
[ May 26 2015 18:10:25 ] [::1] :
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 )
)
[ May 26 2015 18:17:03 ] [::1] eZModuleOperationInfo::execute:
No call method defined for operation 'publish' in module 'content'
[ May 26 2015 18:17:26 ] [::1] eZMySQLiDB:
Query error (1050): 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 )
)
[ May 26 2015 18:17:26 ] [::1] :
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 )
)
[ May 26 2015 18:23:24 ] [::1] eZModuleOperationInfo::execute:
No call method defined for operation 'publish' in module 'content'
[ May 26 2015 18:24:44 ] [::1] eZMySQLiDB:
Query error (1050): 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 )
)
[ May 26 2015 18:24:44 ] [::1] :
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 )
)
[ May 26 2015 18:24:58 ] [::1] eZMySQLiDB:
Query error (1050): 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 )
)
[ May 26 2015 18:24:58 ] [::1] :
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 )
)

and for a previus discussion http://share.ez.no/forums/install-configuration/setup-wizard-unable-to-complete-the-site-creation i didn't understand the solution.

Also, i would like to inform you, that in order to upload the packages, i make changes according to this http://share.ez.no/forums/install-configuration/ez-4.7-installation-package-step-problem

My database is in utf8_general_ci .

Please, could somebody to help me to find a solution ?

Kind Regards

Apostolos

Tuesday 26 May 2015 10:30:37 pm

Hello Apostolos,

A similar problem was reported by another user recently, his issues were very 'similar' to your own.

http://stackoverflow.com/question...site-package-error/30433326#30433326

The above link is the right answer to be in order to be very clear and unique I will answer further here.

In short, your using the wrong WAMP server (Xampp, which does not provide the required php module and version support) and your incorrectly using the wrong version of eZ Publish (terrible old version of the eZ Publish community build) with the wrong version of PHP.

You just happen to also be using win32 host which makes things more complicated and error prone as win32 support has alway been a problem with eZ.

You would be better served using a current Debian GNU/Linux OS within a VirtualBox vm when working on a win32 host with eZ Publish. Installing and using eZ Publish on GNU/Linux is drastically simpler and easier than fighting everything wrong with PHP apps on win32 host OSs*.

If you refuse to use a vm then your best bet to solving these problems is to uninstall Xampp which is already known to not provide the required PHP features by default that eZ Publish requires (Xampp also is very hard to install the required missing features (almost impossible for newbie users)) and instead use / install the latest release of BitNami (which is well supported, tested and provides nearly everything needed by default): 

https://bitnami.com/redirect/to/47507/bitnami-ezpublish-2014.11-0-windows-installer.exe

https://bitnami.com/stack/ezpublish/installer

Bitnami (for windows and macos) has been specifically created and tested to support eZ Publish's requirements and is the best solution for newbie users on these platforms.

Bitnami also provides (by default) the version of eZ Publish which is compatible with the version of PHP it provides (PHP 5.4.35 + eZ Publish Community Build 2014.11).

Also worth pointing out that because your incorrectly using a deprecated community build (2011.5) the patch you report as required (for win32 hosts) has already been long ago solved and merged in the latest release of eZ Publish 5.x Community Build.

Also worth noting is that even if you are trying to use a specific (unsupported) version of eZ Publish incorrectly with the wrong version of PHP (which is not going work correctly) because your client production website uses it (aka you might insist that the client requires it when in fact they absolutely do not) (also the same as the stackoverflow question user's situation requires) you must not continue to use the old version of eZ Publish (specifically with new versions of PHP, because it will fail to function in many ways you can not begin to compensate for).

The related client website production assets (var dir, db, settings, designs, extensions*) (ie: internals, not the install as a whole) can be used, modified, tested and changes from within the internals can all be tested within / using the 2014.11 build required to be used by the current low rev stable PHP version (5.4.x) provided by Bitnami.

I hope this helps!

Cheers,
Heath 

Wednesday 27 May 2015 6:09:10 pm

Hi Heath, first of all i would like to thank your for your response, i downloaded the

https://bitnami.com/redirect/to/47507/bitnami-ezpublish-2014.11-0-windows-installer.exe

as you suggested and it worked properly.

To be honest, my goald is to migrate the content of an ez site version 4.6. For this site, i have only the database, it's any way to show the menus and the articles of the old site ? I attempted to delete the bitnami_ezpublish database, which i installed for the bitnami-ezpublish, and used the old database as the bitnami-ezpublish and this attempt had no success. So, it's any way to view my old content (menus and associated articles) in the new site (new site mean, that i installed from bitnami.com) ?

 

Kind Regards

Apostolos

 

Wednesday 27 May 2015 9:47:22 pm

Hello Apostolos,

Your very welcome. I'm happy to help!

I think what you wish to do is completely possible.

When you say you 'had no success' could you please be much more specific, detailed and descriptive (verbose) so that we can even begin to attempt to help you reach your goal. What exactly did you do? What exactly did not work? What were the exact error messages? Etc ...

In general (normally) switching code bases (from old site) to even a fresh install of eZ (using your old but upgraded db) should just -work- (give or take a few ini settings changes).

Now the menus are another issue. Menus are traditionally both content and template driven. So you might have to refactor the menu templates (within a new custom design extension) to get the feature implementation (design, functionality, etc) you desire / prefer. That said the content / db is not the real problem, that is designed to be portable (within the context of what you are trying to do and even beyond).

Remember the more detail you provide and the faster you respond the quicker we can help you get up and running quickly.

Edit: In order to save more time I am making this quick edit to say the following. If your trying to use an existing older db from another install from an older version of eZ Publish (you mention 4.6) please remember you must make an extra backup of your existing old db ( via oldsite_db.sql.tar.gz backup ) and then upgrade the old site db loaded into the new bitnami database name (in the db server).

Here is some documentation in general on how that's done (including the db): https://doc.ez.no/eZ-Publish/Upgrading

But if your only upgrading the db itself. Here is a pro tip hint, don't read the documentation link I shared till later if at all (till you need it / have true time to dedicate to reading and learning everything it offers, it will take some time to learn it the right way). Because in truth you don't need to know anything to upgrade a db except this ... go through every major version upgrade sql file in order from 4.6 -to- 4.7 (and beyond) one at a time and run them (source /path/to/sql file) in the mysql cli program (interactive mode).

You will start in this directory in general (if you are using mysql for your db): https://github.com/ezsystems/ezpublish-legacy/tree/master/update/database/mysql 

Then you will go into this directory: https://github.com/ezsystems/ezpublish-legacy/tree/master/update/database/mysql/4.6

Then you will source this sql file first (assuming your old site version was 4.6 but not greater than or equal to 4.7): https://github.com/ezsystems/ezpublish-legacy/blob/master/update/database/mysql/4.6/dbupdate-4.5.0-to-4.6.0.sql

Notice that I'm telling you to run the current old site version sql upgrade. This is a best practice that hurts nothing and helps protect you if for any reason the last required sql upgrade was not completed or was missed (rare but i've seen it so many times with existing old site dbs that I do this by default just in case, but only with the current version sql, if other older sql upgrades were missed well that ends up being best manually solved anyway).

Next you will source https://github.com/ezsystems/ezpublish-legacy/blob/master/update/database/mysql/4.7/dbupdate-4.6.0-to-4.7.0.sql

Remember to source the sql files that came with your 2014.11 install of ez and not github too btw (non issue but best practice).

I find it helpful to cd into /path/to/ezp2014.11/ezpublish_legacy/; and run this command: 

find ./update/database/mysql -name "dbupdate*" | grep "4.6.0\|4.7.0\|5.0.0\|5.1.0\|5.2.0\|5.3.0\|5.4.0"| grep -v "cluster\|unstable\|postgresql";

which on GNU/Linux systems will display only the exact sql files you will need to run to upgrade your database to be able to be used with a 2014.11 code base / default installation. Edit: I just remembered your on windows so you might need to use a different command without cigwin bash shell like win32 equivelent to this command. I used this command because I can copy and paste the file paths into mysql terminal source commands and do the upgrade faster that way. You can do this with manual typing and not the above command.

Once the above has been done. You should have no problems using the admin siteaccess of your 2014.11 install with your newly upgraded old site db (provided the install db ini settings for db name, host, db user and db password are correct). If you want / need / have time later, you should read the 4.5 through 5.4 upgrade documentation and run the coresponding database specific (content) cli upgrade scripts (though many are basically optional / not technically required*). 

I hope this helps!

Cheers,
Heath

Modified on Thursday 28 May 2015 8:57:09 am by // Heath

Thursday 28 May 2015 7:09:02 am

Hi,

once again thank you for your help,

to take things for the start, i am in windows enviroment, so i installed the bitnami-ezpublish. I have a database for an ez site, in this old database i see in the table ezsite_data the value '4.7.0beta1' in the ezpublish-version field. My first attempt (to be more clarify) was to delete bitnami_ezpublish, which i installed with the rest of ez demo site, in phpmyadmin, and then i created a new and empty bitnami_ezpublish and imported the data from the db, which i have already (the old i mean). It had not worked, the site opened fine, but i didn't see the content. In the bitnami version i see in in the table ezsite_data the value '5.4.0alpha1' in the ezpublish-version field, and if i understand right, i should try to update the database from 4.7.0beta1' to 5.4.0alpha1 and i assume that these 2 versions have differnses in their db structures, i am right? I tried to change this field and setted the value 5.4.0alpha1, but no result.

I think now i have be more specific of what i try to do.

I tried also to run this query

https://github.com/ezsystems/ezpublish-legacy/blob/master/update/database/mysql/4.6/dbupdate-4.5.0-to-4.6.0.sql but no result.

In the error log i found that

Extension 'ezcommentsbundle' does not exist, looked for directory 'extension/ezcommentsbundle' and i assume that the old site needed this extension and it is stored in database.

I am not familiar with ez publish, so i try things for start and you are my only hope.

Kind Regards

Apostolos

Thursday 28 May 2015 9:29:29 am

Hello Apostolos,

Your very welcome. I'm happy to continue to help you!

OMG, LOL. I've become the Obi Wan Kenobi of the eZ Publish Community!When all this time I wanted to be a 'web' Yoda big-smile.gif Emoticon (re: Jedi / Star Wars expanded universe lore / history / mythos surrounding the Obi Wan Kenobi character's life / events)

First, I must say that changing the version value is not how you upgrade eZ Publish and absolutely will not work.

Second, mysql can not fetch the upgrade sql file via url (to my knowledge) and certainly not how your doing it (the url you say you used is not the raw file url so it certainly would not work). You need to source the sql upgrade files on your local disk instead.

Convert your database to utf8

This step may not be required but it won't hurt you to do either.

I will skip instructions on exactly how to do this since it's mysql specific and there are already thousands of example guides / documentation on the web showing you how to do this.

Though I recommend the process described by this link in general: 

https://www.a2hosting.com/kb/developer-corner/mysql/convert-mysql-database-utf-8#Convert-the-character-encoding-set-to-UTF-8

PS. You would need to skip the hosting service specific instructions (which could confuse / distract you).

EDIT: I just realized that the above instruction link is bash / linux / unix specific and your on windows. You would prolly need to use another implementation but the process they show (actual changes) are still the best I could find in seconds of searching, plus i like this hosting company (Disclaimer: I used to host ezecosystem.org alphas with them while still in development) big-smile.gif Emoticon

Next ...

Upgrading your existing DB

You must run the following sql commands to upgrade your old db.

Warning! You must run each of the following commands *one at a time* and after the completion of each command copy and paste the *entire* the output from mysql terminal app into a separate text file. This step is required because you *must* review the output of each of these commands for any errors or other problems ... otherwise you could have upgrade related problems (sooner or later).

Remember you must run the following commands from within your ezpublish_legacy root directory (or use absolute file paths). So first change directory to /path/to/ezpublishfolder/ezpublish_legacy. Then launch mysql cli client connection to your database (from within the ezpublish_legacy directory) and run the following commnads. I just realized that if you use any other mysql client besides the cli then you *must* replace the following sql file paths with the *absolute* path to the sql files!

source ./UPDATE/DATABASE/mysql/4.6/dbupdate-4.5.0-to-4.6.0.sql;
 
source ./UPDATE/DATABASE/mysql/4.7/dbupdate-4.6.0-to-4.7.0.sql;
 
source ./UPDATE/DATABASE/mysql/5.0/dbupdate-4.7.0-to-5.0.0.sql;
 
source ./UPDATE/DATABASE/mysql/5.1/dbupdate-5.0.0-to-5.1.0.sql;
 
source ./UPDATE/DATABASE/mysql/5.2/dbupdate-5.1.0-to-5.2.0.sql;
 
source ./UPDATE/DATABASE/mysql/5.3/dbupdate-5.2.0-to-5.3.0.sql;
 
source ./UPDATE/DATABASE/mysql/5.4/dbupdate-5.3.0-to-5.4.0.sql;

Missing extension issues

Regarding the extension 'ezcommentsbundle' does not exist errors / warnings.

You can disable this extension in your 'settings/override/site.ini.append.php' settings by commenting out the 'ActiveExtensions[]=ezcommentsbundle' line with the '#' character.

I recommend disabling this extension since your old site install code did not use it since it was only introduced into much later 5.x releases, you don't need it and almost all / most users don't need or use this extension anyway (my boss says that separating comments from the eZ Publish content model is almost always just not needed or the best decision overall).  

Then clear all caches (specifically ini caches at the very least).

Moving forward

That should help you get to the next step .. being able to login to the admin.

After that you'll certainly have to address other issues as well depending on your specific use case needs.

The next issue you'll encounter is that anonymous / other user role policy permissions for 'user/login' contain your (user, at least) siteaccess name stored within the database and you will have to edit the 'Anonymous' Role Policy for 'user/login' to use the default installation user siteaccess name ... or else until you make this admin based change you will not be able to view content within the user siteaccess without having to login first. Re: Content / User permissions 

I hope this helps!

Cheers,
Heath

Modified on Thursday 28 May 2015 9:49:46 am by // Heath

Thursday 28 May 2015 10:53:28 am

Hi, 

realy it would be honor to me, if you consider me as Anakin Skywalker, but you can explain me, what do you think as dark side, Joomla, Drupal or WordPress ? (i am also Star Wars fan). You can follow the famus Yoda quote "Do. Or do not. There is no try." it's helpfull.

So, i found there https://github.com/ezsystems/ezpublish-legacy/tree/master/update/database/mysql the sql commands you suggest me (am i right ?). I will do (not try) your instructions at 18:30 (greek time) and i keep you posted. Can i ask (excuse me if my question would be dumm), about the template ? i mean the old site probaly had a specific template, the template are stored in the db ? Would be a problem ?

Kind Regards

Apostolos

Thursday 28 May 2015 11:21:32 am

Hello Apostolos,

LOL, now your going to get me into 'real' trouble talking about other cms / frameworks aka the other guys blunk.gif Emoticon

I try not to negatively judge the other projects. I like free software / open communities, different tools and different solutions. Think Different blunk.gif Emoticon Let's all work together, help each other, create amazingly good things that positively change lives worldwide for the betterment of all mankind! I really feel this way.

That said, I used to respect the sheer amount of free plugins for Joomla even though I do not like (at all) their cms implementation and poor community plugin code quality. I also recently hear rumblings in their community regarding growing negative outlook for their future. I do like that joomla started as a GPLv2 (required) fork of a dual licensed project (anyone even remember the name mambo anymore?). I think this because they are limited in only being able to distribute their legacy cms under a free software license which I think has helped their community in many ways (while other cms who started with clean copyright can dual license; re: trade offs).

I've not used Drupal much, I love their community activity in a lot of ways, sometimes I borrow ideas from them for implementations (but never code directly). That said I am not a fan of their code base implementation for a cms. I strongly think eZ has been doing it better since before they even existed.

As for Wordpress, I love that it's free software, hate it's code and software design with a passion, love it's large community of free software plugins for nearly anything, love it's auto update features in more current versions and secretly (not any more since I'm sharing too much private info) wish eZ could have the same huge installation base an name recognition. PS. I really really hate the Wordpress code implementation, it's disgusting to look at and worse to work with. big-smile.gif Emoticon I'd create a blog in eZ faster and better than anything even or ever possible in Wordpress any day over willingly choosing to use that monster.

Good luck with your db upgrade! Let us know how things go with the db upgrade.

Please realize that templates (default or custom) are *NOT* stored within the database. Unless you have access or can get access to the old site templates you will have to re-implement them (as required / desired). This could be a problem depending on your project's specific requirements / needs and or the time you have to do the work required / desired. Without more information it's hard to say it's a serious problem since I write templates all day, every day for years and for me, it's no problem at all, it would merely be an additional requirement of additional time to re-implement the required templates, custom functionality, custom features and website design from scratch.

Best wishes

Cheers,
Heath

Thursday 28 May 2015 6:48:13 pm

Hi Obi Wan,

i hope, that you are good. So my database was alredy in utf8 (the collation), the content is in greek.

Also, i followed the queries from https://github.com/ezsystems/ezpublish-legacy/tree/47c69cd900ed1ff9e170cb5bd8c53c91407dd648/update/database/mysql and delete the contents of C:\Bitnami\ezpublish-2014.11-0\apps\ezpublish\htdocs\ezpublish_legacy\var\ezdemo_site\cash\

I see a small amout of the content, but not all. I think is a start but, i feel disappointed. Can you assume what could be wrong ?

You are my only hope to this dedlock.

I remean at your disposal.

Kind Regards

Apostolos

Thursday 28 May 2015 9:32:34 pm

Hi again, i managed to see my content in the administration area, 

so now i can categorize my content and present it to my client. It would be a litle tricky, but it would be do.

Kind Regards

Apostolos

Friday 29 May 2015 12:11:33 am

Hello Apostolos,

I'm pleased you were able to make some additional progress while I was away this afternoon!

You might want to also clear global caches in var/cache/* directory.

Remember that when working on the site locally (especially getting started) it would be a good idea to enable DebugOutput (for both user and admin siteacceses; ie globally) to ensure that you can see any errors that might occur but not trigger a fatal server error (blank page, etc).

I wish you the best of luck with your project development.

Cheers,
Heath

Modified on Friday 29 May 2015 12:11:50 am by // Heath

Monday 01 June 2015 11:12:05 am

Hello Apostolos,

I have some closing requests ... 

1) Can you login to share.ez.no and then click the checkbox at the top of your original post near the title? It is the box with the checkbox inside. It turns green when you have clicked it correctly.

Doing this indicates your question has been solved.

2) I have updated (edited) my answer (on StackOverflow) to provide closure to the question you posted there. Would you please login to stackoverflow.com and mark the my answer as the 'right answer' so that the question can be properly closed since I have more than correctly determined the true cause of the problem you were having in the question. http://stackoverflow.com/question...site-package-error/30433326#30433326

Thanks again for your continued support!

Take it eZ!

Cheers,
Heath

expandshrink

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu

Proudly Developed with from