Issue: Database Error: BEGIN Mysqli prepare error: This command is not supported in the prepared statement protocol yet

Issue Tools
- View Changes

August 29, 2020 9:35 PM

Alfa1

Distinguished Member

Database Error: BEGIN Mysqli prepare error: This command is not supported in the prepared statement protocol yet

Database Error: BEGIN Mysqli prepare error: This command is not supported in the prepared statement protocol yet - library/vw/_core/controller/db/xf.php:187
Generated By: Unknown Account, A moment ago
Stack Trace

#0 /library/vw/_core/controller/db/xf.php(171): vw_DB_Controller_XF->throw_error(Object(Zend_Db_Statement_Mysqli_Exception) , ' BEGIN ')
#1 /library/vw/_core/controller/db/vw.php(142): vw_DB_Controller_XF->query_write(' BEGIN ')
#2 /library/vw/_core/model/db/mysql/vw.php(1337): vw_DB_Controller->transaction()
#3 /library/vw/_core/controller/location/vw.php(128): vw_DB_MySQL_Model->transaction()
#4 /library/vw/XenForo/Model/User.php(109): vw_Location_Controller->update_wiki_browsers()
#5 /library/SV/UserActivity/XenForo/Model/User.php(31): vw_XenForo_Model_User->updateSessionActivity(0, '66.249.65.218', 'vw_XenForo_Cont...', 'Index', 'valid', Array, NULL, 'google')
#6 /library/XenForo/Controller.php(473): SV_UserActivity_XenForo_Model_User->updateSessionActivity(0, '66.249.65.218', 'vw_XenForo_Cont...', 'Index', 'valid', Array, NULL, 'google')
#7 /library/XenForo/Controller.php(359): XenForo_Controller->updateSessionActivity(Object(XenForo_ControllerResponse_ View), 'vw_XenForo_Cont...', 'Index')
#8 /library/XenForo/FrontController.php(376): XenForo_Controller->postDispatch(Object(XenForo_ControllerResponse_View), 'vw_XenForo_Cont...', 'Index')
#9 /library/XenForo/FrontController.php(152): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /index.php(13): XenForo_FrontController->run()
#11 {main}

Request State

array(3) {
["url"] => string(35) "https://my-forum.com/wiki/Butane"
["_GET"] => array(1) {
["/wiki/Butane"] => string(0) ""
}
["_POST"] => array(0) {
}
}

Issue Details

Issue Number 6093

Issue Type Bug

Project VaultWiki 4.x Series

Category General

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.1.0

Fixed Version 4.1.0

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)

August 30, 2020 4:19 PM

pegasus

VaultWiki Team

This occurs when Options > VaultWiki: Miscellaneous > Show Users Browsing the Wiki = Yes in XenForo 1.x. In library/vw/_core/controller/db/xf.php, find:

Code:

public function halt($text = '')

BEFORE it, add (beware scrollbars):

Code:

	public function transaction()
	{
		if (!$this->transaction)
		{
			$this->get_instance()->getProfiler()->queryStart('begin', Zend_Db_Profiler::TRANSACTION);
			$this->get_instance()->getConnection()->query(vw_DB::get($this->key)->query()->transactionSql());
			$this->transaction = true;
		}
		else
		{
			$savepoint = 'vwpoint' . ++$this->pointid;
			$this->get_instance()->getProfiler()->queryStart('begin', Zend_Db_Profiler::TRANSACTION);
			$this->get_instance()->getConnection()->query(vw_DB::get($this->key)->query()->savepoint($savepoint));

			$this->savepoints[] = $savepoint;
		}
	}

	public function commit()
	{
		if ($this->transaction)
		{
			if ($this->savepoints)
			{
				$this->get_instance()->getProfiler()->queryStart('commit', Zend_Db_Profiler::TRANSACTION);
				$this->get_instance()->getConnection()->query(vw_DB::get($this->key)->query()->release(array_pop($this->savepoints)));
			}
			else
			{
				$this->get_instance()->getProfiler()->queryStart('commit', Zend_Db_Profiler::TRANSACTION);
				$this->get_instance()->getConnection()->query(vw_DB::get($this->key)->query()->commitSql());
				$this->transaction = false;
			}
		}
	}

	public function rollback($all = 0)
	{
		if ($this->transaction)
		{
			if ($this->savepoints AND $all != -1)
			{
				$this->get_instance()->getProfiler()->queryStart('rollback', Zend_Db_Profiler::TRANSACTION);
				$this->get_instance()->getConnection()->query(vw_DB::get($this->key)->query()->rollbackSql(array_pop($this->savepoints)));
			}
			else
			{
				$this->get_instance()->getProfiler()->queryStart('rollback', Zend_Db_Profiler::TRANSACTION);
				$this->get_instance()->getConnection()->query(vw_DB::get($this->key)->query()->rollbackSql());
				$this->transaction = false;
				$this->savepoints = array();
			}
		}
	}

This resolved the issue on my XF1 test board.

+ Reply

All times are GMT -4. The time now is 10:45 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: Database Error: BEGIN Mysqli prepare error: This command is not supported in the prepared statement protocol yet

Issue Tools