Help, my host upgraded to PHP 5.3

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

uli · 2009-11-25 13:20:01

As for the other warning I found this here

korpulente · 2009-11-25 13:20:21

This is a completely fresh “out of the box” install: New Textpattern install on faulty server
As you can see, nothing works and there are loads of warnings.

I spoke to the support, and they told me that it’s probably a compatibility problem with PHP 5.3.1

Last edited by korpulente (2009-11-25 13:20:56)

uli · 2009-11-25 13:28:02

korpulente wrote:

As you can see, nothing works and there are loads of warnings.

huhh??

korpulente · 2009-11-25 13:28:31

Okay, the fresh install is okay now. After I logged in to the admin side, the error mystically disappeared.

Now I’ll try to rebuild the site with the data from my old db.

EDIT: Haha, uli, you beat me to it. I just “fixed it” by logging in. :-)

Last edited by korpulente (2009-11-25 13:29:37)

maverick · 2009-11-26 00:51:31

korpulente wrote:

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

fwiw

wet noted this as expected behavior here

As you found out, it goes away after your first login.

Last edited by maverick (2009-11-26 00:52:38)

Textpattern CMS

Textpattern CMS support forum

#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

#16 2009-11-25 13:20:01

Re: Help, my host upgraded to PHP 5.3

#17 2009-11-25 13:20:21

Re: Help, my host upgraded to PHP 5.3

#18 2009-11-25 13:28:02

Re: Help, my host upgraded to PHP 5.3

#19 2009-11-25 13:28:31

Re: Help, my host upgraded to PHP 5.3

#20 2009-11-26 00:51:31

Re: Help, my host upgraded to PHP 5.3

Board footer