File log errors – what do I do?

Hi baldarch deactivate all your other plugins except this one. Then enable one by one and at the same time carry out some test.

Regards

Thanks for your reply mbrsolution.

What test or tests would that be?

One problem looks like it relates to user logins. Would that be right? (I can’t be sure as there is no other history recorded.)

But how do I test the other? I don’t know what the cron job is.

thanks

baldarch

Hi can you check to see if the aiowps log file exist? If it does what permission is the file set to.

Regards

The first log (SUCCESS : Cronjob_Handler – Hourly cron handler got fired) is normal and is nothing to worry about and means that the cron job got triggered correctly.

The second one could mean that an attempted insertion operation into the database failed. I recommend that you check your server log files – they will show more info regarding any DB errors. (Ask you host provider if you don’t know how to find the server logs files)

@wpsolutions

thanks for the reply.

I have access to the traffic log file and some of these have no active traffic.

On the other hand some have POSTS, cron jobs or caching actions immediately before. Some are while admin user is logged in, but not all.

My concern is that aiowps is trying to post something to the DB and it’s not happening.

I would appreciate any further advice you could give me.

thanks

baldarch

Hi,
I was referring to the server log file not traffic logs.
Ask your host support people to tell you where you can view general server php errors and database logs.

I have checked with the provider and the logs are not publicly accessible. They did a check of their logs.

They advised that there are no log entries which correspond with any of the aiows log times. They recommended that I direct a support request to you.

Any further assistance would be appreciated

thanks

baldarch

How often is the following log being produced and is it still currently being generated?
FAILURE : Error inserting record into wp_xxx_aiowps_login_activity

Also, using PHPMyAdmin, can you take a look at the “aiowps_login_activity” table? Are there any entries in that table?

Thank you for the reply.

There are 30 entries in the table, with 26 during the same period as the log entries. There are no suspicious details.

There are 18 entries in the aiowps log. Below is a list of them, security log details on the left, my comments on the right about what I saw in the DB table.

The first entry probably commences after WP and several plugins were updated.

[05/06/2015 8:52 PM] – no login around this time
[05/07/2015 9:11 AM] – admin logged in 1 min after
[05/07/2015 9:54 AM] – no login around this time
[05/07/2015 10:16 AM] – user A
[05/07/2015 5:59 PM] – admin 1 min later
[05/07/2015 9:00 PM] – user A single login
[05/07/2015 9:00 PM] – see above (same time)
[05/08/2015 9:21 AM] – admin 1 min later
[05/08/2015 9:26 AM] – user B 1 min later
[05/08/2015 10:45 AM] – no login around this time
[05/08/2015 10:50 AM] – user A
[05/08/2015 3:39 PM] – no login around this time
[05/08/2015 5:40 PM] – admin
[05/11/2015 8:31 AM] – no login around this time
[05/11/2015 8:31 AM] – no login around this time
[05/11/2015 9:42 AM] – user A
[05/11/2015 10:16 AM] – no login around this time
[05/11/2015 4:02 PM] – user B

In some cases the DB records logins after the log file records them. The DB

thanks

baldarch

Have the same

“FAILURE : Error inserting record into” notice in my wp-security-log.txt

PhpMyAdmin : CHECK TABLE gives status OK

Table contains data from the same day, no corresponding times.
It appears that sometimes, for some reason, the table is locked when the plugin attempts to write to it…

No PHP errors.

I am now seeing the same error on another site.
Updated WP and plugins.
Needed to log back in.
Checked log: the one and only entry was that very login
[05/13/2015 7:28 AM] – FAILURE : Error inserting record into wpXXXX_aiowps_login_activity

A second login had same error as well.

Thanks for the 3.9.6 update.

Issue now resolved on all sites.