Polskie forum wsparcia dla phpBB

Error geting users post stat

DEBUG MODE

SQL Error : 1054 Unknown column 'g.group_id' in 'on clause'

SELECT ug.user_id, g.group_id as g_id, u.user_posts, g.group_count, g.group_count_max FROM phpbb_groups g, phpbb_users u LEFT JOIN phpbb_user_group ug ON g.group_id=ug.group_id AND ug.user_id=3 WHERE u.user_id=3 AND g.group_single_user=0 AND g.group_count_enable=1 AND g.group_moderator<>3

Line : 477
File : functions_post.php

Error geting users post stat

DEBUG MODE

SQL Error : 1054 Unknown column 'g.group_id' in 'on clause'

SELECT ug.user_id, g.group_id as g_id, g.group_name , u.user_posts, g.group_count FROM phpbb_groups g, phpbb_users u LEFT JOIN phpbb_user_group ug ON g.group_id=ug.group_id AND ug.user_id=2640 WHERE u.user_id=2640 AND ug.user_id is NULL AND g.group_count=0 AND g.group_single_user=0 AND g.group_moderator<>2640

Line : 907
File : usercp_register.php

Error

SQL query: Documentation

SELECT ug.user_id, g.group_id AS g_id, u.user_posts, g.group_count, g.group_count_max
FROM phpbb_groups g, phpbb_users u
LEFT JOIN phpbb_user_group ug ON g.group_id = ug.group_id
AND ug.user_id =3
WHERE u.user_id =3
AND g.group_single_user =0
AND g.group_count_enable =1
AND g.group_moderator <>3
LIMIT 0 , 30

MySQL said: Documentation
#1054 - Unknown column 'g.group_id' in 'on clause'

MySQL client version: 5.0.32