Forums

PageStatistics error

Permalink
I'm having lots of trouble with PageStatistics in my database. Attached is the error I keep getting and I have no idea how to fix it. Does anybody have knowledge of this and how to fix?

Any help would be greatly appreciated.
Jordan

1 Attachment

crowljor
 
crowljor replied on at Permalink Reply 1 Attachment
crowljor
Attached is what I get when I run a database repair.

Again thanks.
Jordan
ConcreteOwl replied on at Permalink Best Answer Reply
ConcreteOwl
The PageStatistics table can create a huge amount of bloat on your database.
So, unless you really need to see the Page Statistics in your dashboard, I would suggest you turn off Page Statistics and run this sql on your database
truncate table PageStatistics
crowljor replied on at Permalink Reply
crowljor
New to this database stuff, In the database how and where would I do that?

Thanks
Jordan
ConcreteOwl replied on at Permalink Reply 1 Attachment
ConcreteOwl
In phpMyAdmin on the main database page you will see a SQL button near the top of the page.
Click the button and enter that truncate code then click 'Go'
But first click the Export option to get a copy of your database just in case something goes wrong..

See the attached image
crowljor replied on at Permalink Reply
crowljor
Worked great, thanks for the help.