Database entry creation date
Development and Programming
Hello,
I have a question regarding the information stored on the database.
I have an old install of EE 2.11.9 with a licensed client and we need to find when a post was really created for the first time.
Digging in the database we found out that there are 2 dates for each post in table exp_channels_titles :
entry_date and edit_date
But there is no creation date or anything that can help us figure when actually the post was created.
It’s a legal issue and it’s important to have the real date of creation.
Thanks in advance.
There isn’t a creation date in v2 that would meet legal scrutiny. The entry date can be set to whatever the content person wants by design and the edit date automatically updates each edit. Those dates just weren’t designed to record a creation date, much less one that would meet legal standards.
Thank you very much for the reply.
The only sense I could make for an approximate date and time was through the entry_id which is an incremental variable. By checking entries before and after the post in question. But other than that it’s hopeless.
I wish I had a solution, but doing it retroactively just isn’t super viable. Especially if it’s got to meet legal scrutiny.
You could definitely make some educated guesses and for internal use between that and the internet archive you could fairly confidently narrow in on when an entry was made/last edited, but that’s not really what you need in this case. If I needed to be sure of entry/edit, I’d roll something custom and encrypt the data, but that doesn’t help us here.