Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2006-09-27 16:24:38

nicklas
Member
Registered: 2004-04-13
Posts: 12
Website

r1857 - Comments don't really work (solved)

It’s possible I’ve done something wrong, especially if things have changed extsince 4.0.3 in this, but the preview and all that works fine. When I push send though, it just hangs there and don’t update the database. (They did work when I downgraded temporarily to 4.0.3)

Edit: and yeah, I’ve checked to FAQ about the changes to the comments.

Edit #2: the debug-info on the page:

<code>
!— Runtime: 0,0902 —
!— Query time: 0,000742 —
!— Queries: 27 —
!— Memory: 2715Kb, <txp:comments_help /> —
!— txp tag trace:
[SQL (0,000366): select name from txp_lang where lang=‘sv-se’ limit 1]
[SQL (0,014851): select name, data from txp_lang where lang=‘sv-se’ AND ( event=‘public’ OR event=‘common’)]
[SQL (0,008308): select name, code, version from txp_plugin where status=‘1’]
[SQL (0,000980): select ID, Section from textpattern where ID = 186 and Section = ‘ord’ and Status >= ‘4’ limit 1]
[SQL (0,001171): select * from txp_section where name = ‘ord’ limit 1]
[SQL (0,001438): select *, unix_timestamp(Posted) as uPosted from textpattern where ID=‘186’ and Status = ‘4’]
[artikel 186]
[SQL (0,000876): select ID, Title, url_title, unix_timestamp(Posted) as uposted from textpattern where Posted > ’2006-09-26 19:26:00’ and Section = ‘ord’ and Status=4 and Posted < now() order by Posted asc limit 1]
[SQL (0,005350): select ID, Title, url_title, unix_timestamp(Posted) as uposted from textpattern where Posted < ’2006-09-26 19:26:00’ and Section = ‘ord’ and Status=4 and Posted < now() order by Posted desc limit 1]
[SQL (0,000897): select host from txp_log where ip=‘81.225.3.249’ limit 1]
[SQL (0,000793): insert into txp_log set `time`=now(),page=’/sv/ord/186/’,ip=‘81.225.3.249’,host=‘h249n1c1o1122.bredband.skanova.com’,refer=’‘,status=‘200’,method=‘POST’]
[SQL (0,000962): select user_html from txp_page where name=‘2archive’]
[Sida: 2archive]
</code>*snip things that don’t matter for this*<code> <txp:comments/> [SQL (0,000621): select Form from txp_form where name=‘comments’] [Siddel: comments] [SQL (0,000958): select *, unix_timestamp(posted) as time from txp_discuss where parentid=‘186’ and visible=1 order by posted asc] <txp:if_comments_preview> [<txp:if_comments_preview>: true] <txp:comments_preview form=“previewcomment” /> [SQL (0,000687): select Form from txp_form where name=‘previewcomment’] [Siddel: previewcomment] <txp:comment_message/> <txp:comment_name/> <txp:comment_permlink> </txp:comment_permlink> <txp:comment_time/> </txp:if_comments_preview> <txp:if_comments_allowed> [<txp:if_comments_allowed>: true] <txp:comments_form/> [SQL (0,000567): insert into txp_discuss_nonce set issue_time=now(), nonce=‘5cadc0659b139f62edeb6ecae807143b’, secret=‘e97033662f40cfba19cff5c25ee7ed93’] [SQL (0,000722): select Form from txp_form where `name` = ‘comment_form’ limit 1]
</code><code> <txp:comments_error wraptag=“ul” break=“li” /> <txp:text item=“comment_name” /> <txp:text item=“comment_email” /> <txp:text item=“comment_web” /> <txp:text item=“comment_message” /> <txp:comments_help/> </txp:if_comments_allowed>
<txp:if_article_list> [<txp:if_article_list>: false]
</txp:if_article_list>
[ ~~~ secondpass ~~~ ]
</code>

Last edited by nicklas (2006-09-27 23:42:23)

Offline

#2 2006-09-27 22:49:13

zem
Developer Emeritus
From: Melbourne, Australia
Registered: 2004-04-08
Posts: 2,579

Re: r1857 - Comments don't really work (solved)

N,

In admin > prefs > advanced, try blanking out the “spam blacklists” setting. Default is bl.spamcop.net,sbl.spamhaus.org.


Alex

Offline

#3 2006-09-27 23:06:53

nicklas
Member
Registered: 2004-04-13
Posts: 12
Website

Re: r1857 - Comments don't really work (solved)

zem wrote:

In admin > prefs > advanced, try blanking out the “spam blacklists” setting. Default is bl.spamcop.net,sbl.spamhaus.org.

Well, what do you know, it worked. Thanks. Odd though as when I pasted them back to see if I could use one of them, it still works even though both of them are there.

Offline

#4 2006-09-28 07:02:02

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: r1857 - Comments don't really work (solved)

It should be real easy to check if that could’ve been the problem:
Fill out your own IPnr (http://www.whatismyip.com/) in these places:
http://www.spamcop.net/bl.shtml
http://www.spamhaus.org/sbl/index.lasso

If it’s not listed those blacklists shouldn’t interfere with you posting comments.

It is of course possible that you were listed on spamcop for a short while and that this was undone while you were testing with removing the spamblacklist settings. Spamcop tends to give a much higher rate of false positives than sbl.spamhaus (when used as an RBL in mailing lists, but probably in this situation as well).

Last edited by ruud (2006-09-28 07:05:28)

Offline

Board footer

Powered by FluxBB