SQL error for forum activity tab

Current Version: 1.0.2
Released: 04/25/2010
mrsvox
Mitglied / Member
Mitglied / Member
Beiträge: 6
Registriert: Di 12. Apr 2011, 01:19

SQL error for forum activity tab

Beitrag von 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.

Benutzeravatar
Marc
Administrator
Administrator
Beiträge: 619
Registriert: Di 2. Sep 2008, 23:48
phpbb.com: Marc
Wohnort: Munich

Re: SQL error for forum activity tab

Beitrag von 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.
Bild

mrsvox
Mitglied / Member
Mitglied / Member
Beiträge: 6
Registriert: Di 12. Apr 2011, 01:19

Re: SQL error for forum activity tab

Beitrag von mrsvox »

Thanks very much for the quick response.

Skillz
Newbie
Newbie
Beiträge: 1
Registriert: Mi 14. Dez 2011, 02:46
phpbb.com: {S'PORT}_Skillz

Re: SQL error for forum activity tab

Beitrag von Skillz »

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

VeraKeisey
Newbie
Newbie
Beiträge: 1
Registriert: Mi 24. Okt 2012, 10:01
phpbb.com: VeraKeisey

Re: SQL error for forum activity tab

Beitrag von VeraKeisey »

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