SOLVED: 4.0.5 -> 4.7.1 update problem

funtoosh · 2020-09-03 12:32:54

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?

funtoosh · 2020-09-03 12:50:23

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

etc · 2020-09-03 13:57:40

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?

funtoosh · 2020-09-03 14:00:46

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

etc · 2020-09-03 14:09:49

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

funtoosh · 2020-09-03 14:35:02

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

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

Merci bien, etc!

etc · 2020-09-03 14:43:22

Ende gut, alles gut!

funtoosh · 2020-09-03 15:02:41

:~}

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

etc · 2020-09-03 15:16:01

Good luck then :-)

funtoosh · 2020-09-28 12:35:35

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

Textpattern CMS

Textpattern CMS support forum

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

funtoosh wrote #325731:

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

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

Re: SOLVED: 4.0.5 -> 4.7.1 update problem

Board footer