Issue: Error on installation in XF

Issue Tools
- View Changes

February 7, 2017 2:26 PM

beernuts

Junior Member

Error on installation in XF

Trying to do a fresh install fails into XF 1.5.11 forum

Attempting to do an installation of the latest version of Vaultwiki into a new Xenforo forum (We just moved from vBulletin) and installation is failing on step 10, after telling the installer to create a new usergroup.

Code:

Step 10

Creating super moderators
An exception occurred: Database Error: SELECT moderatorid FROM `vw_moderator` WHERE nodekey = '0:0' AND userid = 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 in [path]/vault/core/controller/db/xf.php on line 173
#0: vw_DB_Controller_XF->throw_error() in [path]/vault/core/controller/db/xf.php at line 254
#1: vw_DB_Controller_XF->query_first() in [path]/vault/core/model/db/mysql/vw.php at line 27
#2: vw_DB_MySQL_Model->select() in [path]/vault/core/controller/dm/moderator/vw.php at line 121
#3: vw_DM_Moderator_Controller->pre_save() in [path]/library/vw/XenForo/DataWriter.php at line 488
#4: vw_XenForo_DataWriter->_preSave() in [path]/library/XenForo/DataWriter.php at line 1460
#5: XenForo_DataWriter->preSave() in [path]/library/vw/XenForo/DataWriter.php at line 186
#6: vw_XenForo_DataWriter->preSaveWithReturn() in [path]/vault/core/controller/dm/xf.php at line 382
#7: vw_DM_Controller_XF->pre_save() in [path]/library/vw/XenForo/DataWriter.php at line 181
#8: vw_XenForo_DataWriter->preSave() in [path]/library/XenForo/DataWriter.php at line 1399
#9: XenForo_DataWriter->save() in [path]/vault/core/controller/dm/xf.php at line 415
#10: vw_DM_Controller_XF->save() in [path]/vault/install/lib/full/steps/xf.php at line 397
#11: vw_Install_Full_Steps_Controller_XF->{closure}() in [path]/vault/core/controller/progress/steps/vw.php at line 83
#12: vw_Progress_Steps_Controller->call() in [path]/vault/core/controller/progress/steps/vw.php at line 53
#13: vw_Progress_Steps_Controller->execute() in [path]/vault/install/lib/full/steps/vw.php at line 244
#14: vw_Install_Full_Steps_Controller->execute() in [path]/vault/core/controller/progress/vw.php at line 92
#15: vw_Progress_Controller->exec_script() in [path]/vault/core/controller/progress/vw.php at line 74
#16: vw_Progress_Controller->execute() in [path]/vault/core/controller/cp/progress/vw.php at line 35
#17: vw_CP_Progress_Controller->process() in [path]/vault/core/controller/cp/install/vw.php at line 258
#18: vw_CP_Install_Controller->install() in [path]/vault/core/controller/cp/install/vw.php at line 62
#19: vw_CP_Install_Controller->execute() in [path]/library/vw/XenForo/ControllerAdmin/Wiki.php at line 119
#20: vw_XenForo_ControllerAdmin_Wiki->actionIndex() in [path]/library/vw/XenForo/ControllerAdmin/Wiki.php at line 176
#21: vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in [path]/library/vw/XenForo/ControllerAdmin/Wiki.php at line 186
#22: vw_XenForo_ControllerAdmin_Wiki->actionInstall() in [path]/library/XenForo/FrontController.php at line 351
#23: XenForo_FrontController->dispatch() in [path]/library/XenForo/FrontController.php at line 134
#24: XenForo_FrontController->run() in [path]/admin.php at line 13

Issue Details

Issue Number 4905

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.16

Fixed Version 4.0.17

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)

February 7, 2017 2:51 PM
pegasus

VaultWiki Team
This error occurs because your forum's standard moderator table contains a super-moderator record for a user who was deleted, but the corresponding moderator record was not also removed.

In vault/core/controller/dm/moderator/vw.php, find:

Code:

$this->instance->do_set('nodekey', $nodekey);

After it, add:

Code:

if (!$this->instance->get('userid')) { return false; }

This will skip trying to add the missing moderator when one is encountered.
Reply
February 7, 2017 2:55 PM

beernuts

Junior Member

Thanks. Installation went through after making that change.

Reply
February 7, 2017 2:58 PM

beernuts

Junior Member

After installation completes, I cannot access any of the Wiki links in the admin area. When I do so, I get a page with no content. In other words, the XF admin panel is there, and the wiki admin links are in the left frame, but the actual content is missing. I checked administrator permissions and didn't see anything there about administering the wiki. What am I missing?

Reply
February 7, 2017 2:59 PM

beernuts

Junior Member

Never mind. Needed to delete the vault/install/lib directory.

The only admin page that showed that error was the vaultwiki options page. All admin pages should show that error to make it very obvious that that directory needs deleting.

Reply
February 7, 2017 3:19 PM
pegasus

VaultWiki Team
All admin pages do show this error (it's calculated in the same preDispatch method used for all VaultWiki admin pages). I suspect you could not see it because either your AdminCP templates or your phrases were still undergoing a rebuild which did not complete until you accessed the options page. However, I was not able to reproduce the behavior you described on a fresh installation. At the "Install Complete" popup, I click "Go to Admin Panel", and then I see the admin navigation on the left and the following in the content:

Code:

Wiki > Home Before you can continue using VaultWiki, you MUST remove the installation directory located at vault/install/lib. Doing so will prevent conflicts when upgrading to a newer version.
Reply
February 7, 2017 3:20 PM

beernuts

Junior Member

Very odd. Chalk it up to user error I suppose.

Thanks for the help.

Reply
February 7, 2017 3:54 PM

pegasus

VaultWiki Team

If you have XenForo's cache enabled in library/config.php, I wonder if there is a bug in the underlying Zend Cache that XenForo uses. On my live XenForo site, I use the same setting and I often have trouble where changing various XenForo options, enabling/disabling add-ons, etc, appears to have no effect until I restart PHP.

Reply
February 7, 2017 4:02 PM

beernuts

Junior Member

Nope, no cache enabled right now specifically because I didn't want it to cause grief during this huge migration undertaking. No opcode caching on the server, either.

Who knows what it was...

Reply

+ Reply

All times are GMT -4. The time now is 7:41 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: Error on installation in XF

Issue Tools