Unmaintained User Essentials 2.8.4
- Author Xon
- Creation date
-
- Tags
- the essentials
XF2 version
Q. The "messages per page" custom fields are usable by anyone.
A. Use the Custom Field Permissions add-on to restrict who can use them. While this is "unmaintained" by the author, please mention me for support questions.
Q. Deleting a custom field does not remove data
A. This is "as designed" behaviour.
To purge custom fields which have been deleted;
Q. Renames are slow
A. Try adding indexes to the following tables;
Q. Likes Given page is very slow.
A. Try adding the index:
Q. The "messages per page" custom fields are usable by anyone.
A. Use the Custom Field Permissions add-on to restrict who can use them. While this is "unmaintained" by the author, please mention me for support questions.
Q. Deleting a custom field does not remove data
A. This is "as designed" behaviour.
To purge custom fields which have been deleted;
SQL:
delete from xf_user_field_value
where field_id not in (select field_id from xf_user_field);Q. Renames are slow
A. Try adding indexes to the following tables;
Code:
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 xf_spam_cleaner_log add index applying_user_id (applying_user_id );
alter table xf_spam_cleaner_log add index user_id (user_id );Q. Likes Given page is very slow.
A. Try adding the index:
Code:
ALTER TABLE `xf_liked_content` ADD INDEX `user_like_date` (`like_user_id` ASC, `like_date` DESC);