Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Simarilius Posted August 8 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
Simarilius Posted August 15 Author Posted August 15 (edited) No, no Users haven been restored Edited August 15 by Simarilius
Jim M Posted August 15 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.
Simarilius Posted August 22 Author 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)
Recommended Posts