Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2008-11-13 16:02:27

thebombsite
Plugin Author
From: Exmouth, England
Registered: 2004-08-24
Posts: 3,251
Website

r2991 - No article listing for search page

I’m bringing this here as I think it’s an introduced bug. I’m currently on r2991 but my feeling is that this may be concerned with r2990. The following code is from thebombsite.com but it is happening on all 3 sites including my vanilla install. You can delete the identical post in the “Troubleshooting” forum.

I don’t know when this started, maybe it’s due to a revision, currently on r2991, but my search page is having a fit. It will display the number of results and the search term in the “title” and also my googlenav plug-in displays the links to all the pages, however there are no results, ie articles, displayed. I’ve checked all my page and form template code which I can show if you want but I think that might be pointless as I have the feeling that this is to do with the database.

Putting the site into debugging mode displays the following at the top of the page:-

Tag error:  <txp:article searchform="search_results" limit="10" /> ->  Textpattern Warning: Can't find FULLTEXT index matching the column list
select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod, match (Title, Body, Excerpt, Keywords) against ('violent') as score from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = 0) and (Title rlike 'violent' or Body rlike 'violent' or Excerpt rlike 'violent' or Keywords rlike 'violent') and Section != 'archivescat' and Section != 'search' order by score desc limit 0, 10
textpattern/lib/txplib_db.php:220 startRows()  on line 82

followed by this:-

textpattern/lib/txplib_db.php:82 trigger_error()
textpattern/lib/txplib_db.php:282 safe_query()
textpattern/lib/txplib_db.php:220 startRows()
textpattern/publish.php:734 safe_rows_start()
textpattern/publish.php:877 doArticles()
textpattern/publish.php:550 parseArticles()
textpattern/publish.php:1080 article()
textpattern/publish.php:1002 processTags()
textpattern/publish.php:496 parse()
index.php:40 textpattern()

