Textpattern CMS

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

hiram001

Member

Registered: 2007-01-24

Posts: 10

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

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…

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

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

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

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)

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

hiram001

Member

Registered: 2007-01-24

Posts: 10

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

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’”.

#16 2007-01-27 14:16:36

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

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

That’s odd – you sure you were trying to backup the correct database? I ask because “mysql” is a database internally used by MySQL.

#17 2007-01-27 14:20:16

hiram001

Member

Registered: 2007-01-24

Posts: 10

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

To do the backup, I went to webmin, and clicked (what I take to be) the appropriate buttons. Mystery upon mystery…

#18 2007-01-27 14:23:19

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

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

Oh dear. If I were you, I would go to the TextDrive forum or post a support ticket to TextDrive to get that problem resolved before you go any further.

#19 2007-01-27 14:34:19

hiram001

Member

Registered: 2007-01-24

Posts: 10

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

Thanks for your help so far, Mary, I will do just that.