Login at Kodi Home

pyro42 · 2012-03-04, 09:39

Went about updating my ATV2 from Beta 2 to RC2 and my Windows PC from Beta 1 to RC2, and now both are having problems with my databases.

ATV2:

Code:
22:54:39 T:126644224   ERROR: SQL: The table does not exist

                                            Query: SELECT idVersion FROM version

Win7:

Code:
00:17:24 T:23536   ERROR: CRemoteControl::Connect - failed to connect

00:17:32 T:22196   ERROR: SQL: The table does not exist

                                            Query: SELECT idVersion FROM version

now i am aware i could probably do what i had to do when i upgraded from 10.1 to 11 beta 1, and reinstall working beta, export old database, delete mysql database, let xbmc recreate, and then re-import, but that's a bit of a pain to do on every upgrade. Surely an Eden to Eden upgrade should go smoother, shouldn't it?

DDDamian · 2012-03-04, 09:45

At Eden B3 the video database was changed to a newer version.

pyro42 · 2012-03-04, 09:55

DDDamian Wrote:At Eden B3 the video database was changed to a newer version.

makes sense why i'm having issues then. i went ahead and reinstalled a known working file and have begin backing up my database, but when i export my music database, it comes out empty
or rather"

Code:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

<musicdb />

to be precise.

now my music database is one of those PC crushing 25,000+ song databases, and i'd really hate to have to recreate it. Any suggestions or should i only have to worry about the video DB?

DDDamian · 2012-03-04, 10:05

IIRC it was only the video database that changed. Kinda concerning you couldn't export your music database, but it should be the same version.

~~Ned Scott~~ · 2012-03-04, 11:54

XBMC should update the MySQL DB all smooth like. Any log files and details you can provide us with will help us figure out why it didn't happen smoothly.

pyro42 · 2012-03-04, 13:07

Ned Scott Wrote:XBMC should update the MySQL DB all smooth like. Any log files and details you can provide us with will help us figure out why it didn't happen smoothly.

XBMC.log Win7
http://pastebin.com/UJzFuDuy

Win7 CrashReports (wtfencoding?)
http://dl.dropbox.com/u/1417895/xbmc_cra...001732.dmp
http://dl.dropbox.com/u/1417895/xbmc_cra...003816.dmp

XBMC Log ATV2
http://pastebin.com/1t5gW7J7

