Various issues after upgrading to Textpattern 4.5.2

Algaris · 2012-10-24 14:30:38

I’ve just loaded a fresh install of Textpattern 4.5.2 onto our IIS server and whenever I try to visit the Diagnostics page receive the following error:

Fatal error: Maximum execution time of 30 seconds exceeded in E:\Inet\ross\projects\ts-calendar\textpattern\lib\txplib_misc.php on line 701

All of the other pages in the admin interface seem to be working fine.

Also after switching to the Hive theme I noticed that none of the images Hive uses are displayed in the admin interface. I had a quick look at the CSS for the theme and see that it’s trying to access the img folder one level up. The folder is there so I’m not sure why Textpattern can’t see them.

Last edited by Algaris (2012-11-05 12:12:04)

Algaris · 2012-10-25 09:10:01

I’ve just tried an upgrade on one of my development sites and I’m getting the same issues. Everything seems to work fine apart from the Diagnostics page and the missing Hive theme graphics.

Could this be an IIS issue? I haven’t had chance to test Textpattern 4.5.2 on an Apache server. Any advice would be much appreciated.

Algaris · 2012-11-05 11:38:42

Also after upgrading I started getting the following error message whenever I tried to post a new article.

Incorrect datetime value: ‘1’ for column ‘Expires’ at row 1
get off my lawn

After doing a search I found a 2008 solution from Wet that fixed my problems.

http://forum.textpattern.com/viewtopic.php?pid=195020#p195020

wet wrote:

See docs.

SQL mode is determined upon MySQL server’s startup and not changed for a single database.

Try to locate MySQL’s configuration file my.ini or my.cnf. For XAMPP, this file would live somewhere around c:\xampp\myqsl\bin\.

