User Essentials

User Essentials [Paid] 4.4.1

No permission to buy ($35.00)
Now i get this one :/
Code:
Server error log

    XF\Db\Exception: MySQL statement prepare error [1146]: Table 'Anzahsql1.xf_xf_sv_thread_lock' doesn't exist src/XF/Db/AbstractStatement.php:212

    Generated by: Tealk Jul 29, 2018 at 6:15 PM

Stack trace

            SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_thread_watch_Watch_2`.*, `xf_draft_DraftReplies_3`.*, `xf_thread_reply_ban_ReplyBans_4`.*, `xf_forum_Forum_5`.*, `xf_node_Node_6`.*, `xf_snog_groups_Group_7`.*, `xf_snog_groups_ParentGroup_8`.*, `xf_snog_groups_settings_Settings_9`.*, `xf_snog_groups_subforums_Subforum_10`.*, `xf_xf_sv_thread_lock_ThreadPermissions_11`.*, `xf_permission_cache_content_Permissions_12`.*, `xf_thread_read_Read_13`.*, `xf_forum_read_Read_14`.*
            FROM `xf_thread`
            LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_thread_watch` AS `xf_thread_watch_Watch_2` ON (`xf_thread_watch_Watch_2`.`thread_id` = `xf_thread`.`thread_id` AND `xf_thread_watch_Watch_2`.`user_id` = '1')
LEFT JOIN `xf_draft` AS `xf_draft_DraftReplies_3` ON (`xf_draft_DraftReplies_3`.`draft_key` = CONCAT('thread-', `xf_thread`.`thread_id`) AND `xf_draft_DraftReplies_3`.`user_id` = '1')
LEFT JOIN `xf_thread_reply_ban` AS `xf_thread_reply_ban_ReplyBans_4` ON (`xf_thread_reply_ban_ReplyBans_4`.`thread_id` = `xf_thread`.`thread_id` AND `xf_thread_reply_ban_ReplyBans_4`.`user_id` = '1')
LEFT JOIN `xf_forum` AS `xf_forum_Forum_5` ON (`xf_forum_Forum_5`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_6` ON (`xf_node_Node_6`.`node_id` = `xf_forum_Forum_5`.`node_id`)
LEFT JOIN `xf_snog_groups` AS `xf_snog_groups_Group_7` ON (`xf_snog_groups_Group_7`.`node_id` = `xf_node_Node_6`.`node_id`)
LEFT JOIN `xf_snog_groups` AS `xf_snog_groups_ParentGroup_8` ON (`xf_snog_groups_ParentGroup_8`.`node_id` > 0 AND `xf_snog_groups_ParentGroup_8`.`node_id` = `xf_node_Node_6`.`parent_node_id`)
LEFT JOIN `xf_snog_groups_settings` AS `xf_snog_groups_settings_Settings_9` ON (`xf_snog_groups_settings_Settings_9`.`id` = 1)
LEFT JOIN `xf_snog_groups_subforums` AS `xf_snog_groups_subforums_Subforum_10` ON (`xf_snog_groups_subforums_Subforum_10`.`node_id` = `xf_node_Node_6`.`node_id`)
LEFT JOIN `xf_xf_sv_thread_lock` AS `xf_xf_sv_thread_lock_ThreadPermissions_11` ON (`xf_xf_sv_thread_lock_ThreadPermissions_11`.`thread_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_12` ON (`xf_permission_cache_content_Permissions_12`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_12`.`content_id` = `xf_node_Node_6`.`node_id` AND `xf_permission_cache_content_Permissions_12`.`permission_combination_id` = '138')
LEFT JOIN `xf_thread_read` AS `xf_thread_read_Read_13` ON (`xf_thread_read_Read_13`.`thread_id` = `xf_thread`.`thread_id` AND `xf_thread_read_Read_13`.`user_id` = '1')
LEFT JOIN `xf_forum_read` AS `xf_forum_read_Read_14` ON (`xf_forum_read_Read_14`.`node_id` = `xf_forum_Forum_5`.`node_id` AND `xf_forum_read_Read_14`.`user_id` = '1')
            WHERE (`xf_thread`.`thread_id` = '2439')
            
        
