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:

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.

[Virtualshiner]

Ah no I will try that.

Also we have 31 files I think it was as we have mods installed.

[Lynne]

Look through those added xml files and I'll bet you find the culprit.

[Virtualshiner]

Okay, what sort of thing will I be looking for as I have no clue?

[Lynne]

Okay, what sort of thing will I be looking for as I have no clue?
Anything that has to do with the error - unknown column "socialgroupcategoryid"

[Virtualshiner]

No not that. When I can get the password for the vbulletin ill try putting the groups.php file back in.

I am really not sure on how to fix this one.

[SEOvB]

Ah no I will try that.

Also we have 31 files I think it was as we have mods installed.

Like i said, Rename your current /includes/xml folder to /includes/xml-bak then reupload a new xml folder from your default vBulletin download

[Virtualshiner]

We have done that but the error still appears.

--------------- Added 1226150911 at 1226150911 ---------------

Okay well what I did was found that table in the database and this is what it shows:

SELECT COUNT( * ) AS `Rows` , `socialgroupcategoryid`
FROM `socialgroupcategory`
GROUP BY `socialgroupcategoryid`
ORDER BY `socialgroupcategoryid`
LIMIT 0 , 30

and this is the error:

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 : Saturday, November 8th 2008 @ 07:28:16 AM
Error Date : Saturday, November 8th 2008 @ 07:28:16 AM
Script : http://www.vfkfansite.com/forums/group.php
Referrer :
IP Address : **.***.***.***
Username : **********
Classname : vB_Database
MySQL Version : 5.0.51a-community

--------------- Added 1226151913 at 1226151913 ---------------

We also have another one now, any help?

Database error in vBulletin 3.8.0 Beta 2:

Invalid SQL:

REPLACE INTO prefixpermission (usergroupid, prefixid)
SELECT 35, prefixid FROM prefix
WHERE options & 1;

MySQL Error : Unknown column 'options' in 'where clause'
Error Number : 1054
Request Date : Saturday, November 8th 2008 @ 07:43:58 AM
Error Date : Saturday, November 8th 2008 @ 07:43:58 AM
Script : http://www.vfkfansite.com/forums/admincp/usergroup.php?do=update
Referrer : http://www.vfkfansite.com/forums/admincp/usergroup.php?do=add

[Virtualshiner]

Hi,

Anyone got any help on this? Please?

[Lynne]

Looking through these posts, I'm confused about something.... what version were you running on the old server and what version are you now running? Some of your errors say 3.7.3 and others say 3.8.0.

Also, when we ask you to disable your plugins, you need to not only do so in your config.php file, you need to get rid of all the extra xml files in your /xml folder - those are part of your modifications.

[Virtualshiner]

Sorry, they are old ones now fixed. We only have the social group one and the one creating the usergroup in the acp.

Okay so how do we disable the plugins in the config file?

So in disabling the plugins you need to:

- Disable in products in acp
- Delete xml files
- Change something in config.php

and that disables all?

[Lynne]

If you do this in the config.php file, then you don't need to disable them in the ACP, but you do still need to remove the xml files.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

[Virtualshiner]

Okay well I added that and just the xml file and still get both db errors.

[Lynne]

I don't know what else to suggest. I cannot find anything like those queries in the code - but I only have 3.7.3, not 3.8. I have no idea if those are default queries or not. You may want to post on vb.com in their 3.8 forum since they are more familar with the code, however you do realize that 3.8 is an upgrade-at-your-own-risk version, right?

[Virtualshiner]

Yeah I realize that.
Im just grasping at straws but any chance it is because the config.php file is 3.7.3 and not 3.8?

Can I go back to 3.7?

[Lynne]

The only way to go back to 3.7 is to restore a 3.7 backup of your database and then upload all the 3.7 files.

[Virtualshiner]

Well thanks for all your help. No idea what happened but they have gone.