форум общения русскоязычных пользователей CMS Текстпаттерн
Вы не зашли.
Всем привет. Второй день как изучаю textpattern, скачал с офсайта версию 4.2, поставил на денвер, создал одну тестовую статью.. И обратил внимание, что если открывать те статьи, в которых включены комментарии, страница открывается очень долго. В чем может быть проблема? Вот отладочный код статьи с комментами:
<!-- Runtime: 15,023 -->
<!-- Query time: 0,009412 -->
<!-- Queries: 27 -->
<!-- Memory: 2739Kb, <txp:comments_help /> -->
<!-- txp tag trace:
[SQL (0,00247001647949): select name, data from tp_txp_lang as txp_lang where lang='ru-ru' AND ( event='public' OR event='common')]
[SQL (0,000296115875244): select name, code, version from tp_txp_plugin as txp_plugin where status = 1 AND type IN (0,1) order by load_order]
[SQL (0,000397920608521): select ID,Section from tp_textpattern as textpattern where posted like '2010-03-10%' and url_title like 'welcome-to-your-site' and Status >= 4 limit 1]
[SQL (0,000283002853394): select page, css from tp_txp_section as txp_section where name = 'articles' limit 1]
[SQL (0,000231981277466): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from tp_textpattern as textpattern where ID=1 and Status in (4,5)]
[статья 1]
[SQL (0,000250816345215): select ID, Title, url_title, unix_timestamp(Posted) as uposted
from tp_textpattern where Posted > '2010-03-10 16:58:39' and Section = 'articles' and Status=4 and Posted < now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') order by Posted asc limit 1]
[SQL (0,000200986862183): select ID, Title, url_title, unix_timestamp(Posted) as uposted
from tp_textpattern where Posted < '2010-03-10 16:58:39' and Section = 'articles' and Status=4 and Posted < now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') order by Posted desc limit 1]
[SQL (0,000330924987793): select host from tp_txp_log as txp_log where ip='127.0.0.1' limit 1]
[SQL (0,0001540184021): insert into tp_txp_log set `time`=now(),page='/2010/03/10/welcome-to-your-site',ip='127.0.0.1',host='localhost',refer='',status='200',method='GET']
[SQL (0,00029993057251): select user_html from tp_txp_page as txp_page where name='archive']
[Страница: archive]
<txp:page_title />
<txp:site_url />
<txp:feed_link flavor="atom" format="link" label="Atom" />
<txp:feed_link flavor="rss" format="link" label="RSS" />
<txp:css format="link" />
<txp:rsd />
<txp:section />
<txp:text item="go_content" />
<txp:text item="go_nav" />
<txp:text item="go_search" />
<txp:link_to_home>
<txp:site_name />
</txp:link_to_home>
<txp:site_slogan />
<txp:section_list default_title='<txp:text item="home" />' include_default="1" wraptag="ul" break="li">
[attribute 'default_title']
<txp:text item="home" />
[/attribute]
[SQL (0,000159978866577): select name, title from tp_txp_section as txp_section where name != 'default' order by name ASC]
<txp:if_section name='<txp:section />'>
[attribute 'name']
<txp:section />
[/attribute]
[<txp:if_section name='<txp:section />'>: false]
</txp:if_section>
<txp:section link="1" title="1" />
<txp:if_section name='<txp:section />'>
[attribute 'name']
<txp:section />
[/attribute]
[<txp:if_section name='<txp:section />'>: false]
</txp:if_section>
<txp:if_section name='<txp:section />'>
[attribute 'name']
<txp:section />
[/attribute]
[<txp:if_section name='<txp:section />'>: false]
</txp:if_section>
<txp:section link="1" title="1" />
<txp:if_section name='<txp:section />'>
[attribute 'name']
<txp:section />
[/attribute]
[<txp:if_section name='<txp:section />'>: false]
</txp:if_section>
<txp:if_section name='<txp:section />'>
[attribute 'name']
<txp:section />
[/attribute]
[<txp:if_section name='<txp:section />'>: true]
</txp:if_section>
<txp:section link="1" title="1" />
<txp:if_section name='<txp:section />'>
[attribute 'name']
<txp:section />
[/attribute]
[<txp:if_section name='<txp:section />'>: true]
<txp:article_custom section='<txp:section />' wraptag="ul" break="li">
[attribute 'section']
<txp:section />
[/attribute]
[SQL (0,000364065170288): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from tp_textpattern as textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and Section IN ('articles') order by Posted desc limit 0, 10]
[статья 3]
<txp:if_article_id>
[<txp:if_article_id>: false]
</txp:if_article_id>
<txp:permlink>
<txp:title />
</txp:permlink>
[статья 2]
<txp:if_article_id>
[<txp:if_article_id>: false]
</txp:if_article_id>
<txp:permlink>
<txp:title />
</txp:permlink>
[статья 1]
<txp:if_article_id>
[<txp:if_article_id>: true]
</txp:if_article_id>
<txp:permlink>
<txp:title />
</txp:permlink>
</txp:article_custom>
</txp:if_section>
</txp:section_list>
<txp:search_input wraptag="p" />
[SQL (0,000294923782349): select form from tp_txp_form where `name` = 'search_input' limit 1]
<txp:feed_link label="RSS" />
<txp:feed_link flavor="atom" label="Atom" />
<txp:linklist wraptag="p" />
[SQL (0,000345945358276): select *, unix_timestamp(date) as uDate from tp_txp_link as txp_link where 1=1 order by linksort asc ]
[SQL (0,000117063522339): select Form from tp_txp_form as txp_form where name='plainlinks']
[Форма: plainlinks]
<txp:linkdesctitle />
[Форма: plainlinks]
<txp:linkdesctitle />
[Форма: plainlinks]
<txp:linkdesctitle />
<txp:image id="2" />
[SQL (0,000318050384521): select * from tp_txp_image as txp_image where id = 2 limit 1]
<txp:if_article_list>
[<txp:if_article_list>: false]
</txp:if_article_list>
<txp:article listform="article_listing" limit="5" />
[SQL (0,000112056732178): select Form from tp_txp_form as txp_form where name='default']
[Форма: default]
<txp:if_individual_article>
[<txp:if_individual_article>: true]
<txp:permlink>
<txp:title />
</txp:permlink>
</txp:if_individual_article>
<txp:posted />
<txp:body />
<txp:author />
[SQL (0,000295877456665): select RealName from tp_txp_users where `name` = 'swap' limit 1]
<txp:category1 title="1" link="1" />
[SQL (0,000308036804199): select title from tp_txp_category as txp_category where name='hope-for-the-future' and type='article']
<txp:category2 title="1" link="1" />
[SQL (0,000124931335449): select title from tp_txp_category as txp_category where name='meaningful-labor' and type='article']
<txp:comments_invite wraptag="p" />
<txp:image id="1" />
[SQL (0,000121831893921): select * from tp_txp_image as txp_image where id = 1 limit 1]
[SQL (0,000104188919067): select Form from tp_txp_form as txp_form where name='comments_display']
[Форма: comments_display]
<txp:text item="comment" />
<txp:comments_invite textonly="1" showalways="1" showcount="0" />
<txp:comments />
[SQL (0,000313997268677): select *, unix_timestamp(posted) as time from tp_txp_discuss as txp_discuss where parentid=1 and visible=1 order by posted ASC ]
[SQL (0,000110864639282): select Form from tp_txp_form as txp_form where name='comments']
[Форма: comments]
<txp:comment_message />
<txp:comment_name />
<txp:comment_time />
<txp:comment_permlink>
</txp:comment_permlink>
<txp:if_comments_preview>
[<txp:if_comments_preview>: false]
</txp:if_comments_preview>
<txp:if_comments_allowed>
[<txp:if_comments_allowed>: true]
<txp:comments_form isize="25" msgcols="45" msgrows="15" />
[SQL (0,000466108322144): select ip from tp_txp_discuss_ipban where `ip` = '127.0.0.1' limit 1]
[SQL (0,000141859054565): select Form from tp_txp_form where `name` = 'comment_form' limit 1]
<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_individual_article>
[<txp:if_individual_article>: true]
<txp:image id="1" />
<txp:link_to_prev>
</txp:link_to_prev>
<txp:link_to_next>
<txp:next_title />
</txp:link_to_next>
</txp:if_individual_article>
[ ~~~ secondpass ~~~ ]
-->
Неактивен
http://textpattern.com/faq/305/why-do-m … oad-slowly
Для незнающих английский:
Preferences > Advanced > Publish > Spam blacklists (comma-separated)
Настройки > Продвинутые > Комментарии > Сервисы, блокирующие спам (через запятую)
удалите sbl.spamhaus.org
Неактивен
спасибо. Все оказалось проще некуда
Неактивен