My Anime 2 (4 Viewers)

[Cinnabuns]

Ok I finally figured out the problem.
It looks like you have a duplicate hidden set of of episode records for One Piece.
This probably occurred some time in the past when you used the config to import episodes.
(You had two different groups which both used the same AniDB of 69)

I'm trying to figure out how I can fix the data, but don't see an easy solution.

For now I would advise against importing episodes from the config screen.

I started poking around the database and I only see one group with an AniDB_ID of 69 (AnimeGroupID=423). (EDIT: I guess you mean that this happened some time in the past.) I'm not that familiar with SQLite but it looks like foreign keys are not turned on in the DB (at least according to the FireFox plugin)? Anyhow, with some guesswork this is what I pieced together to try to wipe out all the One Piece files/hashes from the database so I can just re-hash the One Piece files in my brute force approach:

DELETE FROM CrossRef_File_Episode WHERE FileID IN
  (SELECT FileID FROM CrossRef_Episode_FileHash WHERE Hash IN
    (SELECT Hash FROM FileLocal WHERE FileNameFull LIKE '%One%Piece%')
  );

DELETE FROM CrossRef_Episode_FileHash WHERE Hash IN
  (SELECT Hash FROM FileLocal WHERE FileNameFull LIKE '%One%Piece%');

DELETE FROM CrossRef_Languages_FileHash WHERE Hash IN
  (SELECT Hash FROM FileHash WHERE FileName LIKE '%One%Piece%');

DELETE FROM CrossRef_Subtitles_FileHash WHERE Hash IN
  (SELECT Hash FROM FileHash WHERE FileName LIKE '%One%Piece%');

DELETE FROM FileLocal WHERE FileNameFull LIKE '%One%Piece%';

DELETE FROM FileHash WHERE FileName LIKE '%One%Piece%';

Let me know if that looks OK or if I just really fubar'd my database

The good news about doing this is that the import picked up every single file and re-hashed them, and they are now all showing up as "unrecognized files". The bad news is that they're all "unrecognized files" instead of being automatically linked to the One Piece series.

Edit:
I don't have time to fiddle with it more today but tomorrow I can try deleting the AnimeSeries and AnimeGroup entry to see if the plugin will just pick up all the files again so I don't have to manually associate close to 300 files.

 

[asmoranomar]

I'm still in the process of importing files slowly - but something else I've discovered:

MyAnime2 is not checking the 'watched' flag and is not setting the location ('on HDD', etc) on import.

Is there a way to 'force' MyAnime2 to synchronize the MyList data from AniDB?

I haven't been able to reproduce the banned issue. I have tried a few large imports over the last few days and no issues.
I have noticed that it sends duplicate commands in some cases, which could cause a ban (but not for me so far)

Yes I noticed the watched problem as well. It is do with using the web cache. Turning this off should fix it for any further files you import.
There is no way to sync the status at the moment, as it would need to send a UDP command for every file in your list.
While it's possible to do this I'm not sure of the banning implications. I might ask the AniDB developers about this.

Some goods news I guess. I didn't want to manually update the watched status of 7k files, so I dumped my database and told it to not use web cache.

Turns out, once I did that, the natural hashing process was a long enough delay between look-ups that I was successfully able to import my entire collection in a 2-day period without getting banned.

So~~ I suspected somewhere between using web cache and having all the hashes to all my files once they were found was the source of the problem I was having.

