Odd error... I don't even know where to start

[ZacFields]

If this helps at all, this error started showing up after I posted at almost the exact same time I got a new DDos attempt on my forums. Now everytime I post, I get this error:

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

Line : 772
File : functions_post.php


Anyone know what's up with that?

Zac

[found it]

Hi

Do not quote me on this but it looks like your site has been upgraded to mysql 5...

if you open up functions-post.php and find...about line 764

Code: Select all

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

and then change it too

Code: Select all

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

and that should do it...

back up the file and let me know if it works ok...

[Teelk]

Definately looks like it...

If that is the case I suggest doing all of the fixes found here... http://integramod.com/forum/viewtopic.php?t=1180

[ZacFields]

Found It: that fix worked beautifully! Thank you so much!

Teelk: I will apply those changes as soon as I get home from work tomorrow. I hate it when they make changes like this without telling me. As soon as 140 is done I am moving over to my VPS

Zac

[found it]

no problem ......happy to help

And thanks to Teelk for showing me how to fix mysql 5 errors...