"Resynchronise statistics" shows SQL ERROR

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Suggested Hosts
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
SHIVA_
Registered User
Posts: 181
Joined: Sun Dec 18, 2005 8:03 pm
Location: US
Contact:

"Resynchronise statistics" shows SQL ERROR

Post by SHIVA_ » Sat Mar 17, 2012 3:44 pm

Hi, I get this error message when I click on "Resynchronise statistics."

General Error
SQL ERROR [ mysql4 ]

Table 'phpbb_posts' is marked as crashed and should be repaired [1194]

SQL

SELECT COUNT(post_id) AS stat FROM phpbb_posts WHERE post_approved = 1

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/acp/acp_main.php
LINE: 140
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_main->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()


Support Request Template
What version of phpBB are you using? phpBB 3.0.2
What is your board's URL? http://www.bmwsuperbikes.com/forum
Who do you host your board with? http://www.bluehost.com
How did you install your board? I used the download package from phpBB.com
Is your board a fresh install or a conversion? conversion from 2.
Do you have any MODs installed? yes but years ago, and no new changes for a quite a while. Also I had Tapatalk installed that was removed post this problem.
Is registration required to reproduce this issue? yes, its on ACP
What styles do you currently have installed? Prosilver-se
What language(s) is your board currently using? English
Which database type/version are you using?
What is your level of experience? been running phpbb board since 2004
What username can be used to view this issue?
What password can be used to view this issue?
When did your problem begin?

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50893
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: "Resynchronise statistics" shows SQL ERROR

Post by stevemaury » Sat Mar 17, 2012 3:59 pm

Repair the table using either phpMyAdmin or this SQL:

Code: Select all

REPAIR TABLE phpbb_posts;
Executing SQL Queries in phpMyAdmin KB
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

SHIVA_
Registered User
Posts: 181
Joined: Sun Dec 18, 2005 8:03 pm
Location: US
Contact:

Re: "Resynchronise statistics" shows SQL ERROR

Post by SHIVA_ » Sat Mar 17, 2012 5:08 pm

all resolved thanks.

Locked

Return to “[3.0.x] Support Forum”