Notifications
Clear all

wpForo 1.x.x [Closed] DB errors

21 Posts
2 Users
1 Reactions
12.7 K Views
Robert
Posts: 10587
Admin
(@robert)
Support Team
Joined: 9 years ago

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`);
1 Reply
(@anonymous20)
Joined: 9 years ago

Noble Member
Posts: 1602

Robert, i will wait.

Many thanks.

Robert
Posts: 10587
Admin
(@robert)
Support Team
Joined: 9 years ago
Posted by: Anonymous20

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.

Posts: 1602
Topic starter
(@anonymous20)
Noble Member
Joined: 9 years ago

Oh, ok i will do that asap and update here.

Posts: 1602
Topic starter
(@anonymous20)
Noble Member
Joined: 9 years ago

Seems to work fine now.

Thank you again.

Page 4 / 4