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 has me stumped. (https://vborg.vbsupport.ru/showthread.php?t=142459)

MyArcade 03-18-2007 09:13 PM

Database Error has me stumped.
 
I get this error when trying to modify usergroup manager permissions anyone have any tips or ideas on how to make this go away?

Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`awardpermissions` = '1',
`fcpermissions` = '0',
`vbimghost` = '1',
`vbimghost_upslots` = '3',
`vbimghost_files` = '200',
`vbppermissions` = '21377',
`vbp_discountrate` = '0.00000',
`vbp_paycheckamount` = '0.00000',
`vbp_secondarycost` = '0.00000',
`vbp_primarycost` = '0.00000',
`forumpermissions` = '782847',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions` = '472389319',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '200000',
`signaturepermissions` = '235519',
`sigpicmaxwidth` = '300',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '200000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`rpgpermissions` = '1',
`arcadepermissions` = '15',
`minpoststoplay` = '0',
`minreptoplay` = '-1000',
`minreglengthtoplay` = '0'
WHERE usergroupid=2;

MySQL Error : Unknown column 'fcpermissions' in 'field list'
Error Number : 1054
Date : Sunday, March 18th 2007 @ 05:10:25 PM
Script : http://www.myarcadeplanet.com/home/a....php?do=update
Referrer : http://www.myarcadeplanet.com/home/a...&usergroupid=2
IP Address : 67.35.83.236
Username : XFactorX
Classname : vb_database

Chicago_VLNU_4s 03-19-2007 02:19 AM

do you have the hide hack? I have to diasable the hide hack whenever I edit a usergroup. Not saying that it's the hide hack, but I bet it's one of your hacks that's causing this trial and error. Try disabling hack after hack until you've found the one effecting it.. then disable that hack everytime you want to edit a usergroup

Marco van Herwaarden 03-19-2007 12:28 PM

You have removed a modification, but did not remove the includes/xml/bitfield_XX.xml file for that modification.

MyArcade 03-25-2007 02:40 PM

I did have some stranded XML files deleted but that did not seem to work, I am now proceeding to disable a hack one by one see if that works.

Problem Fixed. Flashchat Integration hack is doing this hence "Fcpermissions".

dirtycrow 03-27-2007 03:12 AM

Quote:

Originally Posted by Marco van Herwaarden (Post 1207268)
You have removed a modification, but did not remove the includes/xml/bitfield_XX.xml file for that modification.

i have a simliar issue. is there ahy way of telling by the error what the mod was?

blueberry 05-10-2007 11:52 AM

MYarcade thanks alot.. you saved me... i had this error for 3 days now and i was trying to solve it with no success... i disabled flash chat and it worked fine :)


All times are GMT. The time now is 01:10 AM.

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.01054 seconds
  • Memory Usage 1,725KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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