[solved] Site problem after upgrade from 4.2 to 4.5.5

monicahu · 2013-12-31 07:29:26

I have two major problems after the upgrade and hope that someone can point me the direction to resolve the errors. I’m not a PHP developer at all so my programming skill is limited.

(1) Admin site – CSS for classic or the others which come with the software doesn’t seem to work properly in Google chrome. Problem solved – thanks Yiannis!

(2) Website (www.stpeterseastlindfield.org) – now set to debugging mode to allow me to trace any warnings/errors after the upgrade – having the following errors on web pages where I used the tags: txp:link_to_prev and txp:link_to_next Problem solved – thanks Oleg and Marc!

Tag error: <txp:link_to_prev> -> Notice: Undefined index: posted while_parsing_page_form: sermons, sermon
textpattern/publish/taghandlers.php:1444 getNextPrev()
textpattern/lib/txplib_publish.php:426 link_to_prev()
textpattern/lib/txplib_publish.php:339 processTags()
textpattern/lib/txplib_misc.php:1974 parse()
textpattern/publish.php:947 parse_form()
textpattern/publish.php:974 doArticle()
textpattern/publish.php:608 parseArticles()
textpattern/lib/txplib_publish.php:426 article()
textpattern/lib/txplib_publish.php:326 processTags()
textpattern/publish/taghandlers.php:3320 parse()

Diagnostics

Pre-flight check

/home/elindf/public_html/textpattern/setup/ still exists ?

The following PHP functions (which may be necessary to run Textpattern) are disabled on your server: show_source, phpinfo, allow_url_fopen ?

Diagnostic info

Textpattern path: /home/elindf/public_html/textpattern
Permanent link mode: section_id_title
open_basedir: /home/elindf:/usr/lib/php:/usr/local/lib/php:/tmp
Temporary directory path: /tmp
Site URL: www.stpeterseastlindfield.org.au
PHP version: 5.2.17
GD Image Library: bundled (2.0.34 compatible); supported formats: GIF, JPG, PNG.
Server TZ: Australia/Melbourne
Server Local Time: 2014-01-01 14:49:41
DST enabled?: 1
Automatically adjust DST setting?: 1
Time Zone: Australia/NSW (36000)
MySQL: 5.0.96-community
Locale: en_GB.UTF-8
Server: Apache
Apache version: Apache
PHP Server API: apache2handler
RFC 2616 headers:
Server OS: Linux 2.6.18-371.3.1.el5
Active plugins: ajw_comment_num-0.2, cbs_navigation_menu-0.4, kgr_safe_excerpt-0.2m, rss_suparchive-0.18, rss_thumbpop-0.7, rss_author_info-0.2, rss_author_email-0.2.1, rss_auto_excerpt-0.5, smd_calendar-0.42c, zem_contact_reborn-4.0.3.20, zem_contact_lang-4.0.3.6, mg_setheader-0.1, jnm_audio-0.3, ign_password_protect-0.5b9, rss_article_edit-0.1, ngd_recaptcha-1.1
Admin-side theme: classic 4.5.5

{Edited to label topic as solved. – Uli}

Last edited by uli (2014-01-08 11:28:09)

colak · 2013-12-31 08:32:53

1st… do delete the setup folder on /home/elindf/public_html/textpattern/setup/

I’m still checking your post for the rest:)

colak · 2013-12-31 08:50:42

I just checked one of my sites using chrome Version 31.0.1650.63 (mac) and all the back end themes seem to be just fine. Would it be a cache problem?

If you leave the site>empty the cache and revisit it most problems should be solved…. I hope:)

monicahu · 2013-12-31 12:37:46

Thank you Yiannis. I’ve already removed the setup folder.
Problem (1) was resolved after history data in Chrome had been cleared. Thank you.

Last edited by monicahu (2014-01-05 05:05:14)

gaekwad · 2013-12-31 13:04:21

This sounds like a similar problem to this.

If you can post a tag trace we can take a look.

monicahu · 2013-12-31 13:18:21

Tag trace for the sermons page using page template “default”.

