Jump to content

Duplicate entry error in core_members_known_devices table during Login attempt (Error 1062)

PanSevence

By PanSevence

  • Status: Not a bug

Today, on version 5.0.2, I encountered this system error. I'm not sure if it's something significant, but I decided to report it. Below is the full event log.

INSERT INTO `core_members_known_devices` ( `device_key`, `member_id`, `anonymous`, `user_agent`, `login_key`, `last_seen`, `login_handler` ) VALUES ( '2d859fe1db62607697e24ea346c038b5', 107, true, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36', '0f95ebcfe4ade54a2a0f243ffe943b66', 1739963156, 1 )
IPS\Db\Exception: Duplicate entry '2d859fe1db62607697e24ea346c038b5-107' for key 'PRIMARY' (1062)
#0 public_html/system/Db/Db.php(1010): IPS\Db->preparedQuery()
#1 public_html/system/Patterns/ActiveRecord.php(511): IPS\Db->insert()
#2 public_html/system/Member/Device.php(197): IPS\Patterns\ActiveRecord->save()
#3 public_html/system/Login/Success.php(125): IPS\Member\Device->updateAfterAuthentication()
#4 public_html/applications/core/modules/front/system/login.php(126): IPS\Login\Success->process()
#5 public_html/system/Dispatcher/Controller.php(139): IPS\core\modules\front\system\login->manage()
#6 public_html/system/Dispatcher/Dispatcher.php(169): IPS\Dispatcher\Controller->execute()
#7 public_html/index.php(16): IPS\Dispatcher->run()
#8 {main}

#0 public_html/init.php(827): IPS\Log::log()
#1 [internal function]: IPS\IPS::exceptionHandler()
#2 {main}

URL: /login/
    •

    User Feedback

    Recommended Comments

    Marc Grand Master

    Marc

    Invision Community Team

    Is this just the one error, or are you getting multiple of them?

    PanSevence Rising Star

    PanSevence

    Clients

    It appeared once a moment ago, but I recently restarted the forum after the update.

    Miss_B Veteran

    Miss_B

    Clients

    I don't think that this is a bug. Most likely the core_members_known_devices table already contains a value called: '2d859fe1db62607697e24ea346c038b5' in the field 'device_key' for the member_id 107.

    Therefore attempts to insert another row containing the same value in the device_key field will cause the aforementioned error, since the 'device_key' field is an unique key where only one occurrence is possible.

    Marc Grand Master

    Marc

    Invision Community Team

    I would just let us know if you see that one happening again

    PanSevence Rising Star

    PanSevence

    Clients
    11 minutes ago, Miss_B said:

    I don't think that this is a bug. Most likely the core_members_known_devices table already contains a value called: '2d859fe1db62607697e24ea346c038b5' in the field 'device_key' for the member_id 107.

    Therefore attempts to insert another row containing the same value in the device_key field will cause the aforementioned error, since the 'device_key' field is an unique key where only one occurrence is possible.

    I understand this log, but I'm wondering what caused it there must be a reason for this error, right?

    1 minute ago, Marc said:

    I would just let us know if you see that one happening again

    Okay

    Miss_B Veteran

    Miss_B

    Clients
    33 minutes ago, PanSevence said:

    I understand this log, but I'm wondering what caused it there must be a reason for this error, right?

    45 minutes ago, Miss_B said:

    Therefore attempts to insert another row containing the same value in the device_key field will cause the aforementioned error, since the 'device_key' field is an unique key where only one occurrence is possible.

    •