Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #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


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 07:45 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.05674 seconds
  • Memory Usage 2,190KB
  • 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