failed login date

To improve performance, we have added the database index key failed logins time in the latest release of the AIOS plugin. On update, the AIOS plugin might try to add this index key. It seems like the table field is corrupted when adding an index key to it.

Resolution:

Note: We highly recommended to take your database backup before following these steps.
If possible, please take help from a server administrator.

* Open your database in PHPMyAdmin.

* Select your site’s database.

* Select wp_aiowps_failed_logins.

* Press on the Operations tab.

* Press on the Repair table link of it.

Thanbk you.

@pmbaldha
thank you for your response.
I tried your instructions but nothing changed. in the database the dates are correct.

Are you using any server-level or database-level cache mechanism? If yes, then please flush it.

Can you please try to deactivate and reactivate the AIOS plugin? And then try again.

Are you facing the same issue in new failed login records too?

Thank you.

Hello,

sorry for my late response. I’ve tried everything that you have said but unfortunately the problem is not resolved.

1970-01-01 00:00:00 is the starting time of Unix timestamps:?en.wikipedia.org/wiki/Unix_time?So if you enter?0?as timestamp, it is in fact 1970-01-01 00:00:00

Can you try making the wp_aiowps_failed_login column in the database nullable so that when date is not submitted in the form set it set to NULL rather than the default unix timestamp

To make the column value NULL,
1) Open PHPMYADMIN.
2) Select Structure.
3) Select edit for the desired column.
4) Select ‘Null’ for default.
5) Click the ‘NULL” checkbox.
6) Select ‘Go’.

I have also asked our development team to look at this

@vupdraft thank you for your response

I have changed the failed_login_date column in the aiowps_failed_logins table and Clicked the ‘NULL” checkbox.

then tried to test and entered wrong information to see the records but the date is still the same. 1 January, 1970 12:00 am

Hi Mina1400, thank you for your patience on this.

The date set in the failed login table is also affected by WordPress settings.

Are you able to go to Settings > General and let me know what you have set for the Timezone , Date Format, and Time Format settings?

Also under the Timezone setting, it shows you the Universal time and the Local time, are you able to paste what they say in here too?

Hello @damien7

Date format is set to custom ” j F, Y ” and Time format is set to first format ” g:i a “.

Universal time is ????-??-?? ??:??:??

Local time is ????-??-?? ??:??:??

Thank you

Hi Mina,

Apologies for the delay in replying. I’ve still not been able to replicate this even after changing the calendar, timezone and language to match yours.

Is there a problem with the other tables in AIOS plugin? Or is it just the failed login table being affected? If it’s just the failed login table being affected, you could deactivate the plugin, delete the aiowps_failed_logins table and reactivate the plugin and see if that resolves the issue.

Alternatively, we can take a look on the backend for you, if you’re able to provide access. If you’d like to go this route, you can post the necessary details to our private support: https://aiosplugin.com/premium-support/

Thanks

Hello @damien7

when i directly check the database in the aiowps_login_lockdown table the lockdown_date column is showing the correct data and time for each record but in WP Admin Dashboard i see this specific date and time “1 January, 1970 12:00 am”.

Hi Mina,

Can I just clarify: Are we talking about WP Security > Dashboard > Permanent block list table or WP Security > User Login > Failed login records table?

If it’s the Failed login record, then the corresponding database table for that would be aiowps_failed_logins. Are the dates correct in that table too?

Thank you for your patience on this issue.

Hello @damien7

Thank you for your help

sorry. my mistake. my point was aiowps_failed_logins table. the failed_login_date in that table in database is correct. but in WP Security > User Login > Failed login records i see the wrong date “1 January, 1970 12:00 am” for all records.

Thank you for clarifying and apologies for the delay in responding!

Can you just confirm whether the date is correctly showing in the audit log? If you go to WP Security > Dashboard > Audit logs and let me know if the date displays correctly for you.

We’re working on moving the failed logins to the audit log. So if the audit log works for you, then it should be resolved shortly.

Hello @damien7

Thank you for your help.

There is no records in audit log

With the latest update (5.1.8), the failed login table entries should now have been transferred to the audit table. If you go to WP Security > Dashboard > Audit logs are you able to confirm whether the date is now correct for you?

If it’s not, could you provide a screenshot of the table? You can blank out any potential sensitive information beforehand.

Thanks again.