• 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
    • Mysqli statement execute error : Can't write; duplicate key in table 'vw_route'

    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: Mysqli statement execute error : Can't write; duplicate key in table 'vw_route'

    • Issue Tools
      • View Changes
    1. issueid=5114 June 17, 2017 12:18 PM
      SeToY SeToY is offline
      Junior Member
      Mysqli statement execute error : Can't write; duplicate key in table 'vw_route'
      Mysqli statement execute error : Can't write; duplicate key in table 'vw_route'

      Hello,

      after approving a page edit in the moderation queue, the following error is created:

      Code:
      Server Error
      
      Mysqli statement execute error : Can't write; duplicate key in table 'vw_route'
      
      Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
      Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
      Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 632
      Zend_Db_Adapter_Abstract->update() in XenForo/DataWriter.php at line 1654
      XenForo_DataWriter->_update() in XenForo/DataWriter.php at line 1623
      XenForo_DataWriter->_save() in vw/XenForo/DataWriter.php at line 356
      vw_XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1419
      XenForo_DataWriter->save() in C:/inetpub/wwwroot/domain.com/vault/core/controller/dm/xf.php at line 415
      vw_DM_Controller_XF->save() in C:/inetpub/wwwroot/domain.com/vault/core/controller/dm/base/routable/vw.php at line 480
      vw_DM_Base_Routable_Controller->save_path() in vw/XenForo/DataWriter.php at line 92
      vw_XenForo_DataWriter->__call() in C:/inetpub/wwwroot/domain.com/vault/core/controller/dm/vw.php at line 100
      vw_DM_Page_Controller_XF->save_path() in C:/inetpub/wwwroot/domain.com/vault/core/controller/dm/vw.php at line 100
      vw_DM_Controller->__call() in C:/inetpub/wwwroot/domain.com/vault/core/controller/dm/revision/vw.php at line 488
      vw_DM_Controller_XF->save_path() in C:/inetpub/wwwroot/domain.com/vault/core/controller/dm/revision/vw.php at line 488
      vw_DM_Revision_Controller->post_save_each() in vw/XenForo/DataWriter.php at line 492
      vw_XenForo_DataWriter->_postSave() in XenForo/DataWriter.php at line 1423
      XenForo_DataWriter->save() in C:/inetpub/wwwroot/domain.com/vault/core/controller/dm/xf.php at line 415
      vw_DM_Controller_XF->save() in vw/XenForo/ModerationQueueHandler/vw.php at line 142
      vw_XenForo_ModerationQueueHandler_vw->approveModerationQueueEntry() in XenForo/Model/ModerationQueue.php at line 200
      XenForo_Model_ModerationQueue->saveModerationQueueChanges() in vw/XenForo/Model/ModerationQueue.php at line 219
      vw_XenForo_Model_ModerationQueue->saveModerationQueueChanges() in SV/UserEss/XenForo/Model/ModerationQueue.php at line 43
      SV_UserEss_XenForo_Model_ModerationQueue->saveModerationQueueChanges() in XenForo/ControllerPublic/ModerationQueue.php at line 74
      XenForo_ControllerPublic_ModerationQueue->actionSave() in XenForo/FrontController.php at line 351
      XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
      XenForo_FrontController->run() in C:/inetpub/wwwroot/domain.com/index.php at line 13
    Issue Details
    Issue Number 5114
    Issue Type Bug
    Project VaultWiki 4.x Series
    Category Moderator Tools
    Status Cannot Reproduce
    Priority 2 - Fatal / Database Errors
    Affected Version 4.0.18
    Fixed Version (none)
    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. June 17, 2017 1:27 PM
      pegasus pegasus is offline
      VaultWiki Team
      Can you reproduce this error consistently? It looks like it should only be possible as a race condition (by deleting the content at the same time that the approval is submitted twice). Under such a race condition, a database error is the expected behavior.

      If you can reproduce this consistently, please submit a support ticket. I don't have this issue with moderated edits on my test site.
      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:37 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.