WordPress.org

Ready to get started?Download WordPress

Forums

Error: WordPress DataBase Error (3 posts)

  1. Lovetransit
    Member
    Posted 9 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 9 years ago #

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

  3. Jonski
    Member
    Posted 8 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...
    <?php
    //s:10:"ISO-8859-1";
    ?>

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

    (WP 2.0.1)

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags