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
or
forum.textpattern.com/viewtopic.php?id=50844
forum.textpattern.com/viewtopic.php?pid=310901#p310901
forum.textpattern.com/viewtopic.php?id=47268
etc
Do check the forum for textpattern/lib/txplib_misc.php:1676 adminErrorHandler and you’ll get more results.
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: SOLVED: 4.0.5 -> 4.7.1 update problem
Hi there,
I’m back from holidays and back at work with my one Textpattern Install from Hell ,-)
To sum up: trying to update from 4.6.2 to 4.8.2, none of the tips above have helped, making a copy of the site now to be able to freely edit the database to hopefully find & eliminate any culprits.
Wish me luck!
Offline
Re: SOLVED: 4.0.5 -> 4.7.1 update problem
If you can look at the database, take a look at the txp_prefs table and see what value is given for the version entry. In rare cases that needs resetting to make it run through the update steps.
If you need some help getting it working again, you’re welcome to send me an email.
Otherwise: good luck!! :-)
TXP Builders – finely-crafted code, design and txp
Offline
Re: SOLVED: 4.0.5 -> 4.7.1 update problem
Jakob, besten Dank! The version is exactly what I’ll be focussing on, as I had trouble with the entry in a previous update.
Offline
Re: SOLVED: 4.0.5 -> 4.7.1 update problem
Okay … this is what happened in the copy:
I deactivated plugins and logged off, then I copied the 4.8.2 files over.
When logging back in, the frontend was gone, with an unkonown section error.
I logged in and found the following errors:
The last ones were easily fixed by deleting the dir and changing permissions. The first ones disappeared after 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 then looked at the language tab and deleted de-de which has been replaced by de.
But … still, no frontend.
When I went to sections, it looked like this v v v below. There were no themes, and all pages were empty … no forms, too. No frontend code at all.
So, the good thing is, I can probably get back to a working site by copying all templates over manually, into a new theme. But why weren’t the old templates recognized?
Offline
Re: SOLVED: 4.0.5 -> 4.7.1 update problem
Okay, I can’t create a theme … “Themes creation failed”. Any ideas? Could I manually add the table for a theme to help me get going?
Offline
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