Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 03-06-2007, 11:20 AM
geevest.com geevest.com is offline
 
Join Date: Apr 2006
Posts: 709
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default error in usergroup member

found error in admincp..i want edit my usergroup member,,and found this :
Quote:
Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Member',
`description` = 'user register',
`usertitle` = '',
`opentag` = '<span style=\"color:#21209C;\"><u>',
`closetag` = '</span></span></u>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`advanced_bbcode_usergroup_on` = '1',
`advpmoptions_options` = '0',
`profileviewpermissions` = '0',
`vbppermissions` = '4225',
`vbp_discountrate` = '0.00000',
`vbp_paycheckamount` = '0.00000',
`vbp_secondarycost` = '0.00000',
`vbp_primarycost` = '0.00000',
`uploaderperm` = '3',
`uploadermaxfilesize` = '200971',
`uploadermaxfoldesize` = '2104857',
`uploaderfilestypes` = 'jpg, jpe, jpeg, png, gif, txt, swf, rar, zip, doc, pdf',
`anymediapermissions` = '1',
`userratingperm` = '3',
`userratingday` = '0',
`forumpermissions` = '774655',
`attachlimit` = '0',
`pmquota` = '30',
`pmpermissions` = '2',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '0',
`adminpermissions` = '0',
`genericpermissions` = '2666587',
`genericoptions` = '54',
`profilepicmaxwidth` = '200',
`profilepicmaxheight` = '200',
`profilepicmaxsize` = '85535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '1024',
`signaturepermissions` = '0',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '20000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '60',
`awardpermissions` = '1',
`advanced_bbcode_permissions` = 'core||allow_bbcode_basic||1|||core||allow_bbcode_ color||1|||core||allow_bbcode_size||1|||core||allo w_bbcode_font||1|||core||allow_bbcode_align||1|||c ore||allow_bbcode_list||1|||core||allow_bbcode_url ||1|||core||allow_bbcode_code||1|||core||allow_bbc ode_php||1|||core||allow_bbcode_html||1|||non_core ||mod||0|||non_core||admin||0'
WHERE usergroupid=2;

MySQL Error : Unknown column 'profileviewpermissions' in 'field list'
Error Number : 1054
Date : Tuesday, March 6th 2007 @ 08:03:32 PM
Script : http://www.abc.com/forum/admincp/use....php?do=update
Referrer : http://www.abc.com/forum/admincp/use...&usergroupid=2
IP Address : 102.124.137.54
Username : admin
Classname : vb_database
anyone can help?
Reply With Quote
  #2  
Old 03-06-2007, 11:28 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You have probably removed a modification, but not remove the bitfield_XXX.xml file from the includes/xml directory.
Reply With Quote
  #3  
Old 03-06-2007, 11:37 AM
geevest.com geevest.com is offline
 
Join Date: Apr 2006
Posts: 709
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

modification of what?
module name?
Reply With Quote
  #4  
Old 03-07-2007, 05:45 PM
harmor19 harmor19 is offline
 
Join Date: Apr 2005
Posts: 1,324
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What are the files that you have in includes/xml that start with "bitfield_"?
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:11 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.03476 seconds
  • Memory Usage 2,182KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete