Upgrading TextPattern from pre-4.1 versions to TXP 4.5

andrewowens · 2012-08-30 22:04:27

My client’s site is running TextPattern 4.0.8.
Her web server is running PHP 5.3 and her MySQL database is version 4.1.

Her site, http://www.kulisekpc.com/ , is showing PHP errors at the top of the page. There are also login issues for the admin area. I think this is related to the old version of TextPattern and the new version of PHP.

I’ve tried installing the latest version of TextPattern, but the current database doesn’t work with it. Looking at MyPHPAdmin, there’s no ‘information-schema’ in the current database, which seems to appear in databases created by more current versions.

I’m trying to figure out the best way to get this site back to running with no errors, all on the latest versions.

Any advice on upgrading the current database?
Any advice on an upgrade path considering the TextPattern, PHP, MySQL versions above?

Thanks for any help you can give.

{Edited in order to alter topic title for better findability – Uli}

Last edited by uli (2012-09-02 14:28:27)

ruud · 2012-08-30 22:24:26

“doesn’t work” usually comes shaped like a set of error messages. It would help if you posted those ;)

Upgrading directly to TXP 4.5 should work.

andrewowens · 2012-08-30 23:29:52

Hi Ruud,

Thanks so much for the quick response.

When loading public-facing pages of the site, I get the following error before any page content:

Deprecated: Function set_magic_quotes_runtime() is deprecated in /home/content/k/u/l/kulisek08/html/textpattern/lib/txplib_db.php on line 14

When visiting the admin login page I receive the following errors:

Deprecated: Function set_magic_quotes_runtime() is deprecated in /home/content/k/u/l/kulisek08/html/textpattern/lib/txplib_db.php on line 14
Deprecated: Function split() is deprecated in /home/content/k/u/l/kulisek08/html/textpattern/include/txp_auth.php on line 77

After logging into the admin section, I receive the following errors:

Deprecated: Function set_magic_quotes_runtime() is deprecated in /home/content/k/u/l/kulisek08/html/textpattern/lib/txplib_db.php on line 14
Warning: Cannot modify header information - headers already sent by (output started at /home/content/k/u/l/kulisek08/html/textpattern/lib/txplib_db.php:14) in /home/content/k/u/l/kulisek08/html/textpattern/include/txp_auth.php on line 196
Warning: Cannot modify header information - headers already sent by (output started at /home/content/k/u/l/kulisek08/html/textpattern/lib/txplib_db.php:14) in /home/content/k/u/l/kulisek08/html/textpattern/include/txp_auth.php on line 203

Lastly, moving from page to page within the admin section, I am required to re-login at every page.

The first thing I tried today was upgrading to TextPattern 4.5. When attempting to access the admin section i received a ‘get_off_my_lawn: ‘ error and none of the site structure or content was displayed on the public-facing pages. I downgraded back to 4.0.8 for the time being as my client’s content still shows up.

http://www.kulisekpc.com

What do you think now?

{Edited in order to make errors distinguishable from annotations. – Uli}

Last edited by uli (2012-08-30 23:41:45)

ruud · 2012-08-31 09:28:22

Do you have the ign_pw_protect plugin installed? Try disabling it and use rvm_privileged instead.

If that’s not it. Try disabling all plugins and see if the error disappears. If so, enable them one by one until you’ve found the one that causes this.

andrewowens · 2012-08-31 16:44:05

EDITED TO ADD:
What follows is an extensive diagnosis. If you’re getting the above errors and it’s not caused by plugins, you can skip the following posts, jump right here and look for “WORKAROUND” in that post. – Uli

–– –– –– –– –– –– –– –– –– ––
Original post:

Hi Ruud,

Thanks again for your help so far. I did not have the ign_pw_protect plugin installed. I did disable all of my plugins and I’m still seeing the issues…

When viewing the public-facing pages, this error message is displayed above the content:

Deprecated: Function set_magic_quotes_runtime() is deprecated in /home/content/k/u/l/kulisek08/html/textpattern/lib/txplib_db.php on line 14

When logging into the admin section, I get this message:

Deprecated: Function set_magic_quotes_runtime() is deprecated in /home/content/k/u/l/kulisek08/html/textpattern/lib/txplib_db.php on line 14
Deprecated: Function split() is deprecated in /home/content/k/u/l/kulisek08/html/textpattern/include/txp_auth.php on line 77

Once inside the admin section, I get the following errors:

