And thanks to Teelk for showing me how to fix mysql 5 errors...
Statistics: Posted Author: found it — Tue Aug 15, 2006 3:26 pm
]]>
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
Statistics: Posted Author: ZacFields — Tue Aug 15, 2006 3:17 pm
]]>
If that is the case I suggest doing all of the fixes found here... http://integramod.com/forum/viewtopic.php?t=1180
Statistics: Posted Author: Teelk — Tue Aug 15, 2006 3:04 pm
]]>
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
FROM " . GROUPS_TABLE . " g, ".USERS_TABLE." u
and then change it too
FROM (" . GROUPS_TABLE . " g, ".USERS_TABLE." u)
and that should do it...
back up the file and let me know if it works ok...
Statistics: Posted Author: found it — Tue Aug 15, 2006 2:49 pm
]]>
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
Statistics: Posted Author: ZacFields — Tue Aug 15, 2006 2:13 pm
]]>