Help, my host upgraded to PHP 5.3

korpulente · 2009-11-24 21:27:33

Since my web host upgraded to PHP 5.3, I’ve had error messages all over my site (Textpattern 4.2.0).

Deprecated: Function set_magic_quotes_runtime() is deprecated in /something/httpd.www/site/textpattern/lib/txplib_db.php on line 14

Deprecated: Function split() is deprecated in /something/httpd.www/site/textpattern/include/txp_auth.php on line 77

Is there a workaround?

MattD · 2009-11-24 21:40:54

Do these still display when in Live Mode?

els · 2009-11-24 21:42:48

Try disabling your plugins one at a time, it may be one or more of these causing it.

korpulente · 2009-11-24 21:51:37

The site is of course in live mode, so yes, apparently.

I cannot deactivate plugins, as the back-end doesn’t function properpy anymore:

When I login, something forces the login prompt upon me every time I click a link in the UI. You can then choose to identify, and you’ll get to the destination of the link you clicked, ie. the plugin page. But I cannot disable plugins – the change isnt committed.

korpulente · 2009-11-24 22:03:06

Seems like Mary addressed the issue with split() earlier this year, but I have no idea what to do with this information.
http://groups.google.com/group/txp-svn/browse_thread/thread/6b503423dbf7150a

Last edited by korpulente (2009-11-24 22:11:45)

Bloke · 2009-11-24 22:13:04

korpulente wrote:

Is there a workaround?

If you’ve upgraded to TXP 4.2.0 already then something’s wrong with your TXP files because the PHP 5.3.0 stuff was squashed (as you found) in 4.2.0. You could try FTPing the 4.2.0 files up again — if nothing else, specifically the four mentioned. Perhaps it missed a few during the upgrade. Your diagnostics would of course tell the full story… if you could see the admin side!

korpulente · 2009-11-24 22:21:21

I just disabled all the plugins via PhpMyAdmin.
Nothing happens (except they don’t work anymore). :-/

korpulente · 2009-11-24 22:28:52

Bloke wrote:

If you’ve upgraded to TXP 4.2.0 already then something’s wrong with your TXP files because the PHP 5.3.0 stuff was squashed (as you found) in 4.2.0. You could try FTPing the 4.2.0 files up again — if nothing else, specifically the four mentioned. Perhaps it missed a few during the upgrade. Your diagnostics would of course tell the full story… if you could see the admin side!

I doubt that some files were missed. The site was “born” with Textpattern 4.2.0 a few months ago, and has been working nicely right until now.

I get these warnings, in addition to the mentioned errors, when I login to the back-end (note that my plugins are still disabled):

Warning: Cannot modify header information - headers already sent by (output started at /yourmom/httpd.www/site/textpattern/lib/txplib_db.php:14) in /yourmom/httpd.www/site/textpattern/include/txp_auth.php on line 196

Warning: Cannot modify header information - headers already sent by (output started at /yourmom/httpd.www/site/textpattern/lib/txplib_db.php:14) in /yourmom/httpd.www/site/textpattern/include/txp_auth.php on line 203

Notice: Undefined index: JPG Support in /yourmom/httpd.www/site/textpattern/include/txp_diag.php on line 398

Last edited by korpulente (2009-11-24 22:29:46)

korpulente · 2009-11-24 22:40:13

korpulente wrote:

Deprecated: Function set_magic_quotes_runtime() is deprecated in /something/httpd.www/site/textpattern/lib/txplib_db.php on line 14

Snippet from txplib_db.php

if (get_magic_quotes_runtime())
{
        set_magic_quotes_runtime(0);
}

There isn’t going to be any easy workaround for this, like turning plugins off. It seems to me that PHP 5.3.1 is complaining about something in Textpattern.

NOTE: The upgrade on my host was to PHP 5.3.1, in case it makes any difference (I falsely wrote 5.3 before).

Last edited by korpulente (2009-11-24 22:41:46)

Bloke · 2009-11-24 22:51:48

korpulente wrote:

I doubt that some files were missed. The site was “born” with Textpattern 4.2.0 a few months ago, and has been working nicely right until now.

That’s very odd then. Because the message Function split() is deprecated in ....../include/txp_auth.php on line 77 implies that the split() function is being used in your txp_auth.php, yet the function doesn’t exist on that line (in fact, anywhere) in TXP 4.2.0 :-S

If you’re sure your files are the 4.2.0 ones and your server is reading the right ones from the location you expect (no weird symlinks or multi-sites or a mangled entry in config.php or something) then I’m afraid you’ve reached the end of my knowledge here, sorry.

Last edited by Bloke (2009-11-24 22:55:17)

korpulente · 2009-11-24 23:27:45

Good point, Bloke. And no, this is just a single site using one db etc.

I will try to re-upload the files via FTP and see what happens. This sounds very weird to me.

els · 2009-11-24 23:39:19

Bloke wrote:

Because the message Function split() is deprecated in ....../include/txp_auth.php on line 77 implies that the split() function is being used in your txp_auth.php, yet the function doesn’t exist on that line (in fact, anywhere) in TXP 4.2.0 :-S

But it is in line 77 of txp_auth.php in 4.0.8…

korpulente · 2009-11-25 11:29:13