Here’s the tag trace if needed. Sorry but it’s a bit long. :(

<!-- txp tag trace: 
[SQL (0.000108003616333): select name, data from txp_lang where lang='en-gb' AND ( event='public' OR event='common')]
[SQL (0.000228881835938): select name, code, version from txp_plugin where status = 1 AND type IN (0,1) order by load_order]
[SQL (6.69956207275E-5): select name from txp_section where `name` like 'search' limit 1]
[SQL (3.60012054443E-5): select page, css from txp_section where name = 'search' limit 1]
[SQL (3.88622283936E-5): select user_html from txp_page where name='search']
[Page: search]
<txp:output_form form="DTD_head" />
	[SQL (3.88622283936E-5): select Form from txp_form where name='DTD_head']
	[Form: DTD_head]
	<txp:output_form form="meta_title_element" />
		[SQL (3.60012054443E-5): select Form from txp_form where name='meta_title_element']
		[Form: meta_title_element]
		<txp:if_article_list>
			[<txp:if_article_list>: true]
			<txp:if_category>
				[<txp:if_category>: false]
				<txp:if_section name="default">
					[<txp:if_section name="default">: false]
					<txp:section title="1" />
						[SQL (3.69548797607E-5): select title from txp_section where name='search']
					<txp:page_url type="pg" />
				</txp:if_section>
				<txp:site_name />
			</txp:if_category>
		</txp:if_article_list>
		<txp:if_individual_article>
			[<txp:if_individual_article>: false]
		</txp:if_individual_article>
	<txp:output_form form="meta_description" />
		[SQL (3.88622283936E-5): select Form from txp_form where name='meta_description']
		[Form: meta_description]
		<txp:if_section name="default">
			[<txp:if_section name="default">: false]
		</txp:if_section>
		<txp:if_section name="about,archivescat,contact,links,privacy,resume">
			[<txp:if_section name="about,archivescat,contact,links,privacy,resume">: false]
		</txp:if_section>
		<txp:if_section name="articles">
			[<txp:if_section name="articles">: false]
		</txp:if_section>
		<txp:if_section name="textpattern-coding">
			[<txp:if_section name="textpattern-coding">: false]
		</txp:if_section>
		<txp:if_section name="textpattern-themes">
			[<txp:if_section name="textpattern-themes">: false]
		</txp:if_section>
	<txp:output_form form="meta_keywords" />
		[SQL (3.71932983398E-5): select Form from txp_form where name='meta_keywords']
		[Form: meta_keywords]
		<txp:if_individual_article>
			[<txp:if_individual_article>: false]
		</txp:if_individual_article>
	<txp:site_url />
	<txp:output_form form="meta_feeds" />
		[SQL (3.50475311279E-5): select Form from txp_form where name='meta_feeds']
		[Form: meta_feeds]
		<txp:feed_link flavor="atom" format="link" label="XML" limit="5" section="articles" title="Weblog Articles" />
		<txp:feed_link flavor="atom" format="link" label="XML" limit="5" section="textpattern-themes" title="Textpattern Themes" />
		<txp:feed_link flavor="atom" format="link" label="XML" limit="5" section="textpattern-coding" title="Textpattern Coding" />
	<txp:rvm_css format="link" />
		[SQL (3.50475311279E-5): select css from txp_section where name='search']
	<txp:rvm_css format="link" n="print" media="print" />
	<txp:rvm_css format="link" n="ie7" media="screen" />
	<txp:rvm_css format="link" n="ie" media="screen" />
<txp:section />
<txp:output_form form="header" />
	[SQL (4.00543212891E-5): select Form from txp_form where name='header']
	[Form: header]
	<txp:link_to_home>
		<txp:image id="735" />
			[SQL (4.79221343994E-5): select * from txp_image where id = 735 limit 1]
	</txp:link_to_home>
	<txp:php>
	</txp:php>
	<txp:php>
	</txp:php>
<txp:output_form form="top_nav" />
	[SQL (4.29153442383E-5): select Form from txp_form where name='top_nav']
	[Form: top_nav]
	<txp:if_section name="default">
		[<txp:if_section name="default">: false]
	</txp:if_section>
	<txp:site_url />
	<txp:if_section name="articles">
		[<txp:if_section name="articles">: false]
	</txp:if_section>
	<txp:site_url />
	<txp:if_section name="textpattern-coding">
		[<txp:if_section name="textpattern-coding">: false]
	</txp:if_section>
	<txp:site_url />
	<txp:if_section name="textpattern-themes">
		[<txp:if_section name="textpattern-themes">: false]
	</txp:if_section>
	<txp:site_url />
	<txp:if_section name="contact">
		[<txp:if_section name="contact">: false]
	</txp:if_section>
	<txp:site_url />
	<txp:if_section name="archivescat">
		[<txp:if_section name="archivescat">: false]
	</txp:if_section>
	<txp:site_url />
	<txp:if_section name="links">
		[<txp:if_section name="links">: false]
	</txp:if_section>
	<txp:site_url />
	<txp:if_section name="about">
		[<txp:if_section name="about">: false]
	</txp:if_section>
	<txp:site_url />
<txp:output_form form="header1" />
	[SQL (3.79085540771E-5): select Form from txp_form where name='header1']
	[Form: header1]
	<txp:if_article_list>
		[<txp:if_article_list>: true]
		<txp:if_category>
			[<txp:if_category>: false]
			<txp:if_section name="default">
				[<txp:if_section name="default">: false]
				<txp:section title="1" />
				<txp:page_url type="pg" />
			</txp:if_section>
			<txp:site_name />
		</txp:if_category>
	</txp:if_article_list>
	<txp:if_individual_article>
		[<txp:if_individual_article>: false]
	</txp:if_individual_article>
<txp:if_section name=",default">
	[<txp:if_section name=",default">: false]
	<txp:section title="1" />
</txp:if_section>
<txp:article pgonly="1" limit="10" />
	[SQL (7.20024108887E-5): select name from txp_section where searchable != '1']
	[SQL (0.0460021495819): select count(*) from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = 0) and (Title rlike 'violent' or Body rlike 'violent' or Excerpt rlike 'violent' or Keywords rlike 'violent') and Section != 'archivescat' and Section != 'search']
