Sub Menu
Links Menu
Online Users

In total there are 318 users online :: 3 registered, 0 hidden and 315 guests

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

Registered users: Bing [Bot], Google [Bot], Majestic-12 [Bot] based on users active over the past 60 minutes

SQL Error : 1054 Unknown column 'g.group_id' in 'on clause'

support for IntegraMOD 132

Moderator: Integra Moderator

SQL Error : 1054 Unknown column 'g.group_id' in 'on clause'

PostAuthor: viragotech » Thu Jul 10, 2008 6:11 am

Your phpBB Version: 2.0.
phpBB Type: Integramod 132
MODs: No
Your knowledge: Basic Knowledge
Board URL: http://viragotechforum.com/phpBB/

PHP Version:
MySQL Version:


What was done before the problem appeared?
hosting went to mysql5 but adding this line to htaccess got it working again.

AddHandler application/x-httpd-php4 .php



What was done to try to solve the problem?
uploaded back up of functions_post.php



De.scription and Message

SQL Error : 1054 Unknown column 'g.group_id' in 'on clause'

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

Line : 675
File : functions_post.php
Last edited by viragotech on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
User avatar
viragotech
Sr Integra Member
Sr Integra Member
 
Posts: 292
Likes: 0 post
Liked in: 0 post
Joined: Wed Jul 04, 2007 10:30 am
Cash on hand: 0.00

PostAuthor: viragotech » Thu Jul 10, 2008 6:23 am

now you get that error after postign a message but the message is still posted, is there a way to turn off and on debug so the messages doesn't display at some times???

sort of assbackwards but would let folks use the forum with less interuption while we work on it.
Last edited by viragotech on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
User avatar
viragotech
Sr Integra Member
Sr Integra Member
 
Posts: 292
Likes: 0 post
Liked in: 0 post
Joined: Wed Jul 04, 2007 10:30 am
Cash on hand: 0.00


Return to IntegraMOD 132

Who is online

Registered users: Bing [Bot], Google [Bot], Majestic-12 [Bot]

cron