Issue Bug Closed

#18365BE anusable if table sys_language is extended (MSSQL)

Georg Ringer 03/04/08, 13:10 updated 09/09/13, 08:51

Description

If the table sys_language is extened by another field, it is not possible anymore to create pages/records in another language

it seems there is something hardcoded!

error msg from sqldebug
ERROR [Microsoft][ODBC SQL Server Driver][SQL Server]Die ‘sys_language.langkey’-Spalte ist in der Auswahlliste ung�ltig, da sie nicht in einer Aggregatfunktion und nicht in der GROUP BY-Klausel enthalten ist.
————-
#
lastBuiltQuery SELECT “sys_language”.*
#
FROM “pages_language_overlay”, “sys_language”
#
WHERE
#
“pages_language_overlay”.“sys_language_uid” = “sys_language”.“uid” AND “pages_language_overlay”.“pid” = 23
#
GROUP BY “pages_language_overlay”.“sys_language_uid”, “sys_language”.“uid”, “sys_language”.“pid”, “sys_language”.“tstamp”, “sys_language”.“hidden”, “sys_language”.“title”, “sys_language”.“static_lang_isocode”, “sys_language”.“flag”
#
ORDER BY “sys_language”.“title”
#
debug_backtrace SC_alt_doc->main // SC_alt_doc->langSelector // SC_alt_doc->languageSwitch // SC_alt_doc->getLanguages // t3lib_DB->exec_SELECTgetRows // t3lib_DB->debug

(issue imported from #M7746)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.