• 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
    • Another upgrade error for 4.04

    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: Another upgrade error for 4.04

    • Issue Tools
      • View Changes
    1. issueid=4358 August 5, 2015 1:55 PM
      rizwank rizwank is offline
      New Member
      Another upgrade error for 4.04
      Undefined index creator id when upgrading XF

      Code:
      Updating data in table: xf_search_index
      Undefined index: creatorid
      vw_CP_Progress_View->handle_php_error() in library/vw/XenForo/Search/DataHandler/vwPage.php at line 23
      vw_XenForo_Search_DataHandler_vwPage->_insertIntoIndex() in library/XenForo/Search/DataHandler/Abstract.php at line 275
      XenForo_Search_DataHandler_Abstract->insertIntoIndex() in vault/core/controller/install/upgradepath/steps/4/0/4/C/xf.php at line 98
      vw_Install_UpgradePath_Steps_404_C_Controller_XF->{closure}() in vault/core/controller/install/upgradepath/vw.php at line 63
      vw_Install_UpgradePath_Controller->call() in vault/core/controller/cp/install/vw.php at line 344
      vw_CP_Install_Controller->exec_step() in vault/core/controller/cp/install/vw.php at line 309
      vw_CP_Install_Controller->upgrade_type() in vault/core/controller/cp/install/vw.php at line 246
      vw_CP_Install_Controller->upgrade() in vault/core/controller/cp/install/vw.php at line 65
      vw_CP_Install_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 113
      vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 170
      vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in library/XenForo/FrontController.php at line 347
      XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
      XenForo_FrontController->run() in admin.php at line 13
    Issue Details
    Issue Number 4358
    Issue Type Bug
    Project VaultWiki 4.x Series
    Category Install / Upgrade
    Status Duplicate
    Priority 2 - Fatal / Database Errors
    Affected Version 4.0.4
    Fixed Version (none)
    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. August 5, 2015 1:57 PM
      rizwank rizwank is offline
      New Member
      Is there a manual SQL statement to fix?

      also tried to refresh install, now have

      Step 3
      Code:
      Updating data in table: vw_route
      An exception occurred: Database Error: SELECT `l`.*,`ch`.*,`c`.*,`i`.*,`r`.*,`page`.*,`likes`.`likes`,`likes`.`like_users`, IF(`sub`.`userid`, 1, 0) AS `issubscribed`,`mk`.`readtime`,`l`.`userid` AS `translate_userid`,`ch`.`userid` AS `chapter_userid`,`r`.`dateline` AS `edit_dateline`,`r`.`flags` + 0 AS `flags`,`r`.`parentid` AS `edit_parentid`,`page`.`pageid` FROM `vw_page` `page` LEFT JOIN `vw_route` `i` ON (`page`.`pageid` = `i`.`itemid` AND `i`.`itemtypeid` = 1) LEFT JOIN `vw_counter` `c` ON (`c`.`pageid` = `page`.`pageid`) LEFT JOIN `vw_revision` `r` ON (`r`.`revisionid` = `page`.`revisionid`) LEFT JOIN `vw_chapter` `ch` ON (`page`.`pageid` = `ch`.`pageid`) LEFT JOIN `vw_langitem` `l` ON (`page`.`pageid` = `l`.`pageid`) LEFT JOIN `vw_markread` `mk` ON (`mk`.`itemtypeid` = 1 AND `mk`.`itemid` = `page`.`pageid` AND `mk`.`userid` = 1) LEFT JOIN `vw_subscribe` `sub` ON (`sub`.`nodetypeid` = 1 AND `sub`.`nodeid` = `page`.`pageid` AND `sub`.`userid` = 1) LEFT JOIN `vw_likes` `likes` ON (`likes`.`itemtypeid` = 1 AND `likes`.`itemid` = `page`.`pageid`) WHERE `page`.`pageid` IN (1) LIMIT 1 Mysqli prepare error: Unknown column 'c.pageid' in 'on clause' in /var/www/html/forum/vault/core/controller/db/xf.php on line 146
      vw_DB_Controller_XF->throw_error() in vault/core/controller/db/xf.php at line 160
      vw_DB_Controller_XF->query_read() in vault/core/model/db/mysql/vw.php at line 29
      vw_DB_MySQL_Model->select() in vault/core/controller/fetch/vw.php at line 211
      vw_Fetch_Controller->get() in vault/core/controller/install/upgradepath/steps/4/0/4/base/vw.php at line 191
      vw_Install_UpgradePath_Steps_404_base_Controller->{closure}() in vault/core/controller/install/upgradepath/vw.php at line 63
      vw_Install_UpgradePath_Controller->call() in vault/core/controller/cp/install/vw.php at line 344
      vw_CP_Install_Controller->exec_step() in vault/core/controller/cp/install/vw.php at line 309
      vw_CP_Install_Controller->upgrade_type() in vault/core/controller/cp/install/vw.php at line 246
      vw_CP_Install_Controller->upgrade() in vault/core/controller/cp/install/vw.php at line 65
      vw_CP_Install_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 113
      vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 170
      vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in library/XenForo/FrontController.php at line 347
      XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
      XenForo_FrontController->run() in admin.php at line 13
      Reply Reply
    2. August 5, 2015 2:02 PM
      rizwank rizwank is offline
      New Member
      Skipped Step 3, now stuck at

      Step 13
      Code:
      Updating data in table: xf_search_index
      An exception occurred: Mysqli statement execute error : Column 'content_id' cannot be null in /var/www/html/forum/library/Zend/Db/Statement/Mysqli.php on line 214
      Zend_Db_Statement_Mysqli->_execute() in library/Zend/Db/Statement.php at line 297
      Zend_Db_Statement->execute() in library/Zend/Db/Adapter/Abstract.php at line 479
      Zend_Db_Adapter_Abstract->query() in library/XenES/Model/Elasticsearch.php at line 301
      XenES_Model_Elasticsearch->logFailedIndex() in library/XenES/Search/SourceHandler/ElasticSearch.php at line 960
      XenES_Search_SourceHandler_ElasticSearch->_logFailedIndex() in library/XenES/Search/SourceHandler/ElasticSearch.php at line 64
      XenES_Search_SourceHandler_ElasticSearch->insertIntoIndex() in library/XenForo/Search/Indexer.php at line 44
      XenForo_Search_Indexer->insertIntoIndex() in library/vw/XenForo/Search/DataHandler/Base.php at line 32
      vw_XenForo_Search_DataHandler_Base->_insertIntoIndex() in library/vw/XenForo/Search/DataHandler/vwPage.php at line 25
      vw_XenForo_Search_DataHandler_vwPage->_insertIntoIndex() in library/XenForo/Search/DataHandler/Abstract.php at line 275
      XenForo_Search_DataHandler_Abstract->insertIntoIndex() in vault/core/controller/install/upgradepath/steps/4/0/4/C/xf.php at line 98
      vw_Install_UpgradePath_Steps_404_C_Controller_XF->{closure}() in vault/core/controller/install/upgradepath/vw.php at line 63
      vw_Install_UpgradePath_Controller->call() in vault/core/controller/cp/install/vw.php at line 344
      vw_CP_Install_Controller->exec_step() in vault/core/controller/cp/install/vw.php at line 309
      vw_CP_Install_Controller->upgrade_type() in vault/core/controller/cp/install/vw.php at line 246
      vw_CP_Install_Controller->upgrade() in vault/core/controller/cp/install/vw.php at line 65
      vw_CP_Install_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 113
      vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 170
      vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in library/XenForo/FrontController.php at line 347
      XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
      XenForo_FrontController->run() in admin.php at line 13
      Reply Reply
    3. August 5, 2015 2:20 PM
      rizwank rizwank is offline
      New Member
      Manual mode shows the above :
      Code:
      Updating data in table: xf_search_index
      Undefined index: creatorid
      vw_CP_Progress_View->handle_php_error() in library/vw/XenForo/Search/DataHandler/vwPage.php at line 23
      vw_XenForo_Search_DataHandler_vwPage->_insertIntoIndex() in library/XenForo/Search/DataHandler/Abstract.php at line 275
      XenForo_Search_DataHandler_Abstract->insertIntoIndex() in vault/core/controller/install/upgradepath/steps/4/0/4/C/xf.php at line 98
      vw_Install_UpgradePath_Steps_404_C_Controller_XF->{closure}() in vault/core/controller/install/upgradepath/vw.php at line 63
      vw_Install_UpgradePath_Controller->call() in vault/core/controller/cp/install/vw.php at line 344
      vw_CP_Install_Controller->exec_step() in vault/core/controller/cp/install/vw.php at line 309
      vw_CP_Install_Controller->upgrade_type() in vault/core/controller/cp/install/vw.php at line 246
      vw_CP_Install_Controller->upgrade() in vault/core/controller/cp/install/vw.php at line 65
      vw_CP_Install_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 113
      vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 170
      vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in library/XenForo/FrontController.php at line 347
      XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
      XenForo_FrontController->run() in admin.php at line 13
      Reply Reply
    4. August 5, 2015 2:32 PM
      pegasus pegasus is offline
      VaultWiki Team
      Skip the search index step and just rebuild it manually from the adminCP after the upgrade. Yes it's true you cannot run the 4.0.4 steps twice that's why you get a lot of these errors.
      Reply Reply
    5. August 5, 2015 2:41 PM
      rizwank rizwank is offline
      New Member
      Code:
      Importing phrases
      An exception occurred: Mysqli statement execute error : Duplicate entry 'area_allowtypes_option_attach-0' for key 'title' in /var/www/html/forum/library/Zend/Db/Statement/Mysqli.php on line 214
      Reply Reply
    6. August 6, 2015 9:13 AM
      pegasus pegasus is offline
      VaultWiki Team
      The duplicate phrase issue is a known issue that can only happen if you accidentally double-click the Next Step or Next batch button to start the phrase step. It creates a race condition where the first click creates the phrase and then the second click tries to create the same phrase. There is no way to avoid an error in that case. But if you refresh the installer after the error, it should detect that the phrase was made already and skip it.

      These were all duplicate error reports, which were fixed in the installer in 4.0.5. Closing this as a duplicate.
      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 4:44 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.