<!-- txp tag trace: 
[SQL (0.00195789337158): select name, data from txp_lang where lang='en-gb' AND ( event='public' OR event='common')]
[SQL (0.00103282928467): select name, code, version from txp_plugin where status = 1 AND type IN (0,1,5) order by load_order]
[SQL (0.000802993774414): select name, val from txp_prefs where prefs_id=1 AND user_name='']
[SQL (0.000290870666504): select title from txp_section where name='sermons']
[SQL (0.000371932983398): select ID,Section from textpattern where ID = 1431 and Status >= 4 limit 1]
[SQL (0.000165939331055): select page, css from txp_section where name = 'sermons' limit 1]
[SQL (0.000263929367065): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where ID=1431 and Status in (4,5)]
[article 1431]
[SQL (0.000377893447876): select host from txp_log where ip='122.106.226.202' limit 1]
[SQL (0.000284910202026): insert into txp_log set `time`=now(),page='/sermons/1431/25-dec-2013-jesus-the-human-what-now',ip='122.106.226.202',host='c122-106-226-202.belrs3.nsw.optusnet.com.au',refer='',status='200',method='GET']
[SQL (0.000272989273071): select user_html from txp_page where name='sermons']
[Page: sermons]
<txp:output_form form="doctype" />
	[SQL (0.000337839126587): select Form from txp_form where name='doctype']
	[Form: doctype]
	<txp:php>
	</txp:php>
<txp:if_article_list>
	[<txp:if_article_list>: false]
	<txp:page_title separator=" | " />
</txp:if_article_list>
<txp:output_form form="webanalytics" />
	[SQL (0.000170946121216): select Form from txp_form where name='webanalytics']
	[Form: webanalytics]
<txp:output_form form="top" />
	[SQL (0.000175952911377): select Form from txp_form where name='top']
	[Form: top]
	<txp:if_section name="default">
		[<txp:if_section name="default">: false]
	</txp:if_section>
<txp:output_form form="navigation" />
	[SQL (0.000175952911377): select Form from txp_form where name='navigation']
	[Form: navigation]
	<txp:cbs_navigation_menu sections="services,bible_study,children,youth,resources,news,events,blog" titles="Sunday Services,Bible Study,Children,Youth,Resources,News,Events,Blog" break="li" activeclass="current" wraptag="" ids=",,,,,,," />
	<txp:search_input html_id="search_form" section="search" label="" button="Search" size="10" wraptag="" />
		[SQL (0.000147104263306): select form from txp_form where `name` = 'search_input' limit 1]
<txp:article form="simple" status="sticky" limit="3" pageby="3" sort="posted asc" />
	[filterAtts accepted]
