[Typo3] Mysql error with static_languages table

[Christian Buelter]

Hi,

a late answer, but I just had a similiar problem.

You should update the extension to the newest version, then you get that 
column.

Christian

Marko Rosic schrieb:
> Clicking on a website language record I get the following error. When I
> click a news translation record I get the similar one. I've checked the
> table static_languages and run the error check and everything seems to be
> ok. What could be the problem then?
> 
> 
> caller  t3lib_DB::exec_SELECTquery
> ERROR   Unknown column 'lg_country_iso_2' in 'field list'
> lastBuiltQuery  SELECT uid, lg_iso_2, lg_name_en, lg_country_iso_2
> FROM static_languages
> WHERE
> 1=1
> ORDER BY lg_name_en
> debug_backtrace N/A
> 
> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result
> resource
> in /var/www/html/sukobinteresa/typo3_src-3.8.0/t3lib/class.t3lib_db.php on
> line 741
> caller  t3lib_DB::exec_SELECTquery
> ERROR   Unknown column 'lg_collate_locale' in 'field list'
> lastBuiltQuery  SELECT lg_collate_locale
> FROM static_languages
> WHERE
> lg_typo3="default"
> debug_backtrace N/A
> 
> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result
> resource
> in /var/www/html/sukobinteresa/typo3_src-3.8.0/t3lib/class.t3lib_db.php on
> line 741
> caller  t3lib_DB::exec_SELECTquery
> ERROR   Unknown column 'static_languages.lg_country_iso_2' in 'field list'
> lastBuiltQuery  SELECT
> static_languages.uid,static_languages.lg_name_en,static_languages.lg_iso_2,static_languages.lg_country_iso_2
> FROM static_languages,tx_staticinfotables_hotlist
> WHERE
> static_languages.uid=tx_staticinfotables_hotlist.uid_local AND
> tx_staticinfotables_hotlist.application="BE"
> ORDER BY tx_staticinfotables_hotlist.sorting DESC
> LIMIT 8
> debug_backtrace N/A
> 
> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result
> resource
> in /var/www/html/sukobinteresa/typo3_src-3.8.0/t3lib/class.t3lib_db.php on
> line 741
> caller  t3lib_DB::exec_SELECTquery
> ERROR   Unknown column 'lg_collate_locale' in 'field list'
> lastBuiltQuery  SELECT lg_collate_locale
> FROM static_languages
> WHERE
> lg_typo3="default"
> debug_backtrace N/A
> 
> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result
> resource
> in /var/www/html/sukobinteresa/typo3_src-3.8.0/t3lib/class.t3lib_db.php on
> line 741