User Essentials

User Essentials [Paid] 4.5.8

No permission to buy ($35.00)
Just here to report a bug, no ill side effects observed from it, but it did trigger an error in the log.

Code:
XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\xA4\x94' for column 'content_title' at row 1 src/XF/Db/AbstractStatement.php:217
Generated by: USER Oct 20, 2019 at 4:45 AM

INSERT  INTO `xf_sv_user_log` (`content_type`, `content_id`, `user_id`, `ip_address`, `content_user_id`, `content_username`, `content_title`, `content_url`, `discussion_content_type`, `discussion_content_id`, `action`, `action_params`, `user_log_id`, `log_date`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1366, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1366, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(218): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#4 src/XF/Mvc/Entity/Entity.php(1452): XF\Db\AbstractAdapter->insert('xf_sv_user_log', Array, false)
#5 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#6 src/addons/SV/UserEssentials/UserLog/AbstractHandler.php(130): XF\Mvc\Entity\Entity->save()
#7 src/addons/SV/UserEssentials/UserLog/AbstractHandler.php(75): SV\UserEssentials\UserLog\AbstractHandler->log(Object(SV\UserEssentials\XF\Entity\Post), 'edit', Array, Object(SV\SignupAbuseBlocking\XF\Entity\User))
#8 src/addons/SV/UserEssentials/UserLog/Logger.php(90): SV\UserEssentials\UserLog\AbstractHandler->logChange(Object(SV\UserEssentials\XF\Entity\Post), 'message', '[QUOTE="ShaunMo...', '[QUOTE="ShaunMo...', Object(SV\SignupAbuseBlocking\XF\Entity\User))
#9 src/addons/SV/UserEssentials/XF/Logger.php(90): SV\UserEssentials\UserLog\Logger->logChanges('post', Object(SV\UserEssentials\XF\Entity\Post), true)
#10 src/addons/SV/UserEssentials/XF/Entity/Post.php(138): SV\UserEssentials\XF\Logger->logUserChanges('post', Object(SV\UserEssentials\XF\Entity\Post))
#11 src/XF/Mvc/Entity/Entity.php(1208): SV\UserEssentials\XF\Entity\Post->_postSave()
#12 src/XF/Service/Post/Editor.php(187): XF\Mvc\Entity\Entity->save(true, false)
#13 src/XF/Service/ValidateAndSavableTrait.php(40): XF\Service\Post\Editor->_save()
#14 src/XF/Pub/Controller/Post.php(135): XF\Service\Post\Editor->save()
#15 src/addons/EWR/Porta/Pub/Controller/Post.php(39): XF\Pub\Controller\Post->actionEdit(Object(XF\Mvc\ParameterBag))
#16 src/XF/Mvc/Dispatcher.php(321): EWR\Porta\Pub\Controller\Post->actionEdit(Object(XF\Mvc\ParameterBag))
#17 src/XF/Mvc/Dispatcher.php(244): XF\Mvc\Dispatcher->dispatchClass('XF:Post', 'Edit', Object(XF\Mvc\RouteMatch), Object(SV\UserEssentials\XF\Pub\Controller\Post), NULL)
#18 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(SV\UserEssentials\XF\Pub\Controller\Post), NULL)
#19 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#20 src/XF/App.php(2178): XF\Mvc\Dispatcher->run()
#21 src/XF.php(390): XF\App->run()
#22 index.php(20): XF::runApp('XF\\Pub\\App')
#23 {main}

array(4) {
  ["url"] => string(29) "/index.php?posts/1829172/edit"
  ["referrer"] => string(103) "https://SITEURL/index.php?threads/THREADTITLE-%F0%9F%A4%94.83565/"
  ["_GET"] => array(1) {
    ["posts/1829172/edit"] => string(0) ""
  }
  ["_POST"] => array(8) {
    ["message_html"] => string(616) "<p>[QUOTE="USER, post: 1829031, member: 62253"]</p><p>POST CONTENTS WENT HERE</p><p>[/QUOTE]</p><p><br></p><p>REPLY CONTENTS WENT HERE</p><p><br></p><p>ANOTHER POST CONTENT HERE</p>"
    ["_xfInlineEdit"] => string(1) "1"
    ["attachment_hash"] => string(32) "7457fdcaf21d8677d841ac05c6b1ff6a"
    ["attachment_hash_combined"] => string(87) "{"type":"post","context":{"post_id":1829172},"hash":"7457fdcaf21d8677d841ac05c6b1ff6a"}"
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(76) "/index.php?threads/THREADTITLE-%F0%9F%A4%94.83565/"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}
That is part of User Essentials, not Signup Detection & Abuse Blocking add-on.

Please make sure you've run php cmd.php xf:convert-utf8mb4 to enable utf8mb4 on all tables and set the $config['fullUnicode'] = true; flag in src/config.php
 
That is part of User Essentials, not Signup Detection & Abuse Blocking add-on.

Please make sure you've run php cmd.php xf:convert-utf8mb4 to enable utf8mb4 on all tables and set the $config['fullUnicode'] = true; flag in src/config.php

Heh, my bad, got my signals mixed up.

We have previously already done that to enable emoji's on our site.
 
Yes, but run it again and see if there is anything that was missed :P

That it fails on that table but not the xf_thread table suggests something is wrong
 
Xon updated User Essentials with a new update entry:

3.4.2 - Maintenance update

  • Fix that "Thread starter permissions" block would not have the correct defaults initialized when a user with unlock/lock own thread starts a new thread
  • Thread starter permissions changes;
    • Add admincp option for various thread starter permissions defaults
    • Add option "Block users unlocking their own thread that was locked by a moderator"
    • Rework unlock thread starter logic; When a thread is locked by a moderator, the (new) "locked by user" UI toggle is set and...

Read the rest of this update entry...
 
I'm quite uncertain of the meaning of sv_ue_locked_by_user_explain. It says: User's can only unlock the thread if it was not done by a moderator.

To my understanding it would actually be:
Users can only unlock the thread if it was not locked by a moderator
right?

Or does it mean "can only lock OR unlock the thread if it was not unlocked OR locked by a mod"?
 
Thanks for the clarification :) Are you going to change that in an upcoming version or should I change it manually?

Also does it only prevent unlocking if the thread was locked by a moderator or does it also prevent locking if it was unlocked by a mod?
 
How would one go about removing password verification from the Username Change tool? Is there an option to just have it Moderator Approved?
 
Would it also possible to add an option for number of limit to change username?
There is already a global setting for that "Maximum user name changes" it just isn't a per-user group permission.

How would one go about removing password verification from the Username Change tool? Is there an option to just have it Moderator Approved?
That currently isn't supported. Wouldn't be hard to implement however
 
No matter how i set yes/no the option "[UserEss] Hide online status", still i can see the Privacy option in the account privacy setting. I thought the option will hide that feature. Am i missing something here?
 
Have you set the "Enable "[UserEss] Hide online status" permission feature" option? This feature adds at most one extra additional query (sometimes it doesn't need them) so it is disabled by default
 
Yes i've tried set both enabled/disabled on usergroup permission but the "Privacy options" feature on /forum/account/privacy still not hiding
 
Back
Top Bottom