Issue: Error creating new area

Issue Tools
- View Changes

May 6, 2015 5:56 AM

hollosch

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)

May 6, 2015 9:43 AM

pegasus

VaultWiki Team

Fixed.

Reply

May 6, 2015 9:48 AM

hollosch

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"
  }
}

May 6, 2015 10:38 AM
pegasus

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
May 6, 2015 11:06 AM

hollosch

Senior Member

I restored a backup of the database...

Reply
May 6, 2015 11:14 AM

hollosch

Senior Member

How to re-creating the keys ?

Reply
May 6, 2015 11:29 AM

pegasus

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
May 6, 2015 11:37 AM

hollosch

Senior Member

Hi, i can restore a completly backup from early today.
Make this sense ?

Reply
May 6, 2015 11:38 AM

pegasus

VaultWiki Team

You can try it.

Reply
May 6, 2015 11:39 AM

hollosch

Senior Member

Ok, i'll try it.

Reply
May 6, 2015 12:21 PM

hollosch

Senior Member

Ok, backup is restored.
Can you have a look to the problem creating a new area?

Reply
May 6, 2015 1:12 PM

pegasus

VaultWiki Team

I made an area called 'Test Area.' It seems okay.

Reply
May 6, 2015 1:18 PM

hollosch

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
May 6, 2015 1:49 PM

pegasus

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
May 6, 2015 1:53 PM

pegasus

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
May 6, 2015 2:43 PM

hollosch

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

All times are GMT -4. The time now is 7:41 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

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Error creating new area

Issue Tools