Textpattern CMS

#1 2010-09-12 20:38:02

tameboy

Plugin Author

Registered: 2006-06-29

Posts: 48

Upgrade attempt from 4.0.4 to 4.2.0

Hi

Just tried to upgrade my site. Followed the instructions and then tried to access my admin side. Get this now:

Warning: Unknown column 'user_name' in 'where clause' select name, val from txp_prefs where prefs_id=1 AND user_name='' in /home/ivygrove/htdocs/textpattern/lib/txplib_db.php on line 85

Notice: Undefined variable: language in /home/ivygrove/htdocs/textpattern/index.php on line 70

Warning: Cannot modify header information - headers already sent by (output started at /home/ivygrove/htdocs/textpattern/lib/txplib_db.php:85) in /home/ivygrove/htdocs/textpattern/include/txp_auth.php on line 169

Warning: Cannot modify header information - headers already sent by (output started at /home/ivygrove/htdocs/textpattern/lib/txplib_db.php:85) in /home/ivygrove/htdocs/textpattern/include/txp_auth.php on line 170

And a message saying ‘invalid cookie’ just above the sign in form. I tried clearing the session cookies and even restarting the browser but the same problem recurrs.

Any ideas?

#2 2010-09-12 21:28:48

uli

Moderator

From: Cologne

Registered: 2006-08-15

Posts: 4,315

Re: Upgrade attempt from 4.0.4 to 4.2.0

tameboy wrote:

Any ideas?

See here?

---

_{In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links}

#3 2010-09-13 08:36:08

tameboy

Plugin Author

Registered: 2006-06-29

Posts: 48

Re: Upgrade attempt from 4.0.4 to 4.2.0

thanks uli, I wish it did only occur once. As I said in the first post I tried clearing cookies, cache and now have tried accessing from a different PC, and it is occurring every time. I think that post is referring to an earlier release candidate anyway – surely that shouldn’t still be occurring in the normal release version.

I noticed that the line numbers in my error messages are slightly different from the ones quoted. Is that relevant? Or is it just because that post refers to an earlier RC?

#4 2010-09-13 14:11:37

Gocom

Developer Emeritus

From: Helsinki, Finland

Registered: 2006-07-14

Posts: 4,533

Website

Re: Upgrade attempt from 4.0.4 to 4.2.0

Did you transfer the files as binary, in non-modified form? Might be that the files have BOM, whitespace or something similiar in them.

tameboy wrote:

surely that shouldn’t still be occurring in the normal release version.

Yes it does.

Last edited by Gocom (2010-09-13 14:15:28)

---

Rah | GitHub

#5 2010-09-13 17:38:44

tameboy

Plugin Author

Registered: 2006-06-29

Posts: 48

Re: Upgrade attempt from 4.0.4 to 4.2.0

Thanks Gocom, point noted re error message still occurring during upgrading. My problem of course is that it persists rather than just occurring once.

Gocom wrote:

Did you transfer the files as binary, in non-modified form? Might be that the files have BOM, whitespace or something similiar in them.

Not sure, I think my ftp software is set to transfer as ascii files, but I will check and try transferring as binary – is that what I should be doing? Will this make any difference to the error message? Or are you just referring to the line numbers differences?

Thanks again

#6 2010-09-13 22:32:07

Gocom

Developer Emeritus

From: Helsinki, Finland

Registered: 2006-07-14

Posts: 4,533

Website

Re: Upgrade attempt from 4.0.4 to 4.2.0

tameboy wrote:

Not sure, I think my ftp software is set to transfer as ascii files, but I will check and try transferring as binary – is that what I should be doing? Will this make any difference to the error message? Or are you just referring to the line numbers differences?

Well, yeah kinda. The files should be transfered as is, without modifying the contents. Something is causing the header problems, and excess whitespace, and BOM etc, can cause that. The extra whitespace can possibly also come from plugins or plugin cache.

---

Rah | GitHub

#7 2010-09-24 06:49:19

tameboy

Plugin Author

Registered: 2006-06-29

Posts: 48

Re: Upgrade attempt from 4.0.4 to 4.2.0

finally got round to uploading textpattern again, this time making sure FTP was using binary transfer. Unfortunately this has not helped. I am still getting the error message:

Warning: Unknown column 'user_name' in 'where clause' select name, val from txp_prefs where prefs_id=1 AND 
user_name='' in /home/ivygrove/htdocs/textpattern/lib/txplib_db.php on line 85

Notice: Undefined variable: language in /home/ivygrove/htdocs/textpattern/index.php on line 70

Warning: Cannot modify header information - headers already sent by (output started at
 /home/ivygrove/htdocs/textpattern/lib/txplib_db.php:85) in 
/home/ivygrove/htdocs/textpattern/include/txp_auth.php on line 169

Warning: Cannot modify header information - headers already sent by (output started at
 /home/ivygrove/htdocs/textpattern/lib/txplib_db.php:85) in
 /home/ivygrove/htdocs/textpattern/include/txp_auth.php on line 170

and just above the sign in dialogue the following appears:

Invalid cookie. Please enter login details.

#8 2010-09-24 10:20:45

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: Upgrade attempt from 4.0.4 to 4.2.0

Can you check you txp_prefs table to see if it has a ‘user_name’ column. If it doesn’t then that’s the problem. It’s not upgrade related, because that column should’ve been there in 4.0.4 as well.

#9 2010-09-29 13:32:25

tameboy

Plugin Author

Registered: 2006-06-29

Posts: 48

Re: Upgrade attempt from 4.0.4 to 4.2.0

no, there is no user_name column. That is a bit odd. Can I resolve this problem by creating one?

#10 2010-11-07 13:41:21

MVB

New Member

From: Netherlands

Registered: 2006-11-14

Posts: 5

Website

Re: Upgrade attempt from 4.0.4 to 4.2.0

I had the same problem. First updating to 4.0.8 and then to 4.3.0 worked for me.

#11 2010-11-07 18:58:36

ruud

Developer Emeritus

From: a galaxy far far away

Registered: 2006-06-04

Posts: 5,068

Website

Re: Upgrade attempt from 4.0.4 to 4.2.0

If that works, it’s a bug.