Failed To Read Auto-Increment Value From Storage Engine – MySQL

Recently after my hosting provider hard-booted one of my machines the MySQL service started to complain “Failed To Read Auto-Increment Value From Storage Engine” when an insert was issued to any table with an auto increment field. I found the solution here, and it basically requires you to reset the auto increment key on the table, like this:

ALTER TABLE `table_name`  AUTO_INCREMENT =1

I had to do that on all of my tables that had auto increment keys to resolve the issue.

phpMyAdmin $cfg[‘Servers’][$i][‘tracking_version_auto_create’]

I found the configuration setting in the documentation that will force phpMyAdmin to automatically track tables during and after creation. It is:

 $cfg['Servers'][$i]['tracking_version_auto_create'] boolean

And the default value is ‘false’. I updated:

 /var/www/www.progclub.org/pcma/config.inc.php

With the line:

  // JE: 2011-09-07: force tracking
  $cfg['Servers'][$i]['tracking_version_auto_create'] = true;

Programmers’ Club

Due to my blatant SEO hacking ProgClub has finally made it to page 3 of search results for programmers’ club. Go team! :)

ProgClub aspires to be *the* Programmers’ Club. So first we get page 3, then we get page 1, then we get first result. Sound like a good plan?

You can help by blogging about ProgClub or linking to our Programmers’ Club page from your blog or your web-site. The text of your link should be “Programmers’ Club”, and you should link to the http://www.progclub.org/wiki/Programmers’_Club page.

p.s. We’re on page 2 for good programmers’ club and we’re on page 2 for the programmers’ club (page 1 in Australia: the programmers’ club).

p.p.s. I posted some more information on how I went about the SEO process.

p.p.p.s. I followed up with some more commentary about the best way to link to ProgClub.