Win Nightly MySQL Issue and a Question about Thumbnails
#1
I've updated from the July 8th nightly to the July 14th nightly and for some reason my Video database isn't be updated. Here's the errors in the log
Code:
11:00:07 T:2844  NOTICE: Attempting to update the database xbmc_video67 from version 64 to 67
11:00:07 T:2844   ERROR: SQL: Undefined MySQL error: Code (1050)
                                            Query: CREATE TABLE tag (idTag integer primary key auto_increment , strTag text) CHARACTER SET utf8 COLLATE utf8_general_ci
11:00:07 T:2844   ERROR: Exception updating database xbmc_video67 from version 64 to 67
11:00:07 T:2844   ERROR: Error updating database xbmc_video67 from version 64 to 67
11:00:07 T:2844  NOTICE: Old database found - updating from version 66 to 67
11:00:08 T:2844   ERROR: SQL: Can't create database for copy: 'xbmc_video66' (1007)
11:00:08 T:2844   ERROR: Unable to copy old database xbmc_video66 to new version xbmc_video67

Also, I'm using folder substitution to put my thumbnails on a network share. I understand that the nighties have the thumbnails integrated into the database. Should I be removing the path substitution and doing something different?
Reply
#2
Kill the xbmc_video65 -> xbmc_video67 databases so you're back on 64. Then update again. There was an issue with the index on one of them earlier that you might have gotten hit by.

And yes, if you're running this build you'll want to remove path subs for thumbs.
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply
#3
Thanks jmarshall that worked for the database.

As for the path sub for thumbs, I removed that from my advancedsettings.xml file and now I don't have any thumbs showing up. I'm assuming that I'm not supposed to copy the contents of the old networked thumbs directory to all of my XBMC machines and I should be doing something different?
Reply
#4
If you were running a v64 database, you probably already had thumbs cached in the texture database. Remove your (local) texture database and they'll recache automatically. This will ensure you don't have stale thumbs as well in the process, at the expense of re-caching.

Alternatively, copy the networked thumbs dir over to your clients. You need only copy the 0-9/a-f folders inside Thumbnails, along with (possibly) the Videos/Bookmarks folder. Nothing else is required (all others are no longer used).

Cheers,
Jonathan
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply
#5
I deleted the Thumbnails folder from one of my machines and removed the path sub from advancedsettings.xml and XBMC doesn't appear to be caching the thumbs. It creates the Thumbnails folder in userdata, but doesn't appear to copy anything over.

Here's the errors in the log
Code:
18:08:40 T:5920   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/7/7cb65daa.jpg
18:08:40 T:4376  NOTICE: Thread Jobworker start, auto delete: true
18:08:40 T:5920   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/3/337970f2.jpg
18:08:40 T:3844  NOTICE: Thread CFileCache start, auto delete: false
18:08:42 T:5920  NOTICE: Previous line repeats 1 times.
18:08:42 T:5920   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/8/837e65a7.jpg
18:08:42 T:5920   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/6/63dd6a55.jpg
18:08:42 T:5920   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/3/39062c9c.jpg
18:08:42 T:5920   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/d/d96bc985.jpg
18:08:42 T:5920   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/3/3f5ecb72.jpg
18:08:42 T:4376   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/d/dd1eaa51.jpg
18:08:46 T:1316   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/e/e5982bed.jpg
18:08:48 T:4308  NOTICE: Thread Background Loader start, auto delete: false
18:09:00 T:4376  NOTICE: Previous line repeats 1 times.
18:09:00 T:4376   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/7/7cb65daa.jpg
18:09:00 T:5920   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/3/337970f2.jpg
18:09:00 T:1316   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/8/837e65a7.jpg
18:09:00 T:2252   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/6/63dd6a55.jpg
18:09:00 T:5920   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/3/39062c9c.jpg
18:09:00 T:4376   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/d/d96bc985.jpg
18:09:00 T:1316   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/3/3f5ecb72.jpg
18:09:02 T:5720  NOTICE: Thread Background Loader start, auto delete: false
18:09:03 T:5920   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/d/decd424b.jpg
18:09:03 T:4376   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/5/5da5a596.jpg
18:09:03 T:2252   ERROR: CDVDDemuxFFmpeg::Open - error probing input format, smb://HOMESERVER/MoviesHD/Experiment, The (2010) [unknown] [R]/Experiment, The (2010) [unknown] [R].mkv
18:09:04 T:2252   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/6/6408cf3a.jpg
18:09:04 T:4376   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/e/e4809766.jpg
18:09:04 T:4376   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/e/e2e4fe11.jpg
18:09:04 T:1316   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/2/2241778a.jpg
18:09:05 T:1316   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/a/a7d2a6f0.jpg
18:09:05 T:4376   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/a/ab4f84c2.jpg
18:09:05 T:1316   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/6/6aa9c779.jpg
18:09:05 T:4376   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/d/d96bc985.jpg
18:09:05 T:4376   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/2/2f60b827.jpg
18:09:05 T:2252   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/0/083b5aac.jpg
18:09:05 T:4376   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/e/eedccf3a.jpg
18:09:05 T:5920   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/e/e40a4366.jpg
18:09:05 T:4376   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/b/bd366293.jpg
18:09:05 T:5920   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/f/f718fb36.jpg
18:09:06 T:4376   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/e/eedccf3a.jpg
18:09:06 T:2252   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/e/e40a4366.jpg
18:09:06 T:5920   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/2/2f60b827.jpg
18:09:06 T:4376   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/0/083b5aac.jpg
18:09:06 T:5920   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/6/6aa9c779.jpg
18:09:06 T:4376   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/d/d96bc985.jpg
18:09:08 T:5920   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/8/837e65a7.jpg
18:09:08 T:2252   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/6/63dd6a55.jpg
18:09:08 T:1316   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/3/39062c9c.jpg
18:09:08 T:4376   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/d/d96bc985.jpg
18:09:08 T:5920   ERROR: Texture manager unable to load file: special://masterprofile/Thumbnails/3/3f5ecb72.jpg
Reply
#6
Again, it's because your Texture13.db contains those URLs, so XBMC thinks it already has them. Remove Texture13.db and they'll then come back.
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply
#7
i am contemplating trying frodo nightlys, or possibly a monthly, and would like to know official recommendation on how to handle my mysql migration?

i have HUGE database.

and i also have path substitution.

so will i just need to remove the substitution?

also, ive just copied over current *.xml for shared library and thumbs to raspberry pi. Wont copying all those thumbs over to the pi take up LOTS of space on the memory card?

thanks in advance,
Dam0
Reply
#8
You can still use path substitution for the sake of saving memory in frodo, for situations like an R-Pi with a small SD card. You can also change the size of the thumbnail's resolution in advancedsettings.xml (wiki) for the R-Pi specifically, which will still give the same thumb on all clients, but allow the R-Pi's thumbs to be smaller in file size. Smaller resolution can also speed up loading of thumbnails, in addition to the speed increase of making them local.
Reply
#9
thanks for the quick response Ned.

do you have any advice regarding MySQL? ie will Frodo break my database?

thanks in advance,
Dam0
Reply
#10
It should work just fine, but I would make a backup of the library database just in case.
Reply

Logout Mark Read Team Forum Stats Members Help
Nightly MySQL Issue and a Question about Thumbnails0