Following tables are missing a primary key (which is required for database replication):
- activity_notification_status
- user_activity_digest
- user_activity_send
Issue fork social-3204517
Show commands
Start within a Git clone of the project using the version control instructions.
Or, if you do not have SSH keys set up on git.drupalcode.org:
Comments
Comment #3
matthijsComment #4
ressinelComment #5
rollins commentedResult of update commands:
Comment #8
rollins commentedComment #11
avig commentedI am using Drupal 10.2.7 and Open Social 12.4.2. In every installation I try I get the above error with the 3 missing keys activity_notification_status
user_activity_digest
user_activity_send
The way I managed to remove the error from the Status page is by creating the column on the database itself, like that:
ALTER TABLE `user_activity_send`
ADD COLUMN `uadid` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
and did that with the other 2 tables.
It removed the error. Hopefully, I won't get any issues further down the road.
Comment #12
nmridul commentedI updated to 12.4.5 and still has this issue.
https://www.drupal.org/project/social/issues/3204517#comment-15749361 -> It should be available from 12.4.4 according to this comment ?
Comment #13
trakoczi commentedI suspect this is the reason why notifications work unreliably in our project. Sometimes, quite randomly, the Activity Creator cron task ends up in a temporary DB lock, which is then automatically gone after a few minutes.
It would be important to have a bugfix release for this problem for the 12.4.x branch, because I fear if we fix it on our own now, even with the changes from the MR, it could later conflict with a different final solution.
Comment #14
socialnicheguru commentedWhich MR is it, 12 or 73?
Comment #15
socialnicheguru commented