Database Error

[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]

Originally Posted by Virtualshiner

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]

Originally Posted by Virtualshiner

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 [DATE]1226150911[/DATE] at [TIME]1226150911[/TIME] ---------------

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 [DATE]1226151913[/DATE] at [TIME]1226151913[/TIME] ---------------

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?