Issue: MySQL error when installing

Issue Tools
- View Changes

January 9, 2022 4:26 AM

thebrainone thebrainone is offline

New Member

MySQL error when installing

Code:

XF\Db\Exception: Database Error: INSERT INTO `xf_vw_upgradelog` (`upgradetype`, `version`, `step`, `offset`) VALUES ('C','0.0.0',1,0) ON DUPLICATE KEY UPDATE version = VALUES(version), step = VALUES(step), offset = VALUES(offset) MySQL statement prepare error [1064]: 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 'offset = VALUES(offset)' at line 3 in src/addons/vw/vw/_core/controller/db/xf2.php at line 383
vw_DB_Controller_XF2->halt() in src/addons/vw/vw/_core/model/db/mysql/vw.php at line 1308
vw_DB_MySQL_Model->replace() in src/addons/vw/vw/Setup/Caller/Install.php at line 96
vw\vw\Setup\Caller\Install->log_step() in src/addons/vw/vw/Setup/Caller/AbstractCaller.php at line 214
vw\vw\Setup\Caller\AbstractCaller->close() in src/addons/vw/vw/_install/lib/full/steps/vw.php at line 42
vw_Install_Full_Steps_Controller->{closure}() in src/addons/vw/vw/Setup.php at line 333
vw\vw\Setup->vwRunStep() in src/addons/vw/vw/Setup.php at line 251
vw\vw\Setup->install() in src/XF/Admin/Controller/AddOn.php at line 419
XF\Admin\Controller\AddOn->actionInstall() in src/XF/Mvc/Dispatcher.php at line 352
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2351
XF\App->run() in src/XF.php at line 517
XF::runApp() in admin.php at line 13

Issue Details

Issue Number 6291

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.1.4

Fixed Version 4.1.4

Milestone (none)

Software DependencyXenForo 2.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

January 9, 2022 6:16 AM

thebrainone

New Member

Right now checked on a freshly installed Xenforo v2.2.8 Patch 1 and getting the same error.

Reply
January 9, 2022 12:43 PM
pegasus

VaultWiki Team
I'm guessing that you are running MariaDB 5.6. It looks like they added "offset" as a reserved term in that version. In src/addons/vw/vw/_core/model/db/mysql/vw.php, find:

Code:

$setfields[] = $setfield . ' = VALUES(' . $setfield . ')';

BEFORE it, add:

Code:

$setfield = $this->wrap($setfield);

Hopefully that is the only change that needs to be made.
Reply
January 9, 2022 1:17 PM
thebrainone

New Member
Originally Posted by pegasus

I'm guessing that you are running MariaDB 5.6. It looks like they added "offset" as a reserved term in that version. In src/addons/vw/vw/_core/model/db/mysql/vw.php, find:

Code:

$setfields[] = $setfield . ' = VALUES(' . $setfield . ')';

BEFORE it, add:

Code:

$setfield = $this->wrap($setfield);

Hopefully that is the only change that needs to be made.

Yes it worked! Thank you!

That message is good?

Yeah, MariaDB installed on server.
Server version: 10.6.5-MariaDB-1:10.6.5+maria~focal mariadb.org binary distribution
Reply
January 9, 2022 1:32 PM

thebrainone

New Member

Nwm, all good and work!
Thank you!
Сan you explain about the allert?

Reply
January 9, 2022 1:35 PM

pegasus

VaultWiki Team

That message means you changed the file, that you edited. It is a warning in case you didn't change the file yourself, in case there is an intruder in the system changing the files, or in case you are uploading the add-on and the files didn't finish uploading. Since you DID change this file yourself, there is nothing to worry about.

---

If you are still receiving the same exact error message, possibly your PHP installation has cached the old file (before the edit) and you have a long-lived cache life. To clear the cache, you can restart your server's PHP process (such as PHP-FPM).

EDIT: Since it is working now, you tried again after the PHP cache expired.

Since the installation is now working, we will be adding this change to the next build to help other users who might have MariaDB 10.6. Thank you for reporting the issue.

Reply
January 9, 2022 1:43 PM

thebrainone

New Member

Originally Posted by pegasus

That message means you changed the file, that you edited. It is a warning in case you didn't change the file yourself, in case there is an intruder in the system changing the files, or in case you are uploading the add-on and the files didn't finish uploading. Since you DID change this file yourself, there is nothing to worry about.

---

If you are still receiving the same exact error message, possibly your PHP installation has cached the old file (before the edit) and you have a long-lived cache life. To clear the cache, you can restart your server's PHP process (such as PHP-FPM).

EDIT: Since it is working now, you tried again after the PHP cache expired.

Since the installation is now working, we will be adding this change to the next build to help other users who might have MariaDB 10.6. Thank you for reporting the issue.

Thanks for the answer and for the help!
Have a good day!

Reply

+ Reply

All times are GMT -4. The time now is 2:32 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: MySQL error when installing

Issue Tools