[RESOLVED] Paint.NET Forum - Getting lots of SQL errors

[Rick Brewster]

For example, if you try to access: http://paintdotnet.forumer.com/membe...profile&u=3602

You get:

General Error
SQL ERROR [ mysql4 ]

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

SQL

SELECT forum_id, COUNT(post_id) AS num_posts FROM phpbb3_posts WHERE poster_id = 3602 AND post_postcount = 1 GROUP BY forum_id ORDER BY num_posts DESC LIMIT 1

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: 157
CALL: dbal_mysql->_sql_query_limit()

FILE: includes/functions_display.php
LINE: 907
CALL: dbal->sql_query_limit()

FILE: memberlist.php
LINE: 478
CALL: display_user_activity()

Users are reporting this for many threads, control panels, profiles, etc.

[Rick Brewster]

Also, I tried e-mailing Limez about this a few days ago but haven't heard anything back.

[Anthony151]

phpbb3 is not fully finished yet as there still testing it for bugs and glitches. i have had some problems too. maybe in a few weeks the problems will be fixed.

[Limez]

Hi Rick,
sorry for the delay in getting this sorted out.

Its fixed now.