vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   database error help please (https://vborg.vbsupport.ru/showthread.php?t=139300)

bahisyeri 02-13-2007 01:11 PM

database error help please
 
i need help about data base error,what i to do about this error.
Please help me.

thats my error about db:
------------------------------------------------------
Database error in vBulletin 3.6.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Adminler',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<b>',
`closetag` = '</b>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`forumpermissions` = '1048575',
`genericpermissions` = '1073741823',
`attachlimit` = '1000',
`pmquota` = '1000',
`pmpermissions` = '7',
`pmsendmax` = '100',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericoptions` = '63',
`profilepicmaxwidth` = '200',
`profilepicmaxheight` = '200',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '200',
`avatarmaxheight` = '250',
`avatarmaxsize` = '65535',
`signaturepermissions` = '245759',
`sigpicmaxwidth` = '200',
`sigpicmaxheight` = '200',
`sigpicmaxsize` = '65535',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '10',
`vbgmepermissions` = '31',
`profileviewpermissions` = '15',
`vbarticles` = '4095',
`vbspacecomments` = '31',
`fcpermissions` = '0',
`vbmates` = '0',
`grpspermissions` = '511'
WHERE usergroupid=6;

MySQL Error : Unknown column 'fcpermissions' in 'field list'
Error Number : 1054
Date : Tuesday, February 13th 2007 @ 03:34:24 PM
Script : http://www.***.org/admincp/usergroup.php?do=update
Referrer : http://www.***.org/admincp/usergroup...&usergroupid=6
IP Address :
Username :
Classname : vB_Database
----------------------------------------------------------------------------------

Thanks...

And that error.

Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT groupid
FROM grps
WHERE approved = '1';

MySQL Error : Table 'wenom_forum.grps' doesn't exist
Error Number : 1146
Date : Tuesday, February 13th 2007 @ 04:39:48 PM
Script : http://www.***.org/groups/
Referrer :
IP Address :
Username :
Classname : vB_Database

Alfa1 10-21-2007 04:10 PM

I have the same error. Does anyone have an idea what it is and how to solve it?

Paul M 10-21-2007 04:44 PM

fcpermissions belongs to my Flashchat Integration mod - you appear to have uninstalled the mod, but not removed the bitfield xml file.

Alfa1 12-24-2007 11:41 AM

I have the same error again. It seems as if this is connected to a hacking attack.
My chat room was working fine. Now it hangs, my chat admin shows an error message and my vbulletin user group administration shows an error as well.

Chat admin error:
Code:

vBulletin 3.6.x : Integration Error 03 : No permissions set for usergroup 6.
vbulletin usergroup admin error:
Code:

MySQL Error  : Unknown column 'fcpermissions' in 'field list'
Error Number : 1054


Paul M 12-24-2007 12:25 PM

Same as before - the field 'fcpermissions' has been removed from the usergroup table.

Alfa1 12-24-2007 03:09 PM

How does this happen and how do I resolve this?
My flashchat was running fine and I do not understand what has caused this.

Paul M 12-24-2007 03:50 PM

Someone or something runs a query to remove it.

If you uninstall the integration mod and then re-install it, it will recreate the field.

Alfa1 12-24-2007 04:29 PM

Done that and that fixed the problem. Though I am afraid it might happen again. I have addressed this here and here.

boxerman 02-27-2008 07:42 AM

It wasnt flash chat that did the problem... the error was u didnt unistall everything!


All times are GMT. The time now is 05:14 PM.

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.02054 seconds
  • Memory Usage 1,729KB
  • 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
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)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