Support » Fixing WordPress » Error: WordPress DataBase Error

  • 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! 🙁

Viewing 2 replies - 1 through 2 (of 2 total)
  • Email your host – that’s an error they need to fix.

    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…
    <?php
    //s:10:”ISO-8859-1″;
    ?>

    or
    <?php
    //s:4:”/uk/”;
    ?>

    (WP 2.0.1)

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Error: WordPress DataBase Error’ is closed to new replies.