Textpattern CMS

#13 2008-12-31 19:22:46

kiplet

Member

Registered: 2006-01-28

Posts: 33

Re: Question regarding how comments are built.

Yup; I was typing as you posted.

thebombsite wrote:

It’s the tag in the comment and preview form. <txp:message /> should now be <txp:comment_message />. That suggests this site might be older than the other two?

Nah, both the other two also have <txp:message />. I just updated the problem site (currently running 4.0.7; the other two run 4.0.5) to change comments to

<txp:comment_message /><br />
<small>&#8212; <txp:comment_name /> &#160;&#160; <txp:comment_time /> &#160;&#160; <txp:comment_permlink>#</txp:comment_permlink></small>

This did not fix the issue.

Last edited by kiplet (2008-12-31 19:23:49)

#14 2008-12-31 19:32:41

thebombsite

Archived Plugin Author

From: Exmouth, England

Registered: 2004-08-24

Posts: 3,251

Website

Re: Question regarding how comments are built.

When Els asked about a tag trace what she was talking about was this; if you go into the problem site’s admin, go to the “Preferences” tab and set the “Production Status” to “Debugging”, then navigate to your site’s page where comments should appear but don’t, then view the source code, near the bottom you will see the “txp tag trace” (for me it usually displays in green). This shows you TXP’s logic as it parses through your page template. If you can copy/paste that here we might be able to see where things are going wrong.

Don’t forget to change the “Production Status” option back to what it was.

---

Stuart

In a Time of Universal Deceit
Telling the Truth is Revolutionary.

#15 2008-12-31 19:42:01

kiplet

Member

Registered: 2006-01-28

Posts: 33

Re: Question regarding how comments are built.

Whoa!

	<txp:comments />
		tag_error <txp:comments /> -> Textpattern Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
select *, unix_timestamp(posted) as time from txp_discuss where parentid=321 and visible=1 order by  
textpattern/lib/txplib_db.php:220 startrows()  on line 82
		[SQL (0.0001060962677): select *, unix_timestamp(posted) as time from txp_discuss where parentid=321 and visible=1 order by  ]

thebombsite, thanks for the patient explanation.

Now the question becomes: since this is on the same ISP and server as the other two, how did the SQL syntax get borked?

#16 2009-01-01 10:55:25

thebombsite

Archived Plugin Author

From: Exmouth, England

Registered: 2004-08-24

Posts: 3,251

Website

Re: Question regarding how comments are built.

Aha. Now I can’t help you with that I’m afraid. We need one of the devs or someone with SQL knowledge to sort this methinks.

Could you copy that last post to the “Developer Support” forum? Might get a quicker answer there.

---

Stuart

In a Time of Universal Deceit
Telling the Truth is Revolutionary.

#17 2009-01-01 15:30:40

kiplet

Member

Registered: 2006-01-28

Posts: 33

Re: Question regarding how comments are built.

Done and done. Posted to the troubleshooting forum there.

http://forum.textpattern.com/viewtopic.php?pid=197083

Thanks for getting me this far!

#18 2009-01-01 17:04:21

kiplet

Member

Registered: 2006-01-28

Posts: 33

Re: Question regarding how comments are built.

All fixed! And I knew it was something stupid. I had an old custom field named sort on that particular site, no longer in use but never removed. Removed it; voila! Comments appear as they should.

Thanks everyone. Much better now.