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!



Rename My TV Series...
 
Share:
Notifications
Clear all

[Solved] Rename My TV Series 2.1.1 b6 - SQLite no such table"

16 Posts
2 Users
1 Reactions
10.4 K Views
(@kilimar)
Trusted Member
Joined: 4 years ago
Posts: 42
Topic starter  

Due to the issue below:

https://www.tweaking4all.com/forum/miscellaneous-software/rename-my-tv-series-2-0-10-b8-something-went-very-wrong-here/

 

I decided to try the beta, however, I am getting:

 

Rename My TV Series: 2.1.1 (Build 6)
SQLite library: v.3.25.2
OS: Windows (64 bit), Windows 10.0, i386 (32 bit application)


   
ReplyQuote
 Hans
(@hans)
Famed Member Admin
Joined: 11 years ago
Posts: 2791
 

Good plan! 👍 

You may have to rename or delete the old data directory. The database has changed significantly with the update.

Easiest is by closing RMTV, renaming the directory, and restarting RMTV:

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

to (for example)

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

The database will be recreated.


   
ReplyQuote
(@kilimar)
Trusted Member
Joined: 4 years ago
Posts: 42
Topic starter  

I actually did delete the directory %appdata%\Rename ... after getting that error and I still got the error after restarting.

 

But I am going to try it again.  And I got a different error:

 

Maybe I missed this error the last time I tried the beta.  Okay and the window closes, but you can re-restart the application.  However, when trying to retreive a show, then I get the 'no table'.  I do see LocalData.sqlite3 in %appdata%.


   
ReplyQuote
(@kilimar)
Trusted Member
Joined: 4 years ago
Posts: 42
Topic starter  

I deleted the LocalData.sqlite3 file.  Started the app.  It seems to delete all files in the directory and re-creates Posters and LocalData.sqlite3 but get the message "unable create SQLite DB".  OK to close.  When I re-open the application a second time, it creates two additional directories, Banners and Fanart.

 

I verified that the newly generated LocalData.sqlite3 does not contain the table 'searchresults' (see attached image).

 

Maybe, race condition?  Trying to do multiple things to the table at the same time? 

 


   
ReplyQuote
 Hans
(@hans)
Famed Member Admin
Joined: 11 years ago
Posts: 2791
 

This is so strange ... I've never seen this happen ... 😳 

It may be a good idea to uninstall RMTV (all versions), remove the data directory (again), install RMTV beta, and try RMTV again.

I just tried it here (also Windows 10), and I did not encounter these errors.

Also: make sure there are no applications open that may access the SQLite library. Including antivirus tools (just for the purpose of testing).


   
ReplyQuote
(@kilimar)
Trusted Member
Joined: 4 years ago
Posts: 42
Topic starter  

I only have Chrome, Notepad++, MS Paint, and whatever Win10 uses (Windows Defender?).  When installing and running the application.

 

  • Removed the application. BTW, I guess the release and beta have the same product code as they overwrite each other in the Windows Installed s/w (only one entry to uninstall).
  • Deleted RMTV appdata
  • Reinstall Beta.  No appdata directory created.
  • Launch RMTV.  I get the "Unable tocreate SQLite Database" dialog.  However, I do see in appdata, 3 directories (Banners, Fanart, Posters) and LocalData.sqlite3.
  • OK to close.  Main window flashes.  Strangely, the Banners and Fanart directories disappear.  

 

 


   
ReplyQuote
 Hans
(@hans)
Famed Member Admin
Joined: 11 years ago
Posts: 2791
 

I have never seen this happen, and I do mess around with those databases a lot when developing.

I've just verified the code, and when creating the database, these queries are explicitly executed:

DROP TABLE IF EXISTS "searchresults";

CREATE TABLE "searchresults"(
"ID" Integer NOT NULL PRIMARY KEY AUTOINCREMENT,
"providerid" Integer NOT NULL,
"provider" Text NOT NULL DEFAULT "not defined",
"title" Text NOT NULL,
"premiereyear" Text,
"summary" Text,
CONSTRAINT "unique_ID" UNIQUE ( "ID" ),
CONSTRAINT "unique_Provider_and_Title" UNIQUE ( "provider", "providerid" ) ON CONFLICT REPLACE );

CREATE INDEX "index_title" ON "searchresults"( "title" );

Everything is executed in sequence, so nothing in parallel. 

Since you're using DB browser;

