Error: WordPress DataBase Error (3 posts)

  1. Lovetransit
    Posted 10 years ago #

    I've had WordPress install for about a month already, and this error appeared yesterday:

    WordPress database error: [Can't create/write to file '/tmp/#sql_9bf_0.MYI' (Errcode: 122)]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2005-04-24 20:42:59' AND (post_status = "publish") AND post_date >= '' GROUP BY wp_posts.ID ORDER BY post_date DESC

    This is where my wp is located at: http://lovetransit.net/wp

    I have no idea what went wrong. someone please help me! :(

  2. Mark (podz)
    Support Maven
    Posted 10 years ago #

    Email your host - that's an error they need to fix.

  3. Jonski
    Posted 9 years ago #

    The error is fixed by emptying the /tmp folder. Unfortunately mine is filling up every day with what seem to be wordpress cache files.

    WordPress database error: [Can't create/write to file '/tmp/#sql_65cd_0.MYI' (Errcode: 122)]

    /tmp fills up with files with names like...
    tmp4BkZcV tmp8VjgGm tmpCn3A5Z tmpHD9en3 tmpLatjxg tmpQ6apT5 tmpUWLtqx tmpZ0P8Nf tmpdVanrf tmpiCyvvC tmpmeazaC tmpr6TUGZ tmpvTFsts tmpzwEo2f
    tmp4CJbgQ tmp8W11C6 tmpCnRoSE

    and contents like...


    (WP 2.0.1)

Topic Closed

This topic has been closed to new replies.

About this Topic