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 most likely no translated for the post!





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

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

Page 1 / 2
  RSS

kilimar
(@kilimar)
Eminent Member
Joined: 2 months ago
Posts: 27
May 28, 2020 4:27 AM  

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
Topic Tags
Hans
 Hans
(@hans)
Noble Member Admin
Joined: 7 years ago
Posts: 1373
May 28, 2020 4:43 AM  

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
(@kilimar)
Eminent Member
Joined: 2 months ago
Posts: 27
May 28, 2020 4:51 AM  

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%.

This post was modified 2 months ago by kilimar

ReplyQuote
kilimar
(@kilimar)
Eminent Member
Joined: 2 months ago
Posts: 27
May 28, 2020 5:12 AM  

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? 

 

This post was modified 2 months ago 2 times by kilimar

ReplyQuote
Hans
 Hans
(@hans)
Noble Member Admin
Joined: 7 years ago
Posts: 1373
May 28, 2020 5:17 AM  

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
(@kilimar)
Eminent Member
Joined: 2 months ago
Posts: 27
May 28, 2020 5:28 AM  

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.  

 

 

This post was modified 2 months ago 2 times by kilimar

ReplyQuote
Hans
 Hans
(@hans)
Noble Member Admin
Joined: 7 years ago
Posts: 1373
May 28, 2020 5:34 AM  

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
(@hans)
Noble Member Admin
Joined: 7 years ago
Posts: 1373
May 28, 2020 5:36 AM  

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
(@hans)
Noble Member Admin
Joined: 7 years ago
Posts: 1373
May 28, 2020 5:37 AM  

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


ReplyQuote
Hans
 Hans
(@hans)
Noble Member Admin
Joined: 7 years ago
Posts: 1373
May 28, 2020 5:40 AM  

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
(@kilimar)
Eminent Member
Joined: 2 months ago
Posts: 27
May 28, 2020 5:46 AM  

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 liked
ReplyQuote
Hans
 Hans
(@hans)
Noble Member Admin
Joined: 7 years ago
Posts: 1373
May 28, 2020 5:54 AM  

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
(@kilimar)
Eminent Member
Joined: 2 months ago
Posts: 27
May 28, 2020 6:15 AM  

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.

This post was modified 2 months ago 2 times by kilimar

ReplyQuote
Hans
 Hans
(@hans)
Noble Member Admin
Joined: 7 years ago
Posts: 1373
May 28, 2020 6:23 AM  

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
(@hans)
Noble Member Admin
Joined: 7 years ago
Posts: 1373
May 28, 2020 6:55 AM  

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: