Announcement

Collapse
No announcement yet.

Database Error

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

  • fiNal
    replied
    Originally posted by Corrupter
    I keep getting emails with the following error..


    Database error in vBulletin 3.0.0 Beta 4:

    Invalid SQL: SELECT threadid , COUNT(*) AS views FROM threadviews GROUP BY threadid
    mysql error: Can't find file: 'threadviews.MYD' (errno: 2)

    mysql error number: 1017

    Can some light be shed on that please oh great ones
    try admincp -> import & maintenance -> Repair / Optimize Tables -> Check threadview, make sure that Optimize Tables & Repair Tables are set to yes and then click Continue.

    im not sure whats this table for, cause it only has one field and no entries (on my board). Maybe its used if you disabled Update Thread Views Immediately or something like that.

    btw: the MYD-file is the file where all the data of the mysql-table is stored... this file is missing now - maybe all the data of this table is lost

    Leave a comment:


  • Corrupter
    started a topic Database Error

    Database Error

    I keep getting emails with the following error..


    Database error in vBulletin 3.0.0 Beta 4:

    Invalid SQL: SELECT threadid , COUNT(*) AS views FROM threadviews GROUP BY threadid
    mysql error: Can't find file: 'threadviews.MYD' (errno: 2)

    mysql error number: 1017

    Can some light be shed on that please oh great ones
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X