[resolved] Inconsistent Tag Error showing up (MySQL server has gone away)

Loraleih · 2009-06-08 19:24:54

I’m getting this error on the pages for specific blog entries. Consequentially, there’s no comment form. Weirdly enough, this is not a problem for several consistent blog entries. Does anyone know what the solution may be?

Error on this page: http://loraleih.com/Blog/4/why-i-love-to-run
Error not on this page: http://loraleih.com/Blog/5/how-not-to-make-sushi

Tag error: <txp:comments_form isize=“25” msgcols=“45” msgrows=“15” /> -> Textpattern Warning: MySQL server has gone away
select ip from txp_discuss_ipban where `ip` = ’71.114.65.81’ limit 1 on line 82

Tag error: <txp:comments_form isize=“25” msgcols=“45” msgrows=“15” /> -> Textpattern Warning: MySQL server has gone away
select Form from txp_form where `name` = ‘comment_form’ limit 1 on line 82

Tag error: <txp:link_to_prev> -> Textpattern Warning: MySQL server has gone away
select ID as thisid, Section as section, Title as title, url_title, unix_timestamp(Posted) as posted from textpattern where ID = 3 on line 82

Tag error: <txp:link_to_next> -> Textpattern Warning: MySQL server has gone away
select ID as thisid, Section as section, Title as title, url_title, unix_timestamp(Posted) as posted from textpattern where ID = 5 on line 82

Thanks a ton!

colak · 2009-06-09 04:01:46

Hi Loraleigh

Can you post your diagnostics and a tag trace?

Loraleih · 2009-06-09 04:23:12

//////////DIAGNOSTICS:

Textpattern version: 4.0.8 (r3085)
Last Update: 2009-05-24 02:06:58/2009-05-24 02:05:03
Document root: /home/loraleih/public_html
$path_to_site: /home/loraleih/public_html
Textpattern path: /home/loraleih/public_html/textpattern
Permanent link mode: section_id_title
Temporary directory path: /home/loraleih/public_html/textpattern/tmp
Site URL: loraleih.com
PHP version: 5.2.8
GD Image Library: version bundled (2.0.34 compatible), supported formats: GIF, JPG, PNG
Server Local Time: 2009-06-08 23:16:36
MySQL: 5.0.77-community-log
Locale: en_US.UTF-8
Server: Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.7a Phusion_Passenger/2.1.3 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
PHP Server API: cgi
RFC 2616 headers: 0
Server OS: Linux 2.6.27-grsec

.htaccess file contents: 
------------------------
#DirectoryIndex index.php index.html

#Options +FollowSymLinks
#Options -Indexes

<IfModule mod_rewrite.c>
	RewriteEngine On
	#RewriteBase /relative/web/path/

	RewriteCond %{REQUEST_FILENAME} -f [OR]
	RewriteCond %{REQUEST_FILENAME} -d
	RewriteRule ^(.+) - [PT,L]

	RewriteCond %{REQUEST_URI} !=/favicon.ico
	RewriteRule ^(.*) index.php

	RewriteCond %{HTTP:Authorization}  !^$
	RewriteRule .* - [E=REMOTE_USER:%{HTTP:Authorization}]
</IfModule>

#php_value register_globals 0

------------------------

//////////TAG TRACE:

[SQL (0.000130891799927): select name, data from txp_lang where lang='en-us' AND ( event='public' OR event='common')]
[SQL (4.81605529785E-5): select name, code, version from txp_plugin where status = 1 AND type IN (0,1) order by load_order]
[SQL (4.60147857666E-5): select ID, Section from textpattern where ID = 9 and Section = 'blog' and Status >= 4 limit 1]
[SQL (3.91006469727E-5): select page, css from txp_section where name = 'Blog' limit 1]
[SQL (7.29560852051E-5): select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from textpattern where ID=9 and Status in (4,5)]
[article 9]
[SQL (0.000362157821655): select ID, Title, url_title, unix_timestamp(Posted) as uposted
			from textpattern where Posted > '2009-06-08 20:29:48' and Section = 'Blog' 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.000279188156128): select ID, Title, url_title, unix_timestamp(Posted) as uposted
			from textpattern where Posted < '2009-06-08 20:29:48' and Section = 'Blog' 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.000262975692749): select host from txp_log where ip='71.114.65.81' limit 1]
