Announcement

Collapse
No announcement yet.

SQL error due to full hard disk space on server

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

  • SQL error due to full hard disk space on server

    I get the following SQL error:
    Database error in vBulletin 3.5.1:

    Invalid SQL:

    SELECT threadid, COUNT(*) AS views
    FROM vb350_threadviews
    GROUP BY threadid;

    MySQL Error : Can't find file: 'vb350_threadviews.MYD' (errno: 2)
    Error Number : 1017
    Date : Monday, November 21st 2005 @ 06:02:01 AM
    Script : http://www.xbox-live.gr/forum/cron.php?&rand=156527
    Referrer : http://www.xbox-live.gr/forum/showthread.php?p=513

    If i run "Repair" in my sql database it cant find the file above.

    I contacted my host company and they said that i ve reached the maximum space limit in my server and the database was corrupted.

    I ve deleted some files on the server,then i run a repair and all were ok.
    The only problem is that the table/file above is "missing".

    Any help?

    Thanks in advance!

  • #2
    You are missing the data files for this table. This seems to happen to the threadviews table along with the attachmentviews table. Run these queries to recreate these tables:

    1:
    DROP TABLE IF EXISTS threadviews;

    2:
    CREATE TABLE threadviews (
    threadid INT UNSIGNED NOT NULL DEFAULT '0',
    KEY threadid (threadid)
    );


    If you find you have the same error with the attachmentviews table, run this queries:

    3:
    DROP TABLE IF EXISTS attachmentviews;

    4:
    CREATE TABLE attachmentviews (
    attachmentid INT UNSIGNED NOT NULL DEFAULT '0',
    KEY postid (attachmentid)
    );
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      That worked!Thanks a lot!

      Comment

      Loading...
      Working...
      X