4.1.13 Upgrade Error - Site down

[peter gariepy]

FYI:  I also opened a ticket with IP but thought I'd ask here as well:

Upgrading to 4.1.13 (routine upgrade)

Got the following error:

Got error 190 "Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine. You have to dump an" from storage engine MyISAM 
/home/forumsaaca/public_html/system/Db/Db.php::1524

Any clue whats up?

Peter

[Hex@gones]

Same for me

[Wayne B]

15 minutes ago, peter gariepy said:

FYI:  I also opened a ticket with IP but thought I'd ask here as well:

Upgrading to 4.1.13 (routine upgrade)

Got the following error:

Got error 190 "Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine. You have to dump an" from storage engine MyISAM 
/home/forumsaaca/public_html/system/Db/Db.php::1524

Any clue whats up?

Peter

I would advise raising a support ticket if your site is down.

[Elena-Viorica]

I got this error:

My site was down, my host restored a backup, I raised a support ticket and IPS is blaming my hosting server. My host support says that everything is fine. I can't upgrade and IPS won't help because "allegedly, it's not their problem".

[Rhett]

15 minutes ago, Elena-Viorica said:

I got this error:

My site was down, my host restored a backup, I raised a support ticket and IPS is blaming my hosting server. My host support says that everything is fine. I can't upgrade and IPS won't help because "allegedly, it's not their problem".

Your ticket has been re-opened and our team is looking into this further. 

 

Thank you 

[LinkMania]

Wow.. i am using mariadb (10.1.14) aswell.. i am glad i saw this topic before upgrading..

[luca3142001]

Also for me is there a problem during the upgrade. Now my site is down and i have open a ticket.

[luca3142001]

The assistance fix for me.Now all go ok

[ayuki]

similar error with mysql' "IPS\Db\Exception (1034) Index corrompu dans la table" same line in db.php( Db.php::1524 ) i open ticket

[iacas]

Ditto here. core_applications table is corrupted.

[iacas]

8 minutes ago, iacas said:

Ditto here. core_applications table is corrupted.

I was instructed to do this (MySQL) and it worked fine:

Quote

REPAIR TABLE core_applications USE_FRM;

[ProSkill]

I ran into a similar issue but my problem was with CMS_BLOCKS, after pulling my hair out for 2+ hours the solution was:

Run: REPAIR TABLE CMS_BLOCKS USE_FRM;

Run: REPAIR TABLE CORE_APPLICATIONS USE_FRM;

I also had a plugin called BackToTop which apparently broke during the upgrade so I had to uninstall it for my forum to come back online.

I am still working with support to determine if running USE_FRM on the two tables is going to be a problem.

[Elena-Viorica]

21 hours ago, Rhett said:

Your ticket has been re-opened and our team is looking into this further. 

 

Thank you 

Thank you for fixing it. 

[forumdev99]

Same thing happened to me just now..

Got error 190 "Incompatible key or row definition between the MariaDB .frm file and the information in the storage engine. You have to dump an" from storage engine MyISAM 
/home/mysite/public_html/system/Db/Db.php::1524

 

[forumdev99]

I ran this statement and it seems to have fixed it:

REPAIR TABLE mysitecms_blocks use_frm

Thanks for your help here guys.

[Kjell Iver Johansen]

18 hours ago, ProSkill said:

I also had a plugin called BackToTop which apparently broke during the upgrade so I had to uninstall it for my forum to come back online.

 

Did you disable it during upgrade?

[LinkMania]

Well, taking Marc's from Invision words in my ticket that everything is going to be okay with my mariadb i started the upgrade. 4 hours ago !

Still going, extremely painful for me. Before the upgrade i made sure mysqlcheck says its ok. Now i am drowning in:

ERROR 1034 (HY000): Incorrect key file for table 'ibf_core_log'; try to repair it

Extremely dissapointed of Invisionpower.

[Neej]

On 06/07/2016 at 0:44 PM, ProSkill said:

I ran into a similar issue but my problem was with CMS_BLOCKS, after pulling my hair out for 2+ hours the solution was:

Run: REPAIR TABLE CMS_BLOCKS USE_FRM;

Run: REPAIR TABLE CORE_APPLICATIONS USE_FRM;

I also had a plugin called BackToTop which apparently broke during the upgrade so I had to uninstall it for my forum to come back online.

I am still working with support to determine if running USE_FRM on the two tables is going to be a problem.

Did you see any errors relating to core_applications or you just ran that repair also because others have recommended?

I had the same issue as you which was cms_blocks, and I ran the repair for that and the IPS Installation seemed to go ahead fine. But now I am noticing strange errors on my website.

Wondering if I also need to do the core_applications repair?

[ZackL]

We're on MariaDB as well. No errors popped up whilst running the upgrader.

Try running the built-in MariaDB/MySQL check tool to check your databases for errors.

[sobrenome]

Fatal error: Call to undefined method IPS\cms\Databases::rebuildReciprocalLinkMaps() in /home/xxx/public_html/applications/cms/setup/upg_101034/upgrade.php on line 36

Site is down here also. Another upgrade error.