<txp:search_result_count text="search results for" />
<txp:search_term />
<txp:article searchform="search_results" limit="10" />
	[SQL (5.60283660889E-5): select name from txp_section where searchable != '1']
	[SQL (0.0456879138947): select count(*) from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = 0) and (Title rlike 'violent' or Body rlike 'violent' or Excerpt rlike 'violent' or Keywords rlike 'violent') and Section != 'archivescat' and Section != 'search']
	Tag error:  <txp:article searchform="search_results" limit="10" /> -> Textpattern Warning: Can't find FULLTEXT index matching the column list
select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod, match (Title, Body, Excerpt, Keywords) against ('violent') as score from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = 0) and (Title rlike 'violent' or Body rlike 'violent' or Excerpt rlike 'violent' or Keywords rlike 'violent') and Section != 'archivescat' and Section != 'search' order by score desc limit 0, 10
textpattern/lib/txplib_db.php:220 startRows()  on line 82
	[SQL (0.000236988067627): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod, match (Title, Body, Excerpt, Keywords) against ('violent') as score from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = 0) and (Title rlike 'violent' or Body rlike 'violent' or Excerpt rlike 'violent' or Keywords rlike 'violent') and Section != 'archivescat' and Section != 'search' order by score desc limit 0, 10]
<txp:ob1_pagination maximumtabs="7" ulid="googlenav" liempty="empty" liselected="here" />
<txp:output_form form="sidebar" />
	[SQL (5.00679016113E-5): select Form from txp_form where name='sidebar']
	[Form: sidebar]
	<txp:rah_google_translate site_language="en" button="Translate" languages="ca|Catala, cs|Cesky, da|Dansk, de|Deutsch, es|Espanol, fi|suomi, fr|Francais, ru|Russian, sv|Svenska" />
	<txp:if_section name="articles">
		[<txp:if_section name="articles">: false]
	</txp:if_section>
	<txp:if_section name="textpattern-coding">
		[<txp:if_section name="textpattern-coding">: false]
	</txp:if_section>
	<txp:if_section name="textpattern-themes">
		[<txp:if_section name="textpattern-themes">: false]
	</txp:if_section>
	<txp:if_section name="about,archivescat,contact,links,privacy">
		[<txp:if_section name="about,archivescat,contact,links,privacy">: false]
	</txp:if_section>
	<txp:if_section name="links">
		[<txp:if_section name="links">: false]
		<txp:linklist break="li" category="textpattern" sort="linksort asc" wraptag="ul" />
			[SQL (5.79357147217E-5): select *, unix_timestamp(date) as uDate from txp_link where category IN ('textpattern') order by linksort asc ]
			[SQL (3.71932983398E-5): select Form from txp_form where name='plainlinks']
			[Form: plainlinks]
			<txp:linkdesctitle />
			[Form: plainlinks]
			<txp:linkdesctitle />
			[Form: plainlinks]
			<txp:linkdesctitle />
			[Form: plainlinks]
			<txp:linkdesctitle />
			[Form: plainlinks]
			<txp:linkdesctitle />
			[Form: plainlinks]
			<txp:linkdesctitle />
			[Form: plainlinks]
			<txp:linkdesctitle />
			[Form: plainlinks]
			<txp:linkdesctitle />
			[Form: plainlinks]
			<txp:linkdesctitle />
			[Form: plainlinks]
			<txp:linkdesctitle />
			[Form: plainlinks]
			<txp:linkdesctitle />
			[Form: plainlinks]
			<txp:linkdesctitle />
			[Form: plainlinks]
			<txp:linkdesctitle />
			[Form: plainlinks]
			<txp:linkdesctitle />
			[Form: plainlinks]
			<txp:linkdesctitle />
	</txp:if_section>
	<txp:if_section name="contact">
		[<txp:if_section name="contact">: false]
		<txp:image id="746" />
			[SQL (4.79221343994E-5): select * from txp_image where id = 746 limit 1]
		<txp:image id="739" />
			[SQL (5.50746917725E-5): select * from txp_image where id = 739 limit 1]
		<txp:hide>
		</txp:hide>
	</txp:if_section>