1. Check the version with this SQL statement, it should return "211":

pragma user_version;

2. Make sure you have totally closed DB browser, as it will interfere with working with SQLite.


   
ReplyQuote
 Hans
(@hans)
Famed Member Admin
Joined: 11 years ago
Posts: 2791
 

I see we cross-posted 😋 

When database creation fails, RMTV tries to clean up whatever it created. So it is to be expected that those dirs disappear.


   
ReplyQuote
 Hans
(@hans)
Famed Member Admin
Joined: 11 years ago
Posts: 2791
 

Note: during install there will not yet be any directory creation, this will happen during first run of RMTV.


   
ReplyQuote
 Hans
(@hans)
Famed Member Admin
Joined: 11 years ago
Posts: 2791
 

OK, after some fooling around, I have managed to reproduce the error! 👍 
No clue why you're the first one to notice this, but I'm grateful that you found it!

I'll try to find a fix asap! 


   
ReplyQuote
(@kilimar)
Trusted Member
Joined: 4 years ago
Posts: 42
Topic starter  

Note: Well, besides Chrome, MS Paint, Notepad++ , I guess there are host of other stuff running like Nvidia applets/drivers, HP Toolbox, ActivClient, auto-updaters (adobe, java, etc), itunes, audio, and a host of other thigns  -- looking through the process list, a crazy amount of things are 'running'.  So, it is not just those 3 applications.... sorry, makes it hard to troublehsoot.

 

Anyway, pragma user_version; does return 211.

 

Glad you were able to reproduce!  Will wait for next beta. :)   If you remember, please reply here so I know when it's ready to grab the update.... I'll have to look around and see if there is a mailing list for beta or something to subscribe for alerts.

 

BTW, thank you for the application, AWESOME work!  Greatly appreciated, not to mention, awesome quick support!


   
Hans reacted
ReplyQuote
 Hans
(@hans)
Famed Member Admin
Joined: 11 years ago
Posts: 2791
 

OK, found the trouble maker ... it is TVDB ... AGAIN 😫 

When trying to load the languages supported by TVDB, the returned API data is malformed or incomplete.
I'll add some "traps" around that and see if I can get that fixed.

As for the app and support: Thanks! And ... you're welcome 😉 


   
ReplyQuote
(@kilimar)
Trusted Member
Joined: 4 years ago
Posts: 42
Topic starter  

Since your making changes, noticed typo(s):

In the Show & Episode Info tab of the preferences dialog, the word "strict" is spelled 'strick'.

and I believe 'stipping' should be 'stripping'.

 

Noticed that in 2.0.10, for that one show "High school easy even" and while TVDB data was malformed, it still displayed episode data.  However in 2.1.1, episode data was not displayed.  Of course, that may change with the fix above.

 

There's not a way to export preferences  is there?  So that switching between versions where the DB changes, I don't have to reconfigure it to my liking each time?  

 

edit: NVM, I guess I can save the %appdata% and rename it as needed. :)  I would still have to configure for the first time when the DB changes.


   
ReplyQuote
 Hans
(@hans)
Famed Member Admin
Joined: 11 years ago
Posts: 2791
 

Thanks for the tip on the typos! 👍 
I've corrected those right away.

The fact that the episodes do not show in 2.1.1 can have a few reasons, but the main reason would be that TVDB is not giving RMTV any data, so RMTV assumes the rest will be unreliable (trademark for TVDB). 🤪 

Exporting the settings; no there is no feature for that.
I always try to make migration smooth, but it does come with its challenges (all the different version).

On that note: when I get this issue fixed, try starting with a copy of your previous data (in case you didn't delete it). RMTV will do an attempt to migrate to the new format, so you should not loose your settings (hopefully).

I guess this is one of the biggest challenges with testing ... there are very few people willing to test, and since RMTV has become pretty complex, nobody will test all options.

Just a heads up: the new version will have the ability to do auto detect (depending on the filename of course) 😋 


   
ReplyQuote
 Hans
(@hans)
Famed Member Admin
Joined: 11 years ago
Posts: 2791
 

Alright, got it fixed ... and I did speed up the initialization of the initial database.
Now I have to build all versions (Windows, macOS, Linux) and I hope to upload them in the next hour (or less).

Thanks again for reporting the issue! 👍 
I'll post here when I completed the uploads.


   
ReplyQuote
Page 1 / 2
Share: