Issue: Unknown column 'Array' in 'field list'

Issue Tools
- View Changes

October 15, 2020 10:35 PM

madolfsson

New Member

Unknown column 'Array' in 'field list'

I am not sure why the templaterules field value comes across as Array?

Database error in vBulletin 4.2.5:

Invalid SQL:
INSERT INTO phenom_vw_area
(title, displayorder, parentid, prefixlist, styleid, autoprotect, allowtypes, defaultsort, blocklist, langlist, topiclist, autolink, templaterules, area_options)
VALUES
('test333', 10, 0, '-1', 0, 0, '0', 'a:3:{s:4:"sort";s:10:"lastupdate";s:5:"order";s:4:"DESC" ;s:6:"filter";i:0;}', '0', '0', '-1', -2, Array, 65604);

MySQL Error : Unknown column 'Array' in 'field list'
Error Number : 1054
Request Date : Thursday, October 15th 2020 @ 10:28:25 PM
Error Date : Thursday, October 15th 2020 @ 10:28:25 PM
Script : /admincp/wiki_cp.php?panel=area&do=save
Referrer : /admincp/wiki_cp.php?panel=area&do=edit
IP Address : 162.158.123.68
Username : Marcus Adolfsson
Classname : vB_Database_MySQLi
MySQL Version : 8.0.21-0ubuntu0.20.04.4
Server : 10.128.0.3
User Agent :

Issue Details

Issue Number 6103

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 w/ ckEditor

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

October 16, 2020 12:25 AM

pegasus

VaultWiki Team

Fixed in the next release. In vault/core/controller/dm/area/vb3.php, find:

Code:

public function verify_styleid(&$styleid)

BEFORE it, add:

Code:

	public function verify_templaterules(&$rules)
	{
		return $this->controller->verify_templaterules($rules);
	}

October 16, 2020 11:10 AM

madolfsson

New Member

Thanks now I get this error when trying to save:

Call to a member function get_info() on null on line 568 in /www/phenompilots.org/vb4/vault/core/controller/cp/area/vw.php
#0 /www/phenompilots.org/vb4/vault/core/controller/cp/area/vw.php(205): vw_CP_Area_Controller->do_save()
#1 /www/phenompilots.org/vb4/vault/core/controller/cp/area/vw.php(173): vw_CP_Area_Controller->process_save()
#2 /www/phenompilots.org/vb4/vault/core/controller/cp/area/vw.php(64): vw_CP_Area_Controller->save()
#3 /www/phenompilots.org/vb4/vault/helper/vb/global.php(83): vw_CP_Area_Controller->execute()
#4 /www/phenompilots.org/vb4/admincp/wiki_cp.php(91): require_once('/www/phenompilo...')
#5 {main}

Reply
October 16, 2020 5:32 PM
pegasus

VaultWiki Team
This occurs when the Save cannot continue due to a problem with the submission. When constructing a list of problems with the submission for display to the user, this error occurs instead.

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

Code:

$this->data['area'][$field . '_array'] = $this->instance->get_info($field . '_array');

Replace with:

Code:

$this->data['area'][$field . '_array'] = $this->data['area_dm']->get_info($field . '_array');
Reply

+ Reply

All times are GMT -4. The time now is 2:44 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: Unknown column 'Array' in 'field list'

Issue Tools