• 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
    • Error creating new area

    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: Error creating new area

    • Issue Tools
      • View Changes
    1. issueid=4289 May 6, 2015 5:56 AM
      hollosch hollosch is offline
      Senior Member
      Error creating new area

      Code:
      ErrorException: Invalid argument supplied for foreach() - vault/core/controller/dm/revision/vw.php:715
      Generiert durch: hollosch, Vor einem Moment
      Stapelverfolgung
      
      #0 /../vault/core/controller/dm/revision/vw.php(715): XenForo_Application::handlePhpError(2, 'Invalid argumen...', '/var/www/vhosts...', 715, Array)
      #1 /../vault/core/controller/dm/base/vw.php(929): vw_DM_Revision_Controller->affected_nodes(Array, false)
      #2 /../vault/core/controller/dm/revision/vw.php(288): vw_DM_Base_Controller->rebuild_lastupdate(7, Array, true)
      #3 /../library/vw/XenForo/DataWriter.php(456): vw_DM_Revision_Controller->post_save_each()
      #4 /../library/XenForo/DataWriter.php(1409): vw_XenForo_DataWriter->_postSave()
      #5 /../vault/core/controller/dm/xf.php(400): XenForo_DataWriter->save()
      #6 /../vault/core/controller/dm/page/vw.php(1562): vw_DM_Controller_XF->save()
      #7 /../vault/core/controller/dm/page/vw.php(1310): vw_DM_Page_Controller->save_revision()
      #8 /../library/vw/XenForo/DataWriter.php(456): vw_DM_Page_Controller->post_save_each()
      #9 /../library/XenForo/DataWriter.php(1409): vw_XenForo_DataWriter->_postSave()
      #10 /../vault/core/controller/dm/xf.php(400): XenForo_DataWriter->save()
      #11 /../vault/core/controller/dm/area/vw.php(455): vw_DM_Controller_XF->save()
      #12 /../library/vw/XenForo/DataWriter.php(456): vw_DM_Area_Controller->post_save_each()
      #13 /../library/XenForo/DataWriter.php(1409): vw_XenForo_DataWriter->_postSave()
      #14 /../vault/core/controller/dm/xf.php(400): XenForo_DataWriter->save()
      #15 /../vault/core/controller/cp/area/vw.php(454): vw_DM_Controller_XF->save()
      #16 /../vault/core/controller/cp/area/vw.php(159): vw_CP_Area_Controller->do_save()
      #17 /../vault/core/controller/cp/area/vw.php(144): vw_CP_Area_Controller->process_save(Array)
      #18 /../vault/core/controller/cp/area/vw.php(67): vw_CP_Area_Controller->save()
      #19 /../library/vw/XenForo/ControllerAdmin/Wiki.php(113): vw_CP_Area_Controller->execute('save', 'post')
      #20 /../library/XenForo/FrontController.php(347): vw_XenForo_ControllerAdmin_Wiki->actionIndex()
      #21 /../library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
      #22 /../admin.php(13): XenForo_FrontController->run()
      #23 {main}
      
      Benötigter Status
      
      array(3) {
        ["url"] => string(56) "http://geislingen.net/admin.php?wiki/&panel=area&do=save"
        ["_GET"] => array(3) {
          ["wiki/"] => string(0) ""
          ["panel"] => string(4) "area"
          ["do"] => string(4) "save"
        }
        ["_POST"] => array(17) {
          ["panel"] => string(4) "area"
          ["do"] => string(4) "save"
          ["_xfToken"] => string(8) "********"
          ["title"] => string(26) "Tischtennis Bezirk Staufen"
          ["parentid"] => string(1) "0"
          ["displayorder"] => string(2) "15"
          ["autoprotect"] => string(1) "0"
          ["prefixlist"] => array(1) {
            [0] => string(0) ""
          }
          ["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"
          ["options"] => array(8) {
            ["page_html"] => string(1) "1"
            ["page_img"] => string(1) "2"
            ["page_bbcode"] => string(1) "4"
            ["comment_img"] => string(2) "32"
            ["comment_bbcode"] => string(2) "64"
            ["comment_smile"] => string(3) "128"
            ["page_header"] => string(1) "0"
            ["uncrawlable"] => string(1) "0"
          }
          ["blocklist"] => array(5) {
            [0] => string(9) "Any Block"
            [3] => string(1) "3"
            [4] => string(1) "4"
            [6] => string(1) "6"
            [7] => string(1) "7"
          }
          ["submit"] => string(9) "Speichern"
          ["url"] => string(48) "http://geislingen.net/admin.php?wiki/&panel=area"
        }
      }
    Issue Details
    Issue Number 4289
    Issue Type Bug
    Project VaultWiki 4.x Series
    Category Areas
    Status Duplicate
    Priority 1 - Security / Login / Data Loss
    Affected Version 4.0.3
    Fixed Version (none)
    Milestone (none)
    Software DependencyXenForo 1.x
    License TypePaid
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 1
    Assigned Users (none)
    Tags (none)


    Page 1 of 2 12 Next LastLast


    1. May 6, 2015 9:43 AM
      pegasus pegasus is offline
      VaultWiki Team
      Fixed.
      Reply Reply
    2. May 6, 2015 9:48 AM
      hollosch hollosch is offline
      Senior Member
      Don't work. Can't create a new area!
      Code:
      Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Field 'pageid' doesn't have a default value - library/Zend/Db/Statement/Mysqli.php:214
      Generiert durch: hollosch, Vor einem Moment
      Stapelverfolgung
      
      #0 /../httpdocs/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
      #1 /../httpdocs/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
      #2 /../httpdocs/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `vw...', Array)
      #3 /../httpdocs/library/XenForo/DataWriter.php(1624): Zend_Db_Adapter_Abstract->insert('vw_page', Array)
      #4 /../httpdocs/library/XenForo/DataWriter.php(1613): XenForo_DataWriter->_insert()
      #5 /../httpdocs/library/vw/XenForo/DataWriter.php(331): XenForo_DataWriter->_save()
      #6 /../httpdocs/library/XenForo/DataWriter.php(1405): vw_XenForo_DataWriter->_save()
      #7 /../httpdocs/vault/core/controller/dm/xf.php(400): XenForo_DataWriter->save()
      #8 /../httpdocs/vault/core/controller/dm/area/vw.php(455): vw_DM_Controller_XF->save()
      #9 /../httpdocs/library/vw/XenForo/DataWriter.php(456): vw_DM_Area_Controller->post_save_each()
      #10 /../httpdocs/library/XenForo/DataWriter.php(1409): vw_XenForo_DataWriter->_postSave()
      #11 /../httpdocs/vault/core/controller/dm/xf.php(400): XenForo_DataWriter->save()
      #12 /../httpdocs/vault/core/controller/cp/area/vw.php(454): vw_DM_Controller_XF->save()
      #13 /../httpdocs/vault/core/controller/cp/area/vw.php(159): vw_CP_Area_Controller->do_save()
      #14 /../httpdocs/vault/core/controller/cp/area/vw.php(144): vw_CP_Area_Controller->process_save(Array)
      #15 /../httpdocs/vault/core/controller/cp/area/vw.php(67): vw_CP_Area_Controller->save()
      #16 /../httpdocs/library/vw/XenForo/ControllerAdmin/Wiki.php(113): vw_CP_Area_Controller->execute('save', 'post')
      #17 /../httpdocs/library/XenForo/FrontController.php(347): vw_XenForo_ControllerAdmin_Wiki->actionIndex()
      #18 /../httpdocs/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
      #19 /../httpdocs/admin.php(13): XenForo_FrontController->run()
      #20 {main}
      
      Benötigter Status
      
      array(3) {
        ["url"] => string(56) "http://geislingen.net/admin.php?wiki/&panel=area&do=save"
        ["_GET"] => array(3) {
          ["wiki/"] => string(0) ""
          ["panel"] => string(4) "area"
          ["do"] => string(4) "save"
        }
        ["_POST"] => array(17) {
          ["panel"] => string(4) "area"
          ["do"] => string(4) "save"
          ["_xfToken"] => string(8) "********"
          ["title"] => string(26) "Tischtennis Bezirk Staufen"
          ["parentid"] => string(1) "0"
          ["displayorder"] => string(2) "15"
          ["autoprotect"] => string(1) "0"
          ["prefixlist"] => array(1) {
            [0] => string(0) ""
          }
          ["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"
          ["options"] => array(7) {
            ["page_html"] => string(1) "1"
            ["page_img"] => string(1) "2"
            ["page_bbcode"] => string(1) "4"
            ["comment_bbcode"] => string(2) "64"
            ["comment_smile"] => string(3) "128"
            ["page_header"] => string(1) "1"
            ["uncrawlable"] => string(1) "0"
          }
          ["blocklist"] => array(5) {
            [1] => string(13) "Suche im Wiki"
            [3] => string(1) "3"
            [4] => string(1) "4"
            [6] => string(1) "6"
            [7] => string(1) "7"
          }
          ["submit"] => string(9) "Speichern"
          ["url"] => string(48) "http://geislingen.net/admin.php?wiki/&panel=area"
        }
      }
      Reply Reply
    3. May 6, 2015 10:38 AM
      pegasus pegasus is offline
      VaultWiki Team
      Did you restore a backup of your database or do anything to your database today? You get the same error if you try to make new pages. It looks like your database randomly forgot that 'pageid' on vw_page is an AUTO_INCREMENT PRIMARY KEY.

      EDIT: It seems that happened to the vw_revision table too so something has definitely happened to the database.

      If this has affected multiple tables, this is not something I want to tinker with by "just re-creating the keys" since the key numbering might be thrown off and cause problems.

      I suspect you copied some database tables, or perhaps the whole database, using something like:
      Code:
      create table [new_db.][new_name] select * from [old_db].[old_name]
      Unfortunately this is flawed code because it doesn't copy and key values, just the table contents.

      The only real way to fix it is to redo whatever copy operation you did before, but to do it in a way that includes key values and other structure information.
      Reply Reply
    4. May 6, 2015 11:06 AM
      hollosch hollosch is offline
      Senior Member
      I restored a backup of the database...
      Reply Reply
    5. May 6, 2015 11:14 AM
      hollosch hollosch is offline
      Senior Member
      How to re-creating the keys ?
      Reply Reply
    6. May 6, 2015 11:29 AM
      pegasus pegasus is offline
      VaultWiki Team
      In phpmyadmin, for every vw_ table, there should be the first column like {table_name}id
      e.g. for vw_page the first column is pageid, for vw_revision the first column is revisionid

      These columns need to be PRIMARY KEY.
      They need the AUTO_INCREMENT property.

      I created primary keys on vw_page and vw_revision, but it seems like there are a lot more that need it.

      If there are no indexes on a lot of tables, you will want to read look at the contents of vault/core/controller/install/db/create to see what indexes everything is supposed to have. This folder is deleted after install, so you will need to get it from the ZIP.

      It's a big job. You will want to review the code that creates your database backups so that you don't create bad backups in the future.

      You want to disable your wiki until this issue is resolved fully, because you can get a lot of useless entries that can't be viewed or deleted.
      Reply Reply
    7. May 6, 2015 11:37 AM
      hollosch hollosch is offline
      Senior Member
      Hi, i can restore a completly backup from early today.
      Make this sense ?
      Reply Reply
    8. May 6, 2015 11:38 AM
      pegasus pegasus is offline
      VaultWiki Team
      You can try it.
      Reply Reply
    9. May 6, 2015 11:39 AM
      hollosch hollosch is offline
      Senior Member
      Ok, i'll try it.
      Reply Reply
    10. May 6, 2015 12:21 PM
      hollosch hollosch is offline
      Senior Member
      Ok, backup is restored.
      Can you have a look to the problem creating a new area?
      Reply Reply
    11. May 6, 2015 1:12 PM
      pegasus pegasus is offline
      VaultWiki Team
      I made an area called 'Test Area.' It seems okay.
      Reply Reply
    12. May 6, 2015 1:18 PM
      hollosch hollosch is offline
      Senior Member
      When i try to rename the Test-area to "Tischtennis Bezirk Staufen" the error: The current Prefix and Title combination matches another item

      ???
      Reply Reply
    13. May 6, 2015 1:49 PM
      pegasus pegasus is offline
      VaultWiki Team
      That means you either already have a page with that name, or if you can't find it, maybe you tried to create it in the past and it failed with a fatal error. In this case, you would have to rebuild your URLs in the Counters page to clear the useless entry.
      Reply Reply
    14. May 6, 2015 1:53 PM
      pegasus pegasus is offline
      VaultWiki Team
      I notice when I go to URL Conflicts that your MySQL database runs out of disk space (error 28). This could explain why you had problems with missing indexes earlier. If you aren't getting this error all the time, I would expect that you will be getting it more and more often since databases really only grow.

      The more it happens, the more corrupt data you will get. You will want to look into allocating more disk space to MySQL and restarting it.
      Reply Reply
    15. May 6, 2015 2:43 PM
      hollosch hollosch is offline
      Senior Member
      Hi,
      i located the problem. i have to configure my partitions on the server...

      I rebuild the urls. see the screen what happens...
      Reply Reply
    Page 1 of 2 12 Next LastLast
    + 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:20 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 © 2023 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
    Copyright © 2008 - 2013 VaultWiki Team, Cracked Egg Studios, LLC.