<txp:if_article_list>
	[<txp:if_article_list>: false]
	<txp:article status="live" limit="1" pageby="1" section='<txp:section />'  form="sermon"  />
		[attribute 'section']
		<txp:section />
		[/attribute]
		[filterAtts ignored]
		[SQL (0.000169038772583): select Form from txp_form where name='sermon']
		[Form: sermon]
		<txp:title />
		<txp:permlink />
		<txp:comments_count />
		<txp:php>
		</txp:php>
		<txp:author link="0"/>
			[SQL (0.000266075134277): select RealName from txp_users where `name` = 'stevenl' limit 1]
		<txp:posted format="%d %b %Y" />
		<txp:category1 title="1" />
		<txp:category2 title="1" />
		<txp:custom_field name="meta_desc" />
		<txp:custom_field name="date" />
		<txp:custom_field name="skipfield_speaker" />
		<txp:custom_field name="time_topic" />
		<txp:custom_field name="stepfield_passage" />
		<txp:file_download form="mp3_download" id='<txp:custom_field name="url" />' />
			[attribute 'id']
			<txp:custom_field name="url" />
			[/attribute]
			[SQL (0.000294923782349): select * from txp_file where id = 355]
			[SQL (0.000159978866577): select Form from txp_form where name='mp3_download']
			[Form: mp3_download]
			<txp:file_download_link>
				<txp:file_download_name />
				<txp:file_download_size format="b" decimals="2" />
			</txp:file_download_link>
		<txp:jnm_audio fileid=".">
			<txp:custom_field name="url" />
			[SQL (0.000177145004272): select * from txp_file where id='355']
		</txp:jnm_audio>
		<txp:body />
			<txp:custom_field name="url" />
		<txp:output_form form="fb_link" />
			[SQL (0.000198125839233): select Form from txp_form where name='fb_link']
			[Form: fb_link]
		<txp:link_to_prev>
			Tag error:  <txp:link_to_prev> -> Notice: Undefined index:  posted while_parsing_page_form: sermons, sermon
			Tag error:  <txp:link_to_prev> -> Notice: Undefined index:   while_parsing_page_form: sermons, sermon
			[SQL (0.000939130783081): select ID, Title, url_title, unix_timestamp(Posted) as uposted
			from textpattern where posted < ''
 and Section = 'sermons'
 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00')
 and Status=4
 order by posted
 desc
 limit 1]
			[SQL (0.000982046127319): select ID, Title, url_title, unix_timestamp(Posted) as uposted
			from textpattern where posted > ''
 and Section = 'sermons'
 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00')
 and Status=4
 order by posted
 asc
 limit 1]
			[SQL (0.000185966491699): select ID as thisid, Section as section, Title as title, url_title, unix_timestamp(Posted) as posted from textpattern where ID = 909]
			<txp:prev_title />
		</txp:link_to_prev>
		<txp:link_to_next>
		</txp:link_to_next>
		<txp:output_form form="comments_display" />
			[SQL (0.000158071517944): select Form from txp_form where name='comments_display']
			[Form: comments_display]
			<txp:variable name="has_comments" value='<txp:comments_count />' />
				[attribute 'value']
				<txp:comments_count />
				[/attribute]
			<txp:if_variable name="has_comments" value="0">
				[<txp:if_variable name="has_comments" value="0">: true]
			</txp:if_variable>
			<txp:comments form="comments" break="div" breakclass="comments" />
			<txp:if_comments_preview>
				[<txp:if_comments_preview>: false]
			</txp:if_comments_preview>
			<txp:if_comments_allowed>
				[<txp:if_comments_allowed>: true]
				<txp:if_variable name="has_comments" value="0">
					[<txp:if_variable name="has_comments" value="0">: true]
				</txp:if_variable>
				<txp:comments_form />
					[SQL (0.000265121459961): select ip from txp_discuss_ipban where `ip` = '122.106.226.202' limit 1]
					[SQL (0.000159978866577): select Form from txp_form where `name` = 'comment_form' limit 1]
					<txp:comments_error wraptag="ul" break="li" />
			</txp:if_comments_allowed>
</txp:if_article_list>
<txp:section />
<txp:section title="1" />
	[SQL (0.000159978866577): select title from txp_section where name='sermons']
<txp:article_custom status="sticky" section='<txp:section />' limit="999" form="article_list" sort="posted asc" />
	[attribute 'section']
	<txp:section />
	[/attribute]
	[SQL (0.000524997711182): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 5 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and Section IN ('sermons') order by posted asc limit 0, 999]
<txp:article_custom status="live" section='<txp:section />' limit="5" form="article_list" sort="posted desc" />
	[attribute 'section']
	<txp:section />
	[/attribute]
	[SQL (0.00106501579285): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and Section IN ('sermons') order by posted desc limit 0, 5]
	[article 1431]
	[SQL (0.000159978866577): select Form from txp_form where name='article_list']
	[Form: article_list]
	<txp:permlink />
	<txp:title />
	<txp:title />
	[article 1430]
	[Form: article_list]
	<txp:permlink />
	<txp:title />
	<txp:title />
	[article 1423]
	[Form: article_list]
	<txp:permlink />
	<txp:title />
	<txp:title />
	[article 1422]
	[Form: article_list]
	<txp:permlink />
	<txp:title />
	<txp:title />
	[article 1420]
	[Form: article_list]
	<txp:permlink />
	<txp:title />
	<txp:title />
<txp:article_custom status="sticky" section ="services"  keywords='<txp:section />' limit="2" form="article_list" sort="posted desc" />
	[attribute 'keywords']
	<txp:section />
	[/attribute]
	[SQL (0.00055193901062): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 5 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and Section IN ('services') and (FIND_IN_SET('sermons',Keywords)) order by posted desc limit 0, 2]
	[article 180]
	[Form: article_list]
	<txp:permlink />
	<txp:title />
	<txp:title />
<txp:section />
......

Last edited by monicahu (2014-01-05 05:10:08)

monicahu · 2013-12-31 13:44:46

Now I have a third kind of problems using plugin rss_suparchive_bycat

URL for the error page

