• 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
    • Task
    • Server 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: Server Error

    • Issue Tools
      • View Changes
    1. issueid=5049 May 3, 2017 1:30 PM
      CarlM24 CarlM24 is offline
      New Member
      Server Error
      XenForo_Exception: Database Error

      Hello,

      I have received the following server error:
      Code:
      Error Info
      
      XenForo_Exception: Database Error: SELECT `u`.*,`s`.`user_id` AS `userid`,`s`.`ip` AS `ipaddress` FROM `vw_session` `i` INNER JOIN `xf_session_activity` `s` ON (`s`.`unique_key` = `i`.`sessionid`) LEFT JOIN `xf_user` `u` ON (`u`.`user_id` = `s`.`user_id`) WHERE 1493807843 < `i`.`dateline` AND `in_area` IN () ORDER BY `i`.`dateline` DESC LIMIT 500 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 `i`.`dateline` DESC LIMIT 500' at line 2 - vault/core/controller/db/xf.php:173 
      Generated By: Prince Eric, Today at 11:52 AM
       
      
      Stack Trace
      
      #0 /home/crimecoa/public_html/vault/core/controller/db/xf.php(189): vw_DB_Controller_XF->throw_error(Object(Zend_Db_Statement_Mysqli_Exception), 'SELECT `u`.*,`s...')
      #1 /home/crimecoa/public_html/vault/core/model/db/mysql/vw.php(27): vw_DB_Controller_XF->query_read('SELECT `u`.*,`s...')
      #2 /home/crimecoa/public_html/vault/core/view/factory/browsers/vw.php(219): vw_DB_MySQL_Model->select(Array)
      #3 /home/crimecoa/public_html/vault/core/view/factory/browsers/vw.php(27): vw_Factory_Browsers_View->get_browsers('area', Array, false)
      #4 /home/crimecoa/public_html/vault/core/view/ui/area/vw.php(200): vw_Factory_Browsers_View->get_once('area', Array)
      #5 /home/crimecoa/public_html/vault/core/controller/ui/area/vw.php(157): vw_UI_Area_View->view(Object(vw_UI_Area_Controller))
      #6 /home/crimecoa/public_html/vault/core/controller/ui/stack/vw.php(359): vw_UI_Area_Controller->view()
      #7 /home/crimecoa/public_html/vault/core/controller/ui/stack/vw.php(286): vw_UI_Stack_Controller->view()
      #8 /home/crimecoa/public_html/library/vw/XenForo/ControllerPublic/Wiki.php(70): vw_UI_Stack_Controller->execute()
      #9 /home/crimecoa/public_html/library/XenForo/FrontController.php(351): vw_XenForo_ControllerPublic_Wiki->actionIndex()
      #10 /home/crimecoa/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
      #11 /home/crimecoa/public_html/index.php(13): XenForo_FrontController->run()
      #12 {main}
       
      
      Request State
      
      array(3) {
        ["url"] => string(49) "https://www.crimecoastforums.com/wiki/?title=Main"
        ["_GET"] => array(1) {
          ["title"] => string(4) "Main"
        }
        ["_POST"] => array(0) {
        }
      }
      Can you explain what has happened, how I can fix it and how to prevent it?

      Regards,
      Carl
    Issue Details
    Issue Number 5049
    Issue Type Task
    Project VaultWiki 4.x Series
    Category General
    Status Rejected
    Priority 4 - Warnings / Script Errors
    Target Version 4.0.17
    Resolved Version (none)
    Milestone (none)
    Software DependencyXenForo 1.x
    License TypePaid
    Votes to perform 0
    Votes not to perform 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. May 4, 2017 2:28 PM
      pegasus pegasus is offline
      VaultWiki Team
      This error occurs because the area called "Main" is damaged. In this case, its column value for vw_area.area_childlist, which will normally contain at least a copy of the vw_area.pageid field, is empty. How was the Main area created? Have you made any changes to the area recently, or received errors when creating/editing the area?

      Under normal operation, the area_childlist column should always have a value, except for a race condition when the pageid column is not populated yet; however, in that case, you would not be able to access the area yet and would not be able to trigger this error.
      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 11:49 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.