Login SQL error

When logging in I'm getting a Database query error. Your help would be greatly appreciated.

ERROR:

Database error in XXXXXXXX.net

Query:

INSERT INTO `sys_ip_members_visits` SET `MemberID` = '1', `From`='1659934059', `DateTime`=NOW()

Mysql error: Unknown column 'MemberID' in 'field list'

Found error in the file '/home/XXXXXX/public_html/member.php' at line 656.
Called 'db_res' function with erroneous argument #0.

It seems there is an issue with your scripts recording IP addresses to the database.  It looks like the database is missing the field MemberID in the table sys_ip_members_visits.  I would log into your database to check this and see.

In the sys_ip_members_visits I have ID, From, DateTime. Is this what I should have or am I missing something?

This doesn't make any sense. I was able to login and out with no problem last week. I didn't notice a problem until after I upgraded to 7.0.4 so naturally I suspected something must have got missed. But this is not the case. I reverted back to 7.0.3 from  a backup I made just before the upgrade. But that didn't work, I was still getting the Database query error.  I had to revert back to a an old backup from mid November to resolve this. It's a good thing  I keep  backups for 6 months.

I think this could have been the result from recent spam attacks from China.

INSERT INTO `sys_ip_members_visits` SET `MemberID` = '1', `From`='1659934059', `DateTime`=NOW()

Add this field -

MemberID
for sys_ip_members_visits

That fixed it, Thank You.