Announcement

Collapse
No announcement yet.

Database error when using PM

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • jakaroo
    replied
    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!

    Leave a comment:


  • Zachery
    replied
    Then contact your host ASAP.

    Leave a comment:


  • jakaroo
    replied
    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

    Leave a comment:


  • Zachery
    replied
    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

    Leave a comment:


  • jakaroo
    started a topic Database error when using PM

    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!
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X