IntegraMOD

Sorry to ask, but i just can't figure out how to fix this. My host recently updated MySQL to 5.0.24-standard and PHP to 4.4.4. and now I get the error below.

Any thoughts on how to fix it?

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 phpbbv2_groups g, phpbbv2_users u LEFT JOIN phpbbv2_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 : 772
File : functions_post.php

IntegraMod 1.40 will only run on MySQL 4.xxx and lower.

IM 1.41 will run on MySQL 4.x & 5.x

I'm sorry but we do not currently have a release date set yet. We are working on it as fast as possible tho.

here are some mysql5 fixes for IM140
http://integramod.com/forum/viewtopic.php?t=1180

Thank You. I will test those fixes and change to resolved if it does fix that error.