[SQL (0.000195980072021): insert into txp_log set `time`=now(),page='/Blog/9/sex-and-the-city',ip='71.114.65.81',host='pool-71-114-65-81.washdc.dsl-w.verizon.net',refer='',status='200',method='GET']
[SQL (4.81605529785E-5): select user_html from txp_page where name='archive']
[Page: 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:if_section name="">
	[<txp:if_section name="">: false]
	<txp:section />
</txp:if_section>
<txp:if_article_list>
	[<txp:if_article_list>: false]
</txp:if_article_list>
<txp:article listform="article_listing" limit="5" />
	[SQL (6.41345977783E-5): select Form from txp_form where name='default']
	[Form: 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 (4.41074371338E-5): select RealName from txp_users where `name` = 'loraleih' limit 1]
	<txp:category1 title="1" link="1" />
		[SQL (3.71932983398E-5): select title from txp_category where name='general' and type='article']
	<txp:category2 title="1" link="1" />
	<txp:comments_invite wraptag="p" />
	<txp:site_url />
	[SQL (4.60147857666E-5): select Form from txp_form where name='comments_display']
	[Form: comments_display]
	<txp:text item="comment" />
	<txp:comments_invite textonly="1" showalways="1" showcount="0" />
	<txp:comments />
	<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" />
			Tag error: <txp:comments_form isize="25" msgcols="45" msgrows="15" /> -> Textpattern Warning: MySQL server has gone away
select ip from txp_discuss_ipban where `ip` = '71.114.65.81' limit 1
textpattern/publish/comment.php:498 fetch()  on line 82
			[SQL (0.000104904174805): select ip from txp_discuss_ipban where `ip` = '71.114.65.81' limit 1]
			Tag error: <txp:comments_form isize="25" msgcols="45" msgrows="15" /> -> Textpattern Warning: MySQL server has gone away
select Form from txp_form where `name` = 'comment_form' limit 1
textpattern/publish/comment.php:146 fetch()  on line 82
			[SQL (9.77516174316E-6): select Form from txp_form where `name` = 'comment_form' limit 1]
	</txp:if_comments_allowed>
<txp:if_individual_article>
	[<txp:if_individual_article>: true]
	<txp:site_url />
	<txp:link_to_prev>
		Tag error: <txp:link_to_prev> -> Textpattern Warning: MySQL server has gone away
select ID as thisid, Section as section, Title as title, url_title, unix_timestamp(Posted) as posted from textpattern where ID = 8
textpattern/lib/txplib_db.php:197 getRow()  on line 82
		[SQL (1.00135803223E-5): select ID as thisid, Section as section, Title as title, url_title, unix_timestamp(Posted) as posted from textpattern where ID = 8]
		<txp:prev_title />
	</txp:link_to_prev>
	<txp:link_to_next>
	</txp:link_to_next>
</txp:if_individual_article>
[ ~~~ secondpass ~~~ ]

(added bc.s for better code display. -Els)

Last edited by els (2009-06-09 16:56:48)

colak · 2009-06-09 04:30:24

Until somebody with more knowledge comes in, Are you sure you have no corrupted table. If so, you might be able to fix it with phpMyAdmin or rss_admin_db_manager

Loraleih · 2009-06-10 00:23:09

I did a repair in phpMyAdmin. However, now nothing’s showing up on the entry page. I went into the textpattern program and looked at the code. I have all the defaults set for forms, but every time I preview, no forms show up. This is so weird. Any ideas?

colak · 2009-06-10 08:58:26

Searching this forum I found another 2 complains with the same error. Does this help?

Boby Dimitrov · 2009-06-11 11:43:27

More in this: http://forum.textpattern.com/viewtopic.php?id=30943

colak · 2009-06-11 12:10:54

Boby, thanks for your input in this. This FAQ relates to another symptom but it might be that they both share the same cause?

Loraleih · 2009-06-11 17:14:26

Thanks for your help Boby and Colak. I removed the spam list url and it seems to have done the trick.

Textpattern CMS

Textpattern CMS support forum

#1 2009-06-08 19:24:54

[resolved] Inconsistent Tag Error showing up (MySQL server has gone away)

#2 2009-06-09 04:01:46

Re: [resolved] Inconsistent Tag Error showing up (MySQL server has gone away)

#3 2009-06-09 04:23:12

Re: [resolved] Inconsistent Tag Error showing up (MySQL server has gone away)

#4 2009-06-09 04:30:24

Re: [resolved] Inconsistent Tag Error showing up (MySQL server has gone away)

#5 2009-06-10 00:23:09

Re: [resolved] Inconsistent Tag Error showing up (MySQL server has gone away)

#6 2009-06-10 08:58:26

Re: [resolved] Inconsistent Tag Error showing up (MySQL server has gone away)

#7 2009-06-11 11:43:27

Re: [resolved] Inconsistent Tag Error showing up (MySQL server has gone away)

#8 2009-06-11 12:10:54

Re: [resolved] Inconsistent Tag Error showing up (MySQL server has gone away)

#9 2009-06-11 17:14:26

Re: [resolved] Inconsistent Tag Error showing up (MySQL server has gone away)

Board footer