Page 1 of 1
Forum

Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!

Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.

Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!




RenameMyTVseries - ...
 
Share:
Notifications
Clear all

RenameMyTVseries - Keeping Hard Link list tidy

5 Posts
2 Users
2 Likes
882 Views
 mfu
(@mfu)
Eminent Member
Joined: 2 years ago
Posts: 39
Topic starter  

Hi Hans,

After a couple of years and a lots of booze, I finally figured out the Hard Link general concept.

I am guessing the tidier it is kept the better.

I spotted a dupe, and when I select either and hit remove, I get this error that hopefully means something to you;


   
ReplyQuote
 Hans
(@hans)
Famed Member Admin
Joined: 9 years ago
Posts: 2282
 

Hi MfU!

Woops, that sounds like a boo-boo on my end with the SQL statement ...
Thanks for reporting!

I found where this goes wrong - I suspect this may depend on the SQLite version. Or better said: how the SQLite version has been compiled.
I've fixed it in my dev environment, so in a next release this will be fixed 😊 

Let me first see if there are other things that need fixing (it take quite a bit of work to prepare 6 releases - Win, 2xLinux GTK, 2xLinux QT, and macOS).

Again: thanks for reporting!


   
mfu reacted
ReplyQuote
 Hans
(@hans)
Famed Member Admin
Joined: 9 years ago
Posts: 2282
 

As a temporary workaround (if needed), you can edit the data in the database with a SQLite editor - DB Browser for SQLite is probably the easiest.

The database file can be found here:

c:\Users\<username>\AppData\Local\Rename My TV Series\LocalData.sqlite3

 

Make sure RMTV is closed while doing this.
It's also a good idea to make a backup of the file (LocalData.sqlite3).

In DB Browser for SQLite, go to the table "autodetect_link", click "Browse Data".
Now locate the row you want removed, right click the row number and from the popup menu select "Delete Record".

You can now close DB Browser for SQLite, it will probably ask if you want to save the changes, which you have to confirm.

Start RMTV again, and the row should be gone.


   
mfu reacted
ReplyQuote
 mfu
(@mfu)
Eminent Member
Joined: 2 years ago
Posts: 39
Topic starter  

@hans

Thanks, my first experience with the sqlite program;  

Unwanted row and half the house gone

 

😀

Later


   
ReplyQuote
 Hans
(@hans)
Famed Member Admin
Joined: 9 years ago
Posts: 2282
 

But at least that single row is gone ... hahah


   
ReplyQuote


Like what you see and you'd like to help out? 

The best way to help is of course by assisting others with their questions here in the forum, but you can also help us out in other ways:

- Do your shopping at Amazon, it will not cost you anything extra but may generate a small commission for us,
- send a cup of coffee through PayPal ($5, $10, $20, or custom amount),
- become a Patreon,
- donate BitCoin (BTC), or BitCoinCash (BCH).

Share: