SQL error for forum activity tab

[mrsvox]

I've just installed the mod onto phpbb3.0.8. When I click on the Forum Activity tab, I get the following:

Genneral Error
SQL ERROR [ mysql4 ]

Error writing file '/dev/shm/MYfQIzXh' (Errcode: 28) [3]

SQL

SELECT COUNT(DISTINCT p.poster_id) AS count, f.forum_id AS f_id, f.forum_name AS f_name FROM phpbb_posts p, phpbb_forums f WHERE p.forum_id = f.forum_id AND p.post_approved = 1 AND f.forum_type = 1 GROUP BY f.forum_id, f.forum_name ORDER BY count DESC LIMIT 10

BACKTRACE

FILE: includes/db/mysql.php
LINE: 175
CALL: dbal_mysql->sql_error()

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

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

FILE: statistics/includes/functions.php
LINE: 605
CALL: dbal_mysql->sql_query_limit()

FILE: includes/stats/stats_activity.php
LINE: 154
CALL: get_top_forums()

FILE: includes/functions_module.php
LINE: 507
CALL: stats_activity->main()

FILE: stats.php
LINE: 71
CALL: p_master->load_active()"

We've got about 1.1 million posts. The install took a little over an hour to process.

Please let me know if there's any other you need.

[Marc]

As far as I can see, the result of query is just too big to be processed by your SQL server. The query needs to be split up in several queries like on the miscellaneous statistics page. This is currently not possible but it will be possible in one of the next versions. Right now I can only suggest you to turn off that part of the statistics.

[mrsvox]

Thanks very much for the quick response.

[Skillz]

Seems I am faced with the same issue. Any idea on an ETA for an update/fix to this?

[VeraKeisey]

Seems I am faced with the same issue. Any idea on an ETA for an update/fix to this?

Yeah, i got the same.