po przeniesieniu forum i bazy mysql na nowy serwer, napotykam dziwne błędy w czasie uzytkowania forum, oto one:
Cytat
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
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
to po dodaniu posta (post sie jakkolwiek pojawia)
a to, po rejestracji:
Cytat
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
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
o co chodzi, jak naprawić ? bardzo proszę o pomoc!