How-to and Troubleshooting
21
Posts
2
Users
1
Reactions
12.7 K
Views
Jan 23, 2018 8:22 am
Ok I see the issue. This issue is only exists in your database because of last custom SQLs .The index we inserted last time was not complete. All this is fixed in next version. If you can't wait for the update please execute these SQLs:
First remove the last index, by executing this SQL, make sure the table prefix wp_ is correct:
ALTER TABLE `wp_wpforo_subscribes` DROP INDEX `itemid_type_user_name_user_email`;
Then create the correct one:
ALTER TABLE `wp_wpforo_subscribes` ADD UNIQUE( `itemid`, `type`, `userid`, `user_email`);
Jan 23, 2018 9:13 am
Robert, i will wait.
Many thanks.
This is a specific issue, you should execute the SQLs for all your sites. The update doesn't have this fix. It only fix the first general issue. This two SQLs fix all problems at once.
Jan 23, 2018 9:15 am
Oh, ok i will do that asap and update here.
Jan 23, 2018 10:08 am
Seems to work fine now.
Thank you again.
Page 4 / 4
Prev