Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
[solved] Updating problem: Unknown column 'author' in 'txp_file'"
Hello!
I did an update from 4.5 to 4.7 this didn’t work out so i updated to 4.6
Now the site is up & running but in the backend i can only access the Language-panel and on top of the page is this warning:
User_Error “Unknown column ‘author’ in ‘txp_file’”
in /is/htdocs/wp1055590_YDHXQ6HXHH/www/cwde/textpattern/lib/txplib_db.php at line 405.
What to do? Alter the MYSQL-DB? tried to upload older scripts but that didn’t work.
Any Idea?
Thanks a Lot
Claus
Last edited by claus (2018-10-22 14:27:23)
Offline
Re: [solved] Updating problem: Unknown column 'author' in 'txp_file'"
Hi Claus,
from what I can see, your site is still running 4.5.7 and trying to update to 4.6.0 when you visit the admin side. The weird thing is missing author
column in txp_file
table, it should be there since 4.2.0. If you can, please check `txp_file` (and also `txp_link` and `txp_image`) table structure and add author VARCHAR(64) NOT NULL
field if missing. You’d also need to create indexes if this works, but first things first.
Offline
Re: [solved] Updating problem: Unknown column 'author' in 'txp_file'"
Hi etc,
Yesh! This did the trick. Thanx a lot! Also you friendly forced me after 13 years of web-development to run my first direct SQL-Statement. Magnificent!
Now what about the Indexes you have mentioned? I made a short websearch and think I got the idea but have – as a MySQL-Newbie no Idea how to proceed. And the database is running – so what should i do for best practice?
Thanx a lot again!
Claus
Last edited by claus (2018-10-22 14:44:35)
Offline