search

ezcommunity / ezupgrade

GNU General Public License v2.0
10 stars 3 forks source link

Upgrading from 4.1.x and 4.2 to 4.5.0 have some database inconsistencies #11

Open jpingo opened 13 years ago

jpingo commented 13 years ago

When upgrading the mentioned versions i get the following database inconsistence , on the upgrade check tool:

ALTER TABLE ezm_pool ADD INDEX ezm_pool__block_id__ts_hidden ( block_id, ts_hidden );

This is happens after upgrading the extensions. In the Direct-upgrading-from-4.1-to-4.5 doc on doc.ez.no this command is run when upgrading the database (step 4), for the 4.1.x and 4.2.0 versions.

jheba commented 13 years ago

Hi,

Please note, that the command should be executed only if you run ezflow extension. Otherwise you don't have such table and mysql will complain with: ERROR 1146 (42S02): Table 'database.ezm_pool' doesn't exist. This info will be added to the doc you mentioned.

J.

cgjengedal commented 13 years ago

Is this a duplicate of issue #12? Maybe both this and issue #12 should be placed in issues.ez.no?

jpingo commented 13 years ago

Hi, This is issue is present after upgrading standard extensions (ezflow, in this case) Issue #12 is similar but the issues/warnings are present before upgrading the extensions

Best Regard's JP