Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Localhosting txp site generates errors in txplib_misc.php and freezes
Hi all! I hope everyone had a marvelous summer :)
I am feeling rusty here after working in a mostly non-txp environment all summer. I am trying to redesign a site on my local machine rather than live which I have had no worries with before. I have synced the db’s and have started, but the local site keeps freezing on me. Specifically on three or four posts. If I restart Apache it will run fine for a few minutes and the I get timeouts again. I have combed the article/page forms and posts, but nothing is special about them apart from any others. A fresh install seems to be working so I am almost sure it is a plug in, but I am scratching my head at this point. The php error log is throwing out this:
bq. [28-Sep-2006 13:08:40] PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\wamp\www\opp\textpattern\lib\txplib_misc.php on line 416
[28-Sep-2006 13:08:40] PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\wamp\www\opp\textpattern\lib\txplib_misc.php(459) : eval()’d code on line 138
The Apache error log is benign as is the mysql log.
Before I start destroying the site to track down the issue blindly I figure I would ask. The only things that may be different with my local server would be that xslt is enabled for symphony and ruby/rails is installed. I have tried disabling xslt which changes nothing and Ruby is not running right now, so any thoughts or directions are most appreciated.
Diagnostics:
Textpattern version: 4.0.3 (r1188)
last_update: 2005-12-29 21:23:51/2006-09-25 14:32:27
Document root: C:/wamp/www (C:\wamp\www)
$path_to_site: C:\wamp\www\opp
Textpattern path: C:\wamp\www\opp\textpattern
Permanent link mode: section_title
upload_tmp_dir: c:/wamp/tmp
Temp folder: C:\wamp\www\opp\textpattern\tmp
Site URL: localhost/opp
PHP version: 5.1.2
server_time: 2006-09-28 14:46:07
MySQL: 4.1.18-nt
Locale: en_GB.UTF-8
Server: Apache/2.0.55 (Win32) SVN/1.3.2 DAV/2 PHP/5.1.2
Apache version: Apache/2.0.55 (Win32) SVN/1.3.2 DAV/2 PHP/5.1.2
php_sapi_mode: apache2handler
os_version: Windows NT 5.1
.htaccess file contents:
------------------------
#DirectoryIndex index.php index.html
#Options +FollowSymLinks
#RewriteBase /relative/web/path/
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^(.+) - [PT,L]
RewriteRule ^(.*) index.php
</IfModule>
#php_value register_globals 0And the TAG Trace from one of the pages:
<!-- Runtime: 5.7321 -->
<!-- Query time: 0.044177 -->
<!-- Queries: 28 -->
<!-- Memory: no info available -->
<!-- txp tag trace:
[SQL (0.000792): select name from `txp_lang` where lang='en-gb' limit 1]
[SQL (0.014498): select name, data from `txp_lang` where lang='en-gb' AND ( event='public' OR event='common')]
[SQL (0.009732): select name, code from `txp_plugin` where status='1']
[SQL (0.000823): select ID,Section from `textpattern` where url_title like 'john-clark-social-ecologist' AND Section='falling-together' limit 1]
[SQL (0.000314): select * from `txp_section` where name = 'Falling-Together' limit 1]
[SQL (0.000233): select Posted, AuthorID, Keywords from `textpattern` where ID=2]
[SQL (0.000347): select ID, Title, url_title, unix_timestamp(Posted) as uposted
from textpattern where Posted > '2006-03-28 18:07:00' and Section = 'Falling-Together' and Status=4 and Posted < now() order by Posted asc limit 1]
[SQL (0.000280): select ID, Title, url_title, unix_timestamp(Posted) as uposted
from textpattern where Posted < '2006-03-28 18:07:00' and Section = 'Falling-Together' and Status=4 and Posted < now() order by Posted desc limit 1]
[SQL (0.000196): select RealName from `txp_users` where `name` = 'farrah' limit 1]
[SQL (0.000282): select host from `txp_log` where ip='127.0.0.1' limit 1]
[SQL (0.000376): insert into `txp_log` set `time`=now(),page='/opp/Falling-Together/john-clark-social-ecologist',ip='127.0.0.1',host='127.0.0.1',refer='',status='200',method='GET']
[SQL (0.000235): select user_html from `txp_page` where name='new archive']
[Page: new archive]
<txp:css/>
<txp:output_form form="nav" />
[SQL (0.000206): select form from `txp_form` where `name` = 'nav' limit 1]
<txp:rdt_article_menu
wraptag="ul"
break="li"
class="menu"
active="active"
id="articles"
limit="100"
sortby="Posted"
sortdir="desc"
dateposted="to_date"
section=""
status="live"
/>
[SQL (0.003267): SELECT *, unix_timestamp(Posted) as uPosted FROM textpattern WHERE ( Status = 4) AND Section = 'Falling-Together' ORDER BY Posted desc LIMIT 100]
<txp:article/>
[SQL (0.000707): select *, unix_timestamp(Posted) as uPosted from `textpattern` where ID='2' and Status in (4,5) limit 1]
[article 2]
<txp:bas_flvplayer/>
[SQL (0.000275): select * from `txp_file` where filename="flvplayer.swf"]
[SQL (0.000222): select * from `txp_file` where id="44"]
<txp:image id="191" />
[SQL (0.000349): select * from `txp_image` where id='191' limit 1]
[SQL (0.000206): select Form from `txp_form` where `name` = 'default' limit 1]
[Form: default]
<txp:permlink>
<txp:title/>
</txp:permlink>
<txp:posted/>
<txp:category1 link="y" />
<txp:if_article_list>
[<txp:if_article_list>: false]
<txp:cng_acronym content="body" />
</txp:if_article_list>
<txp:if_comments_allowed>
[<txp:if_comments_allowed>: false]
</txp:if_comments_allowed>
<txp:rss_article_edit>
</txp:rss_article_edit>
<txp:image id="2" />
[SQL (0.000353): select * from `txp_image` where id='2' limit 1]
[SQL (0.000197): select Form from `txp_form` where `name` = 'comments_display' limit 1]
[Form: comments_display]
<txp:if_comments>
[<txp:if_comments>: true]
<txp:comments_count/>
<txp:title/>
</txp:if_comments>
<txp:comments/>
[SQL (0.000212): select Form from `txp_form` where `name` = 'comments' limit 1]
[Form: comments]
[SQL (0.000321): select *, unix_timestamp(posted) as time from `txp_discuss` where parentid='2' and visible=1 order by posted asc]
<txp:ptv_condition>
<txp:ajw_comment_alt/>
</txp:ptv_condition>
<txp:glx_gravatar size="30" class="gravatar" />
<txp:comment_permlink>
<txp:ajw_comment_num/>
</txp:comment_permlink>
<txp:comment_name/>
<txp:comment_time/>
<txp:message/>
<txp:if_comments_allowed>
[<txp:if_comments_allowed>: false]
</txp:if_comments_allowed>
<txp:if_individual_article>
[<txp:if_individual_article>: true]
<txp:link_to_prev>
<txp:prev_title/>
[SQL (0.001321): select *,ID as thisid, unix_timestamp(Posted) as posted from `textpattern` where ID=39]
</txp:link_to_prev>
<txp:link_to_next>
<txp:next_title/>
[SQL (0.001257): select *,ID as thisid, unix_timestamp(Posted) as posted from `textpattern` where ID=69]
</txp:link_to_next>
</txp:if_individual_article>
<txp:if_article_list>
[<txp:if_article_list>: false]
</txp:if_article_list>
<txp:ajw_clean_feed_link wraptag="li" title="rss" flavor="atom" label="ATOM feed" />
[SQL (0.001038): select *,ID as thisid, unix_timestamp(Posted) as posted from `textpattern` where ID=2]
<txp:ajw_clean_feed_link wraptag="li" title="rss" flavor="rss" label="RSS feed" />
[SQL (0.001002): select *,ID as thisid, unix_timestamp(Posted) as posted from `textpattern` where ID=2]
[ --- secondpass --- ]
-->Thanks!
Jamie
(Edit: updated to display code properly. -Mary)
Last edited by Mary (2006-09-29 01:12:44)
Offline
Re: Localhosting txp site generates errors in txplib_misc.php and freezes
Sorry for the misplaced posting :)
Offline
#3 2006-09-28 22:44:49
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: Localhosting txp site generates errors in txplib_misc.php and freezes
Sorry for moving you here ;) but you’re post will more likely be noticed by the right people in this forum.
Offline
#4 2006-09-29 00:02:56
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: Localhosting txp site generates errors in txplib_misc.php and freezes
Impossible to guess what’s going on. You’ll need to simplify your template to find the tag or block of code that’s causing the problem.
Alex
Offline
#5 2006-09-29 01:20:50
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Localhosting txp site generates errors in txplib_misc.php and freezes
Yeah, I’m afraid you’re stuck with the process of elimination. There’s nothing in the trace that appears suspect.
Offline
Re: Localhosting txp site generates errors in txplib_misc.php and freezes
Thanks everybody, I didnt see anything suspicous so that is what I suspected, but it is always nice to have a second (and third) opinion before I start dismantling stuff. I found it odd that when it is residing on the txd server everything is fine. I guess we shall see.
Thanks for taking the time to look over the dump. :)
Jamie
Offline