Login at Kodi Home

canadave · (This post was last modified: 2011-10-22, 14:29 by canadave.)

*** EDIT ***: Thought that this problem I originally wrote about below was on my end, but in light of the fact that forum.xbmc.org is really slow for me today, and there seems to be a broken nightly on only one mirror, I'm wondering if there's some larger issue with xbmc.org?
*************

So, woke up this beautiful morning, yawned, decided to upgrade to latest nightly as always. And this happened.

Code:
(Reading database ... 3487 files and directories currently installed.)

Preparing to replace org.xbmc.xbmc-atv2 10.0-9 (using xbmc-20111021-79cceb5-master-atv2.deb) ...

Unpacking replacement org.xbmc.xbmc-atv2 ...

dpkg-deb (subprocess): short read in buffer_copy (failed to write to pipe in copy)

dpkg-deb: subprocess paste returned error exit status 2

dpkg: error processing xbmc-20111021-79cceb5-master-atv2.deb (--install):

short read in buffer_copy (backend dpkg-deb during `./Applications/XBMC.frappliance/Frameworks/libsmbclient.dylib.0')

chown: cannot access `/Applications/XBMC.frappliance': No such file or directory

Errors were encountered while processing:

xbmc-20111021-79cceb5-master-atv2.deb

No such file or directory? You're kidding? Nope, not kidding--went and had a look, and XBMC.frappliance is no longer there. Hmmm.

Good morning! Smile

I guess the only thing to do at this point is back up my /var/mobile folder (the contents of THAT are still there, at least) and reinstall from scratch?

**Memphiz** · 2011-10-22, 14:07

Looks like your deb is broken ... no need to rejb ... just retry the download and install again ...

canadave · 2011-10-22, 14:09

oh.

LOL!! Thanks Memphiz...I was panicking there a bit Wink

I'll redownload and try again.

canadave · (This post was last modified: 2011-10-22, 16:59 by canadave.)

Hmmm, interesting. Is there a mirroring issue? Looks like the latest build, from a few hours ago, is only on one mirror server, which is currently hung up completely for me.

http://mirrors.xbmc.org/nightlies/darwin...mirrorlist

*** EDIT ***:
And...now everything's fine Smile

never mind folks, move along, nothing to see here!

canadave · (This post was last modified: 2011-12-01, 21:02 by canadave.)

Hmmm. This just happened to me again ("cannot access /Applications/XBMC.frappliance: no directory found"). There's nothing in /var/mobile/Applications. But unlike last time, this time I tried again and installed the Nov 28 nightly (successfully), and it still doesn't work--I see XBMC in the FrontRow screen, but when I click it, the Apple TV just reboots. And there's still nothing in /Applications. Tried again with Dec 1 nightly, same thing.

Yikes! Any ideas?

Code:
57:23 T:106385408  NOTICE: -----------------------------------------------------------------------

57:24 T:106385408  NOTICE: Starting XBMC, Platform: Darwin iOS (11.0.0 AppleTV2,1). Built on Dec  1 2011 (Git:20111129-b67a2a4)

57:24 T:106385408  NOTICE: special://xbmc/ is mapped to: /private/var/stash/Applications/XBMC.frappliance/XBMCData/XBMCHome

57:24 T:106385408  NOTICE: special://xbmcbin/ is mapped to: /private/var/stash/Applications/XBMC.frappliance/XBMCData/XBMCHome

57:24 T:106385408  NOTICE: special://masterprofile/ is mapped to: /var/mobile/Library/Preferences/XBMC/userdata

57:24 T:106385408  NOTICE: special://home/ is mapped to: /var/mobile/Library/Preferences/XBMC

57:24 T:106385408  NOTICE: special://temp/ is mapped to: /var/mobile/Library/Preferences/XBMC/temp

57:24 T:106385408  NOTICE: special://frameworks/ is mapped to: /var/stash/Applications/XBMC.frappliance/Frameworks

57:24 T:106385408  NOTICE: The executable running is: /var/stash/Applications/XBMC.frappliance/XBMC

57:24 T:106385408  NOTICE: Log File is located: /var/mobile/Library/Preferences/xbmc.log

57:24 T:106385408  NOTICE: -----------------------------------------------------------------------

57:24 T:106385408  NOTICE: load settings...

57:24 T:106385408  NOTICE: special://profile/ is mapped to: special://masterprofile/

57:24 T:106385408  NOTICE: loading special://masterprofile/guisettings.xml

57:24 T:106385408  NOTICE: Getting hardware information now...

57:24 T:106385408    INFO: Using digital output

57:24 T:106385408    INFO: AC3 pass through is enabled

57:24 T:106385408    INFO: DTS pass through is enabled

57:24 T:106385408    INFO: AAC pass through is disabled

57:24 T:106385408    INFO: MP1 pass through is disabled

57:24 T:106385408    INFO: MP2 pass through is disabled

57:24 T:106385408    INFO: MP3 pass through is disabled

57:24 T:106385408   DEBUG: Error: Requested setting (videoscreen.screenmode) was not found.  It must be case-sensitive

57:24 T:106385408  NOTICE: Checking resolution 12

57:24 T:106385408  NOTICE: Loading player core factory settings from special://xbmc/system/playercorefactory.xml.

57:24 T:106385408   DEBUG: CPlayerCoreConfig::<ctor>: created player DVDPlayer for core 1

57:24 T:106385408   DEBUG: CPlayerCoreConfig::<ctor>: created player oldmplayercore for core 1

57:24 T:106385408   DEBUG: CPlayerCoreConfig::<ctor>: created player PAPlayer for core 3

57:24 T:106385408   DEBUG: CPlayerSelectionRule::Initialize: creating rule: system rules

57:24 T:106385408   DEBUG: CPlayerSelectionRule::Initialize: creating rule: rtv

57:24 T:106385408   DEBUG: CPlayerSelectionRule::Initialize: creating rule: hdhomerun/myth/rtmp/mms/udp

57:24 T:106385408   DEBUG: CPlayerSelectionRule::Initialize: creating rule: lastfm/shout

57:24 T:106385408   DEBUG: CPlayerSelectionRule::Initialize: creating rule: rtsp

57:24 T:106385408   DEBUG: CPlayerSelectionRule::Initialize: creating rule: streams

57:24 T:106385408   DEBUG: CPlayerSelectionRule::Initialize: creating rule: flv/aacp/sdp

57:24 T:106385408   DEBUG: CPlayerSelectionRule::Initialize: creating rule: mp2

57:24 T:106385408   DEBUG: CPlayerSelectionRule::Initialize: creating rule: dvd

57:24 T:106385408   DEBUG: CPlayerSelectionRule::Initialize: creating rule: dvdfile

57:24 T:106385408   DEBUG: CPlayerSelectionRule::Initialize: creating rule: dvdimage

57:24 T:106385408   DEBUG: CPlayerSelectionRule::Initialize: creating rule: sdp/asf

57:24 T:106385408   DEBUG: CPlayerSelectionRule::Initialize: creating rule: nsv

57:24 T:106385408  NOTICE: Loaded playercorefactory configuration

57:24 T:106385408  NOTICE: Loading player core factory settings from special://masterprofile/playercorefactory.xml.

57:24 T:106385408  NOTICE: special://masterprofile/playercorefactory.xml does not exist. Skipping.

57:24 T:106385408  NOTICE: No settings file to load to load (special://xbmc/system/advancedsettings.xml)

57:24 T:106385408  NOTICE: Loaded settings file from special://profile/advancedsettings.xml

57:24 T:106385408  NOTICE: Contents of special://profile/advancedsettings.xml are...

                                            <advancedsettings>

                                              <videodatabase>

                                                <type>mysql</type>

                                                <host>192.168.1.211</host>

                                                <port>3306</port>

                                                <user>xbmc</user>

                                                <pass>xbmc</pass>

                                                <name>xbmc_video</name>

                                              </videodatabase>

                                              <musicdatabase>

                                                <type>mysql</type>

                                                <host>192.168.1.211</host>

                                                <port>3306</port>

                                                <user>xbmc</user>

                                                <pass>xbmc</pass>

                                                <name>xbmc_music</name>

                                              </musicdatabase>

                                              <videoextensions>

                                                <add>.html</add>

                                              </videoextensions>

                                              <video>

                                                <playcountminimumpercent>90</playcountminimumpercent>

                                              </video>

                                              <busydialogdelay>20000</busydialogdelay>

                                              <loglevel>1</loglevel>

                                              <network>

                                                <cachemembuffersize>0</cachemembuffersize>

                                              </network>

                                            </advancedsettings>

57:24 T:106385408  NOTICE: Log level changed to 1

57:24 T:106385408 WARNING: VIDEO database configuration is experimental.

57:24 T:106385408  NOTICE: Getting hardware information now...

57:24 T:106385408    INFO: Using digital output

57:24 T:106385408    INFO: AC3 pass through is enabled

57:24 T:106385408    INFO: DTS pass through is enabled

57:24 T:106385408    INFO: AAC pass through is disabled

57:24 T:106385408    INFO: MP1 pass through is disabled

57:24 T:106385408    INFO: MP2 pass through is disabled

57:24 T:106385408    INFO: MP3 pass through is disabled

57:24 T:106385408   DEBUG: Error: Requested setting (videoscreen.screenmode) was not found.  It must be case-sensitive

57:24 T:106385408  NOTICE: Checking resolution 12

57:24 T:106385408  NOTICE: Default DVD Player: dvdplayer

57:24 T:106385408  NOTICE: Default Video Player: dvdplayer

57:24 T:106385408  NOTICE: Default Audio Player: paplayer

57:24 T:106385408  NOTICE: Disabled debug logging due to GUI setting. Level 1.

57:24 T:106385408  NOTICE: Log level changed to 1

57:24 T:106385408  NOTICE: Loading media sources from special://masterprofile/sources.xml

57:24 T:106385408   DEBUG:     Setting <default> source to : Music

57:24 T:106385408    INFO: creating subdirectories

57:24 T:106385408    INFO: userdata folder: special://masterprofile/

57:24 T:106385408    INFO: recording folder:

57:24 T:106385408    INFO: screenshots folder:

57:24 T:106385408    INFO: thumbnails folder: special://masterprofile/Thumbnails

57:25 T:106385408    INFO: load language info file: special://xbmc/language/English/langinfo.xml

57:25 T:106385408   DEBUG: trying to set locale to en_CA.UTF-8

57:25 T:106385408    INFO: global locale set to C

57:25 T:106385408    INFO: load language file:special://xbmc/language/English/strings.xml

57:25 T:106385408   DEBUG: SECTION:LoadDLL(special://xbmcbin/system/libcpluff-arm-osx.so)

57:25 T:106385408   DEBUG: Loading: /private/var/stash/Applications/XBMC.frappliance/XBMCData/XBMCHome/system/libcpluff-arm-osx.so

57:25 T:106385408   ERROR: SQL: The database disk image is malformed

                                            Query: SELECT idVersion FROM version

davilla · 2011-12-01, 21:09

ERROR: SQL: The database disk image is malformed

canadave · (This post was last modified: 2011-12-01, 21:19 by canadave.)

Yep, I see that...but I can connect to my NAS-based SQL (XBMC video/music) databases from elsewhere and access them and browse them without any problems...and I didn't make any changes to anything on that end. Odd! Not quite sure where to go from here to troubleshoot that.

canadave · 2011-12-01, 22:26

Well, this is interesting.

Not knowing what else to do, I blew away my XBMC video/music SQL databases on my NAS (after exporting them as a backup first) and then recreated the databases. When I try to import the backed up data into the newly created databases in phpMyAdmin, I get errors. For the video database, for instance, I get this:

Code:
Error

SQL query: Documentation

-- -------------------------------------------------------- -- -- Table structure for table `episodeview` -- CREATE ALGORITHM=UNDEFINED DEFINER=`xbmc`@`%` SQL SECURITY DEFINER VIEW `xbmc_video`.`episodeview` AS select `xbmc_video`.`episode`.`idEpisode` AS `idEpisode`,`xbmc_video`.`episode`.`idFile` AS `idFile`,`xbmc_video`.`episode`.`c00` AS `c00`,`xbmc_video`.`episode`.`c01` AS `c01`,`xbmc_video`.`episode`.`c02` AS `c02`,`xbmc_video`.`episode`.`c03` AS `c03`,`xbmc_video`.`episode`.`c04` AS `c04`,`xbmc_video`.`episode`.`c05` AS `c05`,`xbmc_video`.`episode`.`c06` AS `c06`,`xbmc_video`.`episode`.`c07` AS `c07`,`xbmc_video`.`episode`.`c08` AS `c08`,`xbmc_video`.`episode`.`c09` AS `c09`,`xbmc_video`.`episode`.`c10` AS `c10`,`xbmc_video`.`episode`.`c11` AS `c11`,`xbmc_video`.`episode`.`c12` AS `c12`,`xbmc_video`.`episode`.`c13` AS `c13`,`xbmc_video`.`episode`.`c14` AS `c14`,`xbmc_video`.`episode`.`c15` AS `c15`,`xbmc_video`.`episode`.`c16` AS `c16`,`xbmc_video`.`episode`.`c17` AS `c17`,[...]

MySQL said: Documentation

#1146 - Table 'xbmc_video.files' doesn't exist

That error occurs while it's trying to create the "episode" table. All tables alphabetically before "episode" are created and populated with data without a problem, but the error above stops the import. I get a similar error occur with the music database: it's another SQL error #1146, except this time it says "Table 'xbmc_music.thumb' doesn't exist". Again some tables are created before it, but that error halts the import.

What in the world Huh

canadave · (This post was last modified: 2011-12-02, 08:13 by canadave.)

Okay...guys, I know I probably screwed this up somehow on my own, but I could use a hand right about now. Or a hug Smile

I have no idea why my XBMC suddenly went haywire on me. End result: I deleted my XBMC folder from my ATV2 and reinstalled the latest nightly. I also deleted my databases from my NAS and recreated them manually.

Now, when I go into XBMC, it's incredibly unresponsive. And I see why:

http://pastebin.com/8pz4KPW7

...but I don't know what to do about that Sad

I know the SQL database is empty...but what am I supposed to do here?

I just tried deleting the SQL databases again (this is all being done in phpMyAdmin btw) and letting XBMC create them itself via the advancedsettings.xml file. But instead of creating "xbmc_video" and "xbmc_music", it creates "xbmc_video57" and "xbmc_music18". I renamed those to xbmc_video and xbmc_music, rebooted XBMC, and now I have FOUR databases; those two, plus, again, xbmc_video57 and xbmc_music18. Ugh!!

**Memphiz** · 2011-12-02, 12:13

canadave Wrote:Okay...guys, I know I probably screwed this up somehow on my own, but I could use a hand right about now. Or a hug

I have no idea why my XBMC suddenly went haywire on me. End result: I deleted my XBMC folder from my ATV2 and reinstalled the latest nightly. I also deleted my databases from my NAS and recreated them manually.

Now, when I go into XBMC, it's incredibly unresponsive. And I see why:

http://pastebin.com/8pz4KPW7

...but I don't know what to do about that I know the SQL database is empty...but what am I supposed to do here?

I just tried deleting the SQL databases again (this is all being done in phpMyAdmin btw) and letting XBMC create them itself via the advancedsettings.xml file. But instead of creating "xbmc_video" and "xbmc_music", it creates "xbmc_video57" and "xbmc_music18". I renamed those to xbmc_video and xbmc_music, rebooted XBMC, and now I have FOUR databases; those two, plus, again, xbmc_video57 and xbmc_music18. Ugh!!

Let XBMC create the DBs and don't touch em. the 57 and 18 are the structure versions and are needed. The way DB updates are working on mysql was changed so that it works identically like with sqlite. So everything looks ok - you just keep your hands off, after xbmc did its job creating the db.

canadave · 2011-12-02, 16:21

Memphiz Wrote:Let XBMC create the DBs and don't touch em. the 57 and 18 are the structure versions and are needed. The way DB updates are working on mysql was changed so that it works identically like with sqlite. So everything looks ok - you just keep your hands off, after xbmc did its job creating the db.

Oh....lol well THAT might explain a few things Smile

So I need to change my advancedsettings.xml so that it points to "xbmc_video57" rather than "xbmc_video", I guess?

Thanks...that was driving me crazy!

jschoen · 2011-12-02, 16:59

Quote:So I need to change my advancedsettings.xml so that it points to "xbmc_video57" rather than "xbmc_video", I guess?

No!!! Don't do that. I am not an expert from my understanding here is how it works.

The DB name you have in advanced settings is used as the prefix for the name of the DB that will be used. It is appeneded with a number that changes with each version of the db.

So on startup it gets the prefix of the db name from advanced settings, then looks for the latest DB schema. Once found it checks if it needs to be updated, if it does, it copys the newest schema you already have and changes the number on the end to the appropriate version. Then it updates the schema it just copied with any needed changes.

So if you change the name in advanced settings to be 'xbmc_video57' the schema name could end up being 'xbmc_video5757'.

Why did they do this? One of the problems use to be when you upgraded to a newer version (nightly for example) it upgraded your dbschema, which will not work with older versions. So if there was an issue, it was next to impossible to rollback. Now you just downgrade xbmc, delete the schema it created and you are back to where you were before.

Please Note that this is just what I pieced together from reading the forum and what not.

canadave · 2011-12-02, 17:04

jschoen, I think I know what you're thinking of with that, but I don't think that's what's happening here Smile

FWIW, before you replied, I did change my advancedsettings.xml to point to xbmc_video57, and it worked fine.

All advancedsettings.xml does is tell XBMC where to connect to your SQL database. When I let XBMC create the database on my NAS, it created "xbmc_video57" without my needing to. Then, in advancedsettings.xml, I told XBMC to go connect to that database. That seems to have worked perfectly.

Note that I was not using advancedsettings.xml to tell XBMC *what to name* the database; I was just telling it where to connect to the existing database.

jschoen · 2011-12-02, 17:25

My undertanding is if you have

Quote:<videodatabase>
<type>mysql</type>
<host>***.***.***.***</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>SOME_NAME</name>
</videodatabase>

Then it would end up creating schemas named SOME_NAME57 and SOME_NAME58 as the db is upgraded. Since we have to be able to define a part of the schema name so we can have different schemas for each profile.

canadave · 2011-12-02, 17:37

You know what? I totally apologize...you are absolutely right! :0 That's exactly what happened. Yikes!