SQL Error Please help!

Posted:
Thu Oct 05, 2006 6:20 pm
Author: Blue-Blood
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
Re: SQL Error Please help!

Posted:
Thu Oct 05, 2006 7:16 pm
Author: Teelk
Apply all of the fixes in the first post and everything should work alright again.
http://integramod.com/forum/viewtopic.php?t=1180

Posted:
Thu Oct 05, 2006 7:30 pm
Author: Blue-Blood
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.

Posted:
Thu Oct 05, 2006 7:34 pm
Author: Blue-Blood
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
Re: SQL Error Please help!

Posted:
Thu Oct 05, 2006 8:55 pm
Author: Helter
Apply all of the fixes in the first post and everything should work alright again.
http://integramod.com/forum/viewtopic.php?t=1180

Posted:
Thu Oct 05, 2006 9:36 pm
Author: Blue-Blood
the fix at this link didnt work
http://integramod.com/forum/viewtopic.php?t=1180the ratings.php code didnt match up with my ratings.php
but the fix at this link worked
http://integrmod.com/home/viewtopic.php?t=9175this 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
Re: SQL Error Please help!

Posted:
Thu Oct 05, 2006 11:19 pm
Author: Helter
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.