alvra / django-spotnet

A Django app to manage and download posts from Spotnet.
GNU General Public License v3.0
7 stars 6 forks source link

NZB can't be retrieved if the NZB is split into multiple segments (because of error in header) #5

Open hagst opened 11 years ago

hagst commented 11 years ago

Message-ID: LFYrARf1xpkpLy3UAAPuT@spot.net Date: 29 Nov 2012 19:52:27 GMT

<NZB><Segment>l1Fkhrx55eIpby3UAAF3M@spot.net></Segment><Segment>vO8CxtZE5gopry3UAABdh@spot.net</Segment><Segment>5dg892yfHHgsLy3UAAFbV@spot.ne</Segment></NZB>

Reason: The spot is added with Spotnet 1.7.4. This client has a bug but is still used for adding spots. Fix: remove the > from the first segment and add a t to the last segment.

An other spot with working NZB created after combining multiple segments. Message-ID: iJKvsMtACvYDeWvUALpAq@spot.net NNTP-Posting-Date: 23 Nov 2012 21:05:15 GMT

<NZB><Segment>uerTTRryjU8DuWvUAOhnZ@spot.net</Segment><Segment>GCuGdYqPKhcDpWvUABH8H@spot.net</Segment></NZB>

NZB size: 9,48 MB

There are 331 spots in the last 150 days with this problem.

Workaround for a mysql database:

UPDATE `spotnet_post` SET `nzb` = REPLACE(REPLACE(REPLACE(`nzb`, '>', ''), 'spot.ne', 'spot.net'), 'spot.nett', 'spot.net')

Removes > from the first segment + Add t to the last segment + Prevent renaming spot.net to spot.nett There is probably a better solution. But this seams to work.