Oh my. This thing is getting a lot worse all the time. :-(

After I re-uploaded the vital files from Textpattern 4.2.0 to my install dir, I am presented with the following errors when I log in, and the back-end is rendered completely useless:

Warning: Unknown column ‘user_name’ in ‘where clause’ select name, val from textpatt_txp_prefs as txp_prefs where prefs_id=1 AND user_name=’‘ in /mysite/httpd.www/site/textpattern/lib/txplib_db.php on line 85

Notice: Undefined variable: language in /mysite/httpd.www/site/textpattern/index.php on line 70

Warning: Cannot modify header information – headers already sent by (output started at /mysite/httpd.www/site/textpattern/lib/txplib_db.php:85) in /mysite/httpd.www/site/textpattern/include/txp_auth.php on line 196

Warning: Cannot modify header information – headers already sent by (output started at /mysite/httpd.www/site/textpattern/lib/txplib_db.php:85) in /mysite/httpd.www/site/textpattern/include/txp_auth.php on line 203

Warning: Unknown column ‘user_name’ in ‘where clause’ select name, val from textpatt_txp_prefs as txp_prefs where prefs_id=1 AND user_name=‘admin’ in /mysite/httpd.www/site/textpattern/lib/txplib_db.php on line 85

Warning: Unknown column ‘user_name’ in ‘where clause’ select name, val from textpatt_txp_prefs as txp_prefs where prefs_id=1 AND user_name=’‘ in /mysite/httpd.www/site/textpattern/lib/txplib_db.php on line 85

Warning: Unknown column ‘user_name’ in ‘where clause’ select name, val from textpatt_txp_prefs as txp_prefs where prefs_id=1 AND user_name=‘admin’ in /mysite/httpd.www/site/textpattern/lib/txplib_db.php on line 85

Warning: Unknown column ‘user_name’ in ‘where clause’ select name, val from textpatt_txp_prefs as txp_prefs where prefs_id=1 AND user_name=’‘ in /mysite/httpd.www/site/textpattern/lib/txplib_db.php on line 85

Notice: Undefined index: blog_uid in /mysite/httpd.www/site/textpattern/include/txp_prefs.php on line 728

korpulente · 2009-11-25 12:49:05

Okay, I tried a complete re-install. Backed up my db, and removed all files.

The completely new index.php (the default frontpage, ‘My Site’ etc.) gives these warnings/errors:

Warning: Unknown column ‘load_order’ in ‘order clause’ select name, code, version from new_txp_plugin as txp_plugin where status = 1 AND type IN (0,1) order by load_order in /customers/logik.dk/logik.dk/httpd.www/site/textpattern/lib/txplib_db.php on line 85

Textpattern errors:

Tag error: <txp:article_custom section=’<txp:section />’ wraptag=“ul” break=“li”> -> Textpattern Warning: Unknown column ‘Expires’ in ‘field list’
select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from new_textpattern as textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = ’0000-00-00 00:00:00’) and Section IN (‘default’) order by Posted desc limit 0, 10 on line 85
Tag error: <txp:article limit=“5” /> -> Textpattern Warning: Unknown column ‘Expires’ in ‘where clause’
select count(*) from new_textpattern as textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = ’0000-00-00 00:00:00’) and Section != ‘about’ on line 85
Tag error: <txp:article limit=“5” /> -> Textpattern Warning: Unknown column ‘Expires’ in ‘field list’
select *, unix_timestamp(Posted) as uPosted, unix_timestamp(Expires) as uExpires, unix_timestamp(LastMod) as uLastMod from new_textpattern as textpattern where 1=1 and Status = 4 and Posted <= now() and (now() <= Expires or Expires = ’0000-00-00 00:00:00’) and Section != ‘about’ order by Posted desc limit 0, 5 on line 85

This tells me that something is totally wrong on this webserver. Right?

uli · 2009-11-25 13:12:32

korpulente wrote:

Textpattern Warning: Unknown column ‘Expires’ in ‘field list’

That’s been an error I saw on the MLP thread. Do you have MLP installed? > Possible solution

Textpattern CMS

Textpattern CMS support forum

#1 2009-11-24 21:27:33

Help, my host upgraded to PHP 5.3

#2 2009-11-24 21:40:54

Re: Help, my host upgraded to PHP 5.3

#3 2009-11-24 21:42:48

Re: Help, my host upgraded to PHP 5.3

#4 2009-11-24 21:51:37

Re: Help, my host upgraded to PHP 5.3

#5 2009-11-24 22:03:06

Re: Help, my host upgraded to PHP 5.3

#6 2009-11-24 22:13:04

Re: Help, my host upgraded to PHP 5.3

#7 2009-11-24 22:21:21

Re: Help, my host upgraded to PHP 5.3

#8 2009-11-24 22:28:52

Re: Help, my host upgraded to PHP 5.3

#9 2009-11-24 22:40:13

Re: Help, my host upgraded to PHP 5.3

#10 2009-11-24 22:51:48

Re: Help, my host upgraded to PHP 5.3

#11 2009-11-24 23:27:45

Re: Help, my host upgraded to PHP 5.3

#12 2009-11-24 23:39:19

Re: Help, my host upgraded to PHP 5.3

#13 2009-11-25 11:29:13

Re: Help, my host upgraded to PHP 5.3

#14 2009-11-25 12:49:05

Re: Help, my host upgraded to PHP 5.3

#15 2009-11-25 13:12:32

Re: Help, my host upgraded to PHP 5.3

Board footer