Database Error

[Virtualshiner]

Hi,

The original errors are solved and we have upgraded to 3.8.0.
Page 2 has the current db errors.

[Lynne]

Neither of those tables are default vbulletin tables (subscribegroup or prefixpermission). Perhaps you need to reinstall the modification that creates those tables. Or, perhaps you turned on a modification that you had previously uninstalled that had those tables.

[Virtualshiner]

Okay thanks.

How do I find out what mod those tables are in?

[TeelK]

disable all hacks and then turn on one by one..

[Virtualshiner]

Okay,

They seem to be solved but we get this:

PHP Code:

Database error in vBulletin 3.8.0 Beta 2:

Invalid SQL:
SELECT cat.socialgroupcategoryid AS categoryid, cat.title, COUNT(socialgroup.groupid) AS total
                
                FROM socialgroupcategory AS cat
                LEFT JOIN socialgroup AS socialgroup
                 ON (socialgroup.socialgroupcategoryid = cat.socialgroupcategoryid)
                
                WHERE socialgroup.groupid IS NOT NULL
                
                GROUP BY cat.socialgroupcategoryid
                ORDER BY total
                LIMIT 0, 40;

MySQL Error   : Unknown column 'socialgroup.socialgroupcategoryid' in 'on clause'
Error Number  : 1054
Request Date  : Thursday, November 6th 2008 @ 02:29:52 PM
Error Date    : Thursday, November 6th 2008 @ 02:29:52 PM
Script        : http://www.vfkfansite.com/forums/group.php
Referrer      : 
IP Address    : **.***.***.***
Username      : **********
Classname     : vB_Database
MySQL Version : 5.0.51a-community 


[SEOvB]

Make sure to remove associate xml files in the includes/xml folder

An easy way to do that is to rename your current includex/xml folder to xml-bak and then reupload the standard xml folder from vBulletin

[Virtualshiner]

Hmm.. I just did that, but we are still getting the database error..
I renamed the current xml folder to xml-back, and re-uploaded the xml folder.

[Lynne]

And your plugins are still disabled? You may want to reupload a totally default group.php file.

[Virtualshiner]

They are disabled and still getting that error.

What shall I try now?

[Lynne]

Did you reupload the group.php script - a default one downloaded from vb.com? Also, check your includes/xml folder. You should have a total of seven files in there that includes the index.html file.