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.
kisjoke91
Posts: 9
Joined: Thu Apr 22, 2021 12:54 am

Upload parameters (XML-RPC)

Tue Aug 03, 2021 4:56 pm

Hei guys,

I did begin to work on the upload feature of my app, and the rpc api documentation is very clear, however i have a question.
It seems, i need to have a movie file loaded in my software in order to get the movie hash, the file size of the movie and so.
In my understanding without this arguments used in TryUploadSubtitles or UploadSubtitles, i am unable to upload any subtitle file to the sites database. Is it right? Is there any way to upload only the srt file? Because i am sure, there are some peoples, they are just translating a subtitle as it is, without modifying on the timing of the frames, and in this use case there is not necessarily needed a video file.

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

Re: Upload parameters (XML-RPC)

Wed Aug 04, 2021 10:28 am

it is undocumented, but you can try without those parameters aswell

kisjoke91
Posts: 9
Joined: Thu Apr 22, 2021 12:54 am

Re: Upload parameters (XML-RPC)

Wed Aug 04, 2021 2:13 pm

Ah cool, I'll try it. Thanks.

kisjoke91
Posts: 9
Joined: Thu Apr 22, 2021 12:54 am

Re: Upload parameters (XML-RPC)

Fri Aug 13, 2021 3:50 pm

Hello, i am again.

So the TryUploadSubtitles method works, but if i want to upload the subtitle with the UploadSubtitles method, i get this server response:

Code: Select all

<null> <!-- date: August 13, 2021, 3:25 pm query: SELECT IDSubtitle, SubFileName, MovieID, c.MovieName, MovieReleaseName, SubAdminCheck from subs_subtitle a left join subs_subtitle_file b on a.IDSubtitle = b.SubtitleID left join subs_movie c on a.MovieID = c.IDMovie WHERE 1=1 AND SubEnabled = 1 AND SubActualCD = 1 AND IDSubtitle = ORDER BY IDSubtitle host: api.opensubtitles.org (172.20.100.1) / /xml-rpc error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY IDSubtitle' at line 9 --> Requested page is temporarily unavailable, please try again later.
It seems, my query is messing up the SQL query.
What am i doing wrong?

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

Re: Upload parameters (XML-RPC)

Fri Aug 13, 2021 6:50 pm

Hi,

send me the XML REQUEST body (xml), so I can debug better, thanks.

kisjoke91
Posts: 9
Joined: Thu Apr 22, 2021 12:54 am

Re: Upload parameters (XML-RPC)

Sat Aug 14, 2021 2:50 pm

Hi,

send me the XML REQUEST body (xml), so I can debug better, thanks.
Here is the assemled XML structure https://pastebin.com/hj8085kg

Edit: I checked the enhanced doc of the RPC method, and the structure of the input example is different, maybe thats all.

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

Re: Upload parameters (XML-RPC)

Sat Aug 14, 2021 6:48 pm

yeah, try to change according enhanced version...try again, should work

Return to “Developing”

Who is online

Users browsing this forum: No registered users and 22 guests