Problems with Language Dropdown in Admin/Preferences

jonimueller · 2008-01-06 09:48:58

I just installed the latest stable version of TXP on a testbed. I haven’t used TXP since it was RC only. :-)

I am interested in it because of specific language packs (latin and cyrillic serbian to be specific).

However, when I try to install those language packs (or any others), the only one that “sticks” is danish. It’s the only language in the dropdown. And if I click it, my site turns danish. The only way to correct that (to get US English back) is to edit the database. I have attached a screen shot showing the language packs present and presumably “updated”. I have the *.txt files in the /lang folder. Yet, as you can see from the screenshot, danish is the only language that appears in the dropdown. Any thoughts?

Screendump

Thanks!

Last edited by jonimueller (2008-01-06 09:50:53)

wet · 2008-01-06 16:07:00

Please issue these two SQL queries and report back:

#1

SELECT `lang`
FROM txp_lang
WHERE 1 =1
GROUP BY `lang`

#2

SELECT `lang`,`name`, `data`
FROM txp_lang
WHERE `name`
IN (
SELECT DISTINCT `lang`
FROM txp_lang
)

jonimueller · 2008-01-06 22:55:51

It kept telling me I had to select a column. I don’t know what that means.

Also, I noticed when I selected the LANG table, I see this error message:
UNIQUE and INDEX keys should not both be set for column `lang`

Okay now that answers the first question. I guess it means I need to select a table before performing those queries? And presumably that would be the LANG table?

Oh, I see the problem. I have a different table prefix. I’ll change your query appropriately and then it should work fine. :)

Last edited by jonimueller (2008-01-06 22:56:31)

jonimueller · 2008-01-06 22:59:45

It says this. I don’t know what it is asking for.

“You have to choose at least one column to display”

wet · 2008-01-07 05:32:54

My query assumed no prefix at all. If the prefix for your site is foo, replace txp_lang with footxp_lang.

jonimueller · 2008-01-07 08:18:51

I did that and it still asks for column selections. I don’t know what it wants. I’m not experienced doing much past editing table data there. But I did have enough snap to figure out about the table prefix and I came up with the same error message regardless. :-(

Mary · 2008-01-11 04:28:42

Where are you trying to run the query from? phpMyAdmin? Commandline?

Try running the following query, and re-install the languages you want:

TRUNCATE txp_lang;

jonimueller · 2008-01-11 06:23:25

Thanks, Mary. I’ve been using PHPMyAdmin and it wants some additional information in a series of dropdown boxes at the top. I’ve attached a screendump of the error message and the Query area here:

Screendump of Error Message in PHPMyAdmin

Thanks for any advice.

Joni

Last edited by jonimueller (2008-01-11 06:25:37)

iblastoff · 2008-01-11 06:43:36

you’re using the wrong tab. use ‘sql’ not the ‘query’ tab (as the latter is meant for you to fill it out like a form)

jonimueller · 2008-01-11 07:10:52

Thanks, Steve. That helped. I was able to run the query TRUNCATE txp_lang; (in my case TRUNCATE maintxp_lang;) and I now at least have English (US) in the dropdown. I go thru the motions of installing those other two language packs (Serbian-Latin and Serbian-Cyrillic) and it shows them updated, but they do not appear in the dropdown for me to choose them, but I am content for the moment having English there. :)

Mary · 2008-01-12 07:23:49

~~Oooo, I think I know why. Lemme check on this.~~

Nope that wasn’t it.

Last edited by Mary (2008-01-25 22:27:51)

Textpattern CMS

Textpattern CMS support forum

#1 2008-01-06 09:48:58

Problems with Language Dropdown in Admin/Preferences

#2 2008-01-06 16:07:00

Re: Problems with Language Dropdown in Admin/Preferences

#3 2008-01-06 22:55:51

Re: Problems with Language Dropdown in Admin/Preferences

#4 2008-01-06 22:59:45

Re: Problems with Language Dropdown in Admin/Preferences

#5 2008-01-07 05:32:54

Re: Problems with Language Dropdown in Admin/Preferences

#6 2008-01-07 08:18:51

Re: Problems with Language Dropdown in Admin/Preferences

#7 2008-01-11 04:28:42

Re: Problems with Language Dropdown in Admin/Preferences

#8 2008-01-11 06:23:25

Re: Problems with Language Dropdown in Admin/Preferences

#9 2008-01-11 06:43:36

Re: Problems with Language Dropdown in Admin/Preferences

#10 2008-01-11 07:10:52

Re: Problems with Language Dropdown in Admin/Preferences

#11 2008-01-12 07:23:49

Re: Problems with Language Dropdown in Admin/Preferences

Board footer