help.axcms.netAxinom Logo
Save Save Chapter Send Feedback
KB10025: Invalid column errors on Language Overview page
The Date and URL columns only exists for the default language and an error occurs while using another language

SYMPTOMS

On LanguageOverview.aspx this error is shown:

Invalid column name 'Date'.
Invalid column name 'Url'.

SQL:
SELECT
DL."ID" AS AxID
, DL."Date" AS Date
, DL."Url" AS Url
, L."Text" AS Text
, TL."Text" AS TranslatedText
FROM "CMS_de" DL
LEFT OUTER JOIN "CMS_de" L ON L.ID = DL.ID
LEFT OUTER JOIN "CMS_en" TL ON TL.ID = L.ID
WHERE
(L.Text IS NOT NULL AND L.Text != '')
ORDER BY
AxID ASC

Connection:
SERVER=(local);DATABASE=AxCMS_Sample;UID=AxinomCMS;PWD=XXXXXX
Current Table config
Column_name Type Computed
------------------------------
ID int (4)
Text nvarchar (7000)
Page nvarchar(200)
Position nvarchar(200)

CAUSE

The fields Date and URL only exists for the default language (“ax”), but the configuration file has some other language in the DefaultLanguage key.

SOLUTION

Change the DefaultLanguage key back to “ax” in the ResourceManager sections in web.config.

APPLIES TO

AxCMS.net versions: All versions