Got error 12 from table handler

  • Resolved Nurice

    (@nurice)


    17 years, 6 months ago

    Upgraded to WP 2.3, had errors but managed to fix all but one type (see https://www.ads-software.com/support/topic/136400?replies=1)

    Still had this error in the custom fields area of write/post:

    WordPress database error: [Got error 12 from table handler]
    SELECT meta_key FROM wp_postmeta WHERE meta_key NOT LIKE ‘\_%’ GROUP BY meta_key ORDER BY meta_id DESC LIMIT 30

    Assumed it may have been there all along and I just missed it. But apparently not so, because when I started to post tonight (first time since upgrade) discovered another error 12 in category checkbox selection area of write/post:

    WordPress database error: [Got error 12 from table handler]
    SELECT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN (‘category’) AND tt.parent = ‘0’ ORDER BY t.name ASC

    I had written a post right before upgrading and the category selection check boxes were all intact then.

    I searched “error 12 from table handler” here:
    https://www.ads-software.com/search/error+12+from+table+handler?forums=1

    I do not think my problem is a host problem since it was not there until I updated to v.2.3.

    I deactivated all plugins, switched to default theme, deleted all wp folders and files by ftp (except those I am not supposed to delete) and ran the upgrade program again. It said no upgrade needed and my blog is back up.

    But the error 12 remains.

    Thanks for any help,
    Lois

Viewing 3 replies - 1 through 3 (of 3 total)

  • I do not think my problem is a host problem…

    To be honest, it doesn’t really matter what you think. It is a host problem.

    Thread Starter Nurice

    (@nurice)

    Ok, I’ll accept that. It doesn’t make sense to me since the previous version worked fine, but I am sure you folks know more than I do about it. I am going to contact my web hosting company.

    After I wrote here (before moshu’s response), I finally decided to delete my database and restored my old pre-2.3 database to see if that would help. I replaced 2.3 (by ftp) with the previous version of wp and deleted all plugins except askimet replaced with correct askimet. I deleted all database files and the restore ran great. Then I ran the upgrade program and my blog worked perfectly. No error 12. But…

    After inactivating plugins and upgrading to wp 2.3 again, the old error 12 is back.

    I looked up the error 12 on google and found a couple posts indicating error 12 is a server memory error (yes, you folks are right as usual…it is a server error). See:
    https://www.vbulletin.com/forum/showthread.php?t=118580.

    Does version 2.3 require more memory than previous versions?

    The restoration was much easier than I expected, and since I had a good backup it worked perfectly, and I learned a lot from it!

    Lois

    Thread Starter Nurice

    (@nurice)

    Just an update here and to close this as resolved:

    I started over with everything using my old WP version and database back up, then upgraded that again to 2.3. I deleted some meta tags I’d put in using an old custom fields program which I’d abandoned long ago. This cleared up the first error 12 above regarding meta tags.

    After this the error came back in categories. My hosting provider moved me to a new server with more memory. I’m not sure if that solved anything, as there were errors that would not permit it all to move. So I deleted what was in the new server database and started with my backup again and repeated steps in first paragraph of this comment.

    Then I double checked that I had the latest verions of google sitemaps plugin. I discovered that the latest version I’d downloaded in prep for 2.3 was no longer the latest…It was the version just previous to v. 3.0. I upgraded to that. My guess is that was a big part of the reason I had so many problems.

    I was using an old theme that I’d hacked to keep it updated, and it had seemed to work, but rather than take a chance, I got a new theme from the compatible with 2.3 list.

    Everything seems to be working well now. I’ll close this as resolved.

    Lois

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Got error 12 from table handler’ is closed to new replies.

Tags