Tue, 11/03/2008 - 12:07 — jonathanm
The back filled news stories mess up listings with story creation dates when added to Drupal rather than when it was new.
Should be able to change the dates in the database.
Reporter:
jonathanm
Created:
Tue, 11/03/2008 - 12:07
Updated:
Thu, 27/03/2008 - 13:23
Comments
#1
Pages are nodes and held in the node table.
A particular story can be sected using an SQL query such as:
SELECT *
FROM `node`
WHERE title LIKE '%hkkh%'
to find the news story about HKKH.
The dates are stored in the database as unix timestamps. These can be found for a date and time by using the Tcl clock scan command, e.g.
(bin) 2 % clock scan "2007-08-19 09:00"
1187510400
NB the 1and1 server displayed the time section of this as 08:00, I think it expected the timestamp to be in CET (it's in Germany) and converted the time to GMT.
#2
All news stories added and creation dates altered to suit.
The news stories text might do with some tidying, e.g. unfiiltered html and extra blanklines
#3
Automatically closed -- issue fixed for two weeks with no activity.