Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2009-02-23 07:02:14

vinref
New Member
Registered: 2008-12-31
Posts: 6

[resolved] [Solved] Warning: Unknown column 'load_order' in 'order clause' select

Hello

I am getting this error on the top of every page when I am logged in.

Here is the complete message on top of the first page when I log in:

Warning: Unknown column ‘load_order’ in ‘order clause’ select name, code, version from txp_plugin where status = 1 AND type IN (1,3) order by load_order in /home/vinref/Web/textpattern-4.0.8/textpattern/lib/txplib_db.php on line 82

Another error message pops up when I write a test article and publish it:
Warning: Unknown column ‘Expires’ in ‘field list’ insert into textpattern set Title = ‘This is a test’, Body = ‘This is a test This is a test This is a test …[lots of the same]…This is a test in /home/vinref/Web/textpattern-4.0.8/textpattern/lib/txplib_db.php on line 82

All the errors refer to “textpattern/lib/txplib_db.php on line 82”. I have made this file executable, as are all .php files.

Your help is appreciated.

Thanks, Vince

Here is the complete diagnostic:

Textpattern version: 4.0.8 (r3085)
Last Update: 2009-02-22 13:02:56/2009-01-23 19:20:55
Document root: /home/vinref/Web/textpattern-4.0.8/textpattern
$path_to_site: /home/vinref/Web/textpattern-4.0.8
Textpattern path: /home/vinref/Web/textpattern-4.0.8/textpattern
Permanent link mode: section_id_title
upload_tmp_dir: /tmp
Temporary directory path: /var/tmp
Site URL: textpattern
PHP version: 5.2.8
GD Image Library: unavailable
Server Local Time: 2009-02-23 17:57:42
MySQL: 5.0.67
Locale: C
Server: Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.8e DAV/2 PHP/5.2.8
Apache version: Apache/2.0.63 (Unix) mod_ssl/2.0.63 OpenSSL/0.9.8e DAV/2 PHP/5.2.8
PHP Server API: apache2handler
RFC 2616 headers:
Server OS: NetBSD 4.0.1_PATCH

Pre-flight check:
————————————
Clean URL test failed.
————————————

.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

————————————

Charset (default/config): latin1/utf8
character_set_client: utf8
character_set_connection: utf8
character_set_database: latin1
character_set_filesystem: binary
character_set_results: utf8
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /usr/pkg/share/mysql/charsets/
17 Tables: OK

PHP extensions: xmlwriter/0.1, libxml, xmlreader/0.1, xml, tokenizer/0.1, session, pcre, SimpleXML/0.1, SPL/0.2, standard/5.2.8, Reflection/0.1, hash/1.0, filter/0.11.0, date/5.2.8, ctype, openssl, apache2handler, mysql/1.0, mbstring, mysqli/0.1, xmlrpc/0.51, zlib/1.1

Apache modules: core, mod_access, mod_auth, mod_auth_anon, mod_auth_dbm, mod_auth_digest, mod_ext_filter, mod_include, mod_deflate, mod_log_config, mod_log_forensic, mod_env, mod_mime_magic, mod_cern_meta, mod_expires, mod_headers, mod_usertrack, mod_unique_id, mod_setenvif, mod_version, mod_proxy, proxy_connect, proxy_ftp, proxy_http, mod_ssl, prefork, http_core, mod_mime, mod_dav, mod_status, mod_autoindex, mod_asis, mod_info, mod_cgi, mod_dav_fs, mod_vhost_alias, mod_negotiation, mod_dir, mod_imap, mod_actions, mod_speling, mod_userdir, mod_alias, mod_rewrite, mod_so, mod_php5

