Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
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
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 sectionOffline
Re: SOLVED: 4.0.5 -> 4.7.1 update problem
funtoosh wrote #325731:
I looked into SQL and found that in
txp_prefsthe 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
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
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
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
Offline
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
Offline
Re: SOLVED: 4.0.5 -> 4.7.1 update problem
Just FYI, it did finally work in the live version as well …
Offline