UserSpice Bugs

ID	Project	Category	Submitted / Last Updated
02302	UserSpice	ACP Code	2026-03-19 08:01:57
Reported	Dan Hoover	Assigned To	Unassigned
Priority	none	Reported	6.0.6
Status	new	Resolution Version and Commit
Summary	Add a few more indexes
Description	plg_tags_matches Needs index on (tag_id, user_id) and/or (tag_name, user_id) us_plugin_hooks Needs index on (page, disabled) plg_api_fails Needs index on (ip)

in 44 minutes

// plg_tags_matches: covers lookups by tag_id+user_id and tag_name+user_id $db->query("ALTER TABLE plg_tags_matches ADD INDEX ix_tag_user (tag_id, user_id)"); $db->query("ALTER TABLE plg_tags_matches ADD INDEX ix_tagname_user (tag_name, user_id)"); // us_plugin_hooks: covers WHERE page=? AND disabled=? $db->query("ALTER TABLE us_plugin_hooks ADD INDEX ix_page_disabled (page, disabled)"); // plg_api_fails: covers lookups by IP $db->query("ALTER TABLE plg_api_fails ADD INDEX ix_ip (ip)");

View Issue Detail