Database errors, editing threads, deleting posts...

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • HHU
    Member
    • Sep 2005
    • 56

    Database errors, editing threads, deleting posts...

    Getting these two database errors when editing thread title, or deleting posts... not sure if theres more for anything else... Boards been running fine for a few weeks since upgrading... and still is running fine... The first is from editing a thread, the second from deleting a post... also it does make the changes

    PHP Code:
    Database error in vBulletin 3.5.5:

    Invalid SQL:

            
    SELECT thread.*
            
    FROM thread AS thread
            WHERE forumid 
    AND
                
    visible AND
                
    open <> 10
                
    AND thread.postuserid NOT IN (3066,3068)
            
    ORDER BY lastpost DESC
            LIMIT 1
    ;

    MySQL Error  Error writing file '/tmp/MYRcz8qq' (Errcode28)
    Error Number 3
    Date         
    SundaySeptember 24th 2006 01:50:09 PM
    Script       
    http://*****/postings.php
    Referrer     http://*****/postings.php
    IP Address   
    Username     
    Classname    vb_database 
    That came when I was trying to edit a thread....

    And this came out from physically deleting a post:

    PHP Code:
    Database error in vBulletin 3.5.5:

    Invalid SQL:

            
    SELECT thread.*
            
    FROM thread AS thread
            WHERE forumid 
    AND
                
    visible AND
                
    open <> 10
                
    AND thread.postuserid NOT IN (3066,3068)
            
    ORDER BY lastpost DESC
            LIMIT 1
    ;

    MySQL Error  Error writing file '/tmp/MY5cjuzE' (Errcode28)
    Error Number 3
    Date         
    SundaySeptember 24th 2006 01:51:33 PM
    Script       
    http://*****/inlinemod.php
    Referrer     http://*****/inlinemod.php
    IP Address   
    Username     
    Classname    vb_database 


    Also, it did delete the post, and edit the thread when I go back to the forum page to check it.. but when I do it, its going to the database error screen and doesn't confirm or anything?
  • HHU
    Member
    • Sep 2005
    • 56

    #2
    I'm also getting them when sending a PM to somebody but I wasn't last night... havent made any changes to the forums EXCEPT... adding ranks system...

    PHP Code:
    Database error in vBulletin 3.5.5:

    Invalid SQL:

                
    SELECT pm.*, pmtext.*
                    , 
    icon.title AS icontitleicon.iconpath
                FROM pm 
    AS pm
                LEFT JOIN pmtext 
    AS pmtext ON(pmtext.pmtextid pm.pmtextid)
                
    LEFT JOIN icon AS icon ON(icon.iconid pmtext.iconid)
                
    WHERE pm.userid=AND pm.folderid=0
                ORDER BY pmtext
    .dateline DESC
                LIMIT 0
    50;

    MySQL Error  Got error 28 from storage engine
    Error Number 
    1030
    Date         
    SundaySeptember 24th 2006 01:57:24 PM
    Script       
    http://*****/private.php
    Referrer     http://*****/private.php?do=newpm&u=84
    IP Address   
    Username     
    Classname    vb_database 

    Comment

    • HHU
      Member
      • Sep 2005
      • 56

      #3
      Removed all the ranks images from FTP and the postbit edit as well as the Ranks listed in AdminCP.... still getting the errors... files on FTP have not been modified since August and its been working fine up until this morning.

      Comment

      • HHU
        Member
        • Sep 2005
        • 56

        #4
        Im also getting DB errors going into Vbulletin Options...

        Comment

        • Zachery
          Former vBulletin Support
          • Jul 2002
          • 59097

          #5
          Error code 28: No space left on device

          One or more partitions on your server is out of space or doesn't have enough space to complete this operation. Shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.

          Comment

          • HHU
            Member
            • Sep 2005
            • 56

            #6
            Appreciated.... figured it out, and freed up the space...

            If possible, please remove the thread for privacy reasons..

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...
            😀
            😂
            🥰
            😘
            🤢
            😎
            😞
            😡
            👍
            👎