IntegraMOD

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

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...

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

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

no problem ......happy to help

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