Sub Menu
Links Menu
Online Users

In total there are 313 users online :: 1 registered, 0 hidden and 312 guests

Most users ever online was 1091 on Wed Aug 16, 2023 5:27 pm

Registered users: Google [Bot] based on users active over the past 60 minutes

[SOLVED] Forced SQP/PhP upgrade. Getting errors now.

Support for IntegraMOD 140

Moderator: Integra Moderator

[SOLVED] Forced SQP/PhP upgrade. Getting errors now.

PostAuthor: jackflack » Wed Nov 08, 2006 10:35 am

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
Last edited by jackflack on Tue Dec 05, 2006 7:34 am, edited 1 time in total.

jackflack
Newbie
Newbie
 
Posts: 13
Likes: 0 post
Liked in: 0 post
Joined: Sat Apr 29, 2006 2:43 pm
Cash on hand: 0.00

PostAuthor: Fubie » Wed Nov 08, 2006 11:03 am

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.
Last edited by Fubie on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
[url=http][img=left]http://www.myhorrorstories.com/files/bannerexchange.gif[/img][/url]

[url=http][img=left]http://www.fubie.net/images/geekstufflarge.jpg[/img][/url]

Fubie
Dev Team
Dev Team
 
Posts: 742
Likes: 0 post
Liked in: 0 post
Joined: Sat Mar 11, 2006 6:52 pm
Cash on hand: 0.00

Re: Forced SQP/PhP upgrade. Getting errors now.

PostAuthor: Helter » Wed Nov 08, 2006 1:56 pm

here are some mysql5 fixes for IM140
http://integramod.com/forum/viewtopic.php?t=1180
Last edited by Helter on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
Always use Protection
Image


Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4167
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Sat Mar 11, 2006 3:46 pm
Cash on hand: 172.60
Location: Seattle Wa
IntegraMOD version: IM 3

Re: Forced SQP/PhP upgrade. Getting errors now.

PostAuthor: jackflack » Wed Nov 08, 2006 5:54 pm

Thank You. I will test those fixes and change to resolved if it does fix that error.
Last edited by jackflack on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.

jackflack
Newbie
Newbie
 
Posts: 13
Likes: 0 post
Liked in: 0 post
Joined: Sat Apr 29, 2006 2:43 pm
Cash on hand: 0.00


Return to IntegraMOD 140

Who is online

Registered users: Google [Bot]

cron