Disable STRICT_TRANS_TABLES by removing a line similar to sql_mode=STRICT_TRANS_TABLES from this file (you can prepend a # to change it into an inoperational comment)

Stop and restart MySQL server

Report back

Algaris · 2012-11-05 12:11:15

I’ve come across other issues now.

Whenever I open an article the Save button is missing. If I press the return key in a text filed (such as the title) to save the article I end up with a page full of code and no saved article.

;
				$(document).ready(function() {
					$("#messagepane").html("<span id=\"message\" class=\"messageflash success\">Article posted.  <a href=\"#close\" class=\"close\">&times;</a></span>");
					$(window).resize(function() {
						$("#messagepane").css({
							left: ($(window).width() - $("#messagepane").outerWidth()) / 2
						});
					});
					$(window).resize();
				});;
$("[name=sLastMod]").val("1352116813");
$("[name=sPosted]").val("1354707032");
$("#keywords").val("");
$("#url-title").val("headmasters-farewell-service");
$("#recent_group .recent").replaceWith("<ul class=\"recent plain-list\">\n	<li class=\"recent-article\"><a href=\"?event=article&step=edit&ID=2708\">Pre-Prep School Ends</a></li>\n	<li class=\"recent-article\"><a href=\"?event=article&step=edit&ID=2690\">Advent Carol Service</a></li>\n	<li class=\"recent-article\"><a href=\"?event=article&step=edit&ID=2689\">TERM ENDS</a></li>\n	<li class=\"recent-article\"><a href=\"?event=article&step=edit&ID=2727\">Joint TS & TP Service of Nine Lessons & Carols</a></li>\n	<li class=\"recent-article\"><a href=\"?event=article&step=edit&ID=2688\">Music: A Festival of Nine Lessons and Carols</a></li>\n	<li class=\"recent-article\"><a href=\"?event=article&step=edit&ID=2687\">PSSP Netball: U14 Playoffs </a></li>\n	<li class=\"recent-article\"><a href=\"?event=article&step=edit&ID=2686\">Rugby: U12 v Polwhele</a></li>\n	<li class=\"recent-article\"><a href=\"?event=article&step=edit&ID=2685\">Music: Mixed Choir Carol Singing</a></li>\n	<li class=\"recent-article\"><a href=\"?event=article&step=edit&ID=2707\">Early Years Nativity Play</a></li>\n	<li class=\"recent-article\"><a href=\"?event=article&step=edit&ID=2684\">Geology: Upper Sixth Fieldtrip</a></li></ul>");
$("#title").val("Headmasters Farewell Service");
$("#article_partial_article_view").replaceWith("<span id=\"article_partial_article_view\"><a href=\"http://example.com/calendar/index.php?id=2784\" class=\"article-view\">View</a></span>");
$("p.author").replaceWith("<p class=\"author\"><small>Posted by: Ross · 05 Dec 2012 · 11:30:32<br />Last modified by: Ross · 05 Nov 2012 · 12:00:13</small></p>");
$("p.nav-tertiary").replaceWith("<p class=\"nav-tertiary\"><a href=\"?event=article&step=edit&ID=2703\" class=\"navlink\" rel=\"prev\">Prev</a><a href=\"?event=article&step=edit&ID=2668\" class=\"navlink\" rel=\"next\">Next</a>\n</p>");
$("#write-status").replaceWith("\n\n<fieldset id=\"write-status\">\n<legend>Status</legend>\n<ul class=\"status plain-list\">\n	<li class=\"status-1\"><input type=\"radio\" name=\"Status\" value=\"1\" id=\"status-1\" class=\"radio\" /><label for=\"status-1\">Draft</label></li>\n	<li class=\"status-2\"><input type=\"radio\" name=\"Status\" value=\"2\" id=\"status-2\" class=\"radio\" /><label for=\"status-2\">Hidden</label></li>\n	<li class=\"status-3\"><input type=\"radio\" name=\"Status\" value=\"3\" id=\"status-3\" class=\"radio\" /><label for=\"status-3\">Pending</label></li>\n	<li class=\"status-4 active\"><input type=\"radio\" name=\"Status\" value=\"4\" id=\"status-4\" checked=\"checked\" class=\"radio active\" /><label for=\"status-4\"><strong>Live</strong></label></li>\n	<li class=\"status-5\"><input type=\"radio\" name=\"Status\" value=\"5\" id=\"status-5\" class=\"radio\" /><label for=\"status-5\">Sticky</label></li>\n</ul>\n</fieldset>");
$("#write-comments").replaceWith("");
$("#write-timestamp").replaceWith("\n\n<fieldset id=\"write-timestamp\">\n<legend>Timestamp</legend>\n<p class=\"reset-time\"><input type=\"checkbox\" name=\"reset_time\" value=\"1\" id=\"reset_time\" class=\"checkbox\" /><label for=\"reset_time\">Reset time to now…</label></p>\n<p class=\"publish-at\">Published at <a rel=\"help\" target=\"_blank\" href=\"http://rpc.textpattern.com/help/?item=timestamp&language=en-gb\" onclick=\"popWin(this.href); return false;\" class=\"pophelp\">?</a></p>\n<p class=\"date posted created\"><span class=\"label\">Date</span> \n<input type=\"text\" name=\"year\" value=\"2012\" size=\"4\" maxlength=\"4\" class=\"year\" title=\"Year\" /> / \n<input type=\"text\" name=\"month\" value=\"12\" size=\"2\" maxlength=\"2\" class=\"month\" title=\"Month\" /> / \n<input type=\"text\" name=\"day\" value=\"05\" size=\"2\" maxlength=\"2\" class=\"day\" title=\"Day\" /></p>\n<p class=\"time posted created\"><span class=\"label\">Time</span> \n<input type=\"text\" name=\"hour\" value=\"11\" size=\"2\" maxlength=\"2\" class=\"hour\" title=\"Hour\" /> : \n<input type=\"text\" name=\"minute\" value=\"30\" size=\"2\" maxlength=\"2\" class=\"minute\" title=\"Minute\" /> : \n<input type=\"text\" name=\"second\" value=\"32\" size=\"2\" maxlength=\"2\" class=\"second\" title=\"Second\" /></p>\n</fieldset>");
$("#write-expires").replaceWith("\n\n<fieldset id=\"write-expires\">\n<legend>Expires</legend>\n<p class=\"date expires\"><span class=\"label\">Date</span> \n<input type=\"text\" name=\"exp_year\" value=\"\" size=\"4\" maxlength=\"4\" class=\"exp_year\" title=\"Year\" /> / \n<input type=\"text\" name=\"exp_month\" value=\"\" size=\"2\" maxlength=\"2\" class=\"exp_month\" title=\"Month\" /> / \n<input type=\"text\" name=\"exp_day\" value=\"\" size=\"2\" maxlength=\"2\" class=\"exp_day\" title=\"Day\" /></p>\n<p class=\"time expires\"><span class=\"label\">Time</span> \n<input type=\"text\" name=\"exp_hour\" value=\"\" size=\"2\" maxlength=\"2\" class=\"exp_hour\" title=\"Hour\" /> : \n<input type=\"text\" name=\"exp_minute\" value=\"\" size=\"2\" maxlength=\"2\" class=\"exp_minute\" title=\"Minute\" /> : \n<input type=\"text\" name=\"exp_second\" value=\"\" size=\"2\" maxlength=\"2\" class=\"exp_second\" title=\"Second\" /></p>\n<input type=\"hidden\" value=\"0\" name=\"sExpires\" />\n</fieldset>");
</div><!-- /txp-body --><div class="txp-footer"><p class="mothership"><a href="http://textpattern.com" title="go_txp_com" rel="external">Textpattern CMS</a> (v4.5.2)</p>
<p class="pagejump"><a href="#">back_to_top</a></p>
<script type="text/javascript">
textpattern.textarray = null
</script>
</div><!-- /txp-footer --></body>
</html>
<!-- runtime: 0.0716 -->
<!-- Memory: 4608Kb -->

I’ve also noticed on the plug-ins page the option to enable or disable pug-ins has vanished. I wanted to disable the plug-ins to make sure they weren’t the problem. In the end I ended up deleting all the non essential plug-ins but with no luck.

I think I’m going to have to downgrade to an older version of Textpattern as I’m starting to encounter too many backend problems while trying to update my live site. Is there a link where I can grab the zip file for previous Textpattern versions?

—Edit—
Following Stef’s advice in this thread seems to have fixed most of my problems, just not my ability to see the Diagnostics page or fix the Hive Theme.

http://forum.textpattern.com/viewtopic.php?pid=267499#p267499

Thanks Stef. As always you’re the man.

{Edited to adjust link. – Uli}

Last edited by Algaris (2013-07-10 22:54:30)

Bloke · 2012-11-05 13:12:30

The missing Hive graphics are a puzzle, though I would check the permissions on the directories are wide enough. Any server log entries that might give you an indication what’s going on?

As for the Diagnostics panel it sounds like one of the checks is just taking too damn long and timing out, which is causing Txp to balk and rendering nothing of interest to the page.

The line number in question in txplib_misc.php is the start of our custom adminErrorHandler, which doesn’t give us much to go on. We could do with finding out exactly which line of the diagnostics panel is causing the server to throw a wobbly.

If there aren’t any more tidbits of info you can glean from your server logs or the page itself, try putting the site in debugging mode and try again. It might just give us a teensy bit more info.

Failing that you could try temporarily editing textpattern/index.php and commenting out line 85 like this:

// set_error_handler('adminErrorHandler', error_reporting());

You should then get a standard set of PHP error messages. Whether that gives us any more (or less) info, I don’t know at present: It might do nothing important.

Third option might be to give one of us a login / FTP access so we can put debug info to the page and try and figure out what’s going on.

Last edited by Bloke (2012-11-05 13:13:17)

Algaris · 2012-11-05 13:48:59

Thanks Stef, I’ll work through your list and see what I can come up with. It turns out you already have a login for this site, which you last used in Feb 2011. I guess I never removed your account.

Bloke · 2012-11-05 14:23:47

Algaris wrote:

It turns out you already have a login for this site

You’re right. In which case, strike off the “Put Site in Debugging” idea ‘cos I just tried it on your site and it made no difference. Strange it thinks the error is in that function… I’d need to be able to slot in some debugging info into the txp_diag.php file though, which I can’t do easily from the admin side.

On the graphics front, one thing it’s complaining about is not being able to find /textpattern/theme/hive/img/svg/. If you say it’s there on the server, then it’ll have to be permissions preventing it from seeing it.

Last edited by Bloke (2012-11-05 14:26:19)

Algaris · 2012-11-05 15:07:19

From what I can see the Windows server is forcing permissions of 700 on everything that is hosted there, whereas the folders in Textpattern 4.5.2 downloaded from textpattern.com have permissions of 755. Try as I might the Windows server refuses to let me change these permissions. The IT department even tried changing the permissions on the Windows side to be more open but this seems to have no effect and I’m stuck with 700.

Maybe if I drop all the graphics and CSS in one folder and edit the themes stylesheet it could fix things.

—Edit—
If this was external hosting rather than an internal server (with no FTP) I’d be able to give you FTP access to make the modifications you need.

Last edited by Algaris (2012-11-05 15:10:31)

Bloke · 2012-11-05 15:13:45

Algaris wrote:

The IT department even tried changing the permissions on the Windows side to be more open but this seems to have no effect and I’m stuck with 700.

Ah the age old battle: IT real world vs Micro$oft dream world! That is a bit baffling, but could also be part of the cause of what you’re seeing on the Diagnostics panel. Perhaps if one of the tests is trying to access an unreadable folder and it’s not error trapped then it may well throw an error like the one you’re seeing. The question then is: which test is it.

Maybe if I drop all the graphics and CSS in one folder and edit the themes stylesheet it could fix things.

Sounds reasonable. I mean, it’s not reasonable that you have to do it at all, but under the circumstances it’s a good workaround if you can make/find a folder with suitable permissions elsewhere.

EDIT:

If this was external hosting rather than an internal server (with no FTP) I’d be able to give you FTP access to make the modifications you need.

OK, no worries. I can talk you through it sometime if you like. Or maybe even prep a pre-debugged txp_diag.php file for you that you can replace on your server. Drop me a line via e-mail sometime if you get nowhere with your sleuthing. We can always chat later if you’re still working on it.

Last edited by Bloke (2012-11-05 15:18:30)

Algaris · 2012-11-05 15:33:14

Thanks Stef. I’ll have a think on it and get back to you.

Textpattern CMS

Textpattern CMS support forum

#1 2012-10-24 14:30:38

Various issues after upgrading to Textpattern 4.5.2

#2 2012-10-25 09:10:01

Re: Various issues after upgrading to Textpattern 4.5.2

#3 2012-11-05 11:38:42

Re: Various issues after upgrading to Textpattern 4.5.2

#4 2012-11-05 12:11:15

Re: Various issues after upgrading to Textpattern 4.5.2

#5 2012-11-05 13:12:30

Re: Various issues after upgrading to Textpattern 4.5.2

#6 2012-11-05 13:48:59

Re: Various issues after upgrading to Textpattern 4.5.2

#7 2012-11-05 14:23:47

Re: Various issues after upgrading to Textpattern 4.5.2

#8 2012-11-05 15:07:19

Re: Various issues after upgrading to Textpattern 4.5.2

#9 2012-11-05 15:13:45

Re: Various issues after upgrading to Textpattern 4.5.2

#10 2012-11-05 15:33:14

Re: Various issues after upgrading to Textpattern 4.5.2

Board footer