Page 1 of 1

Database error trying to edit a specific episode title

Posted: Tue Sep 25, 2018 9:21 am
by Manujito
Hi, I tried to edit an episode of Shameless, since the title was reported wrong, but it seems to be the only one that gives a database error when trying to do so.

The episode is S09E03 - https://www.thetvdb.com/series/shameles ... es/6752211

The title is wrong as you can see from the official Showtime page: http://www.sho.com/shameless/season/9#/closed

As I was saying, when I try to go into "manage translations" to edit the title, all I get is a white page with this error:

Code: Select all

An exception occurred while executing 'SELECT *, (SELECT translation FROM translation_episodename WHERE episodeid=? AND languageid=languages.id) AS episodename, (SELECT translation FROM translation_episodeoverview WHERE episodeid=? AND languageid=languages.id) AS episodeoverview FROM languages ORDER BY name' with params ["6752211", "6752211"]: SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row


I hope this can be fixed, I don't really like to leave that wrong title alone.. :D

Re: Database error trying to edit a specific episode title

Posted: Tue Sep 25, 2018 12:17 pm
by DarklightIndigo
Re-entering the episode seems to circumvent the issue, but it's not really a fix.

Re: Database error trying to edit a specific episode title

Posted: Tue Sep 25, 2018 12:56 pm
by Manujito
Well, at least I was able to fix it now. So, thanks!