Doubt : obtaining the original creation date of a FAQ record

All about webserver configurations, PHP and databases.

Moderator: Thorsten

Post Reply
pt20100201
Posts: 126
Joined: Mon Feb 01, 2010 2:11 pm
Location: Porto . Portugal
Contact:

Doubt : obtaining the original creation date of a FAQ record

Post by pt20100201 » Thu Jan 06, 2011 7:55 pm

Doubt : obtaining the original creation date of a FAQ record – is it possible?

Dear Thorsten / dear All

Does phpMyFAQ’s DB store permanently - and in a non-modifiable way - the original creation date of a FAQ record?

We need to create a report with the number and the question text of FAQ records created on 2009 and 2010 (separately).

Some 2009's FAQs were reviewed in 2010.

We tried several direct MySQL SQL queries on the DB tables/fields (datum, solution_id, revision_id, …)
without consistent results.

Is it possible to obtain this kind of reports?

Software and versions :

phpMyFAQ - 2.6.13
Database Server - MySQL
Database Client Version - 5.1.54
Database Server Version - 5.5.8
PHP - 5.3.4


Thanking in advance

Kind regards
2011-01-06
pt20100201
Last edited by pt20100201 on Fri Jan 07, 2011 10:58 am, edited 1 time in total.

Thorsten
Posts: 14730
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Doubt : obtaining the original creation date of a FAQ re

Post by Thorsten » Fri Jan 07, 2011 8:33 am

Hi,

you can do this by analyzing the faqadminlog table...

I know there's a fixed creation date missing in the faqdata table. Maybe I'll add it in 2.7

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

pt20100201
Posts: 126
Joined: Mon Feb 01, 2010 2:11 pm
Location: Porto . Portugal
Contact:

Re: Doubt : obtaining the original creation date of a FAQ re

Post by pt20100201 » Fri Jan 07, 2011 11:14 am

Thorsten wrote:you can do this by analyzing the faqadminlog table...

I know there's a fixed creation date missing in the faqdata table. Maybe I'll add it in 2.7
Dear Thorsten

Thanks for your quick answer.

We must analyse the faqadminlog table a little more deeper...

The "fixed creation date" is important - even for those that don’t need to present reports.

Please continue your good work.

Kind regards
2011-01-07
pt20100201

Post Reply