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.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
oglach
Registered User
Posts: 498
Joined: Sun Apr 22, 2007 5:58 pm

SQL ERROR

Post by oglach »

wITHOTU DOIN ANY MODS OR ANYTHING, MY FORUM NOW GETS THIS , AFTER 2YEARS....
ALSO WHEN i back up via server cpanel its not 25mb+ like shud be its 350bytes, not the usual

whats wrong does anyone know????

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Table './hunty_SESSIONSFORUM/phpbb31_posts' is marked as crashed and should be repaired [145]

SQL

SELECT u.user_id, u.username, u.user_type, u.user_colour, COUNT(p.post_id) as total_posts FROM phpbb31_users u, phpbb31_posts p WHERE p.post_time > 1238837453 AND u.user_id = p.poster_id AND u.user_id <> 1 AND u.user_type <> 2 GROUP BY u.user_id ORDER BY total_posts DESC LIMIT 10

BACKTRACE

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

FILE: includes/db/mysql.php
LINE: 205
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 159
CALL: dbal_mysql->_sql_query_limit()

FILE: includes/functions_topposter.php
LINE: 102
CALL: dbal->sql_query_limit()

FILE: index.php
LINE: 123
CALL: get_top_posters()
Last edited by ric323 on Mon Apr 06, 2009 5:32 am, edited 1 time in total.
Reason: Topic icon changed

User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Re: SQL ERROR

Post by karlsemple »

Do you have phpmyadmin access to the database? If so use it to run a repair on the posts table in your boards database.
Image

oglach
Registered User
Posts: 498
Joined: Sun Apr 22, 2007 5:58 pm

Re: SQL ERROR

Post by oglach »

Sorted :)

Any reason this would happen a table?

blakebowling
Registered User
Posts: 775
Joined: Sun Apr 27, 2008 4:49 am
Location: 127.0.0.1

Re: SQL ERROR

Post by blakebowling »

It could be because your server was shutdown mid query. It could be something your host did. it could be that data that was being written was corrupted. As you may have noticed.. there is really no way to stop these.

Locked

Return to “[3.0.x] Support Forum”