Live posts show up as scheduled
Posted: Thu Mar 22, 2012 1:39 pm
Re-opening from GitHub Issues. This is definately 1.6 release running on our live server. I think it's been happening for a long time, but I am not the creator of content, so I don't see it. Should my serverOffset be +4? (server is UTC, localtime is UTC-4).
Running the 1.6 release (not updated from HEAD in github)
Published entries show up as "This Entry is not yet Published".
This happens for posts created and published immediately as well as posts saved as a Draft and published later.
I'm not sure if this happens for scheduled posts as well but I assume it does.
Perhaps this has something to do with a server time in UTC?
Post date: 2012-03-21 16:36
Local date: Wed Mar 21 19:03:31 EDT 2012
Server date: Wed Mar 21 23:03:55 UTC 2012
I don't know if this helps:
mysql> select id,timestamp,isdraft,last_modified from serendipity_entries where id=4656;
+------+------------+---------+---------------+
| id | timestamp | isdraft | last_modified |
+------+------------+---------+---------------+
| 4656 | 1332416040 | false | 1332370564 |
+------+------------+---------+---------------+
1 row in set (0.00 sec)
mysql> select * from serendipity_config where name like "%serverOffsetHours%";
+-------------------+-------+----------+
| name | value | authorid |
+-------------------+-------+----------+
| serverOffsetHours | -4 | 0 |
+-------------------+-------+----------+
1 row in set (0.00 sec)
Running the 1.6 release (not updated from HEAD in github)
Published entries show up as "This Entry is not yet Published".
This happens for posts created and published immediately as well as posts saved as a Draft and published later.
I'm not sure if this happens for scheduled posts as well but I assume it does.
Perhaps this has something to do with a server time in UTC?
Post date: 2012-03-21 16:36
Local date: Wed Mar 21 19:03:31 EDT 2012
Server date: Wed Mar 21 23:03:55 UTC 2012
I don't know if this helps:
mysql> select id,timestamp,isdraft,last_modified from serendipity_entries where id=4656;
+------+------------+---------+---------------+
| id | timestamp | isdraft | last_modified |
+------+------------+---------+---------------+
| 4656 | 1332416040 | false | 1332370564 |
+------+------------+---------+---------------+
1 row in set (0.00 sec)
mysql> select * from serendipity_config where name like "%serverOffsetHours%";
+-------------------+-------+----------+
| name | value | authorid |
+-------------------+-------+----------+
| serverOffsetHours | -4 | 0 |
+-------------------+-------+----------+
1 row in set (0.00 sec)
