Forum module - topics in forum:

phpBB Module - Discussions relating directly to the PHP-Nuke phpBB module.

phpBB : Critical Error ?

Was wondering if you guyz could help me on this...It's basically nuke anyhow...But hey see..how we go... I get this error now through my arcade page, I'm using v3Arcade on the PNC clan setup

Thanks in advance.

Code: :

phpBB : Critical Error

Could not query games information

DEBUG MODE

SQL Error : 1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

SELECT u.username, u.user_id, u.user_level, user_allow_viewonline, g.game_name, g.game_id FROM pnc_bbgamehash gh LEFT JOIN pnc_bbsessions s ON gh.user_id = s.session_user_id LEFT JOIN pnc_users u ON gh.user_id = u.user_id LEFT JOIN pnc_bbgames g ON gh.game_id = g.game_id WHERE gh.hash_date >= s.session_time AND (1165769310- gh.hash_date <= 300) AND g.arcade_catid IN (1) ORDER BY gh.hash_date DESC

Line : 38
File : whoisplaying.php

Have no idea, do the arcade makers or pnc clan not have help forums? I'm sure they'd be more likely to know of any issues.

No they don't, The problem seemed to sort itself, Hasnt appeared for the last week, But thx anyway

Forum module - topics in forum:

Search from web