Kodi Community Forum
Database error (starting from scratch w beta1) - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: iOS & tvOS (https://forum.kodi.tv/forumdisplay.php?fid=137)
+---- Thread: Database error (starting from scratch w beta1) (/showthread.php?tid=117597)



Database error (starting from scratch w beta1) - Maetrik - 2011-12-25

How do i start from scratch with a new shared MySQL on a NAS on the Eden beta? I created databases xbmc_video and xbmc_music but xbmc refuses them and tells me nonstop he could not find any database. Before Beta1 i started Cydia version first do create all the nessesary tables into that databases and installed a Nightly version after it. Now XBMC is looking for xbmc_video58 and xbmc_music18 which are not there.

What is told here to set in advancedsettings.xml is def not working anymore. The only way i could get it working is without specifing a name for the dbs in advancedsettings.xml. Anything else, dbs named xbmc_video and xbmc_video or xbmc_video58 / xbmc_music18 gave me tons of errors and XBMC does not react at all

Code:
23:58:42 T:2693809472  NOTICE: Old database found - updating from version 0 to 58
23:58:42 T:2693809472   ERROR: SQL: The source database was unexpectedly empty.
23:58:42 T:2693809472   ERROR: Unable to copy old database xbmc_video to new version xbmc_video58
23:58:42 T:2693809472   ERROR: Unable to open database: xbmc_video58 [1049](Unknown database 'xbmc_video58')
23:58:42 T:2693809472   ERROR: Unable to open database: xbmc_video57 [1049](Unknown database 'xbmc_video57')
23:58:42 T:2693809472   ERROR: Unable to open database: xbmc_video56 [1049](Unknown database 'xbmc_video56')
23:58:42 T:2693809472   ERROR: Unable to open database: xbmc_video55 [1049](Unknown database 'xbmc_video55')
23:58:42 T:2693809472   ERROR: Unable to open database: xbmc_video54 [1049](Unknown database 'xbmc_video54')

as told before: i had this a while ago when starting from scratch with a nightly version. my workaround was to start cydia version first, which created all the tables into xbmc_video and xbmc_music. then i installed a nightly which copied the tables from xbmc_video into xbmc_video58 and everthing went fine. now that beta1 is default cydia, i'm really in trouble.



edit: nevermind, i just created a user for db usage and grand all privileges to it WITHOUT creating databases, now everything went fine without an error.


- Ned Scott - 2011-12-25

Eden can make databases. It should not be necessary to create them before hand if you wish to start from scratch.


- Maetrik - 2011-12-25

Yeah, see my edit above Wink

Another thing, can you tell me what this means (found in my log while rescraping) ? Everything seems to be ok, just wondering

ERROR: CacheImage Unable to create new image from image http://cf1.imgobject.com/backdrops/29c/4d7c2bbc7b9aa11a1401829c/the-woman-in-red-original.jpg
ERROR: DeleteFile - cant delete file <>. trying lower case <>