vb.org Archive
Page 2 of 3 1 2 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-07-2008 03:31 PM
Ah no I will try that.

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

Lynne 11-07-2008 03:55 PM
Look through those added xml files and I'll bet you find the culprit.

Virtualshiner 11-07-2008 04:12 PM
Okay, what sort of thing will I be looking for as I have no clue?

Lynne 11-07-2008 04:15 PM
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"

Virtualshiner 11-07-2008 04:58 PM
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 11-07-2008 05:45 PM
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

Virtualshiner 11-07-2008 06:50 PM
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

Virtualshiner 11-09-2008 02:07 PM
Hi,

Anyone got any help on this? Please?

Lynne 11-09-2008 02:27 PM
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 11-09-2008 02:35 PM
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?


All times are GMT. The time now is 01:14 PM.
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01860 seconds
  • Memory Usage 1,740KB
  • 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_quote_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