Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2007-01-24 13:50:57
- hiram001
- Member
- Registered: 2007-01-24
- Posts: 10
... get rid of error messages no-one else seems to see?
After updating to 4.0.4, every admin page has two error messages at the top, saying:
Warning: Unknown column ‘name’ in ‘field list’ select name from txp_lang where lang=‘nl-nl’ limit 1 in /users/home/CENSORED/textpattern/lib/txplib_db.php on line 84
Warning: Unknown column ‘name’ in ‘field list’ select name, data from txp_lang where lang=‘en-gb’ in /users/home/CENSORED/textpattern/lib/txplib_db.php on line 84
(where CENSORED is actually something else, of course).
When I open the language preferences tab, this kind of error message fills a page meters long, on all other admin pages it’s just the two lines. The public web site itself loads and works just fine.
Can anyone tell me how to get rid of this? Nobody else seems to see these error messages.
Thanks.
Hiram (the same, from the Netherlands; my original login no longer works)
Last edited by hiram001 (2007-01-24 13:52:33)
Offline
#2 2007-01-24 14:49:24
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: ... get rid of error messages no-one else seems to see?
Please post your “High” diagnostics.
Offline
#3 2007-01-24 15:05:00
- hiram001
- Member
- Registered: 2007-01-24
- Posts: 10
Re: ... get rid of error messages no-one else seems to see?
Textpattern version: 4.0.4 (r1956)
last_update: 2007-01-24 13:27:40/2007-01-24 13:20:37
Document root: /users/home/hiram/public_html
$path_to_site: /users/home/hiram/public_html/ipsedixit
Textpattern path: /users/home/hiram/public_html/ipsedixit/textpattern
Permanent link mode: section_id_title
upload_tmp_dir: /usr/local/www/php/tmp
Temp folder: /users/home/hiram/public_html/ipsedixit/textpattern/tmp
Site URL: www.hiram.nl/ipsedixit
PHP version: 5.1.4
Server time: 2007-01-24 15:03:13
MySQL: 4.1.21-log
Locale: en_GB
Server: Apache
PHP mode: cgi-fcgi
rfc2616_headers:
Operating System: FreeBSD 5.5-STABLE
active_plugins: wlk_qt-0.75m, jnm_audio-0.2m, rei_recent_comments-0.3m, tru_tags-1.9m, rss_admin_show_adv_opts-0.3, asy_jpcache-0.9.8
.htaccess file contents:
————————————
#DirectoryIndex index.php index.html
#Options +FollowSymLinks
#RewriteBase /relative/web/path/
<IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]
RewriteRule ^(.*) index.php </IfModule>#php_value register_globals 0
————————————
Charset (default/config): latin1/
character_set_client: latin1
character_set_connection: latin1
character_set_database: latin1
character_set_results: latin1
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /usr/local/share/mysql/charsets/
26 Tables: OK
PHP extensions: standard/5.1.4, SPL, Reflection, date/5.1.4, libxml, ncurses, bz2, imap, ctype, zlib/1.1, mbstring, xml, PDO, openssl, session, pdo_sqlite/1.0.1, SimpleXML, shmop, bcmath, tokenizer/0.1, iconv, fileinfo/0.1, mysqli/0.1, ftp, dom/20031129, readline, xmlwriter/0.1, sockets, mhash, exif/1.4 $Id: exif.c,v 1.173.2.5 2006/04/10 18:23:24 helly Exp $, SQLite, xmlreader/0.1, gmp, pdo_mysql/1.0.2, pcre, mcrypt, pcntl, xsl/0.1, gettext, posix, calendar, pgsql, soap, gd, curl, mysql/1.0, Zend Optimizer
pretext_data: array (
‘id’ => ‘’,
‘s’ => ‘’,
‘c’ => ‘’,
‘q’ => ‘’,
‘pg’ => ‘’,
‘p’ => ‘’,
‘month’ => ‘’,
‘author’ => ‘’,
‘request_uri’ => ‘/ipsedixit/4db4ff28c57d4570496162c045f97550/?txpcleantest=1’,
‘qs’ => ‘txpcleantest=1’,
‘subpath’ => ‘\\/ipsedixit\\/’,
‘req’ => ‘/4db4ff28c57d4570496162c045f97550/?txpcleantest=1’,
)
/include/txp_category.php: r1879 (aee777474b2f67ca07fc25756ba25c15)
/include/txp_plugin.php: r1917 (74184c0d8ed8608f840707a255178617)
/include/txp_auth.php: r1879 (b1dd4072b7daf4e997c6ff65ce3d1b2d)
/include/txp_form.php: r1913 (16ec600b41438b4cca10d2c8a19b2db8)
/include/txp_section.php: r1891 (2959593586ba3e97bc602f369c32e738)
/include/txp_tag.php: r1915 (3b4a7f73d92f9bbbe09985c5aa830d29)
/include/txp_list.php: r1892 (41f4d32fd070234b78f94adefebd5234)
/include/txp_page.php: r1913 (34331a5468bbb18dd9f6a282f3aa11e8)
/include/txp_discuss.php: r1909 (9b9ee934a30f52cd7a4d8cb45c8380ab)
/include/txp_prefs.php: r1946 (05615b6275d8927a2a0d51918d70a896)
/include/txp_log.php: r1919 (ed54d02e865319f2506c642a6bde768b)
/include/txp_preview.php: r1238 (5a4ae3ff0d68f4cb573d6d62a00ce9e8)
/include/txp_image.php: r1955 (20be975e67fa7c4aa9a1a3e51bfaf379)
/include/txp_article.php: r1889 (7749f699c03d0c57e04fafe17dbfa94c)
/include/txp_css.php: r1897 (f5cf1c20badb96a063c7c180e9020359)
/include/txp_admin.php: r1879 (d36dac010d21df7bcf9cf5e242b34d58)
/include/txp_link.php: r1879 (0652287df8bb32c66cfa1b939402404a)
/include/txp_diag.php: r1902 (96697ade63048e517177f4129d47de76)
/include/txp_file.php: r1895 (6ed67b094522e51b028dc88baa07444c)
/include/txp_import.php: r1238 (634e75d1b61958875ff275e3130f23ad)
/lib/admin_config.php: r1747 (1563fcbaffe25b3272b0d85ff9d5571d)
/lib/txplib_misc.php: r1956 (182c50b86195f1abe9dbe15728df3cae)
/lib/taglib.php: r1535 (04806ef864d5b0d2974e0e5f6397a2d7)
/lib/txplib_head.php: r1887 (b110efd071e9a5bb395beea66ced128a)
/lib/classTextile.php: r1943 (2c559991e34738eef1990dc079bd91c4)
/lib/txplib_html.php: r1937 (c206ca9cb9a54a7a95f3355b77fd0fa2)
/lib/txplib_db.php: r1879 (d68b6ea69950e405c4fec23b8641d9c2)
/lib/IXRClass.php: r765 (cbe59b59246dce060a4b4a52b4d448d8)
/lib/txplib_forms.php: r1887 (0049a228dc8eb346f8603478a7c1b2e2)
/lib/class.thumb.php: r1955 (12961180eee3add5096e69e0a154284e)
/lib/constants.php: unknown (0e40251c717c52b2b7fe992b62a3e97a)
/lib/txplib_update.php: r1239 (757f8189fcc53a795d7c807f17b2e788)
/lib/txplib_wrapper.php: unknown (584448787b4a3488200722672c0eee0d)
/publish/taghandlers.php: r1949 (3fa1b9ded18e6074b2495a3f4e3c33b5)
/publish/atom.php: r1864 (50602e2f1c443819a0a60f14f39d3093)
/publish/log.php: r1637 (a4a772567079f18101a1752446f3f6d4)
/publish/comment.php: r1951 (a3f803d744fea80808eb27a3f6b28674)
/publish/search.php: r1748 (b0182abc287055fe0932c263b2a5266d)
/publish/rss.php: r1864 (ae43eaa9ebe6b00e63810ae60ca7c6b6)
/publish.php: r1945 (abff727405efc6c4ec8b1cb403290063)
/index.php: r1948 (adf86f44861797f4969373c708ef48fb)
/css.php: r944 (763fa7658fc19ad23a5b2126fcdf366c)
Offline
#4 2007-01-24 15:45:12
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: ... get rid of error messages no-one else seems to see?
Well your lang table isn’t corrupted but something has definitely tampered with it.
Do you have phpMyAdmin or similar program available to you?
Offline
#5 2007-01-24 19:02:20
- hiram001
- Member
- Registered: 2007-01-24
- Posts: 10
Re: ... get rid of error messages no-one else seems to see?
No, but I can download it, of course. Much obliged if you can tell me how to proceed.
Offline
#6 2007-01-25 17:35:18
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: ... get rid of error messages no-one else seems to see?
Typically a webhost will provide some sort of program to manage your databases with, are you sure you don’t have one via a control panel or something?
If not, the simplest route to try first would be to install this Textpattern plugin.
Offline
#7 2007-01-25 18:36:43
- hiram001
- Member
- Registered: 2007-01-24
- Posts: 10
Re: ... get rid of error messages no-one else seems to see?
Oh, of course. I’m on Textdrive. So what do I do?
Offline
#8 2007-01-25 18:46:15
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: ... get rid of error messages no-one else seems to see?
Okay, login to phpMyAdmin, go to your Textpattern database, and take a look at your txp_lang table’s structure. Here are the fields that should be there:
id int(9) lang varchar(16) name varchar(64) event varchar(64) data tinytext lastmod timestamp
It sounds like the “name” column is missing, can you confirm that?
Offline
#9 2007-01-25 19:45:41
- hiram001
- Member
- Registered: 2007-01-24
- Posts: 10
Re: ... get rid of error messages no-one else seems to see?
I’ll be daft, no doubt, but I can’t find phpMyAdmin on the webmin pages of my Textdrive account. I can see txp_lang in the Edit database window, and when I open it, there are two columns: fieldname var, type varchar(64) and fieldname English, type text. That’s all. Should I look somewhere else?
Offline
#10 2007-01-25 21:14:44
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: ... get rid of error messages no-one else seems to see?
When you signed up at TextDrive, they would have sent you an email with all your details, one of which would be the url to your phpMyAdmin (and you login with your webmin username and password). The url is likely something like https://mysql.yourservername.textdrive.com/ (that’s where mine is).
Offline
#11 2007-01-25 22:39:38
- hiram001
- Member
- Registered: 2007-01-24
- Posts: 10
Re: ... get rid of error messages no-one else seems to see?
Okay, I got in, and there are two rows, no more, just var and english. No id, lang, name, event, data or lastmod.
There are two indexes also, primary and var, and there is a warning saying “PRIMARY and INDEX keys should not both be set for column `var`” Does this tell you anything?
Last edited by hiram001 (2007-01-25 22:40:22)
Offline
#12 2007-01-25 23:33:45
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: ... get rid of error messages no-one else seems to see?
Are there columns named id, lang, name, event, data and lastmod?
If not it means your database has been altered or corrupted somehow. You’ll need to restore a backup or manually create the columns listed in Mary’s post.
Alex
Offline