Issue: SQL error message in Wiki Area

Issue Tools
- View Changes

September 12, 2015 11:16 PM

dvsDave

Regular Member

SQL error message in Wiki Area

Going into an Area on the wiki results in the following error

Visible at http://www.controlbooth.com/wiki/?title=Technical-Terms

Code:

Server Error

Database Error: SELECT `t`.`tag` AS `tagtext`,`t`.`tag_url` AS `tagurl`,`tc`.`content_id` AS `contentid` FROM `xf_tag_content` `tc` LEFT JOIN `xf_tag` `t` ON (`t`.`tag_id` = `tc`.`tag_id`) WHERE `tc`.`content_type` = 'vwpage' AND `tc`.`content_id` IN (11911,11949,12005,12031,) Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1

vw_DB_Controller_XF->throw_error() in /home/control/public_html/vault/core/controller/db/xf.php at line 185
vw_DB_Controller_XF->query_read() in /home/control/public_html/vault/core/model/db/mysql/vw.php at line 29
vw_DB_MySQL_Model->select() in /home/control/public_html/vault/core/model/tagging/xf.php at line 74
vw_Tagging_Model_XF->get() in /home/control/public_html/vault/core/view/content/list/base/vw.php at line 399
vw_Content_List_Base_View->prepare_tags() in /home/control/public_html/vault/core/view/content/list/base/vw.php at line 387
vw_Content_List_Base_View->do_query() in /home/control/public_html/vault/core/view/content/list/base/vw.php at line 27
vw_Content_List_Base_View->get() in /home/control/public_html/vault/core/view/ui/area/vw.php at line 98
vw_UI_Area_View->view() in /home/control/public_html/vault/core/controller/ui/area/vw.php at line 159
vw_UI_Area_Controller->view() in /home/control/public_html/vault/core/controller/ui/stack/vw.php at line 304
vw_UI_Stack_Controller->view() in /home/control/public_html/vault/core/controller/ui/stack/vw.php at line 236
vw_UI_Stack_Controller->execute() in vw/XenForo/ControllerPublic/Wiki.php at line 68
vw_XenForo_ControllerPublic_Wiki->actionIndex() in XenForo/FrontController.php at line 347
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/control/public_html/index.php at line 13

Issue Details

Issue Number 4370

Issue Type Bug

Project VaultWiki 4.x Series

Category Categories

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.6

Fixed Version 4.0.6

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)

September 13, 2015 9:19 AM
pegasus

VaultWiki Team
This will occur if at least one of the pages that appears in the area list was corrupted in the past and does not have a valid route. You will find that it is not possible to visit this page (not found error).

In vault/core/view/content/list/base/vw.php, find:

Code:

$routeids = array(); foreach ($items AS $item) { $routeids[] = $item['routeid']; } $this->prepare_tags($routeids);

Replace with:

Code:

$routeids = array(); foreach ($items AS $item) { if (!empty($item['routeid'])) { $routeids[] = $item['routeid']; } } if ($routeids) { $this->prepare_tags($routeids); }

Other locations that may encounter this problem are resolved by 4.0.6 build 002.
Reply
September 13, 2015 9:34 AM

dvsDave

Regular Member

updated that code, still same error. http://www.controlbooth.com/wiki/?title=Technical-Terms

Reply

September 13, 2015 9:40 AM

pegasus

VaultWiki Team

No the backtrace is different, but it is a similar result.

In vault/core/view/factory/listitem/vw.php, find:

Code:

				if (
					$node['isPage'] AND
					vw_Hard_Core::model('Dependency')->has_tags() AND
					vw_Hard_Core::model('Settings')->get('vw_tagging') AND
					!vw_Hard_Core::controller('Request')->is_mobile()
				)

Replace with:

Code:

				if (
					$node['isPage'] AND
					!empty($page['routeid']) AND
					vw_Hard_Core::model('Dependency')->has_tags() AND
					vw_Hard_Core::model('Settings')->get('vw_tagging') AND
					!vw_Hard_Core::controller('Request')->is_mobile()
				)

September 13, 2015 9:45 AM

dvsDave

Regular Member

That did the trick!

Reply

+ Reply

All times are GMT -4. The time now is 7:35 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: SQL error message in Wiki Area

Issue Tools