<txp:output_form form="footer" />
	[SQL (3.81469726562E-5): select Form from txp_form where name='footer']
	[Form: footer]
	<txp:image id="616" />
		[SQL (4.60147857666E-5): select * from txp_image where id = 616 limit 1]
	<txp:php>
	</txp:php>
	<txp:site_url />
<txp:output_form form="google_analytics" />
	[SQL (3.79085540771E-5): select Form from txp_form where name='google_analytics']
	[Form: google_analytics]
[ ~~~ secondpass ~~~ ]
 -->

This shows the tag error reported in the above notice.

If you need anything else let me know.


Stuart

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

Offline

#2 2008-11-13 17:44:54

the_ghost
Plugin Author
From: Minsk, The Republic of Belarus
Registered: 2007-07-26
Posts: 907
Website

Re: r2991 - No article listing for search page

Did you try to recreate index for textpattern table? Some time ago ruud adviced me to do this when i didn’t het search_results_excerpts


Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?

Offline

#3 2008-11-13 18:03:41

thebombsite
Plugin Author
From: Exmouth, England
Registered: 2004-08-24
Posts: 3,251
Website

Re: r2991 - No article listing for search page

I haven’t tried that but I have just newly installed r2991 in XAMPP cuz I have a new theme to port and before I messed with anything I tried a search and got the same result as above, so it is happening both in XAMPP and on a live server, in existing sites and in a vanilla install and would definitely seem to be a base-code problem of some kind that needs a fix.

Last edited by thebombsite (2008-11-13 18:05:36)


Stuart

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

Offline

#4 2008-11-17 23:05:41

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

Re: r2991 - No article listing for search page

You have to create a FULLTEXT index that covers the columns Title, Body, Excerpt, Keywords.
Apparently you’re using a hacked version of publish.php

Offline

#5 2008-11-18 06:16:51

wet
Developer
From: Lenzing, Austria
Registered: 2005-06-06
Posts: 3,267
Website

Re: r2991 - No article listing for search page

Umm, yes. This hacked version has slipped into r2991. Will be fixed real soon.

Offline

#6 2008-11-18 13:50:01

thebombsite
Plugin Author
From: Exmouth, England
Registered: 2004-08-24
Posts: 3,251
Website

Re: r2991 - No article listing for search page

I was about to protest my innocence on the hacked publish.php file but…

maybe I am. Ghost hackers? Spooky! ;)

Last edited by thebombsite (2008-11-18 13:52:07)


Stuart

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

Offline

#7 2008-11-18 18:42:56

wet
Developer
From: Lenzing, Austria
Registered: 2005-06-06
Posts: 3,267
Website

Re: r2991 - No article listing for search page

Please try r2995. It should fix the bug introduced in r2990, and add a hook for plugin authors or MySQL DJs to amend the set of fulltext-indexed columns as a by-product.

Offline

#8 2008-11-18 18:54:21

thebombsite
Plugin Author
From: Exmouth, England
Registered: 2004-08-24
Posts: 3,251
Website

Re: r2991 - No article listing for search page

OK. I’ll try it later.
Would that extra hook be handy for the MLP plug-in? I spotted some problems after r2990.


Stuart

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

Offline

#9 2008-11-18 18:59:21

wet
Developer
From: Lenzing, Austria
Registered: 2005-06-06
Posts: 3,267
Website

Re: r2991 - No article listing for search page

thebombsite wrote:

Would that extra hook be handy for the MLP plug-in? I spotted some problems after r2990.

No, this is unrelated. As for MLP and TXP 4.0.7, it’s just about adding the new column according to this post from Els.

Offline

#10 2008-11-18 19:46:00

thebombsite
Plugin Author
From: Exmouth, England
Registered: 2004-08-24
Posts: 3,251
Website

Re: r2991 - No article listing for search page

OK.
Just to confirm – I have updated my XAMPP and “live” vanilla installs and search seems to be working fine. I need to hack the txplib_head.php file (as you probably know) for the other 2 sites but it’s looking rosy. ;)


Stuart

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

Offline

Board footer

Powered by FluxBB