Tag error:  <txp:rss_suparchive_bycat section="blog,news" linktosection="archive_topics" showdate="1" datesep=" &raquo; " dateformat="%d %b %Y" showauthor="1" authorsep="&nbsp; &nbsp;  by " showheader="1" headerlabel="Articles By Topics" limit="999" sort="posted desc" /> ->  Textpattern Notice: Unknown tag attribute: sort while_parsing_page_form: archive, None
textpattern/lib/txplib_misc.php:968 trigger_error()
textpattern/lib/txplib_misc.php(812) : eval()'d code:324 lAtts()
textpattern/lib/txplib_publish.php:426 rss_suparchive_bycat()
textpattern/lib/txplib_publish.php:326 processTags()
textpattern/publish/taghandlers.php:3789 parse()
textpattern/lib/txplib_publish.php:426 if_section()
textpattern/lib/txplib_publish.php:339 processTags()
textpattern/publish.php:544 parse()
index.php:83 textpattern()
Tag error:  <txp:rss_suparchive_bycat section="blog,news" linktosection="archive_topics" showdate="1" datesep=" &raquo; " dateformat="%d %b %Y" showauthor="1" authorsep="&nbsp; &nbsp;  by " showheader="1" headerlabel="Articles By Topics" limit="999" sort="posted desc" /> ->  Notice: Undefined index:  excerpt while_parsing_page_form: archive, None
textpattern/lib/txplib_publish.php:426 rss_suparchive_bycat()
textpattern/lib/txplib_publish.php:326 processTags()
textpattern/publish/taghandlers.php:3789 parse()
textpattern/lib/txplib_publish.php:426 if_section()
textpattern/lib/txplib_publish.php:339 processTags()
textpattern/publish.php:544 parse()
index.php:83 textpattern()

Partial tag trace:

[Page: archive]
<txp:output_form form="doctype" />
	[SQL (0.0245368480682): select Form from txp_form where name='doctype']
	[Form: doctype]
	<txp:php>
	</txp:php>
<txp:if_article_list>
	[<txp:if_article_list>: true]
	<txp:site_name />
	<txp:section title="1" />
		[SQL (0.00901317596436): select title from txp_section where name='archive_topics']
</txp:if_article_list>
...
...
<txp:if_section name="archive_dates">
	[<txp:if_section name="archive_dates">: false]
