Support community for TTG plugins and products.
NOTICE
The Turning Gate's Community has moved to a new home, at https://discourse.theturninggate.net.
This forum is now closed, and exists here as a read-only archive.
You are not logged in.
Pages: 1
By clicking 'DE' or 'EN' in the top pallet, visitors to my Website were able to change between a text in German and in English. Somewhow this doesn't work anymore. By clicking 'EN' this message appears:
Expected one or zero rows from SQL query, multiple rows returned. sql: 'SELECT id FROM language WHERE iso_language_code=?' params: array ( 0 => 'en', )|#0 /mnt/web423/a1/83/51686383/htdocs/backlight/modules/module-framework/dao/PdoExtended.php(221): PdoExtended->_throwSqlQueryException('SELECT id FROM ...', Array, 'Expected one or...') #1 /mnt/web423/a1/83/51686383/htdocs/backlight/modules/module-framework/dao/PdoExtended.php(319): PdoExtended->selectRowOrNull('SELECT id FROM ...', Array) #2 /mnt/web423/a1/83/51686383/htdocs/backlight/modules/module-framework/Framework.php(466): PdoExtended->selectFieldOrNull('SELECT id FROM ...', Array) #3 /mnt/web423/a1/83/51686383/htdocs/backlight/modules/module-framework/Framework.php(444): Framework->handleLanguage(Object(DesignerApplicationHelper), Object(DesignerConfigManager)) #4 /mnt/web423/a1/83/51686383/htdocs/backlight/modules/module-framework/Framework.php(151): Framework->initApplication() #5 /mnt/web423/a1/83/51686383/htdocs/backlight/modules/module-framework/Framework.php(41): Framework->init() #6 /mnt/web423/a1/83/51686383/htdocs/index.php(37): Framework->__construct('.', Array) #7 {main}|URL: /index.php
This far surpasses my abilities in coding and I Need your help.
Thanks and best regards
Eckart
Offline
Can you post a link to the site?
Rod
Just a user with way too much time on his hands.
www.rodbarbee.com
ttg-tips.com, Backlight 2/3 test site
Offline
Offline
Thanks, that will give Ben more to work with
Rod
Just a user with way too much time on his hands.
www.rodbarbee.com
ttg-tips.com, Backlight 2/3 test site
Offline
That looks like somehow your site has two languages with ‘DE’ as the code. Can you please email me a Backlight admin login so that I can look into this and clean up any potential issue in the database?
Offline
Hi Eckart, thanks for the access. I found you had three languages with the following ISO Language Codes:
English - en
German - en
Deutsch - de
I assume that "German - en" is redundant. For now I've changed the code to 'fr' just so that the error goes away. Can you go into your Backlight and delete that language if it's not needed, or otherwise edit the German and Deutsch languages so that the ISO Language Codes don't clash?
Offline
Thanks a lot, Ben. It is working now. As you recommended, I tried to delete the third language, but I did not find a way to delete a lanuage. Apparently, you can only add a language.
Regards
Eckart
Offline
In Languages, click on the name of the language. One of the options shown will be Delete
Rod
Just a user with way too much time on his hands.
www.rodbarbee.com
ttg-tips.com, Backlight 2/3 test site
Offline
Dear Rod,
I thought I had tried everything to delete the third language. Somehow, I must have missed this obvious solution. You probably thought: Another one of these dumb user. Well - sorry!
Thanks for your help and best regards
Eckart
Offline
Actually, it took me a little while to find it too!
Rod
Just a user with way too much time on his hands.
www.rodbarbee.com
ttg-tips.com, Backlight 2/3 test site
Offline
In Languages - Manage Language.
Then on top left in the breadcrumps - US English - (or other)
Then you can delete the language.
Rainer
Last edited by Rainer Goergen (2020-04-03 22:31:28)
Offline
Pages: 1