XenForo
Administrative
- Thread starter
- Admin
- #1
Moderator accidentally soft-deletes thread that is 1,300 pages long. When attempting to undelete it, this query starts:
Code:
These are the indexes on my table. I'm not sure which ones I added myself if any. I remember adding more indexes because my table is 79,770,962 rows long. It's frequently a problem child when dealing with the database and if a default...
Read more
ادامه مطلب...
Code:
UPDATE `xf_reaction_content` SET `is_counted` = '1' WHERE content_type = 'post' AND content_id IN (88987 ids) AND is_counted = '0'These are the indexes on my table. I'm not sure which ones I added myself if any. I remember adding more indexes because my table is 79,770,962 rows long. It's frequently a problem child when dealing with the database and if a default...
Read more
ادامه مطلب...