spxtools Posted March 18, 2014 Share Posted March 18, 2014 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/joomla30MySQL Database : spxtools_joom130MySQL DB User : spxtools_joom130 Quote Link to comment Share on other sites More sharing options...
wolstech Posted March 19, 2014 Share Posted March 19, 2014 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/ Quote Link to comment Share on other sites More sharing options...
spxtools Posted March 20, 2014 Author Share Posted March 20, 2014 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. Quote Link to comment Share on other sites More sharing options...
wolstech Posted March 20, 2014 Share Posted March 20, 2014 Yep. That's the solution many of us are using to convert our tables. Good to hear it's working for you now Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.