Welcome to WebmasterWorld Guest from 184.108.40.206
I'm having a small problem and wanted to see if anyone had any suggestions on how to go about solving this issue.
I'm using PHP to parse my access_log and add the parsed data into a mysql database table. The problem is that my access_log rars up every 24 hours and starts up with a new empty access_log file.
When it's the same access_log it has no problem double checking that it does not put in any duplicate data but when the access log rars up and starts a new one it can't do that anymore because it checks the first entry in the db table with the first entry of the new access_log file and they are not the same and all of a sudden it starts dumping in duplicate data.
I hope I'm making sense with this. But is there anyway for it not to do that? Is there possibly a different route I can take? Any help is appreciated, I've spent a week messing with it and I'm stumped.
This isn't perfect because if someone manages two requests to the same page at the same time from the same IP, you will reject the second one from your log.