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!


Forums
Software
Windows Software
RenameMyTVseries - ...
 
Share:
Notifications
Clear all

[Solved] RenameMyTVseries - Keeping Hard Link list tidy

 
Windows Software
Last Post by Hans 4 years ago
5 Posts
2 Users
2 Reactions
2,069 Views
RSS
 mfu
(@mfu)
Trusted Member
Joined: 4 years ago
Posts: 39
Topic starter March 10, 2021 4:04 PM  

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;

Attachment : image.png

Attachment : image.png

   
ReplyQuote
 Hans
(@hans)
Famed Member Admin
Joined: 12 years ago
Posts: 2869
March 11, 2021 5:02 AM  

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: 12 years ago
Posts: 2869
March 11, 2021 5:52 AM  

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)
Trusted Member
Joined: 4 years ago
Posts: 39
Topic starter March 11, 2021 4:34 PM  

@hans

Thanks, my first experience with the sqlite program;  

Attachment : image.png

Unwanted row and half the house gone

 

😀

Later


   
ReplyQuote
 Hans
(@hans)
Famed Member Admin
Joined: 12 years ago
Posts: 2869
March 12, 2021 5:48 AM  

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

Attachment : laughing.gif

   
ReplyQuote
Forum Jump:
  Previous Topic
Next Topic  
Share: