Log in

View Full Version : Threads - only 1 view when they have had more


Sp32
06-19-2009, 10:27 AM
All my threads are saying they have had only 1 view/s

when I know for a fact they have had hundreds of views

what is going wrong???

:confused:

It's only happening in 1 forum I think..

JMEWLS`
06-19-2009, 12:08 PM
Checked your scheduled tasks?

AdminCP -> Scheduled Tasks -> Scheduled Task Manager -> Thread Views -> Run Now

Try that?

Sp32
06-19-2009, 04:03 PM
Damn something is broken:

I get this when I click run now

Database error in vBulletin 3.8.3:

Invalid SQL:

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

MySQL Error : Table './x/threadviews' is marked as crashed and should be repaired
Error Number : 145
Request Date : Friday, June 19th 2009 @ 05:02:41 PM
Error Date : Friday, June 19th 2009 @ 05:02:41 PM
Script : http://www.x.org/admincp/cronadmin.php?do=runcron&cronid=2
Referrer : http://www.x.org/admincp/cronadmin.php?do=modify
IP Address : x
Username : x
Classname : vB_Database
MySQL Version : 5.0.77-community

--------------- Added 1245432315 at 1245432315 ---------------

I went into phpmyadmin to see if I could fix it in there but I couldn't find anything (I dont know a great deal about phpmyadmin so I might of missed it)

Lynne
06-19-2009, 04:25 PM
Run Repair/Optimize on your threadviews table. It's under the Maintenance tab in your admin cp.

Sp32
06-19-2009, 04:34 PM
Damn you're awesome :D

I love you!

Thank you very much once again :)