/home/vinref/Web/textpattern-4.0.8/index.php: r2885 (b2215d9fc23dc9aa88c92cdb7e4627f2)
/home/vinref/Web/textpattern-4.0.8/textpattern/css.php: r2772 (2a3cef700a253208e1140acfb27b7895)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_admin.php: r3013 (4f25d38445705e8135eafb47fe69c5e6)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_article.php: r3040 (d5e4b175b1f7eec4ca73a0362b943185)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_auth.php: r2856 (c6e17d38408910606b38ea6fbb8e97a8)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_category.php: r3072 (38cb7ab1fca56ec11e66bc7fcb4dcf1d)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_css.php: r3081 (4a0fc4c539e86aef5eb061d6bbaca5ac)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_diag.php: r3060 (0116e33dc27867bc7004f788da2fc610)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_discuss.php: r3071 (9b53af05cd0c1baa8fc99c07c99d3640)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_file.php: r3069 (0dfc75eaa35e524313a40812dfa82886)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_form.php: r3069 (3edf3408cd05fe8e82137735b1bce5c7)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_image.php: r3069 (4c9b3db31c3df354b9055725e9fb2091)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_import.php: r2812 (4401e213b8b68af2001734ac67b85f51)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_link.php: r3069 (0fffe5a42a06327c15064d54ddd5f478)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_list.php: r3069 (256b992e07a9d67acb4334b57fe64cd3)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_log.php: r3003 (942e39aade8d8ccf4232bfc46c6c9902)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_page.php: r3056 (d6aa9f8ad7605fbba705c96710cc1802)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_plugin.php: r3052 (dcd7dc1e43b1479965378dbb802d52e1)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_prefs.php: r2965 (55a6d6e2fa6994e16566c6e1b19d2e1d)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_preview.php: r1238 (c3e3678d655eb19ece72af65b763fd1b)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_section.php: r3072 (0034cc064a65b78900e164d118a0ef8b)
/home/vinref/Web/textpattern-4.0.8/textpattern/include/txp_tag.php: r2868 (3ac47c5e472b54b5bc27909581120167)
/home/vinref/Web/textpattern-4.0.8/textpattern/index.php: r3085 (d65f4b0d862d74000e2bcc37260c706f)
/home/vinref/Web/textpattern-4.0.8/textpattern/lib/IXRClass.php: r2932 (a14c1fa6441a4faf1d097d397bf61841)
/home/vinref/Web/textpattern-4.0.8/textpattern/lib/admin_config.php: r2812 (b4bb30f62aab58b164ea6c3e6c786b9c)
/home/vinref/Web/textpattern-4.0.8/textpattern/lib/class.thumb.php: r3041 (45ed990e57ba5daebe11f274b32626c6)
/home/vinref/Web/textpattern-4.0.8/textpattern/lib/classTextile.php: r2812 (76416becc5a4789efbc543c4681041c3)
/home/vinref/Web/textpattern-4.0.8/textpattern/lib/constants.php: r3038 (f87766c302fa9275024a06b2351a2411)
/home/vinref/Web/textpattern-4.0.8/textpattern/lib/taglib.php: r2868 (b804c3222d47e5b24c16bd3731b5eac9)
/home/vinref/Web/textpattern-4.0.8/textpattern/lib/txplib_admin.php: r3047 (4adad7711c24f49ecd26b24d80d27884)
/home/vinref/Web/textpattern-4.0.8/textpattern/lib/txplib_db.php: r3029 (ae35ec3566cfab83178eb0bb6cc6adf5)
/home/vinref/Web/textpattern-4.0.8/textpattern/lib/txplib_forms.php: r3079 (79a5b4411412a41feb64fea544ef1eb2)
/home/vinref/Web/textpattern-4.0.8/textpattern/lib/txplib_head.php: r3004 (813dd318366c7f823e5c1202e253c7e9)
/home/vinref/Web/textpattern-4.0.8/textpattern/lib/txplib_html.php: r2981 (1b048fdbe1f6fec8f052274c2b2c0736)
/home/vinref/Web/textpattern-4.0.8/textpattern/lib/txplib_misc.php: r3074 (804959a9253b0ad9b472ca8d55965382)
/home/vinref/Web/textpattern-4.0.8/textpattern/lib/txplib_update.php: r2812 (31a52cb8894ab8d0c81c9c8905d8ab60)
/home/vinref/Web/textpattern-4.0.8/textpattern/lib/txplib_wrapper.php: r2931 (81f3780d9972c5fadd478a13a7204d2a)
/home/vinref/Web/textpattern-4.0.8/textpattern/publish.php: r3050 (8c4ad513ead711cf336d17fb7605ce63)
/home/vinref/Web/textpattern-4.0.8/textpattern/publish/atom.php: r3029 (2b7568a730855c05eb275125069c17cb)
/home/vinref/Web/textpattern-4.0.8/textpattern/publish/comment.php: r3011 (18ab83ecddef7499afdb3ff399973113)
/home/vinref/Web/textpattern-4.0.8/textpattern/publish/log.php: r2937 (40cfffaca8aa34c71ab0ad7434a95767)
/home/vinref/Web/textpattern-4.0.8/textpattern/publish/rss.php: r3029 (240cef01dd4aa72d32ebf05baa56ccfe)
/home/vinref/Web/textpattern-4.0.8/textpattern/publish/search.php: r2812 (e5b4f62da431aec72118414ed2bcd2a2)
/home/vinref/Web/textpattern-4.0.8/textpattern/publish/taghandlers.php: r3078 (bfb48cb4ffff860c7b2fc7f635988ec5)
/home/vinref/Web/textpattern-4.0.8/rpc/index.php: r2998 (d7b0e58e0dac47472401982f2953a5a4)
/home/vinref/Web/textpattern-4.0.8/rpc/TXP_RPCServer.php: r2998 (95942b5917b4d45d6c0e48d1deb53154)
/home/vinref/Web/textpattern-4.0.8/textpattern/update/_to_1.0.0.php: r3047 (f12fd6e63f344f1802c1f17f854b2ad7)
/home/vinref/Web/textpattern-4.0.8/textpattern/update/_to_4.0.2.php: r3047 (cdd0e5fe346c0702eb414f42f9cfbcc6)
/home/vinref/Web/textpattern-4.0.8/textpattern/update/_to_4.0.3.php: r3047 (ebef8def3b71b07aa01929f335b7afc6)
/home/vinref/Web/textpattern-4.0.8/textpattern/update/_to_4.0.4.php: r3047 (8fd20a90592394a65fbd9b0d6c6a388c)
/home/vinref/Web/textpattern-4.0.8/textpattern/update/_to_4.0.5.php: r2894 (6c60b97917192d4f4c4aa4ee377b6329)
/home/vinref/Web/textpattern-4.0.8/textpattern/update/_to_4.0.6.php: r3047 (d2f218d57ba0faf018df88825c225e68)
/home/vinref/Web/textpattern-4.0.8/textpattern/update/_to_4.0.7.php: r3014 (507a199ad584314f9131152eac028433)
/home/vinref/Web/textpattern-4.0.8/textpattern/update/_to_4.0.8.php: r3057 (836b291ed122ced3759b5909c7d442d4)
/home/vinref/Web/textpattern-4.0.8/textpattern/update/_update.php: r3085 (c9332d78f697754fab18fae5cfea481f)

