URGENT: Error 122

  • Resolved subminimal

    (@subminimal)


    19 years, 4 months ago

    Alright so I host several sites on a dedicated server with the newest wordpress release installed. This morning, all the sites were running fine (one is in fact a personal journal, so its checked everyday) JUST now I recieved this error completely out of the blue on ALL WP sites I host:

    WordPress database error: [Got error 122 from table handler]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2005-07-28 21:16:59’ AND (post_status = “publish”) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10

    WordPress database error: [Got error 122 from table handler]
    SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM wp_posts WHERE post_date < ‘2005-07-28 14:16:53’ AND post_status = ‘publish’ GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC

    Same in the admin panel under posts, pages unaffected. I have searched high and low on this error to no avail, and my host assures me they have made no changes to either php or MySql, nor have I, and I cant find any reference to this error anywhere on the web.

    Any help would be greatly appreciated.

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

  • table handler errors are hosting matters – email their support.

    A quick Google search might help, too.

    Thread Starter subminimal

    (@subminimal)

    Wow I swear I searched google…lol. Just to resolve this issue for anyone else who gets it, the error does in fact mean that you simply ran out of disk space on your host. (With a little research I found out that my kid sister has spent the past three days uploading mpgs of our family dog to the blog I set up for…lesson learned…NEVER give family ftp access…9 GIGS??? LOL anyway thanks again for the google lead.

    Wow. Think of the bandwidth if anyone actually watches all of those. Three visitors plus her uploads and you’re at 36 gigs of bandwidth.

    friday

    (@friday)

    WordPress database error: [Got error 122 from table handler]
    SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id) WHERE 1=1 AND (category_id = 15) AND (post_date_gmt <= ‘2005-11-14 14:12:59’ AND id NOT IN (-1,43,44,45,46,47,48,52,57,58,59,61,62,63,64,65,66,70,71,73) ) AND (post_status = “publish” OR post_author = 1 AND post_status != ‘draft’ AND post_status != ‘static’) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 7
    ——————–
    That’s the error msg I got from my page. Even I can’t access my Cpanel, it told that:
    Sorry for the inconvience!
    The filesystem mounted at / on this server is running out of disk space. cPanel operation has been temporarily suspended to prevent something bad from happening. Please ask your system admin to remove any files not in use on that partition.
    ———————–
    I have installed a Gallery on a subdomain, and it’s still running well.
    Could somebody help me to solve this problem?!? I haven’t backed up my database yet!

    Moderator James Huff

    (@macmanx)

    “Please ask your system admin to remove any files not in use on that partition.”

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘URGENT: Error 122’ is closed to new replies.