vb.org Archive - Database Error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Database Error (https://vborg.vbsupport.ru/showthread.php?t=195598)

Hi,

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

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.

Okay thanks.

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

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

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

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

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.

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

They are disabled and still getting that error.

What shall I try now?

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.

Ah no I will try that.

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

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

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

Quote:

Originally Posted by Virtualshiner (Post 1661317)

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"

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.

Quote:

Originally Posted by Virtualshiner (Post 1661278)

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

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:

Code:

SELECT COUNT( * ) AS `Rows` , `socialgroupcategoryid` 

FROM `socialgroupcategory` 

GROUP BY `socialgroupcategoryid` 

ORDER BY `socialgroupcategoryid` 

LIMIT 0 , 30

and this is the error:

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  : 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?

Code:

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

Hi,

Anyone got any help on this? Please?

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.

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?

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

PHP Code:


		
			
define('DISABLE_HOOKS', true);

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

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?

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?

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.

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

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01314 seconds Memory Usage 1,782KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (2)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (26)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: