Code: Select all
General Error
SQL ERROR [ mysqli ]
Unknown column 'U.user_id' in 'on clause' [1054]
SQL
SELECT u.group_id, g.group_name, COUNT(p.post_id) AS total FROM phpbb_posts p LEFT JOIN phpbb_users u ON U.user_id = p.poster_id LEFT JOIN phpbb_groups g ON g.group_id = u.group_id WHERE YEAR(FROM_UNIXTIME(p.post_time)) = 2014 AND MONTH(FROM_UNIXTIME(p.post_time)) = 10 GROUP BY g.group_id ORDER BY total DESC LIMIT 20
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 194
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/ext/forumhulp/postsstats/vendor/stat_functions.php
LINE: 374
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/ext/forumhulp/postsstats/acp/postsstats_module.php
LINE: 123
CALL: stat_functions::gp()
FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: forumhulp\postsstats\acp\postsstats_module->main()
FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()