Deprecated: Function set_magic_quotes_runtime() is deprecated in /home/content/k/u/l/kulisek08/html/textpattern/lib/txplib_db.php on line 14
Warning: Cannot modify header information - headers already sent by (output started at /home/content/k/u/l/kulisek08/html/textpattern/lib/txplib_db.php:14) in /home/content/k/u/l/kulisek08/html/textpattern/include/txp_auth.php on line 196
Warning: Cannot modify header information - headers already sent by (output started at /home/content/k/u/l/kulisek08/html/textpattern/lib/txplib_db.php:14) in /home/content/k/u/l/kulisek08/html/textpattern/include/txp_auth.php on line 203

Last edited by uli (2012-09-02 14:35:35)

colak · 2012-08-31 17:16:36

Hi Andy

Can you post your diagnostics?

andrewowens · 2012-08-31 17:51:40

Sure thing, but only the ‘low’ diagnostics due to having to re-login with every button click on the admin side. Here you go:

Textpattern version: 4.0.8 (r4011)
Last Update: 2012-08-30 21:32:19/2012-08-30 21:04:40
Document root: /home/content/k/u/l/kulisek08/html
$path_to_site: /home/content/k/u/l/kulisek08/html
Textpattern path: /home/content/k/u/l/kulisek08/html/textpattern
Permanent link mode: section_title
upload_tmp_dir: /tmp
Temporary directory path: /home/content/k/u/l/kulisek08/html/textpattern/tmp
Site URL: www.kulisekpc.com
PHP version: 5.3.6
GD Image Library: version bundled (2.0.34 compatible), supported formats: GIF, PNG
Server Local Time: 2012-08-31 10:49:40
MySQL: 4.1.24-log
Locale: en_US.UTF-8
Server: Apache
PHP Server API: cgi-fcgi
RFC 2616 headers: 0
Server OS: Linux 2.6.18-238.19.1.el5PAE
Pre-flight check: 
------------------------
/home/content/k/u/l/kulisek08/html/textpattern/setup/ still exists
You are running a development version of Textpattern on a live server.: 
	/home/content/k/u/l/kulisek08/html/rpc/index.php, 
	/home/content/k/u/l/kulisek08/html/rpc/TXP_RPCServer.php
clean_url_data_failed: <br />
------------------------
.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
------------------------

ruud · 2012-08-31 18:39:35

All that’s posted above, except for the ‘get off my lawn’ error, is happening in a TXP 4.0.8 install.

Can you post the exact and complete “get off my lawn” error you’re getting after upgrading to TXP 4.5?

Your website seems to be running in “live” mode (not “testing” or “debug”).
What does the HTML source of your public home page show after upgrading to TXP 4.5?

Do you use a favorite/bookmark to visit the admin side? If so, just visit www.kulisekpc.com/textpattern/ … does that make a difference?

andrewowens · 2012-08-31 18:55:33

After installing TXP 4.5.0, visiting the admin login (not from a bookmark) yields:

internal_error.
get_off_my_lawn: ,

The homepage now features a visible error message of:

general_error Textpattern Error: Unknown column 'user_name' in 'where clause' on line 95

The homepage source is as follows:

<pre>general_error <b>Textpattern Error: Unknown column 'user_name' in 'where clause' on line 95</b></pre><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="content-type">
<title></title>
<style type="text/css" media="screen">
@import url(/main.css);
</style>
<!--[if lt IE 7]>
<script src="http://ie7-js.googlecode.com/svn/version/2.0(beta3)/IE7.js" type="text/javascript"></script>
<![endif]-->
</head>
<body>
<div id="siteMasthead">
<a href="/"><img src="/images/lisa_kulisek_pc.gif" alt="image" /></a>
</div>
<div id="mainContent">
<div id="mainNav">
<ul>
<li id="portfolio"><a href="/Portfolio">Portfolio</a></li>
<li id="resume"><a href="/Resume">Resume</a></li>
<li id="contact"><a href="/Contact">Contact</a></li>
</ul>
</div>
<div id="pageContent">
<div id="homepagetext">
<p>Kulisek PC was formed in 2008 by Lisa Kulisek, <span class="caps">AIA</span>. Kulisek believes that the success of a project depends not only on the client’s program and the architect’s problem-solving skills, but on the ability of the members of the project team to communicate well.  The architect must have a good working relationship with the client, consulting engineers and contractors.  Lisa has been involved in the successful building of project teams and brings her knowledge and passion to bear to take full advantage of strong relationships.  Her talent, vision and strong design skills are employed with sensitivity and good humor. The architect’s role as leader, mediator and translator is one that she particularly enjoys.  Lisa takes pride in being both creative and diligent.  She would be delighted to discuss with you any aspect of the design and construction process.</p>
<p>Lisa’s primary goal is to use her well-honed design skills to edit the project choices and direct the overall design process in a way that is less stressful, more enjoyable, and ultimately yields a better product than a project in which she is not involved.  Kulisek PC strives for excellence with the belief that high standards and enthusiasm are contagious and will inspire the entire project team to produce good buildings and spaces.  Our positive, people-centered attitude distinguishes Kulisek P.C. from many other firms.</p>
<p>Kulisek P.C. is a new breed of architecture firm.  We will provide a supportive environment for employees at all levels and will constantly re-evaluate the status of our human resources.  These are our most valuable assets and deserve to be our highest priority in the quest for a sustainable practice.  Informed by Lisa’s experience as a new mom, Kulisek P.C. will provide daycare options for employees with young children and will actively seek to employ men and women who find themselves unable to sustain their pre-parent architecture jobs but need and desire to continue to work- a highly under-utilized group.   Kulisek PC recognizes that architects must evolve in order to survive global challenges even though their work gets done locally.  </p>
<p>We welcome this challenge.</p>
</div>
</div>
</div>
<div id="footer">
<p>&copy; 2008 Kulisek P.C.  |  design by <a href="http://www.nadesignlab.com/portfolio" target="_blank">www.nadesignlab.com</a></p>
</div>
</body>
</html>

