Issue: Error Deleting a synonym

Issue Tools
- View Changes

September 4, 2018 12:01 PM

expanserpb

Junior Member

Error Deleting a synonym

The user did not have permissions to delete a synonym.

The following information was presented to the user. This should instead be doing some error catching and presenting a different message to the user?

Chronicles Roleplay

Server Error
Database Error: UPDATE `vw_usercount` SET `vw_contribs` = IF(1 < vw_contribs, vw_contribs - 1, 0) , `vw_redirects` = IF(1 < vw_redirect, vw_redirects - 1, 0) WHERE userid = 8 LIMIT 1 Mysqli prepare error: Unknown column 'vw_redirect' in 'field list'

vw_DB_Controller_XF->throw_error() in /var/www/html/vault/core/controller/db/xf.php at line 171
vw_DB_Controller_XF->query_write() in /var/www/html/vault/core/model/db/mysql/vw.php at line 1125
vw_DB_MySQL_Model->shutdown_or_run() in /var/www/html/vault/core/model/db/mysql/vw.php at line 773
vw_DB_MySQL_Model->update() in /var/www/html/vault/core/controller/dm/redirect/vw.php at line 403
vw_DM_Redirect_Controller->post_save_each() in vw/XenForo/DataWriter.php at line 505
vw_XenForo_DataWriter->_postSave() in XenForo/DataWriter.php at line 1423
XenForo_DataWriter->save() in /var/www/html/vault/core/controller/dm/xf.php at line 436
vw_DM_Controller_XF->save() in /var/www/html/vault/core/controller/ui/imod/vw.php at line 1492
vw_UI_iMod_Controller->kill() in /var/www/html/vault/core/controller/ui/imod/vw.php at line 160
vw_UI_iMod_Controller->execute() in vw/XenForo/ControllerPublic/Wiki/Moderate.php at line 51
vw_XenForo_ControllerPublic_Wiki_Moderate->actionIndex() in XenForo/FrontController.php at line 369
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 152
XenForo_FrontController->run() in /var/www/html/index.php at line 13

User did not have permissions to delete the synonym.

Issue Details

Issue Number 5471

Issue Type Bug

Project VaultWiki 4.x Series

Category Unknown

Status Fixed

Priority 5 - Minor Bugs / Small Tweaks

Affected Version 4.0.23

Fixed Version 4.0.24

Milestone (none)

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

September 4, 2018 4:01 PM

pegasus

VaultWiki Team

The database error is fixed in the next release. It occurs when soft-deleting or un-approving a publicly visible synonym. Awaiting your updated ticket to check whether permissions were violated here.

Reply
September 6, 2018 11:12 AM

pegasus

VaultWiki Team

After checking permissions, I have determined that the user who performed this action did have the necessary permissions to do so. The user is in the "Administrative" group, which has all permissions. So no further action is necessary beyond fixing the database error.

Reply
September 6, 2018 11:14 AM

expanserpb

Junior Member

Sorry I should have been more clear.

I expected the user not to be able to delete it (or at least realised that was the case afterwards), but thought that an error like that should not have been coming to the user instead of a "you don't have permissions" type message.

Thank you again for looking into it.

Reply
September 6, 2018 11:20 AM

pegasus

VaultWiki Team

If you mean what I think you do, I believe that members of the Administrative group might have permissions to see full error messages. I believe XenForo displays a more generic message to non-admins.

Reply

+ Reply

All times are GMT -4. The time now is 3:32 PM.

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 Deleting a synonym

Issue Tools