... get rid of error messages no-one else seems to see?

hiram001 · 2007-01-24 13:50:57

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)

Mary · 2007-01-24 14:49:24

Please post your “High” diagnostics.

hiram001 · 2007-01-24 15:05:00

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)

Mary · 2007-01-24 15:45:12

Well your lang table isn’t corrupted but something has definitely tampered with it.

Do you have phpMyAdmin or similar program available to you?

hiram001 · 2007-01-24 19:02:20

No, but I can download it, of course. Much obliged if you can tell me how to proceed.

Mary · 2007-01-25 17:35:18

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.

hiram001 · 2007-01-25 18:36:43

Oh, of course. I’m on Textdrive. So what do I do?

Mary · 2007-01-25 18:46:15

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?

hiram001 · 2007-01-25 19:45:41

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?

Mary · 2007-01-25 21:14:44

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).

hiram001 · 2007-01-25 22:39:38

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)

zem · 2007-01-25 23:33:45

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.

hiram001 · 2007-01-25 23:52:10

As I wrote: no id, lang, name, event, data or lastmod. Just var and english.

Is it really necessary to restore a backup? All the content is appearing on my web site just fine. It’s just the error messages appearing on top of the admin pages that I’d like to get rid of. So when I manually create the missing columns, will my content be safe? And is creating columns straightforward? Questions, questions…

Mary · 2007-01-26 21:59:26

You don’t need to restore from backup, just use phpMyAdmin to follow these steps:

1. Make a new backup of your Txp database. This step is important.

2. If you look at the top line of tabs for the txp_lang table, one of which is “Empty”. Click it.

3. Underneath the listing of fields, you should see a line like this:

Add [] field(s) [] At End of Table [] At Beginning of Table…

Make yours look like:

Add [6] fields()… [x] At Beginning of Table…

and click the “Go” button.

4. Create your fields…

|Field   |Type     | Length/Values  |Attributes                 |Null    |Default          |Extra         |Primary Key*|
==
|id      |INT      |9               |                           |not null|                 |auto_increment|X           |
|lang    |VARCHAR  |16              |                           |not null|                 |              |            |
|name    |VARCHAR  |64              |                           |not null|                 |              |            |
|event   |VARCHAR  |64              |                           |not null|                 |              |            |
|data    |TINYTEXT |                |                           |null    |NULL             |              |            |
|lastmod |TIMESTAMP|                |ON UPDATE CURRENT_TIMESTAMP|not null|CURRENT_TIMESTAMP|              |            |

* checkbox with a little “key” icon

…and click “Save”

5. Now looking at the txp_lang table’s structure again, check the fields “var” and “english” and click on the “X” icon underneath the table.

6. Login to the Txp admin, and go to the Language admin preference page. Click the links for each language you want installed.

You should be good to go.

Last edited by Mary (2007-01-26 22:05:21)

hiram001 · 2007-01-27 11:29:14

Hi Mary,
thanks for your patience! You’re going to need a bit more of that… I got stuck at step 1 with an error saying: “SQL show character set failed : Access denied for user ‘hiram’@‘localhost’ to database ‘mysql’”.

Textpattern CMS

Textpattern CMS support forum

#1 2007-01-24 13:50:57

... get rid of error messages no-one else seems to see?

#2 2007-01-24 14:49:24

Re: ... get rid of error messages no-one else seems to see?

#3 2007-01-24 15:05:00

Re: ... get rid of error messages no-one else seems to see?

#4 2007-01-24 15:45:12

Re: ... get rid of error messages no-one else seems to see?

#5 2007-01-24 19:02:20

Re: ... get rid of error messages no-one else seems to see?

#6 2007-01-25 17:35:18

Re: ... get rid of error messages no-one else seems to see?

#7 2007-01-25 18:36:43

Re: ... get rid of error messages no-one else seems to see?

#8 2007-01-25 18:46:15

Re: ... get rid of error messages no-one else seems to see?

#9 2007-01-25 19:45:41

Re: ... get rid of error messages no-one else seems to see?

#10 2007-01-25 21:14:44

Re: ... get rid of error messages no-one else seems to see?

#11 2007-01-25 22:39:38

Re: ... get rid of error messages no-one else seems to see?

#12 2007-01-25 23:33:45

Re: ... get rid of error messages no-one else seems to see?

#13 2007-01-25 23:52:10

Re: ... get rid of error messages no-one else seems to see?

#14 2007-01-26 21:59:26

Re: ... get rid of error messages no-one else seems to see?

#15 2007-01-27 11:29:14

Re: ... get rid of error messages no-one else seems to see?

Board footer