Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2016-06-29 21:35:40
- nixcamic
- New Member
- Registered: 2016-06-29
- Posts: 5
Error on article posting/section editing
I moved my small blog over to a server running Ubuntu 16.04, with PHP 7 and lighttpd. I installed the 4.6 beta because PHP7, since I figured its a small blog, beta is fine, and copied my sql database/edited my config.php and got it up and running, or so I thought.
Whenever I try to publish a new article I get “The article was not saved due to an error. Please try again.” which is probably the least helpful error message ever :D Also editing sections gives “The section was not saved due to an error. Please try again.”
Is there any way to get a more detailed view of whats happening?
Offline
Re: Error on article posting/section editing
This error sounds vaguely familiar from a time past, but I can’t recall the context. A dev will surely have an idea.
What does your Admin > Diagnostics say? Are there any errors there? Or do “All checks passed!” ;)
It’s probably too soon to try a tag trace if you’re only setting up a new site, but could be useful later.
Offline
#3 2016-06-30 12:42:09
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,313
Re: Error on article posting/section editing
Hi, nixcamic, and welcome to the Textpattern forums.
Please try uploading the textpattern files one more time, we’ve had an identical error warning that could be fixed that way, albeit not on 4.6 beta.
In case that doesn’t help please post in the 4.6-beta topic with updated information, very likely the devs are subscribed there.
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline
#4 2016-06-30 17:40:43
- nixcamic
- New Member
- Registered: 2016-06-29
- Posts: 5
Re: Error on article posting/section editing
Hey, I’ve tried uploading textpattern again, and also I’ve tried chmoding the whole folder to 755 just to see if for some reason something was missing write permissions. Nope.
All that’s shown on the diagnostics screen is “The following PHP functions (which may be necessary to run Textpattern) are disabled on your server: pcntl_alarm, pcntl_fork, pcntl_waitpid, pcntl_wait, pcntl_wifexited, pcntl_wifstopped, pcntl_wifsignaled, pcntl_wifcontinued, pcntl_wexitstatus, pcntl_wtermsig, pcntl_wstopsig, pcntl_signal, pcntl_signal_dispatch, pcntl_get_last_error, pcntl_strerror, pcntl_sigprocmask, pcntl_sigwaitinfo, pcntl_sigtimedwait, pcntl_exec, pcntl_getpriority, pcntl_setpriority,”
Which according to other posts is completely fine.
—————————————————————-So, after enabling debugging, the error I get is:
User_Error “Unknown column ‘description’ in ‘field list’”
in /var/www/html/mic/textpattern/lib/txplib_db.php at line 405.
adminErrorHandler()
textpattern/lib/txplib_db.php:405 trigger_error()
textpattern/lib/txplib_db.php:479 safe_query()
textpattern/include/txp_article.php:289 safe_insert()
textpattern/include/txp_article.php:126 article_post()
textpattern/index.php:211 include()
Last edited by nixcamic (2016-06-30 17:40:57)
Offline
Re: Error on article posting/section editing
Hi, tables structure has changed between 4.5 and 4.6, and it looks like the update script hasn’t done its job. Could it be that your db account has insufficient privileges (no ALTER, in particular)?
Offline
#6 2016-06-30 21:16:47
- nixcamic
- New Member
- Registered: 2016-06-29
- Posts: 5
Re: Error on article posting/section editing
I am fairly mysql ignorant, but I did grant all privileges to the database to my user. Is there any way to rerun the update script?
Offline
Re: Error on article posting/section editing
nixcamic wrote #300069:
Is there any way to rerun the update script?
Not sure, but try to open and save some file in textpattern/update directory, just to set its timestamp to now.
Edit: you can also create a new file, starting its name with _ (say, _fake.txt).
Last edited by etc (2016-06-30 21:48:59)
Offline
#8 2016-06-30 22:53:46
- nixcamic
- New Member
- Registered: 2016-06-29
- Posts: 5
Re: Error on article posting/section editing
Thanks! I ran touch * in the update directory, that fixed that error. Then I was just left with the 0000-00-00 error, which is fairly well documented.
Last edited by nixcamic (2016-06-30 22:54:07)
Offline