Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#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: 4,079
- 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.2I 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: 4,079
- 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: 4,079
- Website
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: 4,079
- Website
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