• Register
    • Help

    striker  0 Items
    Currently Supporting
    • Home
    • News
    • Forum
      • Try XenForo Demo
      • New Posts
      • FAQ
      • Calendar
      • Community
        • Groups
        • Albums
        • Member List
      • Forum Actions
        • Mark Forums Read
      • Quick Links
        • Today's Posts
        • Who's Online
      • Sponsor
        • Sponsor a Feature
        • List of Donors
    • Wiki
    • Support
    • What's New?
    • Buy Now
    • Manual
    • 
    • Forum
    • VaultWiki How-Tos
    • VaultWiki Questions
    • Database Error

    1. Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

      VaultWiki allows your existing forum users to collaborate on creating and managing a site's content pages. VaultWiki is a fully-featured and fully-supported wiki solution for vBulletin and XenForo.

      The VaultWiki Team encourages you to join our community of forum administrators and check out VaultWiki for yourself.

    Results 1 to 2 of 2

    Thread: Database Error

    • Thread Tools
      • Show Printable Version
    1. April 4, 2010 #1
      Blue6995
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • View Articles
      Blue6995 is offline
      Junior Member
      Join Date
      June 26, 2009
      Posts
      7
      Rep Power
      0

      Database Error

      I tried to update the UserGroup permissions to Yes for most options in Wiki. When I clicked on the Update button I got the following error message. I am assuming it's a Wiki error due to the line that says
      Code:
      MySQL Error   : Unknown column 'ms_wic_addon_permissions' in 'field list'
      The full message:
      Code:
      Database error in vBulletin 3.8.4:
      
      Invalid SQL:
      UPDATE vb3_usergroup SET
      
      ### UPDATE QUERY GENERATED BY fetch_query_sql() ###
      	`title` = 'Administrators',
      	`description` = '',
      	`usertitle` = 'Administrator',
      	`opentag` = '<font color = \"black\"><u><b>',
      	`closetag` = '</b></u></font>',
      	`passwordexpires` = '0',
      	`passwordhistory` = '0',
      	`forumpermissions` = '486539263',
      	`genericpermissions` = '2113929151',
      	`attachlimit` = '0',
      	`vbblog_general_permissions` = '524286',
      	`vbblog_customblocks` = '5',
      	`vbblog_custompages` = '5',
      	`vbblog_entry_permissions` = '24575',
      	`vbblog_comment_permissions` = '990',
      	`vault_permissions` = '255',
      	`specialpage_permissions` = '255',
      	`awardpermissions` = '1',
      	`c_news_letter_perms` = '0',
      	`creditpermissions` = '54',
      	`credit_induction` = '100',
      	`credit_referral` = '100',
      	`credit_refbonus` = '0.05',
      	`credit_paycheck` = '0',
      	`credit_active` = '10',
      	`credit_birthday` = '100',
      	`credit_repgive` = '0.1',
      	`credit_reputation` = '10',
      	`credit_infraction` = '-10',
      	`credit_thread` = '20',
      	`credit_threadrate` = '5',
      	`credit_post` = '5',
      	`credit_ownthreadpost` = '3',
      	`credit_postsize` = '0.1',
      	`credit_ownthreadview` = '0.05',
      	`credit_ownthreadrate` = '1',
      	`credit_ownthreadreply` = '2',
      	`credit_ownprofileview` = '0.05',
      	`credit_pollmake` = '10',
      	`credit_pollvote` = '3',
      	`credit_attachment` = '3',
      	`credit_sendpm` = '-2',
      	`credit_addevent` = '3',
      	`credit_addprofpic` = '3',
      	`credit_profile` = '0',
      	`credit_donmaxuser` = '-1',
      	`credit_pastotpost` = '0',
      	`credit_pastotuser` = '0',
      	`credit_pasawuser` = '0',
      	`credit_pasawthread` = '0',
      	`credit_saveint` = '0.035',
      	`credit_maxsave` = '10000',
      	`credit_loanint` = '0.195',
      	`credit_maxloan` = '1000',
      	`credit_totloan` = '5',
      	`credit_goodgroup` = '0',
      	`credit_midgroup` = '0',
      	`credit_badgroup` = '0',
      	`credit_maxtickets` = '10',
      	`credit_lotdiscount` = '0',
      	`memberindex` = '0',
      	`vault_misc` = '0',
      	`sf_permissions` = '31',
      	`pmquota` = '100',
      	`pmpermissions` = '7',
      	`pmsendmax` = '5',
      	`pmthrottlequantity` = '0',
      	`calendarpermissions` = '63',
      	`wolpermissions` = '31',
      	`adminpermissions` = '3',
      	`genericpermissions2` = '1',
      	`genericoptions` = '63',
      	`profilepicmaxwidth` = '200',
      	`profilepicmaxheight` = '200',
      	`profilepicmaxsize` = '65535',
      	`avatarmaxwidth` = '80',
      	`avatarmaxheight` = '80',
      	`avatarmaxsize` = '20000',
      	`signaturepermissions` = '235519',
      	`sigpicmaxwidth` = '500',
      	`sigpicmaxheight` = '100',
      	`sigpicmaxsize` = '20000',
      	`sigmaxrawchars` = '0',
      	`sigmaxchars` = '0',
      	`sigmaxlines` = '0',
      	`sigmaxsizebbcode` = '7',
      	`sigmaximages` = '0',
      	`albumpermissions` = '255',
      	`albumpicmaxwidth` = '600',
      	`albumpicmaxheight` = '600',
      	`albumpicmaxsize` = '100000',
      	`albummaxpics` = '100',
      	`albummaxsize` = '0',
      	`usercsspermissions` = '63',
      	`visitormessagepermissions` = '62',
      	`socialgrouppermissions` = '65535',
      	`maximumsocialgroups` = '5',
      	`groupiconmaxsize` = '65535',
      	`ms_wic_addon_permissions` = '0'
      WHERE usergroupid=6;
      
      MySQL Error   : Unknown column 'ms_wic_addon_permissions' in 'field list'
      Error Number  : 1054
      Request Date  : Sunday, April 4th 2010 @ 01:00:51 AM
      Error Date    : Sunday, April 4th 2010 @ 01:00:51 AM
      Script        : http://www.rwf-forum.co.uk/vBulletin/admincp/usergroup.php?do=update
      Referrer      : http://www.rwf-forum.co.uk/vBulletin/admincp/usergroup.php?do=edit&usergroupid=6
      IP Address    : 94.195.159.114
      Username      : xxxxxxxxxxx
      Classname     : vB_Database
      MySQL Version : 5.0.89-community-log
      Reply With Quote Reply With Quote

    2. April 4, 2010 #2
      pegasus
      • View Profile
      • View Forum Posts
      • View Blog Entries
      • Visit Homepage
      • View Articles
      pegasus is offline
      VaultWiki Team
      Join Date
      March 28, 2004
      Location
      New York, NY
      Posts
      2,934
      Blog Entries
      18
      Rep Power
      659
      That field is not from this product. I don't know what product it is. If you don't have its product installed, then you'll want to delete the bitfield file in includes/xml/ for it. I can't tell you the exact file name you want to delete either for the same reasons.
      - lead developer for VaultWiki
      Reply With Quote Reply With Quote

    Similar Threads

    1. Oh suddendly database error tracked to a vault file, help please
      By Jella in forum VaultWiki Questions
      Replies: 3
      Last Post: April 10, 2011, 11:27 PM
    2. database error
      By mickknutson in forum VaultWiki Questions
      Replies: 1
      Last Post: October 6, 2009, 4:20 AM
    3. Database error when editing the name of a Book
      By mickknutson in forum VaultWiki Questions
      Replies: 1
      Last Post: May 3, 2009, 11:52 PM
    4. Database error VaultWki
      By TTG in forum VaultWiki Questions
      Replies: 3
      Last Post: January 5, 2009, 9:28 PM
    5. Database Error
      By mangus580 in forum VaultWiki Questions
      Replies: 5
      Last Post: November 6, 2008, 7:16 AM

    Tags for this Thread

    addon, admincp, attachment, but, button, color, community, database, description, don, due, error, field, full, general, http, its, know, line, list, message, most, name, news, open, options, own, permissions, php, post, reputation, same, size, that, thread, title, try, unknown, update, url, usergroup, vault, vbulletin, version, wiki, www, xml, you

    View Tag Cloud

    Bookmarks

    Bookmarks
    • Submit to Digg Digg
    • Submit to del.icio.us del.icio.us
    • Submit to StumbleUpon StumbleUpon
    • Submit to Google Google

    Posting Permissions

    • 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 Off
    • [VIDEO] code is
    • HTML code is Off

    Forum Rules

    • Contact Us
    • License Agreement
    • Privacy
    • Terms
    • Top
    All times are GMT -4. The time now is 3:07 PM.
    This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Learn more… Accept Remind me later
  • striker
    Powered by vBulletin® Version 4.2.5 Beta 2
    Copyright © 2023 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
    Copyright © 2008 - 2013 VaultWiki Team, Cracked Egg Studios, LLC.