Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
(4.0.4) posted by and modified by times...
I’ve nailed down some more details about problems I’m having when publishing new articles. Zem had asked for some more details in this thread: http://forum.textpattern.com/viewtopic.php?id=19204
Here’s an example from today: Article number 4718 Posted by: xxxx · 21 Oct 2006 · 11:51:21 PM Last modified by: · 22 Oct 2006 · 03:13:50 PM
It displayed before article number 4717 which carried the following time: Posted by: xxxx · 22 Oct 2006 · 07:39:05 AM Last modified by: · 22 Oct 2006 · 12:48:09 PM. In other words, the weblog showed a more recent article lower down the home page than the article that should have preceded it.
In spite of what the dates and times show, each of these articles was published within one hour of the time it was begun and both were written on Oct 22.
Here’s a link that shows all the plugins in use on the site: http://rodentregatta.com/images/25.jpg
“Well, I, uh, don’t think it’s quite fair to condemn a whole program because of a single slip-up, sir.” General ‘Buck’ Turgidson
Offline
#2 2006-10-22 22:08:52
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: (4.0.4) posted by and modified by times...
What tag are you using to display these articles? Best way to be sure is to switch to Debug mode, view the html source of a page that demonstrates the problem, and find the relevant part of the tag trace.
Also, are either of those articles marked Sticky?
Last edited by zem (2006-10-22 22:11:03)
Alex
Offline
Re: (4.0.4) posted by and modified by times...
Zem, neither article was “sticky.”
The home page of my weblog is produced by this code on the default page:
<txp:article form="def_if_excerpt" limit="5" />
<txp:output_form form="front_nav" />That code points to the def_if_excerpt form which contains this code:
<div class="entry">
<h2 class="entrytitle"><txp:permlink><txp:title /></txp:permlink></h2>
<h3 class="entrysub"><txp:posted /></h3>
<txp:swf_if_empty field="excerpt" minlength="2">
<div class="post"><txp:body /></div>
</txp:swf_if_empty>
<txp:swf_if_not_empty field="excerpt" minlength="2">
<div class="post"><txp:excerpt /><p><txp:permlink>Read on...</txp:permlink></p></div>
</txp:swf_if_not_empty>
<div class="subentry">
<p class="invite"><txp:comments_invite /></p><p class="posted">Filed under: <txp:category1 link=1 /></p>
</div>
</div>OFF TOPIC: Is Team Textpattern the outfit I should turn to in order to get rid of all the plugins and clean up the forms, pages and code?
“Well, I, uh, don’t think it’s quite fair to condemn a whole program because of a single slip-up, sir.” General ‘Buck’ Turgidson
Offline
#4 2006-10-23 00:46:42
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: (4.0.4) posted by and modified by times...
There’s nothing obviously wrong in what you’ve shown us sofar.
Can you post a complete tag trace please?
Is Team Textpattern the outfit I should turn to in order to get rid of all the plugins and clean up the forms, pages and code?
Yes, we can do that for you. Contact page.
Alex
Offline
Re: (4.0.4) posted by and modified by times...
Zem, I hope this is what you were asking for:
<!-- Runtime: 0.9910 -->
<!-- Query time: 0.508285 -->
<!-- Queries: 26 -->
<!-- Memory: 2370Kb, <txp:image id="20" /> -->
<!-- txp tag trace:
[SQL (0.000387): select name from txp_lang where lang='en-us' limit 1]
[SQL (0.002123): select name, data from txp_lang where lang='en-us' AND ( event='public' OR event='common')]
[SQL (0.006822): select name, code, version from txp_plugin where status = 1]
[SQL (0.079374): select * from txp_section where name = 'default' limit 1]
[SQL (0.013579): select host from txp_log where ip='24.95.121.243' limit 1]
[SQL (0.029430): select user_html from txp_page where name='default']
[Page: default]
<txp:fla_style_switcher/>
<txp:page_title/>
<txp:output_form form="home_head" />
[SQL (0.028716): select Form from txp_form where name='home_head']
[Form: home_head]
<txp:article form="def_if_excerpt" limit="5" />
[SQL (0.043728): select name from txp_section where on_frontpage != '1']
[SQL (0.075068): select count(*) from textpattern where 1 and Status = 4 and Posted <= now()and Section != 'about' and Section != 'archive' and Section != 'categories' and Section != 'colophon' and Section != 'contact' and Section != 'links']
[SQL (0.221517): select *, unix_timestamp(Posted) as uPosted from textpattern where 1 and Status = 4 and Posted <= now()and Section != 'about' and Section != 'archive' and Section != 'categories' and Section != 'colophon' and Section != 'contact' and Section != 'links' order by Posted desc limit 0, 5]
[SQL (0.000134): select Form from txp_form where name='def_if_excerpt']
[Form: def_if_excerpt]
[article 4718]
<txp:permlink>
<txp:title/>
</txp:permlink>
<txp:posted/>
<txp:swf_if_empty field="excerpt" minlength="2">
<txp:body/>
</txp:swf_if_empty>
<txp:swf_if_not_empty field="excerpt" minlength="2">
</txp:swf_if_not_empty>
<txp:comments_invite/>
<txp:category1 link=1 />
[article 4717]
<txp:permlink>
<txp:title/>
</txp:permlink>
<txp:posted/>
<txp:swf_if_empty field="excerpt" minlength="2">
<txp:body/>
</txp:swf_if_empty>
<txp:swf_if_not_empty field="excerpt" minlength="2">
</txp:swf_if_not_empty>
<txp:comments_invite/>
<txp:category1 link=1 />
[article 4716]
<txp:permlink>
<txp:title/>
</txp:permlink>
<txp:posted/>
<txp:swf_if_empty field="excerpt" minlength="2">
<txp:body/>
</txp:swf_if_empty>
<txp:swf_if_not_empty field="excerpt" minlength="2">
</txp:swf_if_not_empty>
<txp:comments_invite/>
<txp:category1 link=1 />
[article 4715]
<txp:permlink>
<txp:title/>
</txp:permlink>
<txp:posted/>
<txp:swf_if_empty field="excerpt" minlength="2">
<txp:body/>
</txp:swf_if_empty>
<txp:swf_if_not_empty field="excerpt" minlength="2">
</txp:swf_if_not_empty>
<txp:comments_invite/>
<txp:category1 link=1 />
[article 4714]
<txp:permlink>
<txp:title/>
</txp:permlink>
<txp:posted/>
<txp:swf_if_empty field="excerpt" minlength="2">
<txp:body/>
</txp:swf_if_empty>
<txp:swf_if_not_empty field="excerpt" minlength="2">
</txp:swf_if_not_empty>
<txp:comments_invite/>
<txp:category1 link=1 />
<txp:output_form form="front_nav" />
[SQL (0.000220): select Form from txp_form where name='front_nav']
[Form: front_nav]
<txp:if_article_list>
[<txp:if_article_list>: true]
<txp:older>
</txp:older>
<txp:newer>
</txp:newer>
</txp:if_article_list>
<txp:output_form form="tagline" />
[SQL (0.000096): select Form from txp_form where name='tagline']
[Form: tagline]
<txp:site_slogan/>
<txp:fla_altstyle_link style="green">
</txp:fla_altstyle_link>
<txp:fla_altstyle_link style="yellow">
</txp:fla_altstyle_link>
<txp:fla_altstyle_link style="red">
</txp:fla_altstyle_link>
<txp:fla_altstyle_link style="blue">
</txp:fla_altstyle_link>
<txp:fla_altstyle_link style="brown">
</txp:fla_altstyle_link>
<txp:fla_altstyle_link style="default">
</txp:fla_altstyle_link>
<txp:search_input label="Search" button="Search" size="15" />
[SQL (0.000097): select form from txp_form where `name` = 'search_input' limit 1]
<txp:rss_linkcat_list linktosection="archive" />
[SQL (0.000131): SELECT DISTINCT name, title FROM txp_category WHERE name !="default" and name !="root" and type="article" ORDER BY name]
[SQL (0.000127): SELECT DISTINCT name, title FROM txp_category WHERE name !="default" and name !="root" and type="article" ORDER BY name]
<txp:linklist category="Thinkers" form="linklist_li" sort="rand()" wraptag="ul" limit="15" />
[SQL (0.000078): select Form from txp_form where name='linklist_li']
[Form: linklist_li]
[SQL (0.004626): select *, unix_timestamp(date) as uDate from txp_link where category = 'Thinkers' order by rand() limit 15]
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:output_form form="footer" />
[SQL (0.000361): select Form from txp_form where name='footer']
[Form: footer]
<txp:email email="steve@rodentregatta.com" linktext="Email" />
[ ~~~ secondpass ~~~ ]
<txp:css n="" />
<txp:image id="15" />
[SQL (0.000185): select * from txp_image where id = 15 limit 1]
<txp:image id="16" />
[SQL (0.000130): select * from txp_image where id = 16 limit 1]
<txp:image id="17" />
[SQL (0.000148): select * from txp_image where id = 17 limit 1]
<txp:image id="18" />
[SQL (0.000127): select * from txp_image where id = 18 limit 1]
<txp:image id="19" />
[SQL (0.000122): select * from txp_image where id = 19 limit 1]
<txp:image id="20" />
[SQL (0.000136): select * from txp_image where id = 20 limit 1]
-->“Well, I, uh, don’t think it’s quite fair to condemn a whole program because of a single slip-up, sir.” General ‘Buck’ Turgidson
Offline
#6 2006-10-23 02:44:31
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: (4.0.4) posted by and modified by times...
Yes, that’s what we need to see, thanks.
Everything in the query and page output looks consistent.
Article 4718’s Posted date is Sun, 22 Oct 2006 20:15:39 GMT
Article 4717’s Posted date is Sun, 22 Oct 2006 12:39:05 GMT
The article tag query is correctly sorting by Posted in descending order, so it shows 4718 first, then 4717.
Assuming you’re in GMT-0500, those posted timestamps would be 15:15:39 and 07:39:05 respectively. That doesn’t match the timestamp for article 4718 included in your initial post. Has it changed?
The problem might be specific to the way you’re posting articles. Are you posting new articles from scratch, or editing and posting older drafts? If that’s the case, can you tell us exactly what you’re doing, step by step?
Does it happen if you post two fresh new Live articles, without ever saving them as Draft/Pending/Hidden?
Last edited by zem (2006-10-23 02:48:39)
Alex
Offline
Re: (4.0.4) posted by and modified by times...
Neither of the articles were ever draft, pending or hidden.
I’m in GMT-6, USA CDT.
My articles are always written from scratch with infrequent use of the preview tab to check links, etc.
Here’s what I’m about to do:
- Turn on “debugging” mode.
- Write two test articles and publish them (from scratch).
- Post the tag trace before correcting any errors to the home page.
Thanks again for your help. I’ll have this new information posted within the hour.
EDIT/UPDATE:
Test #1 shows the following information:
- Posted by: spilgrim · 23 Oct 2006 · 04:11:10 AM for article number 4719.
- The article posted properly at the top of the weblog.
Test #2 shows the following information:
- Posted by: spilgrim · 23 Oct 2006 · 04:16:40 AM
- The article posted properly at the top of the weblog.
Test #3 involved editing the first article. It now shows the following:
- Posted by: spilgrim · 23 Oct 2006 · 04:11:10 AM; Last modified by: spilgrim · 23 Oct 2006 · 04:19:02 AM
- The article remained in the proper sequence on the home page.
So, these tests show no problems at all. Here’s the tag trace once more:
<!-- Runtime: 0.1738 -->
<!-- Query time: 0.142776 -->
<!-- Queries: 26 -->
<!-- Memory: 2370Kb, <txp:image id="20" /> -->
<!-- txp tag trace:
[SQL (0.006064): select name from txp_lang where lang='en-us' limit 1]
[SQL (0.006045): select name, data from txp_lang where lang='en-us' AND ( event='public' OR event='common')]
[SQL (0.001151): select name, code, version from txp_plugin where status = 1]
[SQL (0.000225): select * from txp_section where name = 'default' limit 1]
[SQL (0.000116): select host from txp_log where ip='24.95.121.243' limit 1]
[SQL (0.000106): select user_html from txp_page where name='default']
[Page: default]
<txp:fla_style_switcher/>
<txp:page_title/>
<txp:output_form form="home_head" />
[SQL (0.000163): select Form from txp_form where name='home_head']
[Form: home_head]
<txp:article form="def_if_excerpt" limit="5" />
[SQL (0.000132): select name from txp_section where on_frontpage != '1']
[SQL (0.108977): select count(*) from textpattern where 1 and Status = 4 and Posted <= now()and Section != 'about' and Section != 'archive' and Section != 'categories' and Section != 'colophon' and Section != 'contact' and Section != 'links']
[SQL (0.001701): select *, unix_timestamp(Posted) as uPosted from textpattern where 1 and Status = 4 and Posted <= now()and Section != 'about' and Section != 'archive' and Section != 'categories' and Section != 'colophon' and Section != 'contact' and Section != 'links' order by Posted desc limit 0, 5]
[SQL (0.000112): select Form from txp_form where name='def_if_excerpt']
[Form: def_if_excerpt]
[article 4720]
<txp:permlink>
<txp:title/>
</txp:permlink>
<txp:posted/>
<txp:swf_if_empty field="excerpt" minlength="2">
<txp:body/>
</txp:swf_if_empty>
<txp:swf_if_not_empty field="excerpt" minlength="2">
</txp:swf_if_not_empty>
<txp:comments_invite/>
<txp:category1 link=1 />
[article 4719]
<txp:permlink>
<txp:title/>
</txp:permlink>
<txp:posted/>
<txp:swf_if_empty field="excerpt" minlength="2">
<txp:body/>
</txp:swf_if_empty>
<txp:swf_if_not_empty field="excerpt" minlength="2">
</txp:swf_if_not_empty>
<txp:comments_invite/>
<txp:category1 link=1 />
[article 4718]
<txp:permlink>
<txp:title/>
</txp:permlink>
<txp:posted/>
<txp:swf_if_empty field="excerpt" minlength="2">
<txp:body/>
</txp:swf_if_empty>
<txp:swf_if_not_empty field="excerpt" minlength="2">
</txp:swf_if_not_empty>
<txp:comments_invite/>
<txp:category1 link=1 />
[article 4717]
<txp:permlink>
<txp:title/>
</txp:permlink>
<txp:posted/>
<txp:swf_if_empty field="excerpt" minlength="2">
<txp:body/>
</txp:swf_if_empty>
<txp:swf_if_not_empty field="excerpt" minlength="2">
</txp:swf_if_not_empty>
<txp:comments_invite/>
<txp:category1 link=1 />
[article 4716]
<txp:permlink>
<txp:title/>
</txp:permlink>
<txp:posted/>
<txp:swf_if_empty field="excerpt" minlength="2">
<txp:body/>
</txp:swf_if_empty>
<txp:swf_if_not_empty field="excerpt" minlength="2">
</txp:swf_if_not_empty>
<txp:comments_invite/>
<txp:category1 link=1 />
<txp:output_form form="front_nav" />
[SQL (0.000109): select Form from txp_form where name='front_nav']
[Form: front_nav]
<txp:if_article_list>
[<txp:if_article_list>: true]
<txp:older>
</txp:older>
<txp:newer>
</txp:newer>
</txp:if_article_list>
<txp:output_form form="tagline" />
[SQL (0.000095): select Form from txp_form where name='tagline']
[Form: tagline]
<txp:site_slogan/>
<txp:fla_altstyle_link style="green">
</txp:fla_altstyle_link>
<txp:fla_altstyle_link style="yellow">
</txp:fla_altstyle_link>
<txp:fla_altstyle_link style="red">
</txp:fla_altstyle_link>
<txp:fla_altstyle_link style="blue">
</txp:fla_altstyle_link>
<txp:fla_altstyle_link style="brown">
</txp:fla_altstyle_link>
<txp:fla_altstyle_link style="default">
</txp:fla_altstyle_link>
<txp:search_input label="Search" button="Search" size="15" />
[SQL (0.000089): select form from txp_form where `name` = 'search_input' limit 1]
<txp:rss_linkcat_list linktosection="archive" />
[SQL (0.000141): SELECT DISTINCT name, title FROM txp_category WHERE name !="default" and name !="root" and type="article" ORDER BY name]
[SQL (0.000137): SELECT DISTINCT name, title FROM txp_category WHERE name !="default" and name !="root" and type="article" ORDER BY name]
<txp:linklist category="Thinkers" form="linklist_li" sort="rand()" wraptag="ul" limit="15" />
[SQL (0.000090): select Form from txp_form where name='linklist_li']
[Form: linklist_li]
[SQL (0.005598): select *, unix_timestamp(date) as uDate from txp_link where category = 'Thinkers' order by rand() limit 15]
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:linkdesctitle/>
<txp:output_form form="footer" />
[SQL (0.000117): select Form from txp_form where name='footer']
[Form: footer]
<txp:email email="steve@rodentregatta.com" linktext="Email" />
[ ~~~ secondpass ~~~ ]
<txp:css n="" />
<txp:image id="15" />
[SQL (0.000140): select * from txp_image where id = 15 limit 1]
<txp:image id="16" />
[SQL (0.000135): select * from txp_image where id = 16 limit 1]
<txp:image id="17" />
[SQL (0.000133): select * from txp_image where id = 17 limit 1]
<txp:image id="18" />
[SQL (0.000135): select * from txp_image where id = 18 limit 1]
<txp:image id="19" />
[SQL (0.000132): select * from txp_image where id = 19 limit 1]
<txp:image id="20" />
[SQL (0.000132): select * from txp_image where id = 20 limit 1]
-->Last edited by 6sigma (2006-10-23 09:21:45)
“Well, I, uh, don’t think it’s quite fair to condemn a whole program because of a single slip-up, sir.” General ‘Buck’ Turgidson
Offline
#8 2006-10-23 11:16:37
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: (4.0.4) posted by and modified by times...
Ok, so it looks like everything works fine under normal circumstances. Whatever the problem is, it’s triggered by something else. The tag trace looks fine.
Can you tell me what’s up with the timestamp difference on article 4718? 11:51:21 PM in your original post, 20:15:39 GMT (15:15:39?) according to the XML feed. Did you reset the timestamp, or is there a genuine difference?
Alex
Offline
Re: (4.0.4) posted by and modified by times...
Each time I discover an article has posted out of sequence and go into Textpattern and reset the time. However, this happens within 2 to 3 minutes of the original post time. That time discrepancy on 4718 remains unexplained.
The times on this morning’s two articles and one edit came out as expected. Two more tests within the past few minutes also posted fine with Textpattern set in debugging mode.
“Well, I, uh, don’t think it’s quite fair to condemn a whole program because of a single slip-up, sir.” General ‘Buck’ Turgidson
Offline
#10 2006-10-23 22:10:52
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: (4.0.4) posted by and modified by times...
I’m not quite clear on exactly what you’re saying here.
Each time I discover an article has posted out of sequence and go into Textpattern and reset the time. However, this happens within 2 to 3 minutes of the original post time.
Are you saying there’s a 2-3 minute difference? Between what and what?
That time discrepancy on 4718 remains unexplained.
Do you mean that the article timestamp still shows as 11:51:21 PM in the back-end?
One simple change that might help identify the problem is to use a Date Format (admin > prefs) that includes the time on your posts, rather than just the date.
Alex
Offline
Re: (4.0.4) posted by and modified by times...
zem wrote:
I’m not quite clear on exactly what you’re saying here.
Each time I discover an article has posted out of sequence and go into Textpattern and reset the time. However, this happens within 2 to 3 minutes of the original post time.
Are you saying there’s a 2-3 minute difference? Between what and what?
I’m saying that immediately after pressing the publish button, I refresh my site and see if everything is ok. If I find articles out of sequence on the home page, I go back to the article in Textpattern and check “reset time to now” under the “more” link. That puts the “reset (modified) time” only a couple of minutes after the “publish time” – not several hours different.
That time discrepancy on 4718 remains unexplained.
Do you mean that the article timestamp still shows as 11:51:21 PM in the back-end?
No. On the “Articles” tab, 4718 shows 22 Oct 2006 03:15 PM.
One simple change that might help identify the problem is to use a Date Format (admin > prefs) that includes the time on your posts, rather than just the date.
Done!
“Well, I, uh, don’t think it’s quite fair to condemn a whole program because of a single slip-up, sir.” General ‘Buck’ Turgidson
Offline
Re: (4.0.4) posted by and modified by times...
This afternoon at 2:05pm, I began composing an article. At 2:25pm, I pressed the publish button in Textpattern. On the write tab and beneath the excerpt-entry field were the following times: Posted by: xxxx · 24 Oct 2006 · 04:17:33 AM Last modified by: · 24 Oct 2006 · 02:31:24 PM. The article was never a draft, hidden or anything else. I previewed it twice before actually posting it.
The article (#4723) appeared in the proper place on the home page, but shows a time of 04:17 which corresponds with the “posted” time shown on the write tab of Textpattern.
I’m no longer all that worried about this phenomenon, but it does seem a bit odd.
edited a spelling error
Last edited by 6sigma (2006-10-24 19:41:01)
“Well, I, uh, don’t think it’s quite fair to condemn a whole program because of a single slip-up, sir.” General ‘Buck’ Turgidson
Offline