Issue: Merge Error

Issue Tools
- View Changes

September 25, 2017 4:06 AM

Forsaken

Junior Member

Merge Error

Code:

XenForo_Exception: Database Error: UPDATE `vw_usercount` SET `vw_contribs` = vw_contribs + , `vw_comments` = vw_comments + , `vw_reports` = vw_reports + , `vw_feeds` = vw_feeds + , `vw_feedposts` = vw_feedposts + , `vw_uploads` = vw_uploads + , `vw_categorizes` = vw_categorizes + , `vw_chapters` = vw_chapters + , `vw_grouped` = vw_grouped + , `vw_islands` = vw_islands + , `vw_redirects` = vw_redirects + , `vw_templates` = vw_templates + , `vw_translates` = vw_translates + WHERE userid = 2415 LIMIT 1 Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `vw_comments` = vw_comments + , `vw_reports` = vw_reports + , `vw_feeds` = v' at line 1 - vault/core/controller/db/xf.php:187

Code:

#0 /home/adept/public_html/vault/core/controller/db/xf.php(171): vw_DB_Controller_XF->throw_error(Object(Zend_Db_Statement_Mysqli_Exception), 'UPDATE  `vw_use...')
#1 /home/adept/public_html/vault/core/model/db/mysql/vw.php(1120): vw_DB_Controller_XF->query_write('UPDATE  `vw_use...')
#2 /home/adept/public_html/vault/core/model/db/mysql/vw.php(768): vw_DB_MySQL_Model->shutdown_or_run('UPDATE  `vw_use...', false)
#3 /home/adept/public_html/vault/core/model/plugins/data/vw.php(469): vw_DB_MySQL_Model->update(Array)
#4 /home/adept/public_html/vault/core/model/plugins/data/vw.php(89): vw_Plugins_Data_Model->do_user_merge_target_required(Array, Array)
#5 /home/adept/public_html/library/vw/XenForo/Model/User.php(159): vw_Plugins_Data_Model->do_user_merge(Array, Array)
#6 /home/adept/public_html/library/XenForo/Model/User.php(3080): vw_XenForo_Model_User->changeContentUser(2320, 'sobn120', 'Boms', 2415)
#7 /home/adept/public_html/library/EWRporta2/Model/User.php(7): XenForo_Model_User->mergeUsers(Array, Array)
#8 /home/adept/public_html/library/XenGallery/Model/User.php(7): EWRporta2_Model_User->mergeUsers(Array, Array)
#9 /home/adept/public_html/library/EWRdiscord/Model/User.php(61): XenGallery_Model_User->mergeUsers(Array, Array)
#10 /home/adept/public_html/library/XenForo/ControllerAdmin/User.php(646): EWRdiscord_Model_User->mergeUsers(Array, Array)
#11 /home/adept/public_html/library/XenForo/FrontController.php(351): XenForo_ControllerAdmin_User->actionMerge()
#12 /home/adept/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#13 /home/adept/public_html/admin.php(13): XenForo_FrontController->run()
#14 {main}

[code]

Issue Details

Issue Number 5246

Issue Type Bug

Project VaultWiki 4.x Series

Category User Profiles

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.19

Fixed Version 4.0.20

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)

September 25, 2017 9:02 AM
pegasus

VaultWiki Team
Fixed in the next release. This occurs when the user used as the merge source was created/registered after VaultWiki was installed but during a period while VaultWiki was disabled, but only if the merge is performed immediately after re-enabling VaultWiki and there have been few visits to non-admin pages since it was re-enabled. Such users have no contributions to merge, until a cron job is able to generate the records for them. The cron job is triggered at the first visit to a non-admin page and usually takes about a minute to complete. Once the cron job completes, the error should disappear.

In the event the job fails (which would normally be accompanied by different errors in the logs), or in a future case where the merge is triggered before the job has a chance to complete, the fix to the merge code is as follows:

In vault/core/model/plugins/data/vw.php, find:

Code:

if ($usercount)

Replace with:

Code:

if ($usercount AND isset($sourceuser['vw_contribs']))
Reply
September 26, 2017 3:54 AM
Forsaken

Junior Member
Originally Posted by pegasus

Fixed in the next release. This occurs when the user used as the merge source was created/registered after VaultWiki was installed but during a period while VaultWiki was disabled, but only if the merge is performed immediately after re-enabling VaultWiki and there have been few visits to non-admin pages since it was re-enabled. Such users have no contributions to merge, until a cron job is able to generate the records for them. The cron job is triggered at the first visit to a non-admin page and usually takes about a minute to complete. Once the cron job completes, the error should disappear.

In the event the job fails (which would normally be accompanied by different errors in the logs), or in a future case where the merge is triggered before the job has a chance to complete, the fix to the merge code is as follows:

In vault/core/model/plugins/data/vw.php, find:

Code:

if ($usercount)

Replace with:

Code:

if ($usercount AND isset($sourceuser['vw_contribs']))

Okay thanks .
Reply

+ Reply

All times are GMT -4. The time now is 4:28 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: Merge Error

Issue Tools