Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2015-09-14 19:15:58
- marsgoose
- New Member
- Registered: 2015-09-14
- Posts: 3
Errors on a fresh installation
Errors:
General error Textpattern Error: Unknown column ‘load_order’ in ‘order clause’ on line 95
Tag error: <txp:article limit=“5” /> -> Textpattern Error: Unknown column ‘Expires’ in ‘where clause’ while parsing form None on page default
Tag error: <txp:article limit=“5” /> -> Textpattern Error: Unknown column ‘Expires’ in ‘field list’ while parsing form None on page default
I did the install twice, once from the .zip once from the .tar.gz. Removed all the files and dropped the database in between.
PHP 5.6.13
nginx/1.0.15
10.0.21-MariaDB
Google and docs didn’t help me much.
i appreciate any input.
Offline
#2 2015-09-14 19:31:14
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,304
Re: Errors on a fresh installation
Hi marsgoose, and welcome to the forum.
What does the diagnostics page say, anything in red or orange?
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline
#3 2015-09-14 19:49:46
- marsgoose
- New Member
- Registered: 2015-09-14
- Posts: 3
Re: Errors on a fresh installation
Hi uli,
I get the following:
Textpattern version: 4.5.7 (r5900)
Last update: 2015-09-14 19:39:50/2015-09-14 18:10:43
Document root: /srv/fedora
$path_to_site: /srv/fedora
Textpattern path: /srv/fedora/textpattern
Permanent link mode: messy
Temporary directory path: /tmp
Site URL: tinfoilfedora.org
PHP version: 5.6.13
GD Graphics Library: unavailable
Server TZ: US/Central
Server local time: 2015-09-14 14:46:52
DST enabled?: 0
Automatically adjust DST setting?: 0
Time zone: (+0)
MySQL: 5.5.5-10.0.21-MariaDB
Locale: en_US.UTF-8
Server: nginx/1.0.15
PHP server API: fpm-fcgi
RFC 2616 headers: 0
Server OS: Linux 2.6.32-042stab108.8
Admin-side theme: classic 4.5.7
Pre-flight check:
————————————
Image directory is not writable: /srv/fedora/images
File directory path is not writable: /srv/fedora/files
————————————
I can see the recommendation to set this directories to 755, which I have done:
drwxr-xr-x 2 nginx nginx 4096 Sep 14 14:10 files
drwxr-xr-x 2 nginx nginx 4096 Sep 14 14:10 images
Warning is still shown, not sure if related.
Offline
#4 2015-09-14 19:51:25
- marsgoose
- New Member
- Registered: 2015-09-14
- Posts: 3
Re: Errors on a fresh installation
Hi,
I’m not sure what happened, but the errors are gone. Thanks for your time. :)
Offline
Re: Errors on a fresh installation
Probably a database that wasn’t updated yet after the TXP files were upgraded (the DB update happened the moment you logged in on the admin side).
Offline
Re: Errors on a fresh installation
From README.txt:
NOTE: Upgrades from versions prior to 4.2.0 will present warnings or errors
upon the first login to the admin-side. These may include:
Unknown column 'user_name' in 'where clause' select name,
val from txp_prefs where prefs_id=1 AND user_name='' in
/path/to/your/site/textpattern/lib/txplib_db.php on line xx
Undefined variable: language in
/path/to/your/site/textpattern/index.php at line xx
Undefined variable: gmtoffset in
/path/to/your/site/textpattern/update/_to_4.2.0.php at line xx
This is expected behaviour. The messages will disappear with subsequent
navigation in the admin-side.
Offline
Re: Errors on a fresh installation
wet wrote #294810:
From README.txt:
NOTE: Upgrades from versions prior to 4.2.0 will present warnings or errors...
Thanks, wet. I’ll find a place to mention that in the detailed Installing Textpattern instructions too, which I’m just finishing up.
Though he was doing a fresh install, not an upgrade from “versions prior to 4.2.0”, if I understood correctly.
I have a similar question…
I just installed a fresh package on my local OS X server. After advancing to install screen #3, labeled “Populate database” (i.e., before first log in) I got about 100 (no kidding) of these at the top of the screen:
Warning: strftime(): It is not safe to rely on the system’s timezone settings. You are required to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone ‘UTC’ for now, but please set date.timezone to select your timezone. in /Users/destry/Sites/sandbox/textpattern/setup/txpsql.php on line 467
I ignored the error and sallied forth anyway. After logging in, I got an OS X error indicating something similar about the date/time but not written the same way (much shorter). I went straight to to Basic prefs and set my time zone choice, etc, and haven’t seen the error since, though that might just be coincidence so far.
Any idea what happened there?
Offline
Re: Errors on a fresh installation
I just installed a dev 4.6 version locally and the same thing happened:
Warning: strftime(): It is not safe to rely on the system’s timezone settings. You are required to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone ‘UTC’ for now, but please set date.timezone to select your timezone. in /Users/destry/Sites/txpfuture/textpattern/setup/txpsql.php on line 503
Though adding to what I said before:
- It happens right after submitting my admin login details (when generating the db tables).
- I advanced to the next screen (Go!) and there’s a gazillion replications of the error at the top of the screen.
- When I log in, the login stalls a minute until OS X throws up a warning of it’s own. I click okay, click okay again on the second one and check the “don’t tell me again” box, and it logs me in.
- I’m dropped at the Languages panel, as expected, and I see the “Update” link on the my language choice. If I click it, it doesn’t update, instead I get the OX X error messages again as described.
- From here on, every time I try to change a panel location, I get the system error.
Not sure what to do to fix the “time” issue.
I’m guessing there’s something about the way my local MySQL server is configured that’s not playing nice with Txp?
Last edited by Destry (2015-09-16 15:37:20)
Offline
Re: Errors on a fresh installation
@Destry, that’s a known issue
Offline
Re: Errors on a fresh installation
Cool. Thanks, Ruud!
1157 times in a row.
That’s more than I thought. I didn’t bother counting. That guy is dedicated.
Offline
Re: Errors on a fresh installation
Putting this in php.ini will fix it, apparently:
date.timezone = "Europe/Paris"But, uh… where is that file? What folders should I start poking around in?
Never mind, found it.
Last edited by Destry (2015-09-16 15:51:30)
Offline
Re: Errors on a fresh installation
Can’t find a php.ini file, actually, but in /etc. there’s a php.ini.default, and at line 910:
; date.timezone = I changed that to:
date.timezone = Europe/ParisBut still have errors. Do I need to remove the “.default” of the file name?
Edit: Yep, removed “.default” and restarted Apache and all is well now.
Thanks for the lead, Ruud.
Last edited by Destry (2015-09-16 16:50:37)
Offline