[Solved] Error -1 From Storage Engine

[spxtools]

Hello,

when i access onlinesprixtools.heliohost.org i get Sql errors: may be the user lost its privileges on database.

In phpmyadmin when I try modifying an existing db table I am getting "Error -1 from Storage Engine". On new tables I can insert/delete.

I deleted and then reinserted db user, assigning all privileges on db and I checked/modified configuration.php (as found on forum) with no results.

I executed a script update in the hope it could fix it, but i fear the situation is even worse ...

I thank you in advance.

Regards.

details of installation:

URL : http://www.onlinesprixtools.heliohost.org/joomla30

MySQL Database : spxtools_joom130

MySQL DB User : spxtools_joom130

[wolstech]

InnoDB is broken on Stevie. Use MyISAM tables instead, or wait until the issue is fixed. You are one of many that is affected by this issue.

 

See http://www.helionet.org/index/topic/18427-stevie-mysql-issues/

[spxtools]

Solved.

Exported database to .sql file, changed 'ENGINE=InnoDB' to 'ENGINE=MyISAM', created new database, added existing database user with full priviledges and populated new database by importing .sql file. Finally changed configuration.php for new database name. The site appears to be running. Deleted old database.

Thanks. Regards.

[wolstech]

Yep. That's the solution many of us are using to convert our tables.

 

Good to hear it's working for you now