Announcement

Collapse
No announcement yet.

Unable to save administrator permissions

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Unable to save administrator permissions

    Hello,

    If I try and edit any admin permissions (even my own) and click save, the forum gives me the following db error. I have removed the VBCPMS product so I'm wondering why it's still giving me this error.

    Invalid SQL:
    UPDATE administrator SET
    ### Bitfield: administrator.adminpermissions ###
    adminpermissions = IF(adminpermissions & 4, adminpermissions, adminpermissions + 4),
    adminpermissions = IF(adminpermissions & 8, adminpermissions, adminpermissions + 8),
    adminpermissions = IF(adminpermissions & 16, adminpermissions, adminpermissions + 16),
    adminpermissions = IF(adminpermissions & 32, adminpermissions, adminpermissions + 32),
    adminpermissions = IF(adminpermissions & 64, adminpermissions, adminpermissions + 64),
    adminpermissions = IF(adminpermissions & 128, adminpermissions, adminpermissions + 128),
    adminpermissions = IF(adminpermissions & 256, adminpermissions, adminpermissions + 256),
    adminpermissions = IF(adminpermissions & 512, adminpermissions, adminpermissions + 512),
    adminpermissions = IF(adminpermissions & 1024, adminpermissions, adminpermissions + 1024),
    adminpermissions = IF(adminpermissions & 2048, adminpermissions, adminpermissions + 2048),
    adminpermissions = IF(adminpermissions & 4096, adminpermissions, adminpermissions + 4096),
    adminpermissions = IF(adminpermissions & 8192, adminpermissions, adminpermissions + 8192),
    adminpermissions = IF(adminpermissions & 16384, adminpermissions, adminpermissions + 16384),
    adminpermissions = IF(adminpermissions & 65536, adminpermissions, adminpermissions + 65536),
    adminpermissions = IF(adminpermissions & 131072, adminpermissions, adminpermissions + 131072),
    adminpermissions = IF(adminpermissions & 262144, adminpermissions, adminpermissions + 262144),
    adminpermissions = IF(adminpermissions & 524288, adminpermissions - 524288, adminpermissions),
    adminpermissions = IF(adminpermissions & 1048576, adminpermissions - 1048576, adminpermissions),
    adminpermissions = IF(adminpermissions & 2097152, adminpermissions, adminpermissions + 2097152),
    adminpermissions = IF(adminpermissions & 4194304, adminpermissions, adminpermissions + 4194304),
    adminpermissions = IF(adminpermissions & 8388608, adminpermissions, adminpermissions + 8388608),
    ### Bitfield: administrator.dtogarageperms ###
    dtogarageperms = IF(dtogarageperms & 1, dtogarageperms - 1, dtogarageperms),
    admin_log_in_as_user = 1,
    vbgadminperms = 1,
    ### Bitfield: administrator.dbtech_thanksadminperms ###
    dbtech_thanksadminperms = IF(dbtech_thanksadminperms & 1, dbtech_thanksadminperms - 1, dbtech_thanksadminperms),
    vbcmspermissions = 0,
    ### Bitfield: administrator.dtovendoradminperms ###
    dtovendoradminperms = IF(dtovendoradminperms & 1, dtovendoradminperms - 1, dtovendoradminperms),
    cssprefs = 'vBulletin_3_Default',
    dismissednews = '1,8,11,13,15,18,24,31,34,37,41,42,44,46,49,54,55,61,63,66,67,68,74,79,81,84,86,88,90,91,9 2,93,94,95,97,98,102,103,105,107,111,113,120,122,124,125,126,127,134,138,141,142,143,149,1 51,152,153,155,156,158,160,161,162,163,166,167,174,175,177,178,182,183,184,185,186,187'
    WHERE userid = 1;

    MySQL Error : Unknown column 'vbcmspermissions' in 'field list'
    Error Number : 1054
    Request Date : Friday, January 31st 2020 @ 09:36:39 AM
    Error Date : Friday, January 31st 2020 @ 09:36:39 AM
    Script : http://www.montrealracing.com/forums....php?do=update
    Referrer : https://www.montrealracing.com/forum...hp?do=edit&u=1
    Danny
    My Site ---->www.montrealracing.com

  • #2
    It is giving the error because you removed the CMS. You should reinstall the CMS product. If you do not want to use the CMS, you can disable it instead of removing it.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X