minsim Posted December 21, 2014 Share Posted December 21, 2014 Please, presta people i need help My site shut down for 7 hrs now Nd i don't know what to do Please, tell me and fix it for me!, Link to comment Share on other sites More sharing options...
Oron Posted December 21, 2014 Share Posted December 21, 2014 Hello Change your title Argent_! Need HELP <PrestaShopDatabaseException> Argent_! = money or silber Read the forum rules please thanks Link to comment Share on other sites More sharing options...
tuk66 Posted December 21, 2014 Share Posted December 21, 2014 (edited) You database schema has changed, specifically ps_guest table. Make sure that the schema looks like: CREATE TABLE IF NOT EXISTS `ps_guest` ( `id_guest` int(10) unsigned NOT NULL AUTO_INCREMENT, .... Edited December 21, 2014 by tuk66 (see edit history) Link to comment Share on other sites More sharing options...
minsim Posted December 21, 2014 Author Share Posted December 21, 2014 Thank you Do you mean that i have to change this table to what you show me right? Link to comment Share on other sites More sharing options...
tuk66 Posted December 21, 2014 Share Posted December 21, 2014 You already have the id_guest AUTO_INCREMENT, so I don't understand what the message means. Learn more: http://stackoverflow.com/questions/7346934/mysql-failed-to-read-auto-increment-value-from-storage-engine http://stackoverflow.com/questions/17690926/failed-to-read-auto-increment-value-from-storage-engine-error-number-1467 http://serverfault.com/questions/273074/mysql-auto-increment-failing Link to comment Share on other sites More sharing options...
bellini13 Posted December 22, 2014 Share Posted December 22, 2014 i attempted to help. The problem is that the mysql database is Innodb and it got into a corrupted state. all the table indexes and auto_increment values are corrupt. If you try to perform an alter table command to reset the auto_increment value, it fails with a generic mysql error. If you try to create a new table with a new auto_increment value, it also fails. I advised that they should work with their host to fix this issue. The latest was that they should backup and restore the database and it 'should' fix the problem. However they did not say what the problem is. Also note, it is not just ps_guest table, it is all tables with an auto_increment column. In addition, all tables with an index (almost all of them). Waiting to hear back on the restore of the database to see if that fixed the issue. Link to comment Share on other sites More sharing options...
Dh42 Posted December 22, 2014 Share Posted December 22, 2014 Just curious, did you try to optimize the tables? Link to comment Share on other sites More sharing options...
bellini13 Posted December 22, 2014 Share Posted December 22, 2014 yea, didn't help. it is a vps server on inmotionhosting, and v4 of mysql server. honestly I have not experienced this issue before, even when working with InnoDB table structures. not sure if this is a bug in that particular version of mysql. the mysql service is down currently, so I imagine the hosting support is currently trying to resolve the issue. the last thing they said was to backup and restore the database, which they were instructed to do. being that the service is down 24 hours later, I imagine this did not work Link to comment Share on other sites More sharing options...
Recommended Posts