Bloke · 2012-08-31 18:58:35

andrewowens wrote:

Textpattern version: 4.0.8 (r4011)

r4011 is not a full release, it’s nearly the final Textpattern 4.5.0. That implies that something may have gone wrong with the file upload process. Can you be sure that all files were FTP’d up to the server correctly, overwriting any existing ones completely?

Perhaps try uploading them all again and then seeing if logging into the admin side works. If you can possibly get to the Admin->Preferences page and put the site in testing or debugging mode then that’ll help: it’ll give us more error output which can sometimes point the way a little easier. If not — and you can get into your host’s control panel and run phpMyAdmin (or equivalent) — you may be able to go through the txp_prefs table and change the production_status entry to debug.

Last edited by Bloke (2012-08-31 19:02:51)

andrewowens · 2012-08-31 19:03:32

Thanks for the response Stef. I just upgraded to 4.5 at the request of Ruud. I’m going to see how he responds and then I can try re-uploading 4.0.8.

I have the old version of 4.0.7 still on the server – if 4.5 doesn’t work out, would it be better to revert to 4.0.7? I was still getting the errors with 4.0.7 and tried to do an incremental upgrade to 4.0.8 to see if that helped, then never went back to 4.0.7.

Andy

ruud · 2012-08-31 20:07:49

You can get full diagnostics by visiting this URL (after upgrading to 4.5):
www.kulisekpc.com/textpattern/index.php?event=diag&step=high

Bloke’s on to something. Why doesn’t the automatic update database procedure complete, as it does normally when you visit the admin side after an update. If you were at 4.0.8 previously and tried upgrading to 4.5 and visited the admin site afterwards. I’d expect the reported TXP version to be 4.2, 4.3, 4.4, or preferably 4.5, but not 4.0.8. So what prevents upgrades from 4.0.8 to 4.5? Or in your case, what causes the “get off my lawn” error, which perhaps triggers before the database update starts?

Last edited by ruud (2012-08-31 20:09:37)

Textpattern CMS

Textpattern CMS support forum

#1 2012-08-30 22:04:27

Upgrading TextPattern from pre-4.1 versions to TXP 4.5

#2 2012-08-30 22:24:26

Re: Upgrading TextPattern from pre-4.1 versions to TXP 4.5

#3 2012-08-30 23:29:52

Re: Upgrading TextPattern from pre-4.1 versions to TXP 4.5

#4 2012-08-31 09:28:22

Re: Upgrading TextPattern from pre-4.1 versions to TXP 4.5

#5 2012-08-31 16:44:05

Re: Upgrading TextPattern from pre-4.1 versions to TXP 4.5

#6 2012-08-31 17:16:36

Re: Upgrading TextPattern from pre-4.1 versions to TXP 4.5

#7 2012-08-31 17:51:40

Re: Upgrading TextPattern from pre-4.1 versions to TXP 4.5

#8 2012-08-31 18:39:35

Re: Upgrading TextPattern from pre-4.1 versions to TXP 4.5

#9 2012-08-31 18:55:33

Re: Upgrading TextPattern from pre-4.1 versions to TXP 4.5

#10 2012-08-31 18:58:35

Re: Upgrading TextPattern from pre-4.1 versions to TXP 4.5

#11 2012-08-31 19:03:32

Re: Upgrading TextPattern from pre-4.1 versions to TXP 4.5

#12 2012-08-31 20:07:49

Re: Upgrading TextPattern from pre-4.1 versions to TXP 4.5

Board footer