home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
MediaPortal 1 Plugins
My Anime 2
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="bert_r" data-source="post: 495865" data-attributes="member: 90426"><p>When reinstalling the PC name is probably changed from lower- to uppercase or the opposite. This seems indeed to be bug (see <a href="http://code.google.com/p/animeplugin2/issues/detail?id=65" target="_blank">Issue #65</a>).</p><p></p><p>Seeing you can access the database yourself, I think it would be best to delete the duplicate entries manually. Make sure you delete the old entries (otherwise the other ones will be re-inserted). This query for example will delete everything starting with \\0PTERON185\:</p><p style="margin-left: 20px">delete from FileLocal where sub_str(FileNameFull,0,13)='\\0PTERON185\'</p><p>(Replace the 'sub_str' with 'substr'; The forum was choking on my post otherwise ... some anti-sql-injection tactic?)</p><p>Note that we can't use the sql LIKE syntax because that's case insensitive, while '=' is case sensitive.</p><p></p><p></p><p></p><p></p><p>Could you try running 'cleanup database' in the utilities screen, and then try 'run import' again? That should fix any inconsistencies in the database caused by the crash.</p><p>Also, do you have any logs/dumps from the crash? It appears as if the plugin might have caused the crash, so I'd like to see if we can fix that.</p></blockquote><p></p>
[QUOTE="bert_r, post: 495865, member: 90426"] When reinstalling the PC name is probably changed from lower- to uppercase or the opposite. This seems indeed to be bug (see [URL="http://code.google.com/p/animeplugin2/issues/detail?id=65"]Issue #65[/URL]). Seeing you can access the database yourself, I think it would be best to delete the duplicate entries manually. Make sure you delete the old entries (otherwise the other ones will be re-inserted). This query for example will delete everything starting with \\0PTERON185\: [INDENT]delete from FileLocal where sub_str(FileNameFull,0,13)='\\0PTERON185\'[/INDENT] (Replace the 'sub_str' with 'substr'; The forum was choking on my post otherwise ... some anti-sql-injection tactic?) Note that we can't use the sql LIKE syntax because that's case insensitive, while '=' is case sensitive. Could you try running 'cleanup database' in the utilities screen, and then try 'run import' again? That should fix any inconsistencies in the database caused by the crash. Also, do you have any logs/dumps from the crash? It appears as if the plugin might have caused the crash, so I'd like to see if we can fix that. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
MediaPortal 1 Plugins
My Anime 2
Contact us
RSS
Top
Bottom