Hi,
I'm administrating two Forums and both have the  following error in the mysql / mariadb log:
 

2024-08-08 10:14:47 user[user] @ localhost [] ERROR 1062: Duplicate entry '74797-2024-08-08' for key 'lookup' : /*user::user::IPS\_Member::recordLogin:221*/ INSERT INTO `ip_core_members_logins` ( `member_id`, `member_timestamp`, `member_date` ) VALUES ( 74797, 1723104887, '2024-08-08' )
2024-08-08 10:15:04 user[user] @ localhost [] ERROR 1062: Duplicate entry '85893-2024-08-08' for key 'lookup' : /*user::user::IPS\_Member::recordLogin:221*/ INSERT INTO `ip_core_members_logins` ( `member_id`, `member_timestamp`, `member_date` ) VALUES ( 85893, 1723104904, '2024-08-08' )
2024-08-08 10:15:04 user[user] @ localhost [] ERROR 1062: Duplicate entry '85893-2024-08-08' for key 'lookup' : /*user::user::IPS\_Member::recordLogin:221*/ INSERT INTO `ip_core_members_logins` ( `member_id`, `member_timestamp`, `member_date` ) VALUES ( 85893, 1723104904, '2024-08-08' )

How can i fix this (cause other errors get lost in the amount of these log entries)

Edited August 8, 2024Aug 8 by Simarilius

Have these recently been restored?

No, no Users haven been restored

Edited August 15, 2024Aug 15 by Simarilius

We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. 

We look forward to further assisting you. 

 

Hi,
adjusted the Access Information for filmvorfuehrer.de  and remembered that we have an enhanced error log active:

log_warnings = 2  # to log authentication errors to error-log for fail2ban

# logs SQL errors and other stuff 
plugin_load_add = sql_errlog
sql_error_log = ON
sql_error_log_filename = /var/log/mysql/mysql.log

-> we do this to see which webspace on the server has issues (and to find sql injection attacks)