mediaserverd_1969-12-31-160818_Apple-TV.plist ATV2 (couldn't find a AppleTV_*_Apple-TV.plist)
http://pastebin.com/3BsLrsFv

ATV2 syslog is 23MB and spammy as hell
http://dl.dropbox.com/u/1417895/syslog

anything else? i can get mysql logs if you point me in the right direction.

jmarshall · 2012-03-04, 22:49

The log files are useless once the update has already failed. We need the very first update (i.e. the one that caused the screwup).

Remove any xbmc_video60 databases and see if you can reproduce.

**Suicide Machine** · 2012-03-05, 01:19

I think I have the same error upgrading from last stable (Dharma) to RC2

On my first client (W7 X86) I didn't have debug enabled so I also got this and simply no DB is found/opend

Code:
14:47:55 T:2700 M:898715648   ERROR: SQL: Unable to open the database file

                                            Query: select id from disabled where addonID='metadata.themoviedb.org'

On my second client (W7 X64) I enabled debug before upgrade to Eden. While starting up XBMC was unresponsive for somewhere from 15 to 30 minutes with very low cpu usage though (14% on an oc'd i5 2500k) but when it was done my main menu showed movies and tv shows as if db was loaded. Entering the movies caused it to stop responding again (~10minutes) and then went into the file view. From there on basically every new menu took a few minutes to open.

log: http://dl.dropbox.com/u/353950/suicide.machine.xbmc.log

thank you for your time and support Smile

trmentry · 2012-03-05, 01:51

I think I'm in the same boat, but not 100%.

I have a Win7 Dharma box that was talking back to MySQL. There was a 2nd Win7 box (Dharma) that has been re-purposed into something else. I replaced it with a ATV2, jailbroken and running Eden.

I put the MySQL config on the ATV2, and things don't seem to be in sync. I have the following in the logs.

This is from the xbmc.old.log but I've rebooted the ATV2 a few times so not sure if I have the first instance of the issue.

Code:
19:17 T:81395712  NOTICE: Attempting to update the database xbmc_video60 from version 42 to 60

19:17 T:81395712   ERROR: SQL: Undefined MySQL error: Code (1060)

                                            Query: ALTER TABLE settings ADD VerticalShift float

19:17 T:81395712   ERROR: Error attempting to update the database version!

19:17 T:81395712   ERROR: Can't update the database xbmc_video60 from version 42 to 60

19:17 T:81395712   ERROR: Unable to open database: xbmc_video59 [1049](Unknown database 'xbmc_video59')

19:17 T:81395712  NOTICE: Old database found - updating from version 58 to 60

19:17 T:81395712   ERROR: SQL: Can't create database for copy: 'xbmc_video58' (1007)

19:17 T:81395712   ERROR: Unable to copy old database xbmc_video58 to new version xbmc_video60

19:17 T:81395712  NOTICE: Attempting to update the database xbmc_video60 from version 42 to 60

19:17 T:81395712   ERROR: SQL: Undefined MySQL error: Code (1060)

                                            Query: ALTER TABLE settings ADD VerticalShift float

19:17 T:81395712   ERROR: Error attempting to update the database version!

19:17 T:81395712   ERROR: Can't update the database xbmc_video60 from version 42 to 60

19:17 T:81395712   ERROR: Unable to open database: xbmc_video59 [1049](Unknown database 'xbmc_video59')

19:17 T:81395712  NOTICE: Old database found - updating from version 58 to 60

19:17 T:81395712   ERROR: SQL: Can't create database for copy: 'xbmc_video58' (1007)

19:17 T:81395712   ERROR: Unable to copy old database xbmc_video58 to new version xbmc_video60

19:18 T:81395712  NOTICE: initialize done

My advancedsettings.xml file

Code:
<advancedsettings>

                                              <videodatabase>

                                                <type>mysql</type>

                                                <host>xx.xx.xx.xx</host>

                                                <name>xbmc_video</name>

                                                <user>root</user>

                                                <pass><SNIP></pass>

                                              </videodatabase>

When I pull up phpMyadmin, it shows 3 databases
xbmc_video
xbmc_video58
xbmc_video60

I dropped 58 and 60. But when the Win7 box reboots, it creates a new 60 database. Not sure why as xml shows xbmc_video.

My guess is dharma boxes and eden boxes don't play well together when using MySQL.

I'm working on trying to install Eden remotely (I'm at work) on my Win7 box to see if that helps.

trmentry · (This post was last modified: 2012-03-05, 02:31 by trmentry.)

Ok... was able to get Eden installed remotely. I completely uninstalled 10.1 and told it to delete everything in /user/xbox/AppData/Roaming/XBMC

I then dropped all xbmc_video# and xbmc_video databases.

I created a new (nothing in it) xbmc_video database.

Fired up Eden for the first time and it failed. Didn't create the tables, etc.

http://pastebin.com/bRUbkmEq

It keeps looking for a database xbmc_video60-1

Please note that between the following 2 lines.

Code:
17:00:00 T:2912   ERROR: Unable to copy old database xbmc_video to new version xbmc_video60

17:00:02 T:2912  NOTICE: initialize done

I had to snip out it repeating the
ERROR: Unable to open database: xbmc_video##
where ## is 60 - 1
as pastebin said it was too large.

pyro42 · 2012-03-05, 02:45

jmarshall Wrote:The log files are useless once the update has already failed. We need the very first update (i.e. the one that caused the screwup).

Remove any xbmc_video60 databases and see if you can reproduce.

i dare say i cannot. it would seem dropping the xbmc_video60 db has fixed my crashing problem on both ATV2 and Win7. The only thing i did differently this time i was i had uninstalled the org.tomcool.xbmc-booter from my atv2. I'm on my meal break atm, but i can test if its the xbmcbooter that caused the problem when i get home tonight.

Although i still cannot export my music library >.>

jmarshall · 2012-03-05, 03:32

Quote:I created a new (nothing in it) xbmc_video database.

DO NOT DO THIS!!!!!!!!!!

Read the Wiki and follow the instructions instead: http://wiki.xbmc.org/index.php?title=HOW..._libraries

~~Ned Scott~~ · 2012-03-05, 04:31

Eden will add the DB number to whatever you used for <name>. This is normal. Don't edit the advancedsettings.xml file to point to name+number as then XBMC will try to make name+number+number.