Issue: vw_templatepack doesn't exist

Issue Tools
- View Changes

October 16, 2020 8:16 AM

madolfsson

New Member

vw_templatepack doesn't exist

It tries to write to vw_templatepack, but that table is named vw_template_pack. Same issue with the

vw_template_pack_area
vw_template_pack_item

Database error in vBulletin 4.2.5:

Invalid SQL:
UPDATE phenom_vw_templatepack SET
displayorder = 10,
title = 'test',
description = 'test'
WHERE packid = 1;

MySQL Error : Table 'phenompilots.phenom_vw_templatepack' doesn't exist
Error Number : 1146
Request Date : Friday, October 16th 2020 @ 08:14:23 AM
Error Date : Friday, October 16th 2020 @ 08:14:24 AM

Issue Details

Issue Number 6104

Issue Type Bug

Project VaultWiki 4.x Series

Category Admin Panel

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.1.0

Fixed Version 4.1.1

Milestone (none)

Software DependencyvBulletin 4.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

October 16, 2020 5:52 PM

pegasus

VaultWiki Team

In vault/core/controller/dm/vb3.php, find and remove:

Code:

		if (!$this->table)
		{
			$this->table = 'vw_' . strtolower($this->dmkey);
		}

Find:

Code:

$this->_construct_delayed();

AFTER it, add:

Code:

		$node = $this->controller->instance->get_node();

		if (!$node)
		{
			$dmkey = strtolower($this->dmkey);

			$node = array(
				'idfield' => $dmkey . 'id',
				'table' => $dmkey
			);
		}

		if (!$this->table)
		{
			$this->table = 'vw_' . $node['table'];
		}

A similar issue exists in the XenForo 1.x version. The same edits as above can be applied to library/vw/XenForo/DataWriter.php.
The issue does not affect XenForo 2.x versions.

October 21, 2020 2:07 PM

pegasus

VaultWiki Team

Please note that the previous post has been edited since it was originally posted to correct some issues in the hotfix.

Reply

+ Reply

All times are GMT -4. The time now is 7:49 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: vw_templatepack doesn't exist

Issue Tools