Announcement

Collapse
No announcement yet.

blog_views Missing - How to fix?

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

  • Trevor Hannant
    replied
    If you're running Blog 2.0.2, try running this in phpMyAdmin:

    Code:
    CREATE TABLE blog_views (
            blogid INT UNSIGNED NOT NULL DEFAULT '0',
            KEY blogid (blogid)
        )
    This will recreate that table.

    Leave a comment:


  • calvis
    started a topic blog_views Missing - How to fix?

    blog_views Missing - How to fix?

    Not sure how it got missing, but this error pops up frequently.

    Database error in vBulletin 3.8.4:

    Invalid SQL:

    INSERT INTO blog_aggregate_temp_1285022100
    SELECT blogid, COUNT(*) AS views
    FROM blog_views
    GROUP BY blogid;

    MySQL Error : Can't find file: 'blog_views' (errno: 2)
    Error Number : 1017
    Request Date : Monday, September 20th 2010 @ 03:35:09 PM
    Error Date : Monday, September 20th 2010 @ 03:35:11 PM

Related Topics

Collapse

Working...
X