• 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
    • Database Error on creating Areas

    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: Database Error on creating Areas

    • Issue Tools
      • View Changes
    1. issueid=5494 September 25, 2018 2:40 AM
      expanserpb expanserpb is offline
      Junior Member
      Database Error on creating Areas

      Attempted to create a new area to store pages for projects on the Wiki.

      Upon creating the Area, I received this error in the AdminCP:
      Server Error
      Database Error: SELECT * FROM `vw_lastupdate` WHERE nodetypeid = 3 AND nodeid = ORDER BY lastdateline DESC LIMIT 10 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 'ORDER BY lastdateline DESC LIMIT 10' at line 1

      vw_DB_Controller_XF->throw_error() in /var/www/html/vault/core/controller/db/xf.php at line 203
      vw_DB_Controller_XF->query_read() in /var/www/html/vault/core/model/db/mysql/vw.php at line 27
      vw_DB_MySQL_Model->select() in /var/www/html/vault/core/controller/dm/base/vw.php at line 1363
      vw_DM_Base_Controller->move_lastupdate() in /var/www/html/vault/core/controller/dm/area/vw.php at line 465
      vw_DM_Area_Controller->post_save_once() in /var/www/html/vault/core/controller/dm/area/xf.php at line 96
      vw_DM_Area_Controller_XF->_postSaveAfterTransaction() in XenForo/DataWriter.php at line 1437
      XenForo_DataWriter->save() in /var/www/html/vault/core/controller/dm/xf.php at line 431
      vw_DM_Controller_XF->save() in /var/www/html/vault/core/controller/cp/area/vw.php at line 490
      vw_CP_Area_Controller->do_save() in /var/www/html/vault/core/controller/cp/area/vw.php at line 167
      vw_CP_Area_Controller->process_save() in /var/www/html/vault/core/controller/cp/area/vw.php at line 152
      vw_CP_Area_Controller->save() in /var/www/html/vault/core/controller/cp/area/vw.php at line 65
      vw_CP_Area_Controller->execute() in vw/XenForo/ControllerAdmin/Wiki.php at line 125
      vw_XenForo_ControllerAdmin_Wiki->actionIndex() in XenForo/FrontController.php at line 369
      XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 152
      XenForo_FrontController->run() in /var/www/html/admin.php at line 13
      The Area was created. Upon navigating to the Area, I received this error:
      Server Error
      Invalid argument supplied for foreach()

      XenForo_Application::handlePhpError() in /var/www/html/vault/core/view/ui/area/vw.php at line 62
      vw_UI_Area_View->view() in /var/www/html/vault/core/controller/ui/area/vw.php at line 159
      vw_UI_Area_Controller->view() in /var/www/html/vault/core/controller/ui/stack/vw.php at line 374
      vw_UI_Stack_Controller->view() in /var/www/html/vault/core/controller/ui/stack/vw.php at line 290
      vw_UI_Stack_Controller->execute() in vw/XenForo/ControllerPublic/Wiki.php at line 70
      vw_XenForo_ControllerPublic_Wiki->actionIndex() in XenForo/FrontController.php at line 369
      XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 152
      XenForo_FrontController->run() in /var/www/html/index.php at line 13
      The Area could be edited. I edited the Display Order - changing it from 999 to 100. The edit went through and I could access the Area on the Wiki. I changed the Display Order back to 999 and I didn't receive a repeat error.

      The problem is repeatable by creating new Areas. Editing the Display Order removes the problem.
    Issue Details
    Issue Number 5494
    Issue Type Bug
    Project VaultWiki 4.x Series
    Category Areas
    Status Fixed
    Priority 3 - Loss of Functionality
    Affected Version 4.0.24
    Fixed Version 4.0.24
    Milestone (none)
    Software DependencyAny
    License TypePaid
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. September 25, 2018 9:24 AM
      pegasus pegasus is offline
      VaultWiki Team
      This occurs when creating a new area as a sub-area of an existing parent area. It is possible to avoid this error by creating the new area with no parent area first, then editing it to give it the desired parent area.

      In vault/core/controller/dm/area/vw.php, find:
      Code:
      if ($areaid != $old_areaid)
      Replace with:
      Code:
      if ($areaid != $old_areaid AND $this->instance->get_existing('pageid'))
      In lieu of a 4.0.24 build 003, this fix was included in the October patches by mistake. So if you installed the October 2018 patch, you should no longer experience this issue. The issue first appeared in 4.0.21.
      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 3:21 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 © 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.