Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2009-04-12 06:25:56
- Lauski
- New Member
- Registered: 2009-02-19
- Posts: 5
[resolved] Warning: Unknown column 'load_order' in 'order clause' select name ...
Hello! I just install a new fresh version of 4.0.8 (r3085).
When logged in to TextPattern, I’ve got this error:
Warning: Unknown column ‘load_order’ in ‘order clause’ select name, code, version from papitxp_plugin as txp_plugin where status = 1 AND type IN (1,3) order by load_order in /home/www/mysite.fi/textpattern/lib/txplib_db.php on line 82
When saving a new article (title “a”, text “a”):
Warning: Unknown column ‘load_order’ in ‘order clause’ select name, code, version from papitxp_plugin as txp_plugin where status = 1 AND type IN (1,3) order by load_order in /home/www/mysite.fi/textpattern/lib/txplib_db.php on line 82
Warning: Unknown column ‘Expires’ in ‘field list’ insert into papitextpattern set Title = ‘a’, Body = ‘a’, Body_html = ‘
a
‘, Excerpt = ‘’, Excerpt_html = ‘’, Image = ‘’, Keywords = ‘’, Status = 4, Posted = from_unixtime(1239347440), Expires = ’0000-00-00 00:00:00’, LastMod = now(), AuthorID = ‘Lauski’, Section = ‘blogi’, Category1 = ‘’, Category2 = ‘’, textile_body = 1, textile_excerpt = 1, Annotate = 1, override_form = ‘’, url_title = ‘a’, AnnotateInvite = ‘Kommentti’, custom_1 = ‘’, custom_2 = ‘’, custom_3 = ‘’, custom_4 = ‘’, custom_5 = ‘’, custom_6 = ‘’, custom_7 = ‘’, custom_8 = ‘’, custom_9 = ‘’, custom_10 = ‘’, uid = ‘6cdd736845bf6748bb2860f6bb071027’, f in /home/www/mysite.fi/textpattern/lib/txplib_db.php on line 82
Articles:
Warning: Unknown column ‘Expires’ in ‘field list’ select *, unix_timestamp(Posted) as posted, unix_timestamp(LastMod) as lastmod, unix_timestamp(Expires) as expires from papitextpattern as textpattern where 1 order by Posted desc limit 0, 25 in /home/www/mysite.fi/textpattern/lib/txplib_db.php on line 82
Diagnostics:
Site URL preference might be incorrect: mysite.fi/mysite.fi (this is because I have two different domains in one webhotel and this one is /home/www/mysite.fi)
Textpattern version: 4.0.8 (r3085)
Last Update: 2009-04-10 06:25:04/2009-01-23 19:20:55
Document root: /home/www
$path_to_site: /home/www/mysite.fi
Textpattern path: /home/www/mysite.fi/textpattern
Permanent link mode: section_id_title
Temporary directory path: /home/www/mysite.fi/textpattern/tmp
Site URL: www.mysite.fi
PHP version: 5.2.9
GD Image Library: bundled (2.0.34 compatible); supported formats: GIF, JPG, PNG.
Server Local Time: 2009-04-12 09:23:19
MySQL: 5.0.67
Locale: C
Server: Apache
Apache version: Apache
PHP Server API: apache2handler
RFC 2616 headers:
Server OS: Linux 2.6.18-6-amd64
Pre-flight check:
————————————
Site URL preference might be incorrect: mysite.fi/mysite.fi
————————————
.htaccess file contents:
————————————
#DirectoryIndex index.php index.html
#Options +FollowSymLinks
#Options -Indexes
<IfModule mod_rewrite.c> RewriteEngine On #RewriteBase /relative/web/path/
RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]
RewriteCond %{REQUEST_URI} !=/favicon.ico RewriteRule ^(.*) index.php
RewriteCond %{HTTP:Authorization} !^$
RewriteRule .* – [E=REMOTE_USER:%{HTTP:Authorization}]
</IfModule>
#php_value register_globals 0
————————————
Any ideas?
(I have replaced my domain with mysite.fi)
Offline
Re: [resolved] Warning: Unknown column 'load_order' in 'order clause' select name ...
There is a similar post here which might be of help.
Last edited by colak (2009-04-12 07:05:13)
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
#3 2009-04-12 08:20:34
- Lauski
- New Member
- Registered: 2009-02-19
- Posts: 5
Re: [resolved] Warning: Unknown column 'load_order' in 'order clause' select name ...
I can’t edit version number.
Offline
Re: [resolved] Warning: Unknown column 'load_order' in 'order clause' select name ...
Does your database user have ALTER permissions? If not, that might be the cause of your errors.
Lauski wrote:
I can’t edit version number.
Btw, ofcourse you can, as you can access your database. Either with update query or by using your favorite MySQL management tool. It’s just matter of setting version row in txp_prefs table to your previous TXP install number which makes the update script to run again.
Last edited by Gocom (2009-04-12 11:40:30)
Offline
#5 2009-05-14 19:38:11
- inspectaneck
- New Member
- Registered: 2009-05-14
- Posts: 4
Re: [resolved] Warning: Unknown column 'load_order' in 'order clause' select name ...
Lauski wrote:
I can’t edit version number.
Btw, ofcourse you can, as you can access your database. Either with update query or by using your favorite MySQL management tool. It’s just matter of settingversionrow in txp_prefs table to your previous TXP install number which makes the update script to run again.
Can you give the command line with args for doing this?
Thank you.
Last edited by inspectaneck (2009-05-14 19:42:19)
Offline
Re: [resolved] Warning: Unknown column 'load_order' in 'order clause' select name ...
In the mysql client or phpMyAdmin, execute the following:
-- add your table prefix if necessary
update txp_prefs set val='4.0.6' where name='version';Offline
#7 2009-05-15 12:59:16
- inspectaneck
- New Member
- Registered: 2009-05-14
- Posts: 4
Re: [resolved] Warning: Unknown column 'load_order' in 'order clause' select name ...
Thanks, JM.
I did that and when the script re-ran, I received several errors. Although errors are not great, it is something different… which means progress. I am talking to my host (a friend) to see about resolving this.
Offline