2.1.5 Error "Incorrect key file for table..."

Comments

• peregrine MVP

  November 2014 edited November 2014

  see

  http://stackoverflow.com/questions/11805793/incorrect-key-file-for-table-tmp-sql-3c51-0-myi-try-to-repair-it

  and google it. you might see other answers on mysql sites

  you could also use the stop autodraft plugin which might mitigate things perhaps.

  P.S. - thanks for voting here. really appreciate that you did that. bonus point for you. wish more people would follow in your footsteps instead of being apathetic.

  http://vanillaforums.org/discussion/28401/vanilla-awards-for-best-community-developed-plugin-theme-and-application

  I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  0
• peregrine MVP

  November 2014 edited November 2014

  also see:

  http://www.mysqlperformancetuning.com/a-fix-for-incorrect-key-file-for-table-mysql

  http://stackoverflow.com/questions/2011050/mysql-126-incorrect-key-file-for-table

  http://stackoverflow.com/questions/19003106/mysql-error-126-incorrect-key-file-for-table

  report back when you have a solution.

  I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  1
• MrCanadian ✭

  November 2014 edited November 2014

  @peregrine said:
  also see:

  http://www.mysqlperformancetuning.com/a-fix-for-incorrect-key-file-for-table-mysql

  http://stackoverflow.com/questions/2011050/mysql-126-incorrect-key-file-for-table

  http://stackoverflow.com/questions/19003106/mysql-error-126-incorrect-key-file-for-table

  report back when you have a solution.

  Thanks for the direction. I'll comb through those suggestions and see if I can muster a solution.

  [Addition:] I think I'll go with the deactivation of auto saving. Seems the simplest and prevents me from having to fiddle with a (very likely sensative) database. Thanks!

  0
• R_J Admin

  November 2014

  Generally I would favor solving a problem than ignoring the symptoms, but that's completely up to you.

  Here is an alternative to simply disabling drafts: http://vanillaforums.org/addon/localdrafts-plugin
  It replaces the standard Vanilla drafting mechanism with HTML5 local storage drafts.

  0
• peregrine MVP

  November 2014

  @MrCanadian

  as r_j says you have a problem, you might as well solve it, ask your host. and check if you have enough file space in tmpdir folders, etc.

  if i didn't see the other stack exchange comments, i was originally going to see try to run utility structure, then run phpmyadmin repair and optimize the tables.

  http://dev.mysql.com/doc/refman/5.0/en/temporary-files.html

  I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  0
• MrCanadian ✭

  November 2014

  I ultimately went with the "stop autodraft" plugin, and haven't seen the error since.

  Everything seems to be working smoothly now. Thanks for the great plug-in suggestion!

  2