Page 1 of 1

SQL ERROR - Trying to add Translation

Posted: Wed Jan 30, 2019 8:04 am
by dldummy
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

Re: SQL ERROR - Trying to add Translation

Posted: Wed Mar 06, 2019 3:12 am
by Cahine
FYI, same problem with "death and nightingales" TV SHOW.

Re: SQL ERROR - Trying to add Translation

Posted: Wed Mar 27, 2019 2:55 pm
by 4sag
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