Forum rules
Under no circumstances is spamming or advertising of any kind allowed. Do not post any abusive, obscene, vulgar, slanderous, hateful, threatening, sexually-orientated or any other material that may violate others security. Profanity or any kind of insolent behavior to other members (regardless of rank) will not be tolerated. Remember, what you don’t find offensive can be offensive to other members. Please treat each other with the kind of reverence you’d expect from other members.
Failure to comply with any of the above will result in users being banned without notice. If any further details are needed, contact: “The team” using the link at the bottom of the forum page. Thank you.
User avatar
eduo
Posts: 716
Joined: Sat Feb 10, 2007 1:40 am
Location: Information Technology
Contact: ICQ Website Yahoo Messenger

Subtitle upload returning MySQL error

Tue Jan 04, 2011 3:44 am

I was trying to upload today a movie subtitle that wasn't present and I found a weird response back.

If I keep trying I keep getting higher SubtitleIDs but the subtitle never seems to be created in the database. In the query itself seems the timecodes don't have a closing singlequote but I wouldn't know if that's the error.
http://eduo.info/
[url=http://eduo.info/soleol/]OpenSubtitles from your desktop: SolEol for Mac/Windows/Linux[/url]
[url=http://forums.plexapp.com/index.php?showtopic=325&st=0&p=2480&#entry2480]My current episode processing work flow[/url].

User avatar
oss
Site Admin
Posts: 5890
Joined: Sat Feb 25, 2006 11:26 pm
Contact: Website

Re: Subtitle upload returning MySQL error

Tue Jan 04, 2011 10:51 am

Hi Eduo,

thanks for info, it should be corrected now. If not, let me know.

User avatar
eduo
Posts: 716
Joined: Sat Feb 10, 2007 1:40 am
Location: Information Technology
Contact: ICQ Website Yahoo Messenger

Re: Subtitle upload returning MySQL error

Tue Jan 04, 2011 1:16 pm

It works now.

Funny thing happened, though. After upload I got this returned:

http://www.opensubtitles.org/en/subtitl ... m-tapes-pt

The subtitle is the right one, but the language and the IMDB are wrong. I'll correct them, but it's weird.
http://eduo.info/
[url=http://eduo.info/soleol/]OpenSubtitles from your desktop: SolEol for Mac/Windows/Linux[/url]
[url=http://forums.plexapp.com/index.php?showtopic=325&st=0&p=2480&#entry2480]My current episode processing work flow[/url].

User avatar
oss
Site Admin
Posts: 5890
Joined: Sat Feb 25, 2006 11:26 pm
Contact: Website

Re: Subtitle upload returning MySQL error

Mon Jan 10, 2011 5:51 am

thats really really weird. Maybe db was a little corrupted...I hope now it is working ok

User avatar
eduo
Posts: 716
Joined: Sat Feb 10, 2007 1:40 am
Location: Information Technology
Contact: ICQ Website Yahoo Messenger

Re: Subtitle upload returning MySQL error

Sun Jan 16, 2011 12:56 am

Subtitle uploads have now been regularly OK for some time. I've uploaded a few hundred subs in the last weeks without major issues.

Incorrect IMDBs have regularly been because the moviehash was already incorrectly identified.
http://eduo.info/
[url=http://eduo.info/soleol/]OpenSubtitles from your desktop: SolEol for Mac/Windows/Linux[/url]
[url=http://forums.plexapp.com/index.php?showtopic=325&st=0&p=2480&#entry2480]My current episode processing work flow[/url].

Return to “Developing”

Who is online

Users browsing this forum: No registered users and 28 guests