Jump to content

Recommended Posts

Posted (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 by Simarilius
Posted

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. 

 

Posted

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) 

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...