Last edited by els (2012-05-16 19:36:47)

Offline

#2 2009-02-23 14:00:41

vinref
New Member
Registered: 2008-12-31
Posts: 6

Re: [resolved] [Solved] Warning: Unknown column 'load_order' in 'order clause' select

I should add I have granted all privileges to textpattern over the textpattern database.

Below is the virtual host directive from httpd.conf: <VirtualHost *:80> ServerAdmin vinref DocumentRoot “/home/vinref/Web/textpattern-4.0.8/textpattern” ServerName textpattern
  1. ErrorLog /var/log/httpd/dummy-host.example.com-error_log
  2. CustomLog /var/log/httpd/dummy-host.example.com-access_log common
    </VirtualHost>

Thanks again for your help in advance

Vince

Offline

#3 2009-02-23 14:17:16

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: [resolved] [Solved] Warning: Unknown column 'load_order' in 'order clause' select

If you have all permissions to the TXP database (including ALTER), try editing the txp_prefs table and change the row that contains the TXP version from 4.0.8 back to 4.0.6, then log in again on the TXP admin side to trigger the upgrade scripts.

Offline

#4 2009-02-24 12:06:14

vinref
New Member
Registered: 2008-12-31
Posts: 6

Re: [resolved] [Solved] Warning: Unknown column 'load_order' in 'order clause' select

Hello

You are a genius, ruud. It worked.

For anyone else’s information, here is how I got into difficulties and how, with ruud’s help, fixed it.

I tried to install Textpattern (v4.0.7) before but abandoned as I was too busy at the time. I removed it, but left the database intact. When I had more time, I downloaded v4.0.8 and connected it to the same database, giving the above error.

I did as ruud recommended like this:

mysql> show tables;
+-----------------------+
| Tables_in_textpattern |
+-----------------------+
| textpattern           | 
| txp_category          | 
| txp_css               | 
| txp_discuss           | 
| txp_discuss_ipban     | 
| txp_discuss_nonce     | 
| txp_file              | 
| txp_form              | 
| txp_image             | 
| txp_lang              | 
| txp_link              | 
| txp_log               | 
| txp_page              | 
| txp_plugin            | 
| txp_prefs             | 
| txp_section           | 
| txp_users             | 
+-----------------------+
17 rows in set (0.00 sec)
mysql> select * from txp_prefs where name="version";
+----------+---------+-------+------+---------+------------+----------+
| prefs_id | name    | val   | type | event   | html       | position |
+----------+---------+-------+------+---------+------------+----------+
|        1 | version | 4.0.8 |    2 | publish | text_input |        0 | 
+----------+---------+-------+------+---------+------------+----------+
1 row in set (0.00 sec)
mysql> UPDATE txp_prefs SET val="4.0.6" WHERE name="version";

This changed “4.0.8” to “4.0.6”. When I logged in as admin again, it triggered the update script back to “4.0.8”.

Thanks again ruud.

Last edited by ruud (2009-02-24 16:40:34)

Offline

#5 2009-02-24 12:06:50

vinref
New Member
Registered: 2008-12-31
Posts: 6

Re: [resolved] [Solved] Warning: Unknown column 'load_order' in 'order clause' select

Oops. The formatting did not come out as in the preview…

Offline

Board footer

Powered by FluxBB