Issue: Error Creating Area

Issue Tools
- View Changes

May 27, 2015 9:15 AM

Gossamer

Junior Member

Error Creating Area

When I attempt to create a new area, I get this error:

Code:

Database Error: INSERT IGNORE INTO `vw_counter` (`pageid`) VALUES (7) Mysqli prepare error: Unknown column 'pageid' in 'field list'

vw_DB_Controller_XF->throw_error() in /home/pandorar/public_html/markedrp.com/vault/core/controller/db/xf.php at line 132
vw_DB_Controller_XF->query_write() in /home/pandorar/public_html/markedrp.com/vault/core/model/db/mysql/vw.php at line 950
vw_DB_MySQL_Model->shutdown_or_run() in /home/pandorar/public_html/markedrp.com/vault/core/model/db/mysql/vw.php at line 820
vw_DB_MySQL_Model->insert() in /home/pandorar/public_html/markedrp.com/vault/core/controller/dm/area/vw.php at line 484
vw_DM_Area_Controller->post_save_each() in vw/XenForo/DataWriter.php at line 456
vw_XenForo_DataWriter->_postSave() in XenForo/DataWriter.php at line 1409
XenForo_DataWriter->save() in /home/pandorar/public_html/markedrp.com/vault/core/controller/dm/xf.php at line 400
vw_DM_Controller_XF->save() in /home/pandorar/public_html/markedrp.com/vault/core/controller/cp/area/vw.php at line 454
vw_CP_Area_Controller->do_save() in /home/pandorar/public_html/markedrp.com/vault/core/controller/cp/area/vw.php at line 159
vw_CP_Area_Controller->process_save() in /home/pandorar/public_html/markedrp.com/vault/core/controller/cp/area/vw.php at line 144
vw_CP_Area_Controller->save() in /home/pandorar/public_html/markedrp.com/vault/core/controller/cp/area/vw.php at line 67
vw_CP_Area_Controller->execute() in vw/XenForo/ControllerAdmin/Wiki.php at line 113
vw_XenForo_ControllerAdmin_Wiki->actionIndex() in XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/pandorar/public_html/markedrp.com/admin.php at line 13

The area was still successfully created.

Issue Details

Issue Number 4306

Issue Type Bug

Project VaultWiki 4.x Series

Category Areas

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.4

Fixed Version 4.0.4

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)

May 27, 2015 9:22 AM

pegasus

VaultWiki Team

Fixed. In vault/core/controller/dm/area/vw.php, find:

Code:

			vw_DB::get()->query()->insert(array(
				'table' => 'vw_counter',
				'ignore' => 1,
				'values' => array(
					array(
						'pageid' => $pageid
					)
				)
			));

Replace with:

Code:

			$routeid = $this->pagedm->get_info('routeid');

			if ($routeid)
			{
				vw_DB::get()->query()->insert(array(
					'table' => 'vw_counter',
					'ignore' => 1,
					'values' => array(
						array(
							'routeid' => $routeid
						)
					)
				));
			}

May 27, 2015 6:55 PM

Gossamer

Junior Member

Thanks! That fixed it! Will the previous error have negatively affected the areas I created before?

Reply
May 27, 2015 9:46 PM

pegasus

VaultWiki Team

Yes, those areas would never be able to count their contents. If you can, you might want to recreate those areas.

Reply

+ Reply

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

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

Issue: Error Creating Area

Issue Tools