Database error when using PM

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jakaroo
    Member
    • Mar 2005
    • 69

    Database error when using PM

    I recently deleted around 300,000+ posts and now when you log in and try to send a PM, you receive this error:
    Database error in vBulletin 3.7.4:

    Invalid SQL:

    SELECT pm.*, pmtext.*
    , icon.title AS icontitle, icon.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=1 AND pm.folderid=0
    ORDER BY pmtext.dateline DESC
    LIMIT 0, 50;

    MySQL Error : Got error 28 from storage engine
    Error Number : 1030
    Request Date : Tuesday, August 28th 2012 @ 08:51:37 PM
    Error Date : Tuesday, August 28th 2012 @ 08:51:37 PM




    I also have post count and thread count errors and issues when trying to respond. I've updated the counters, but still have issues if I try to optimize and repair the database.

    Any help and all help is appreciated in correcting this issue to get things back working properly
    Thanks!
  • Zachery
    Former vBulletin Support
    • Jul 2002
    • 59097

    #2
    MySQL Error : Got error 28 from table handler

    Error Code 28 (No space left on device):
    Got error 28 from table handler means your server's mysql partition for your mysql database ran out of disk space or that the /tmp directory ( http://www.mysql.com/doc/T/e/Temporary_files.html )on your server doesn't have enough space, you need to

    1. close your forum to prevent further posting or writing to the database
    2. contact your web host
    3. or if your host yourself on a dedicated server, you need to move your mysql partition to a larger disk or change the /tmp directory location via your servers my.cnf file

    Comment

    • jakaroo
      Member
      • Mar 2005
      • 69

      #3
      thanks!

      but when going to Vbull Options to shut down the site, I receive the following message in the screen to the right of the menu bar.



      Invalid SQL:

      SELECT setting.*, settinggroup.grouptitle
      FROM settinggroup AS settinggroup
      LEFT JOIN setting AS setting USING(grouptitle)
      WHERE settinggroup.displayorder <> 0
      ORDER BY settinggroup.displayorder, setting.displayorder;

      MySQL Error : Got error 28 from storage engine
      Error Number : 1030

      Comment

      • Zachery
        Former vBulletin Support
        • Jul 2002
        • 59097

        #4
        Then contact your host ASAP.

        Comment

        • jakaroo
          Member
          • Mar 2005
          • 69

          #5
          and my error is:
          mysql partition to a larger disk or change the /tmp directory location via your servers my.cnf file?

          I'm not sure what could have happened suddenly to cause all the database errors when room was made on the site

          - - - Updated - - -

          If i go to repair and optimize tables, all tables show zero overhead except the following

          Data Length Index Length Overhead
          311.05 MB 413.14 MB 49.95 MB

          - - - Updated - - -

          Thank you, i was able to resolve this issue based on your response!

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...