• Register
    • Help

    striker  0 Items
    Currently Supporting
    • Home
    • News
    • Forum
    • Wiki
    • Support
      • Manage Subscriptions
      • FAQ
      • Support For
        • VaultWiki 4.x Series
        • VaultWiki.org Site
    • What's New?
    • Buy Now
    • Manual
    • 
    • Support
    • VaultWiki 3.x Series
    • Bug
    • Lamp forum upgrade issue oh sos

    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.

    Issue: Lamp forum upgrade issue oh sos

    • Issue Tools
      • View Changes
    1. issueid=747 August 1, 2009 10:04 AM
      Jella Jella is offline
      Regular Member
      Lamp forum upgrade issue oh sos
      seemed to go ok but

      you have logins.

      I upgraded everything and it seemed to go okay, also rebuilt and checked all permission ok.

      Only now:

      1. I cannot edit any wiki

      2. This error when clicking Title Protector, if there is no tiltle to protect, I get the following database error:
      Code:
      Database error in vBulletin 3.8.3:
      
      Invalid SQL:
      
      		SELECT protectid, namespaceid, title
      		FROM vault_protect
      		WHERE protectid IN ();
      
      MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3
      Error Number  : 1064
      Request Date  : Saturday, August 1st 2009 @ 09:51:42 AM
      Error Date    : Saturday, August 1st 2009 @ 09:51:42 AM
      Script        : http://tvlampforum.com/admincp/vaultwiki_protect.php?do=add
      Referrer      : http://tvlampforum.com/admincp/vaultwiki_protect.php?do=modify
      IP Address    : 98.229.123.186
      Username      : admin
      Classname     : vB_Database
      MySQL Version : 5.0.81-community
      and when going to Usergroups --> Administrator Permissions --> Edit Permissions and checking off the ones that are not checked such as (Can Administer HelpCenter, UMG etc...) I get the following error when saving:
      Code:
      Database error in vBulletin 3.8.3:
      
      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),
      	### Bitfield: administrator.garsadminperms ###
      		garsadminperms = IF(garsadminperms & 1, garsadminperms, garsadminperms + 1),
      	ptpermissions = 3,
      	### Bitfield: administrator.customumgpermissions ###
      		customumgpermissions = IF(customumgpermissions & 1, customumgpermissions, customumgpermissions + 1),
      	blogpermissions = 3,
      	admin_view_pm_log = 1,
      	### Bitfield: administrator.customadminperms ###
      		customadminperms = IF(customadminperms & 1, customadminperms, customadminperms + 1),
      	cssprefs = 'vBulletin_2_Default',
      	dismissednews = '61,63,74'
      WHERE userid = 1;
      
      MySQL Error   : Unknown column 'customadminperms' in 'field list'
      Error Number  : 1054
      Request Date  : Saturday, August 1st 2009 @ 10:03:16 AM
      Error Date    : Saturday, August 1st 2009 @ 10:03:16 AM
      Script        : http://tvlampforum.com/admincp/adminpermissions.php?do=update
      Referrer      : http://tvlampforum.com/admincp/adminpermissions.php?do=edit&u=1
      IP Address    : 98.229.123.186
      Username      : admin
      Classname     : vB_Database
      MySQL Version : 5.0.81-community
    Issue Details
    Issue Number 747
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Protection
    Status Fixed
    Priority 5 - Minor Bugs / Small Tweaks
    Affected Version 2.5.0
    Fixed Version 2.5.1
    Milestone (none)
    Software DependencyAny
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. August 1, 2009 2:17 PM
      pegasus pegasus is offline
      VaultWiki Team
      What happens when you try to edit a wiki page?

      'customadminperms' is not a field added by or used by VaultWiki. I will have a look for you.

      EDIT: Yup, it's used by your Help Center mod.
      Reply Reply  
    2. August 1, 2009 5:06 PM
      pegasus pegasus is offline
      VaultWiki Team
      It looks like you need to set forum permissions for your wiki forums again. Not sure what would have caused this, unless you recently reset them to inherit from the Lampipedia category?
      Reply Reply  
    3. August 1, 2009 6:36 PM
      Jella Jella is offline
      Regular Member
      There is no edit tab showing

      oh I see okay now I know where to look, I will report back
      Reply Reply  
    4. August 1, 2009 7:55 PM
      Jella Jella is offline
      Regular Member
      Well I disabled helpcenter, so that's done and it fixed those permission

      ... and I went through the Wiki settings but of course I can't seem to get it to work again.

      There is no edit tab showing, I disabled all the wiki's but that didn't help either

      and when I click on Title Protector then click UNPROTECT titles (even tho there are none to unprotect) I get this error
      Code:
      Warning: array_keys() [function.array-keys]: The first argument should be an array in [path]/admincp/vaultwiki_protect.php on line 106
      
      Warning: implode() [function.implode]: Invalid arguments passed in [path]/admincp/vaultwiki_protect.php on line 106
      Reply Reply  
    5. August 1, 2009 8:37 PM
      pegasus pegasus is offline
      VaultWiki Team
      Well, you are getting the errors in the title protector because as you say, there are no titles to unprotect.

      Your edit tab is not showing because your wiki permissions have all been disabled - they are now correctly inheriting custom permissions. See your AdminCP -> Forums & Moderators -> Forum Permissions for the wiki forums.
      Reply Reply  
    6. August 1, 2009 10:20 PM
      Jella Jella is offline
      Regular Member
      OK it seems to work now, thank you.

      But shouldn't when I click on unprotect even with nothing to unprotect, I get a page that says ' hey stupid, there is nothing to unprotect? instead of a database error???? Yes?

      One more thing, it seems 2.50 has different templates? When you create an article or image etc... I need to add a line break... one line break between the footer table and topic table, seen here in the image below... I have tried numerous templates but can't find it, can you help please.... this is the only place that needs a line break.

      I had the <br /> before the upgrade.

      Reply Reply  
    7. August 2, 2009 1:40 AM
      pegasus pegasus is offline
      VaultWiki Team
      Yes there should be an error message. I'll make sure that's added.

      The name of the template is vault_edit_newform
      Reply Reply  
    + Reply

    Assigned Users
    Loading Please Wait
    Tags
    Loading Please Wait
    • Contact Us
    • License Agreement
    • Privacy
    • Terms
    • Top
    All times are GMT -4. The time now is 1:59 AM.
    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.