Error 1146; 'threadviews' table doesn't exist?

Filed Under zjbr.com |

  • I hate to be asking about what looks to be an error that a lot of other people have already had, but in reviewing earlier threads about this error I'm just not clear on what it is I need to do to fix it - looks like the solution I'm seeing the most has to do with "vBulletin Blog," but that isn't even something we're using so I'm not sure that's applicable here?

    At any rate, here is the error I'm getting via email - thus far I haven't been able to reproduce it myself, even when signed out, so I'm having an even harder time trying to figure out how the heck to address it:


    Invalid SQL:

    INSERT INTO taggregate_temp_1215543360
    SELECT threadid, COUNT(*) AS views
    FROM threadviews
    GROUP BY threadid;

    MySQL Error : Table 'eddzone.threadviews' doesn't exist
    Error Number : 1146
    Request Date : Tuesday, July 8th 2008 @ 02:56:43 PM
    Error Date : Tuesday, July 8th 2008 @ 02:56:43 PM
    Script : http://www.edtropolis.com/forum/cron.php?rand=687470
    Referrer : http://www.edtropolis.com/forum/postings.php?t=3931&pollid=
    IP Address : xx.xxx.x.xx
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :


    If anybody could offer any insight or suggestions I would be eternally grateful :o


  • Something or someone with database access must've deleted the table. Here's the query to re-create it. You can issue this query via Admin CP's run query option (if you have yourself configured) or via phpMyAdmin:
    CREATE TABLE threadviews (
    threadid INT UNSIGNED NOT NULL DEFAULT '0',
    KEY threadid (threadid)
    )

    You may wish to change your FTP and MySQL passwords (don't forget to update config.php) just to be safe, too.


  • Yes, I did see that - my problem is that I'm not sure what to do about it. I'm not sure how to figure out what's calling this table or what I can do to restore it (if a restoration IS necessary). Our board appears to be functioning normally for folks who are logged in - and again, even when I log out and view the forum as a guest, things have looked fine to me so I'm just not sure what's going on or even how to get started (the only reason I even know there's a problem is because I keep getting error report emails about it).

    Unfortunately, I've not been able to find a thread on the matter that's helped me work this out on my own (most of the ones I've found either suggested upgrading (I've just implemented the 3.7.2 Patch Level 1 so I am up-to-date), or else made mention of the "vBulletin Blog," which again we're not using. It's possible that I'm just not looking at the right threads so if anybody does know of one that could be of more help, or else could point me in the right direction with some advice/suggestions, I'd be most grateful ...


  • Ah, that did the trick perfectly - thanks very much for your help!


  • MySQL Error : Table 'eddzone.threadviews' doesn't exist

    table missing







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Error 1146; 'threadviews' table doesn't exist? , Please add it free.

    Comments