Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#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

#2 2009-04-12 07:04:36

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,090
Website GitHub Mastodon Twitter

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

#4 2009-04-12 11:40:01

Gocom
Developer Emeritus
From: Helsinki, Finland
Registered: 2006-07-14
Posts: 4,533
Website

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 setting version row 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

#6 2009-05-14 20:19:27

jm
Plugin Author
From: Missoula, MT
Registered: 2005-11-27
Posts: 1,746
Website

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

Board footer

Powered by FluxBB