SQL ERROR - Trying to add Translation

Discuss the new site and features.
Forum rules
Updates. Issues. Resolutions.

If you don't see it here, feel free to ask!
Please note that the new site is in its early infancy, and asking the same question will not lead to different results.
That said, a number of features will be returning as soon as the site is stable and reliable.
dldummy
Posts: 10
Joined: Mon Oct 26, 2009 5:38 pm

SQL ERROR - Trying to add Translation

Postby dldummy » Wed Jan 30, 2019 8:04 am

Eat-Man

https://www.thetvdb.com/series/eat-man

After hitting the button "Manage translations" the following error occure:

An exception occurred while executing 'SELECT *, (SELECT translation FROM translation_seriesname WHERE seriesid=? AND languageid=languages.id) AS seriesname, (SELECT translation FROM translation_seriesoverview WHERE seriesid=? AND languageid=languages.id) AS seriesoverview FROM languages ORDER BY name' with params ["87941", "87941"]: SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row

Cahine
Posts: 11
Joined: Wed Mar 08, 2017 7:14 am

Re: SQL ERROR - Trying to add Translation

Postby Cahine » Wed Mar 06, 2019 3:12 am

FYI, same problem with "death and nightingales" TV SHOW.

4sag
Posts: 1
Joined: Wed Mar 27, 2019 2:54 pm

Re: SQL ERROR - Trying to add Translation

Postby 4sag » Wed Mar 27, 2019 2:55 pm

Death and Nightingales
https://www.thetvdb.com/series/death-and-nightingales

Code: Select all

An exception occurred while executing 'SELECT *, (SELECT translation FROM translation_seriesname WHERE seriesid=? AND languageid=languages.id) AS seriesname, (SELECT translation FROM translation_seriesoverview WHERE seriesid=? AND languageid=languages.id) AS seriesoverview FROM languages ORDER BY name' with params ["348338", "348338"]: SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row