Skip to content

Integrity constraint violation: 1062 Duplicate entry '...' for key 'forum_id' #1111

@cebe

Description

@cebe

What steps will reproduce the problem?

unsure how to reproduce, but this happens regularily in prod.

#371 yii\db\IntegrityException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '...' for key 'forum_id' The SQL being executed was: UPDATE `user` SET `forum_id`=... WHERE `id`=...

relevant part from the stack trace:

+
at
yii\db\ActiveRecord::updateAll(/var/www/yiiframework/vendor/yiisoft/yii2/db/BaseActiveRecord.php:775)
+
at
yii\db\BaseActiveRecord::updateAttributes(/var/www/yiiframework/components/forum/DiscourseAdapter.php:118)
+
at
app\components\forum\DiscourseAdapter::getForumUserId(/var/www/yiiframework/models/User.php:481)
+
at
app\models\User::getForumUrl(/var/www/yiiframework/views/user/view.php:15)

Example URL: https://www.yiiframework.com/user/48952

Rollbar Item: https://app.rollbar.com/a/yiisoft/fix/item/yiiframework.com/371

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions