Upgrade 4.0.1 to 4.1.1

Author Message

Przemek Niemczuk

Wednesday 20 May 2009 7:44:47 am

Hi,

I can not find, but I know that somewhere I read once about this, that you can not upgrade directly from 4.0.1 to version 4.1.1 Is it true?

best regards

primo

primo

Gurudutt Verma

Saturday 23 May 2009 6:55:51 pm

Hi Przemek,

If you have any niceurl related issue then or say yes it is recommended to upgrade to latest version of eZ Publish 4.0.x (4.0.4 for now) first and then perform migration procedure (http://ez.no/doc/ez_publish/upgrading/upgrading_to_4_0/from_4_0_x_to_4_0_y) and then upgrade to 4.1.x

Przemek Niemczuk

Sunday 24 May 2009 2:11:38 pm


I did the update.
Currently I have version 4.1.1, but I can not log in after upgrading. My information is incorrect.

primo

Greg McAvoy-Jensen

Sunday 24 May 2009 3:59:15 pm

Can you get any debug messages to show? Have you confirmed your var directory permissions on the new install are ok?

Granite Horizon, Certified Developer of eZ Publish Web Solutions
Provider of the SaaS Solution Granite Horizon In The Cloud | http://granitehorizon.com/cloud
http://granitehorizon.com | +1 916 647 6350 | California USA | @granitegreg
Blog: http://granitehorizon.com/blog

Przemek Niemczuk

Sunday 24 May 2009 11:00:57 pm

At present, the detected errors:
- I can not login to either the panel or on the website Administrator
- I can not register

When I try to login I get an error:

Fatal error: A database transaction in eZ Publish failed.

The current execution was stopped to prevent further problems.
You should contact the System Administrator of this site with the information on this page.
The current transaction ID is TRANSID-58611a0a3993f7104a9bb7511d04e1f7 and has been logged.
Please include the transaction ID and the current URL when contacting the system administrator.

Fatal error: A database transaction in eZ Publish failed.

The current execution was stopped to prevent further problems.
You should contact the System Administrator of this site with the information on this page.
The current transaction ID is TRANSID-4a7011d5255a8eb324dfa4327e9c92dd and has been logged.
Please include the transaction ID and the current URL when contacting the system administrator.

primo

Przemek Niemczuk

Sunday 24 May 2009 11:18:11 pm

I see even in the logs this error:

Query error: Unknown column 'user_hash' in 'field list'. Query: INSERT INTO ezsession ( session_key, expiration_time, data, user_id, user_hash )
VALUES ( 'e01a8e82d5610b6ba5b19f08ed8c66b7', '1243479625', 'eZUserLoggedInID|i:10;eZUserInfoCache_Timestamp|i:1243220424;eZUserInfoCache|a:1:{i:10;a:5:{s:16:\"contentobject_id\";s:2:\"10\";s:5:\"login\";s:9:\"anonymous\";s:5:\"email\";s:12:\"nospam@ez.no\";s:13:\"password_hash\";s:32:\"4e6f6184135228ccd45f8233d72a0363\";s:18:\"password_hash_type\";s:1:\"2\";}}AccessArray|a:3:{s:7:\"content\";a:2:{s:4:\"read\";a:2:{s:5:\"p_657\";a:1:{s:7:\"Section\";a:1:{i:0;s:1:\"1\";}}s:5:\"p_662\";a:2:{s:5:\"Class\";a:7:{i:0;s:2:\"28\";i:1;s:2:\"29\";i:2;s:2:\"30\";i:3;s:2:\"31\";i:4;s:2:\"32\";i:5;s:2:\"33\";i:6;s:2:\"40\";}s:7:\"Section\";a:1:{i:0;s:1:\"3\";}}}s:3:\"pdf\";a:1:{s:5:\"p_658\";a:1:{s:7:\"Section\";a:1:{i:0;s:1:\"1\";}}}}s:3:\"rss\";a:1:{s:4:\"feed\";a:1:{s:1:\"*\";s:1:\"*\";}}s:4:\"user\";a:1:{s:5:\"login\";a:2:{s:5:\"p_660\";a:1:{s:10:\"SiteAccess\";a:1:{i:0;s:10:\"2576532274\";}}s:5:\"p_661\";a:1:{s:10:\"SiteAccess\";a:1:{i:0;s:9:\"231861081\";}}}}}AccessArrayTimestamp|i:1243220424;eZRoleIDList_Timestamp|i:1243220424;eZUserGroupsCache_Timestamp|i:1243220424;eZUserGroupsCache|a:2:{i:0;s:2:\"42\";i:1;s:1:\"4\";}eZRoleIDList|a:1:{i:0;s:1:\"1\";}eZRoleLimitationValueList_Timestamp|i:1243220424;eZRoleLimitationValueList|a:1:{i:0;s:0:\"\";}eZUserDiscountRulesTimestamp|i:1243220425;eZUserDiscountRules10|a:0:{}eZGlobalSection|a:1:{s:2:\"id\";s:1:\"1\";}LastAccessesURI|s:41:\"/Artykuly/Przemyslaw-Niemczuk/(offset)/20\";LastAccessedModifyingURI|s:41:\"/Artykuly/Przemyslaw-Niemczuk/(offset)/20\";', '10', '1a7e26421ac09d670e5731b7af119aa0' )
[ May 25 2009 05:08:20 ] [93.174.93.200] eZMySQLDB:
Query error: Unknown column 'user_hash' in 'field list'. Query: INSERT INTO ezsession ( session_key, expiration_time, data, user_id, user_hash )
VALUES ( 'a3d56d6a28e659f8bfcebf1711265951', '1243480100', 'eZUserLoggedInID|i:10;eZUserInfoCache_Timestamp|i:1243220899;eZUserInfoCache|a:1:{i:10;a:5:{s:16:\"contentobject_id\";s:2:\"10\";s:5:\"login\";s:9:\"anonymous\";s:5:\"email\";s:12:\"nospam@ez.no\";s:13:\"password_hash\";s:32:\"4e6f6184135228ccd45f8233d72a0363\";s:18:\"password_hash_type\";s:1:\"2\";}}AccessArray|a:3:{s:7:\"content\";a:2:{s:4:\"read\";a:2:{s:5:\"p_657\";a:1:{s:7:\"Section\";a:1:{i:0;s:1:\"1\";}}s:5:\"p_662\";a:2:{s:5:\"Class\";a:7:{i:0;s:2:\"28\";i:1;s:2:\"29\";i:2;s:2:\"30\";i:3;s:2:\"31\";i:4;s:2:\"32\";i:5;s:2:\"33\";i:6;s:2:\"40\";}s:7:\"Section\";a:1:{i:0;s:1:\"3\";}}}s:3:\"pdf\";a:1:{s:5:\"p_658\";a:1:{s:7:\"Section\";a:1:{i:0;s:1:\"1\";}}}}s:3:\"rss\";a:1:{s:4:\"feed\";a:1:{s:1:\"*\";s:1:\"*\";}}s:4:\"user\";a:1:{s:5:\"login\";a:2:{s:5:\"p_660\";a:1:{s:10:\"SiteAccess\";a:1:{i:0;s:10:\"2576532274\";}}s:5:\"p_661\";a:1:{s:10:\"SiteAccess\";a:1:{i:0;s:9:\"231861081\";}}}}}AccessArrayTimestamp|i:1243220900;eZRoleIDList_Timestamp|i:1243220900;eZUserGroupsCache_Timestamp|i:1243220900;eZUserGroupsCache|a:2:{i:0;s:2:\"42\";i:1;s:1:\"4\";}eZRoleIDList|a:1:{i:0;s:1:\"1\";}eZRoleLimitationValueList_Timestamp|i:1243220900;eZRoleLimitationValueList|a:1:{i:0;s:0:\"\";}eZUserDiscountRulesTimestamp|i:1243220900;eZUserDiscountRules10|a:0:{}eZGlobalSection|a:1:{s:2:\"id\";s:1:\"1\";}LastAccessesURI|s:11:\"/Slowniczek\";LastAccessedModifyingURI|s:11:\"/Slowniczek\";', '10', '3ba7ca53efa9f24e3a23cab4a71a7874' )
[ May 25 2009 05:08:43 ] [220.181.7.97] eZMySQLDB:

primo

Steven E. Bailey

Monday 25 May 2009 12:32:05 am

Two things are possible here I think - either the database upgrade script didn't get run or the entire database didn't get copied over. I'm going to guess it was first one though.

Check if the user_hash field is in the ezsession table - which should have been added with this:

update/database/mysql/4.1/dbupdate-4.0.0-to-4.1.0.sql :
ALTER TABLE ezsession ADD COLUMN user_hash VARCHAR( 32 ) NOT NULL;

If it doesn't exist then this file wasn't run or was only partially run.

Otherwise, I have had it happen that for whatever reason copying an updated database to a live server would hang silently and not copy the entire database. But that's easy to see too because then the ezsession table wouldn't be there at all.

Certified eZPublish developer
http://ez.no/certification/verify/396111

Available for ezpublish troubleshooting, hosting and custom extension development: http://www.leidentech.com

Gurudutt Verma

Monday 25 May 2009 4:22:02 am

While upgrading from eZ Publish 4.0.4 to eZ Publish 4.1.1

Have you updated your database with followings ?

update/database/mysql/4.1/dbupdate-4.0.0-to-4.1.0.sql
update/database/mysql/4.1/dbupdate-4.1.0-to-4.1.1.sql

Przemek Niemczuk

Monday 25 May 2009 7:20:16 am

Thank you very much for your help. Most of the errors removed. He remained, however, a dispute. The extensions I can not turn YouTube. An error pops up:

*

Class eZOOConverter in file extension/ezodf/modules/ezodf/ezooconverter.php is already defined in:
extension/ezodf/classes/ezooconverter.php (var/autoload/ezp_extension.php)
This class was not added to the autoload array.
*

Class eZOOGenerator in file extension/ezodf/modules/ezodf/ezoogenerator.php is already defined in:
extension/ezodf/classes/ezoogenerator.php (var/autoload/ezp_extension.php)
This class was not added to the autoload array.
*

Class eZOOImport in file extension/ezodf/modules/ezodf/ezooimport.php is already defined in:
extension/ezodf/classes/ezooimport.php (var/autoload/ezp_extension.php)
This class was not added to the autoload array.

primo

Steven E. Bailey

Monday 25 May 2009 10:20:11 am

Well, one of the changes in 4.1.1 is that it warns you when there is a conflict such as this - I suppose before, if a conflict like this existed it would just use the first one that was picked up in the autoload index.

In any event, the clean 4.1.1 install that I have doesn't have the extension/ezodf/modules/ezodf/ezooconverter.php file... which leads me to believe that you copied the old directory over the new directory - well, this is the reason why that isn't a good idea...

You can probably just move the ezodf extension and recopy the extension from the tarfile or whatever.

Then run the autogen script. I'm not sure what it would have to do with youtube though.

Certified eZPublish developer
http://ez.no/certification/verify/396111

Available for ezpublish troubleshooting, hosting and custom extension development: http://www.leidentech.com

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