SQL Error Please help!

Support for IntegraMOD 140

Moderator: Integra Moderator

SQL Error Please help!

PostAuthor: Blue-Blood » Thu Oct 05, 2006 6:20 pm

Fresh install
140 with no updates
integrastyle
getting error when i make a post
the message is posted but i get this error when i submit

Thanks for your help!!

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 qf4u_groups g, qf4u_users u LEFT JOIN qf4u_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 : 802
File : functions_post.php
Last edited by Blue-Blood on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.

Blue-Blood
Integra Member
Integra Member
 
Posts: 102
Likes: 0 post
Liked in: 0 post
Joined: Tue Jul 04, 2006 9:46 pm
Cash on hand: 0.00
Location: Louisville KY

Re: SQL Error Please help!

PostAuthor: Teelk » Thu Oct 05, 2006 7:16 pm

Apply all of the fixes in the first post and everything should work alright again.

http://integramod.com/forum/viewtopic.php?t=1180
Last edited by Teelk on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
User avatar
Teelk
Dev Team
Dev Team
 
Posts: 1309
Likes: 0 post
Liked in: 0 post
Joined: Tue Mar 14, 2006 6:25 pm
Cash on hand: 0.00
Location: Canada

PostAuthor: Blue-Blood » Thu Oct 05, 2006 7:30 pm

I dont want to install the updates beacuse then I cant use integrastyle. There is no updated integrastyle.

Also before there were updates for 140 it worked fine it should work with out the updates.
Last edited by Blue-Blood on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.

Blue-Blood
Integra Member
Integra Member
 
Posts: 102
Likes: 0 post
Liked in: 0 post
Joined: Tue Jul 04, 2006 9:46 pm
Cash on hand: 0.00
Location: Louisville KY

PostAuthor: Blue-Blood » Thu Oct 05, 2006 7:34 pm

in mysql control center
when i opoen a table i get this message
[root] ERROR 1146: Table 'qf4u.1' doesn't exist

All the tables are there and when install all messages say Successfull
Last edited by Blue-Blood on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.

Blue-Blood
Integra Member
Integra Member
 
Posts: 102
Likes: 0 post
Liked in: 0 post
Joined: Tue Jul 04, 2006 9:46 pm
Cash on hand: 0.00
Location: Louisville KY

Re: SQL Error Please help!

PostAuthor: Helter » Thu Oct 05, 2006 8:55 pm

Apply all of the fixes in the first post and everything should work alright again.

http://integramod.com/forum/viewtopic.php?t=1180
Last edited by Helter on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
"Success is getting what you want. Happiness is wanting what you get." - Dale Carnegie
User avatar
Helter
Administrator
Administrator
 
Posts: 4554
Likes: 40 posts
Liked in: 116 posts
Images: 0
Joined: Sat Mar 11, 2006 4:46 pm
Cash on hand: 1,959.15
Location: Seattle Wa
IntegraMOD version: phpBB2x

PostAuthor: Blue-Blood » Thu Oct 05, 2006 9:36 pm

the fix at this link didnt work
http://integramod.com/forum/viewtopic.php?t=1180
the ratings.php code didnt match up with my ratings.php

but the fix at this link worked
http://integrmod.com/home/viewtopic.php?t=9175
this one dosent change anything in the ratings.php

I still get this
in mysql control center
when i opoen a table i get this message
[root] ERROR 1146: Table 'qf4u.1' doesn't exist
Last edited by Blue-Blood on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.

Blue-Blood
Integra Member
Integra Member
 
Posts: 102
Likes: 0 post
Liked in: 0 post
Joined: Tue Jul 04, 2006 9:46 pm
Cash on hand: 0.00
Location: Louisville KY

Re: SQL Error Please help!

PostAuthor: Helter » Thu Oct 05, 2006 11:19 pm

im assuming your running php5. You can try the beta Integramod141 package. just dont add any mods or go live, till Fubie updates the 141 release as the files are a little bit behind the .svn development. Since your putting up a new forum, you should be fine. When the release package is done you should be able to overwrite all your files except for config.php with the new ones since the db wil not change. I still stress for your own sake, do not go live till the package is final or you may encounter unsupported errors.
Last edited by Helter on Wed Dec 31, 1969 5:00 pm, edited 1 time in total.
"Success is getting what you want. Happiness is wanting what you get." - Dale Carnegie
User avatar
Helter
Administrator
Administrator
 
Posts: 4554
Likes: 40 posts
Liked in: 116 posts
Images: 0
Joined: Sat Mar 11, 2006 4:46 pm
Cash on hand: 1,959.15
Location: Seattle Wa
IntegraMOD version: phpBB2x


Return to IntegraMOD 140

Who is online

Registered users: App360MonitorBot, Bing [Bot], Google [Bot]