</txp:if_section>
<txp:if_section name="archive_topics">
	[<txp:if_section name="archive_topics">: true]
	<txp:article status="sticky" form="simple_content" sort="posted asc" />
		[filterAtts accepted]
		[SQL (0.0377078056335): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where 1=1 and Status = 5 and Posted <= now() and (now() <= Expires or Expires = '0000-00-00 00:00:00') and Section IN ('archive_topics') order by posted asc limit 0, 10]
		[article 224]
		[SQL (0.0145049095154): select Form from txp_form where name='simple_content']
		[Form: simple_content]
		<txp:article_image class="article-image" />
		<txp:body />
	<txp:rss_suparchive_bycat section="blog,news" linktosection="archive_topics" showdate="1" datesep=" &raquo; " dateformat="%d %b %Y" showauthor="1" authorsep="&nbsp; &nbsp;  by " showheader="1" headerlabel="Articles By Topics" limit="999" sort="posted desc" />
		Tag error:  <txp:rss_suparchive_bycat section="blog,news" linktosection="archive_topics" showdate="1" datesep=" &raquo; " dateformat="%d %b %Y" showauthor="1" authorsep="&nbsp; &nbsp;  by " showheader="1" headerlabel="Articles By Topics" limit="999" sort="posted desc" /> -> Textpattern Notice: Unknown tag attribute: sort while_parsing_page_form: archive, None
		[SQL (0.063364982605): SELECT DISTINCT name FROM txp_category, textpattern WHERE name !="default" and type="article" and (category1 = name or category2 = name)  AND ( (section = 'blog')  OR  (section = 'news') ) AND status=4  AND posted < now() ORDER BY name]
		[SQL (0.0385670661926): SELECT DISTINCT name FROM txp_category, textpattern WHERE name !="default" and type="article" and (category1 = name or category2 = name)  AND ( (section = 'blog')  OR  (section = 'news') ) AND status=4  AND posted < now() ORDER BY name]
		[SQL (0.0159411430359): select *, unix_timestamp(Posted) as uPosted, ID, title, authorid, unix_timestamp(posted) as posted, section, category1, category2, url_title from textpattern where  (category1 = 'bible_study' or category2 = 'bible_study') AND ( (section = 'blog')  OR  (section = 'news') )  AND status=4  AND posted < now()  ORDER BY section, posted desc]
		[SQL (0.440690994263): select title from txp_category where name='bible_study' and type='article']
		[SQL (0.0591139793396): select *, unix_timestamp(Posted) as uPosted, ID, title, authorid, unix_timestamp(posted) as posted, section, category1, category2, url_title, comments_count from textpattern where  (category1 = 'bible_study' or category2 = 'bible_study') AND ( (section = 'blog')  OR  (section = 'news') )  AND status=4  AND posted < now()  ORDER BY section, posted desc LIMIT 999]
		Tag error:  <txp:rss_suparchive_bycat section="blog,news" linktosection="archive_topics" showdate="1" datesep=" &raquo; " dateformat="%d %b %Y" showauthor="1" authorsep="&nbsp; &nbsp;  by " showheader="1" headerlabel="Articles By Topics" limit="999" sort="posted desc" /> -> Notice: Undefined index:  excerpt while_parsing_page_form: archive, None
		[SQL (0.00329399108887): select realname from txp_users where name='stevenl']
		Tag error:  <txp:rss_suparchive_bycat section="blog,news" linktosection="archive_topics" showdate="1" datesep=" &raquo; " dateformat="%d %b %Y" showauthor="1" authorsep="&nbsp; &nbsp;  by " showheader="1" headerlabel="Articles By Topics" limit="999" sort="posted desc" /> -> Notice: Undefined index:  excerpt while_parsing_page_form: archive, None
		[SQL (0.00837588310242): select realname from txp_users where name='stpeters']
		[SQL (0.0295898914337): select *, unix_timestamp(Posted) as uPosted, ID, title, authorid, unix_timestamp(posted) as posted, section, category1, category2, url_title from textpattern where  (category1 = 'children' or category2 = 'children') AND ( (section = 'blog')  OR  (section = 'news') )  AND status=4  AND posted < now()  ORDER BY section, posted desc]
		[SQL (0.0121381282806): select title from txp_category where name='children' and type='article']
		[SQL (0.0120837688446): select *, unix_timestamp(Posted) as uPosted, ID, title, authorid, unix_timestamp(posted) as posted, section, category1, category2, url_title, comments_count from textpattern where  (category1 = 'children' or category2 = 'children') AND ( (section = 'blog')  OR  (section = 'news') )  AND status=4  AND posted < now()  ORDER BY section, posted desc LIMIT 999]

Last edited by monicahu (2014-01-05 05:15:16)

colak · 2013-12-31 15:14:56

rss_suparchive is a very old plugin which hasn’t been updated for ages. I think that it doesn’t work with more recent version of txp. You can do what the plugin did using native tags now.

uli · 2013-12-31 17:32:33

monicahu wrote #277686:

(2) Website (www.stpeterseastlindfield.org) – now set to debugging mode – having the following errors on pages where I used the tags: txp:link_to_prev and txp:link_to_next

Like mentioned in the FAQ:

When your Production Status is set to Debugging, it’s not uncommon to see PHP Notices similar to this […] Debugging mode is intended for just that: debugging problems. If everything is working fine, there’s no reason to turn on Debugging.

What you didn’t write: Are there any real problems aside of these errors?

(Re code/diagnostics posted here: Chances are much higher having sombody read all that and getting an answer when they’re posted only on request, and if necessary, when they’re structured and formatted with the help of Textile :)

monicahu · 2014-01-01 13:57:10

After hours of trials including reading the documentation on the article and article_custom tags, I can’t get rid of the error of undefined index when the page contains the link_to_prev and link_to_next tags. The link to the previous article is always the first one in the section and there is no link to the next article.

Adding pageby attributes to article and article_custom tags didn’t help the situation. Can anyone please help me on this one?

maruchan · 2014-01-01 16:19:42

I wonder: Does this plugin work instead? http://www.iut-fbleau.fr/projet/etc/index.php?id=19

Last edited by maruchan (2014-01-01 16:20:08)

colak · 2014-01-01 16:38:33

maruchan wrote #277738:

I wonder: Does this plugin work instead? http://www.iut-fbleau.fr/projet/etc/index.php?id=19

Olegs plugins work and they are well supported:)

Textpattern CMS

Textpattern CMS support forum

#1 2013-12-31 07:29:26