Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#31 2020-09-03 12:32:54

funtoosh
Member
From: Münster, Germany
Registered: 2006-10-09
Posts: 149
Website

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

So I’ve copied the txp_skin from another installation. However, all my related database tables miss columns, e.g. txp_page is missing both skin and lastmod:

Could anybody help me out with an SQL command to create the columns in question?

Any other place that might need additional columns, except txp_page, txp_form oh and txp_section?
Are there any other new fields that my installation may be missing?

Offline

#32 2020-09-03 12:50:23

funtoosh
Member
From: Münster, Germany
Registered: 2006-10-09
Posts: 149
Website

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

PS when in debug mode, I get the following errors in front end:

Tag error:  ->  Textpattern Error: Unknown column 'skin' in 'field list' while parsing form Keine on page default
textpattern/lib/txplib_db.php:448 trigger_error()
textpattern/lib/txplib_db.php:1127 safe_query()
textpattern/lib/txplib_db.php:966 getRow()
textpattern/lib/txplib_misc.php:3258 safe_row()
textpattern/lib/txplib_misc.php:3297 fetch_page()
textpattern/publish.php:740 parse_page()
index.php:74 textpattern()
Tag error:  ->  Textpattern Error: Unknown column 'skin' in 'where clause' while parsing form Keine on page default
textpattern/lib/txplib_db.php:448 trigger_error()
textpattern/lib/txplib_db.php:867 safe_query()
textpattern/lib/txplib_misc.php:3267 safe_field()
textpattern/lib/txplib_misc.php:3297 fetch_page()
textpattern/publish.php:740 parse_page()
index.php:74 textpattern()
Tag error:  ->  Textpattern Error: Unknown column 'skin' in 'field list' while parsing form Keine on page default
textpattern/lib/txplib_db.php:448 trigger_error()
textpattern/lib/txplib_db.php:1127 safe_query()
textpattern/lib/txplib_db.php:966 getRow()
textpattern/lib/txplib_misc.php:3258 safe_row()
textpattern/lib/txplib_misc.php:4216 fetch_page()
textpattern/publish.php:743 txp_die()
index.php:74 textpattern()
Tag error:  ->  Textpattern Error: Unknown column 'skin' in 'where clause' while parsing form Keine on page default
textpattern/lib/txplib_db.php:448 trigger_error()
textpattern/lib/txplib_db.php:867 safe_query()
textpattern/lib/txplib_misc.php:3267 safe_field()
textpattern/lib/txplib_misc.php:4216 fetch_page()
textpattern/publish.php:743 txp_die()
index.php:74 textpattern()
Tag error:  ->  Textpattern Error: Unknown column 'skin' in 'field list' while parsing form Keine on page default
textpattern/lib/txplib_db.php:448 trigger_error()
textpattern/lib/txplib_db.php:1127 safe_query()
textpattern/lib/txplib_db.php:966 getRow()
textpattern/lib/txplib_misc.php:3258 safe_row()
textpattern/lib/txplib_misc.php:4216 fetch_page()
textpattern/publish.php:743 txp_die()
index.php:74 textpattern()
Tag error:  ->  Textpattern Error: Unknown column 'skin' in 'where clause' while parsing form Keine on page default
textpattern/lib/txplib_db.php:448 trigger_error()
textpattern/lib/txplib_db.php:867 safe_query()
textpattern/lib/txplib_misc.php:3267 safe_field()
textpattern/lib/txplib_misc.php:4216 fetch_page()
textpattern/publish.php:743 txp_die()
index.php:74 textpattern()
Unknown section

Offline

#33 2020-09-03 13:57:40

etc
Developer
Registered: 2010-11-11
Posts: 3,934
Website

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

funtoosh wrote #325731:

I looked into SQL and found that in txp_prefs the version was actually still at 4.6.2

I changed that to 4.8.2 and all errors disappeared.

I guess that’s why the update script did not run. Have you tried reverting it back to 4.6.2?

Offline

#34 2020-09-03 14:00:46

funtoosh
Member
From: Münster, Germany
Registered: 2006-10-09
Posts: 149
Website

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

etc, do you mean I should revert it to 4.6.2 and then re-run the update script directly at _update.php?

Offline

#35 2020-09-03 14:09:49

etc
Developer
Registered: 2010-11-11
Posts: 3,934
Website

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

txp should run update itself when you access the backend and version pref does not match txp version.

Offline

#36 2020-09-03 14:35:02

funtoosh
Member
From: Münster, Germany
Registered: 2006-10-09
Posts: 149
Website

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

Yay, that worked! Front end is back. Phew …

There are a few errors from deprecated tags, but, so far, nothing major.

Merci bien, etc!

Offline

#37 2020-09-03 14:43:22

etc
Developer
Registered: 2010-11-11
Posts: 3,934
Website

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

Ende gut, alles gut!

Offline

#38 2020-09-03 15:02:41

funtoosh
Member
From: Münster, Germany
Registered: 2006-10-09
Posts: 149
Website

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

:~}

Well let’s see, this was just the copy update, not yet the real stuff …

Offline

#39 2020-09-03 15:16:01

etc
Developer
Registered: 2010-11-11
Posts: 3,934
Website

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

Good luck then :-)

Offline

#40 2020-09-28 12:35:35

funtoosh
Member
From: Münster, Germany
Registered: 2006-10-09
Posts: 149
Website

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

Just FYI, it did finally work in the live version as well …

Offline

Board footer

Powered by FluxBB