• 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 4.x Series
    • Bug
    • XenForo_Exception: 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.

    Issue: XenForo_Exception: Database Error

    • Issue Tools
      • View Changes
    1. issueid=4871 January 9, 2017 11:59 AM
      hollosch hollosch is offline
      Senior Member
      XenForo_Exception: Database Error

      Code:
      Fehlerinformation
      XenForo_Exception: Database Error: SELECT permissionid FROM `vw_permission` WHERE applytypeid = 1 AND applyid = AND nodetypeid = 3 AND nodeid = Mysqli prepare 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 'AND nodetypeid = 3 AND nodeid =' at line 1 - vault/core/controller/db/xf.php:173
      Generiert durch: hollosch, Vor einer Minute
      Stapelverfolgung
      #0 ../vault/core/controller/db/xf.php(254): vw_DB_Controller_XF->throw_error(Object(Zend_Db_Statement_Mysqli_Exception), 'SELECT permissi...')
      #1 ../vault/core/model/db/mysql/vw.php(27): vw_DB_Controller_XF->query_first('SELECT permissi...')
      #2 ../vault/core/controller/dm/permissions/vw.php(255): vw_DB_MySQL_Model->select(Array)
      #3 ../library/vw/XenForo/DataWriter.php(477): vw_DM_Permissions_Controller->pre_save(true)
      #4 ../library/XenForo/DataWriter.php(1460): vw_XenForo_DataWriter->_preSave()
      #5 ../library/vw/XenForo/DataWriter.php(186): XenForo_DataWriter->preSave()
      #6 ../vault/core/controller/dm/xf.php(375): vw_XenForo_DataWriter->preSaveWithReturn()
      #7 ../library/vw/XenForo/DataWriter.php(181): vw_DM_Controller_XF->pre_save()
      #8 ../library/XenForo/DataWriter.php(1399): vw_XenForo_DataWriter->preSave()
      #9 ../vault/core/controller/dm/xf.php(408): XenForo_DataWriter->save()
      #10 ../vault/core/controller/cp/area/vw.php(514): vw_DM_Controller_XF->save()
      #11 ../vault/core/controller/cp/area/vw.php(163): vw_CP_Area_Controller->do_save()
      #12 ../vault/core/controller/cp/area/vw.php(148): vw_CP_Area_Controller->process_save(Array)
      #13 ../vault/core/controller/cp/area/vw.php(65): vw_CP_Area_Controller->save()
      #14 ../library/vw/XenForo/ControllerAdmin/Wiki.php(118): vw_CP_Area_Controller->execute('save', 'post')
      #15 ../library/XenForo/FrontController.php(351): vw_XenForo_ControllerAdmin_Wiki->actionIndex()
      #16 ../library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
      #17 ../admin.php(13): XenForo_FrontController->run()
      #18 {main}
      Benötigter Status
      array(3) {
        ["url"] => string(59) "http://regio-portal.wiki/admin.php?wiki/&panel=area&do=save"
        ["_GET"] => array(3) {
          ["wiki/"] => string(0) ""
          ["panel"] => string(4) "area"
          ["do"] => string(4) "save"
        }
        ["_POST"] => array(20) {
          ["panel"] => string(4) "area"
          ["do"] => string(4) "save"
          ["_xfToken"] => string(8) "********"
          ["baseid"] => string(1) "4"
          ["title"] => string(10) "JUGENDWIKI"
          ["parentid"] => string(1) "0"
          ["displayorder"] => string(3) "110"
          ["autoprotect"] => string(1) "0"
          ["prefixlist"] => array(1) {
            [0] => string(11) "[No Prefix]"
          }
          ["allowtypes"] => array(2) {
            [1] => string(4) "page"
            [14] => string(8) "redirect"
          }
          ["langlist"] => array(1) {
            [0] => string(12) "Any Language"
          }
          ["topiclist"] => array(1) {
            [0] => string(19) "User-Created Topics"
          }
          ["sort"] => string(10) "lastupdate"
          ["sortorder"] => string(4) "desc"
          ["sortfilter"] => string(1) "0"
          ["options"] => array(10) {
            ["list_tiled"] => string(1) "0"
            ["page_img"] => string(1) "2"
            ["page_bbcode"] => string(1) "4"
            ["page_media"] => string(4) "4096"
            ["comment_img"] => string(2) "32"
            ["comment_bbcode"] => string(2) "64"
            ["comment_smile"] => string(3) "128"
            ["comment_media"] => string(4) "8192"
            ["page_header"] => string(1) "1"
            ["uncrawlable"] => string(1) "0"
          }
          [-2] => string(1) "0"
          ["blocklist"] => array(5) {
            [1] => string(13) "Suche im Wiki"
            [2] => string(19) "Letzte Aktivitäten"
            [3] => string(1) "3"
            [4] => string(1) "4"
            [7] => string(1) "7"
          }
          ["sbutton"] => string(9) "Speichern"
          ["url"] => string(51) "http://regio-portal.wiki/admin.php?wiki/&panel=area"
        }
      }
    Issue Details
    Issue Number 4871
    Issue Type Bug
    Project VaultWiki 4.x Series
    Category Areas
    Status Fixed
    Priority 1 - Security / Login / Data Loss
    Affected Version 4.0.16
    Fixed Version 4.0.16
    Milestone (none)
    Software DependencyXenForo 1.x
    License TypePaid
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. January 10, 2017 8:50 AM
      pegasus pegasus is offline
      VaultWiki Team
      This error occurs whenever saving permissions fails because the usergroup or userid associated with those permissions does not exist. In that case, the required IDs are not available to use for a query. However, it is not necessary to execute the query if the permissions will not save anyway.

      In your case, by creating an area based on another area, you have attempted to copy permissions from an existing area, and the existing area contains permissions for usergroups or users that do not exist. If the new area is a sub-area of the existing one, then the permissions would be inherited anyway.

      This error does not prevent the new area from being created or otherwise working properly, but some permissions were not able to be copied from the old area.

      Looking at the code changes, this issue has existed for about a year in its current form and about 2 years in its most generic form. It will be fixed in the next build, but based on the frequency and severity of the issue, there doesn't appear to be a need to rush that.

      A quick fix would be to edit vault/core/controller/dm/permissions/vw.php. Find:
      Code:
      $duplicate_check = vw_DB::get()->query()->select(array(
      Before it, add:
      Code:
      if (!$this->instance->_isset('applytypeid') OR !$this->instance->_isset('applyid') OR !$this->instance->_isset('nodetypeid') OR !$this->instance->_isset('nodeid')) return false;
      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 5:08 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 © 2025 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
    Copyright © 2008 - 2024 VaultWiki Team, Cracked Egg Studios, LLC.