vb.org Archive - Database Error

Page 1 of 3

Show 40 post(s) from this thread on one page

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)

Virtualshiner

11-06-2008 05:48 PM

Database Error

Hi,

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

Lynne

11-06-2008 05:53 PM

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

11-06-2008 05:57 PM

Okay thanks.

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

TeelK

11-06-2008 06:03 PM

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

Virtualshiner

11-06-2008 06:30 PM

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

11-06-2008 06:35 PM

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

11-06-2008 07:19 PM

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

11-06-2008 07:49 PM

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

Virtualshiner

11-07-2008 03:00 PM

They are disabled and still getting that error.

What shall I try now?

Lynne

11-07-2008 03:23 PM

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.

All times are GMT. The time now is 07:28 AM.

Page 1 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01058 seconds Memory Usage 1,735KB 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 (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: