SQL error for forum activity tab

Current Version: 1.0.2
Released: 04/25/2010
Post Reply
mrsvox
Mitglied / Member
Mitglied / Member
Posts: 6
Joined: Tue 12. Apr 2011, 00:19

SQL error for forum activity tab

Post by 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.
User avatar
Marc
Administrator
Administrator
Posts: 620
Joined: Tue 2. Sep 2008, 22:48
phpbb.com: Marc
Location: Munich
Contact:

Re: SQL error for forum activity tab

Post by 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.
Image
mrsvox
Mitglied / Member
Mitglied / Member
Posts: 6
Joined: Tue 12. Apr 2011, 00:19

Re: SQL error for forum activity tab

Post by mrsvox »

Thanks very much for the quick response.
Skillz
Newbie
Newbie
Posts: 1
Joined: Wed 14. Dec 2011, 01:46
phpbb.com: {S'PORT}_Skillz

Re: SQL error for forum activity tab

Post by Skillz »

Seems I am faced with the same issue. Any idea on an ETA for an update/fix to this?
VeraKeisey
Newbie
Newbie
Posts: 1
Joined: Wed 24. Oct 2012, 09:01
phpbb.com: VeraKeisey
Contact:

Re: SQL error for forum activity tab

Post by VeraKeisey »

Skillz wrote:Seems I am faced with the same issue. Any idea on an ETA for an update/fix to this?
Yeah, i got the same.
Post Reply