Simarilius Posted August 8 Share Posted August 8 (edited) 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 by Simarilius Link to comment Share on other sites More sharing options...
Marc Posted August 8 Share Posted August 8 Have these recently been restored? Link to comment Share on other sites More sharing options...
Simarilius Posted August 15 Author Share Posted August 15 (edited) No, no Users haven been restored Edited August 15 by Simarilius Link to comment Share on other sites More sharing options...
Jim M Posted August 15 Share Posted August 15 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. Link to comment Share on other sites More sharing options...
Simarilius Posted August 22 Author Share Posted August 22 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) Link to comment Share on other sites More sharing options...
Recommended Posts