LIMIT 1
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1146, '42S02')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1146, '42S02')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Mvc/Entity/Finder.php(1130): XF\Db\AbstractAdapter->query('\n\t\t\tSELECT `xf_...')
#5 src/XF/Mvc/Entity/Manager.php(149): XF\Mvc\Entity\Finder->fetchOne()
#6 src/XF/Pub/Controller/Thread.php(1254): XF\Mvc\Entity\Manager->find('XF:Thread', '2439', Array)
#7 src/addons/ThemeHouse/QAForums/XF/Pub/Controller/Thread.php(17): XF\Pub\Controller\Thread->assertViewableThread('2439', Array)
#8 src/addons/XFMG/XF/Pub/Controller/Thread.php(11): ThemeHouse\QAForums\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#9 src/addons/SV/UserEssentials/XF/Pub/Controller/Thread.php(27): XFMG\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#10 src/XF/Mvc/Dispatcher.php(249): SV\UserEssentials\XF\Pub\Controller\Thread->actionIndex(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:Thread', 'Index', 'html', Object(XF\Mvc\ParameterBag), 'forums', Object(SV\MultiPrefix\XF\Pub\Controller\Thread), NULL)
#12 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#13 src/XF/App.php(1931): XF\Mvc\Dispatcher->run()
#14 src/XF.php(328): XF\App->run()
#15 index.php(13): XF::runApp('XF\\Pub\\App')
#16 {main}

Request state

array(4) {
  ["url"] => string(52) "/threads/teamspeak-aenderungen-am-rechtesystem.2439/"
  ["referrer"] => bool(false)
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
 
Any eta on when this will be available?
Ended up being implemented in User Essentials (ie this thread).

It seems that you don't look at your error logs. Its good to keep an eye on the error log and keep it clean.

The problem is two fold:
  1. This addon will fill up your error log as it keeps looking for non-existent avatars. i.e. dead links and possibly bad for SEO.
  2. For users without avatar, a blank block is displayed. (as you noticed later)
https://xenforo.com/community/threads/mini-avatar-with-tag.85978/post-1106531
In User Essentials for XF2, this is solved by 1 extra query per page where it loads the user records so it knows if a user has an avatar or not. Additionally the default XF2 avatars are letters rather than a mostly blank image.

I may need to add an option so only users with avatars are rendered.
 
Lock / Unlock own thread. Permission to allow thread authors to lock/unlock their own threads. User cannot unlock threads locked by a moderator.
is it possible to automatically lock posts after a certain time so that users can unlock them?
 
Xon updated User Essentials with a new update entry:

3.1.4 - Maintenance update

  • Add additional indexes which can massively speed up deleting large number of users on a forum with large amounts of content.
    • Previous 3.1.3 didn't run the schema modification code when upgrading from 3.1.2
    • Equivalent of running;
      SQL:
      alter table xf_thread add index last_post_user_id (last_post_user_id);
      alter table xf_report add index last_modified_user_id (last_modified_user_id);
      alter table xf_warning add index warning_user_id (warning_user_id);
      alter table...

Read the rest of this update entry...
 
Xon updated User Essentials with a new update entry:

3.2.0 - Feature update

  • Generate a name change record on user-merge
    • Options to send notifications or to mark it as private
  • On user merge, reassign additional content which XF doesn't do by default;
    • Drafts/ thread read/forum read/custom user fields/dismissed notices
    • If the target user already has a record the old record is deleted, not merged.
  • Remove orphaned approval queue records
  • Tweak previous username display in admincp

Read the rest of this update entry...
 
Hi @XenConcept can you add 0 queries feature like this addon https://xenforo.com/community/resources/mini-avatar-with-tag.3738/
i get lot queries with this addon, from this:
View attachment 180062

to this:
View attachment 180063

thanks.
Did this got implemented or is this add-on dead? 180 vs 11 is a huge difference!
My User Essentials (paid) add-on implements this (with a 1-2 query overhead), and is supported. It also lets users send mentions (without duplicates!) when they edit someone into a post
 
Top Bottom