[solved]functions_post.php Error

[MoonMaiden]

On a new post this error is showing, but the post shows up.

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=2 WHERE u.user_id=2 AND g.group_single_user=0 AND g.group_count_enable=1 AND g.group_moderator<>2

Line : 802
File : functions_post.php

[Dragonsys]

On a new post this error is showing, but the post shows up.

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=2 WHERE u.user_id=2 AND g.group_single_user=0 AND g.group_count_enable=1 AND g.group_moderator<>2

Line : 802
File : functions_post.php

Did you install any mods recently?

[Teelk]

This is a mysql5 error I believe, I don't have the fix with me since I'm not home at the moment. I'll look it up and post it when I do get home.

[Teelk]

Here ya go.

OPEN modcp.php

FIND

Code: Select all

$user_updated [] = "SELECT ug.user_id, g.group_id as g_id, u.user_posts, g.group_count, g.group_count_max, ".$row['poster_id']." as u_id FROM " . GROUPS_TABLE . " g, ".USERS_TABLE." u         LEFT JOIN ". USER_GROUP_TABLE." ug ON g.group_id=ug.group_id AND ug.user_id=".$row['poster_id']."         WHERE u.user_id=".$row['poster_id']."         AND g.group_single_user=0         AND g.group_count_enable=1         AND g.group_moderator<>".$row['poster_id'];

IN LINE, FIND

Code: Select all

" . GROUPS_TABLE . " g, ".USERS_TABLE." u

REPLACE WITH

Code: Select all

(" . GROUPS_TABLE . " g, ".USERS_TABLE." u)

OPEN admin/admin_groups.php

FIND

Code: Select all

$sql = "SELECT u.user_id FROM " . USERS_TABLE . " u                     LEFT JOIN " . USER_GROUP_TABLE ." ug ON u.user_id=ug.user_id AND ug.group_id='$group_id'                     WHERE u.user_posts>='$group_count' AND u.user_posts<'$group_count_max'                     AND ug.group_id is NULL                     AND u.user_id NOT IN ('$group_moderator','".ANONYMOUS."')";

IN LINE, FIND

Code: Select all

" . USERS_TABLE . " u

REPLACE WITH

Code: Select all

(" . USERS_TABLE . " u)

FIND

Code: Select all

$sql = "SELECT u.user_id FROM " . USERS_TABLE . " u                     LEFT JOIN " . USER_GROUP_TABLE ." ug ON u.user_id=ug.user_id AND ug.group_id='$new_group_id'                     WHERE u.user_posts>='$group_count' AND u.user_posts<'$group_count_max'                     AND ug.group_id is NULL                     AND u.user_id NOT IN ('$group_moderator','".ANONYMOUS."')";

IN LINE, FIND

Code: Select all

" . USERS_TABLE . " u

REPLACE WITH

Code: Select all

(" . USERS_TABLE . " u)

OPEN includes/functions_post.php

FIND

Code: Select all

$sql = "SELECT ug.user_id, g.group_id as g_id, u.user_posts, g.group_count, g.group_count_max FROM " . GROUPS_TABLE . " g, ".USERS_TABLE." u             LEFT JOIN ". USER_GROUP_TABLE." ug ON g.group_id=ug.group_id AND ug.user_id=$user_id             WHERE u.user_id=$user_id             AND g.group_single_user=0             AND g.group_count_enable=1             AND g.group_moderator<>$user_id";

IN LINE, FIND

Code: Select all

" . GROUPS_TABLE . " g, ".USERS_TABLE." u

REPLACE WITH

Code: Select all

(" . GROUPS_TABLE . " g, ".USERS_TABLE." u)

OPEN profilcp/profilcp_board_config.php

FIND

Code: Select all

$sql = "SELECT ug.user_id, g.group_id as g_id, g.group_name , u.user_posts, g.group_count FROM " . GROUPS_TABLE . " g, ".USERS_TABLE." u             LEFT JOIN ". USER_GROUP_TABLE." ug ON g.group_id=ug.group_id AND ug.user_id=$user_id             WHERE u.user_id=$user_id                  AND ug.user_id is NULL                  AND g.group_count=0                  AND g.group_single_user=0                  AND g.group_moderator<>$user_id";

IN LINE, FIND

Code: Select all

" . GROUPS_TABLE . " g, ".USERS_TABLE." u

REPLACE WITH

Code: Select all

(" . GROUPS_TABLE . " g, ".USERS_TABLE." u)

[MoonMaiden]

O that's alot of replacing but thank you! LOL. No I didn't install any mods this is a brand new installation of the forum. All I did was configure, install and try to post. Thanks so much!!! I'll go do it now and let you know how it works.

[MoonMaiden]

It's working perfectly now.. thank you!

[Teelk]

Glad I could help! <img>