I have about 100 unrecognized files after my import. I tested my assumption by leaving the unrecognized files in place (so they wouldn't be re-hashed) and tried to do another import. About 40 files later I was banned.

It seems like MyAnime2 isn't properly set to queue UDP requests properly (in the event the hashes are already known), and is exceeding the AniDB limits. I would assume you have it set to the correct value (or more) - but might I recommend that in the future the delay could be user defined (say, a slide bar between 2 and 100 seconds for example)?

 

[Cinnabuns]

I don't have time to fiddle with it more today but tomorrow I can try deleting the AnimeSeries and AnimeGroup entry to see if the plugin will just pick up all the files again so I don't have to manually associate close to 300 files.

Yay, quoting myself! Anyhow, I also deleted anything One Piece related from AnimeSeries, AnimeGroup, AnimeEpisode (there were 2 AnimeSeries referenced by One Piece here), AniDB_File, and AniDB_Episode, and everything seems to be working now after I ran another import.

 

[lwerndly]

I have about 100 unrecognized files after my import. I tested my assumption by leaving the unrecognized files in place (so they wouldn't be re-hashed) and tried to do another import. About 40 files later I was banned.

It seems like MyAnime2 isn't properly set to queue UDP requests properly (in the event the hashes are already known), and is exceeding the AniDB limits. I would assume you have it set to the correct value (or more) - but might I recommend that in the future the delay could be user defined (say, a slide bar between 2 and 100 seconds for example)?

I think UDP is working properly, but HTTP is not.
If you were getting banned on UDP you would see "banned" in your logs.
So I will look at fixing this up.

Yay, quoting myself! Anyhow, I also deleted anything One Piece related from AnimeSeries, AnimeGroup, AnimeEpisode (there were 2 AnimeSeries referenced by One Piece here), AniDB_File, and AniDB_Episode, and everything seems to be working now after I ran another import.

Yeah sorry for the late reply, but let me know if there are any other issues.

 

[Cinnabuns]

Yeah sorry for the late reply, but let me know if there are any other issues.

No need to apologize I just made that comment because it's always weird to quote myself

 

[slamdance]

I have about 100 unrecognized files after my import. I tested my assumption by leaving the unrecognized files in place (so they wouldn't be re-hashed) and tried to do another import. About 40 files later I was banned.

It seems like MyAnime2 isn't properly set to queue UDP requests properly (in the event the hashes are already known), and is exceeding the AniDB limits. I would assume you have it set to the correct value (or more) - but might I recommend that in the future the delay could be user defined (say, a slide bar between 2 and 100 seconds for example)?

I think UDP is working properly, but HTTP is not.
If you were getting banned on UDP you would see "banned" in your logs.
So I will look at fixing this up.

UDP isn't working properly either, anidb banned me within 3 minutes of starting a new import session.

I completely reinstalled my htpc yesterday, and want to start with a clean db.
as I expected problems, I only put one piece in the import directory and ran the import.
After a few "598 UNKNOWN COMMAND" responses, it soon changed into a 555 BANNED with only a single file matched.

please find attached the complete log.

 

[jbsoum]

Well, I've just installed My Anime 2 and it seems to be importing fine for me.

Also, quick side question: I was wondering if it would be possible to play a random episode from a season or genre, kind of like with my TV series plugin. While most anime should be watched in sequence, there are series where that's not really necessary, like excel saga or pani poni dash!

 

[lwerndly]

I completely reinstalled my htpc yesterday, and want to start with a clean db.
as I expected problems, I only put one piece in the import directory and ran the import.
After a few "598 UNKNOWN COMMAND" responses, it soon changed into a 555 BANNED with only a single file matched.

please find attached the complete log.

Hmmm the 598 messages used to be associated with incorrect encoding (to AniDB)
But it seems you login, get the first file and then start getting the 598 messages.

I will try the same One Piece import tonight and see what happens for me.

Did you have the web cache turned off?

 

[himochi]

hi guys, quick question.

My computer blew up and i had to reinstall MP from scratch, i lost my old DB when that happened so here is my issue: After running an Import my Dragon ball z series goes into unrecognized files.
This happened before but i manually added the 300+ individual chapters.

You can imagine I really dont want to do it again, so is there a reason why some files dont get properly assigned? does it have to have a special name on the file? i try to keep all my series with the same kind of name order like: Dragon Ball Z 01, Dragon Ball Z 02... and so on. But some of them dont seem to go through the import.

any answers will be appreciated as i couldnt find anything on the forum.

 

[jbsoum]

hi guys, quick question.

My computer blew up and i had to reinstall MP from scratch, i lost my old DB when that happened so here is my issue: After running an Import my Dragon ball z series goes into unrecognized files.
This happened before but i manually added the 300+ individual chapters.

You can imagine I really dont want to do it again, so is there a reason why some files dont get properly assigned? does it have to have a special name on the file? i try to keep all my series with the same kind of name order like: Dragon Ball Z 01, Dragon Ball Z 02... and so on. But some of them dont seem to go through the import.

any answers will be appreciated as i couldnt find anything on the forum.

Basically, the file name is irrelevant. All that matters when adding a series to your database is the crc checksum on the file. What group released the files? The only way the files wouldn't get recognized is if you encoded them yourself, or if your files are corrupted.

I've heard that there will be file name support in the next release, but not yet. But, usually this isn't necessary. If you got the files from a fansub or dvd group, then they are probably corrupted, and you can re-download them, or even just use a torrent to rehash them, so you can just re-download the corrupted parts.