beta 2/3 not reading 'sources' xml file

labtopia · 2012-12-08 22:45

ive tried both b2 and 3 of frodo and my sources file is not being parsed. i use xbmc with multiple systems and use sources and advanced xml to make the libraries share.

beta1 works fine in this scenario.

any ideas?

**davilla** · 2012-12-08 23:04

xbmc.log or it did not happen Smile

labtopia · 2012-12-13 03:19

(2012-12-08 23:04)davilla Wrote: xbmc.log or it did not happen

Code:

07:28 T:6280  NOTICE: -----------------------------------------------------------------------

07:28 T:6280  NOTICE: Starting XBMC (12.0-RC1 Git:20121210-baaa51c), Platform: Windows 7 SP1 32-bit, build 7601. Built on Dec 10 2012 (compiler 1600)

07:28 T:6280  NOTICE: Loaded settings file from special://profile/advancedsettings.xml

07:28 T:6280  NOTICE: Contents of special://profile/advancedsettings.xml are...

                                            <advancedsettings>

                                              <videodatabase>

                                                <type>mysql</type>

                                                <host>10.1.1.152</host>

                                                <port>3306</port>

                                                <user>xbmc</user>

                                                <pass>xbmc</pass>

                                                <name>LABTOPIAvideo</name>

                                              </videodatabase>

                                              <musicdatabase>

                                                <type>mysql</type>

                                                <host>10.1.1.152</host>

                                                <port>3306</port>

                                                <user>xbmc</user>

                                                <pass>xbmc</pass>

                                                <name>LABTOPIAmusic</name>

                                              </musicdatabase>

                                            </advancedsettings>

07:29 T:6280  NOTICE: Running database version Addons15

07:29 T:6280  NOTICE: Running database version ViewModes4

07:29 T:6280  NOTICE: Running database version Textures13

07:29 T:6280  NOTICE: Running database version LABTOPIAmusic32

07:29 T:6280  NOTICE: Attempting to update the database LABTOPIAvideo75 from version 72 to 75

07:30 T:6280   ERROR: SQL: Undefined MySQL error: Code (1235)

                                            Query: CREATE TRIGGER delete_tag AFTER DELETE ON taglinks FOR EACH ROW BEGIN DELETE FROM tag WHERE idTag=old.idTag AND idTag NOT IN (SELECT DISTINCT idTag FROM taglinks); END

07:30 T:6280   ERROR: Exception updating database LABTOPIAvideo75 from version 72 to 75

07:30 T:6280   ERROR: Error updating database LABTOPIAvideo75 from version 72 to 75

07:30 T:6280   ERROR: Unable to open database: LABTOPIAvideo74 [1049](Unknown database 'labtopiavideo74')

07:30 T:6280   ERROR: Unable to open database: LABTOPIAvideo73 [1049](Unknown database 'labtopiavideo73')

07:30 T:6280  NOTICE: Old database found - updating from version 72 to 75

07:30 T:6280   ERROR: SQL: Can't create database for copy: 'LABTOPIAvideo72' (1007)

07:30 T:6280   ERROR: Unable to copy old database LABTOPIAvideo72 to new version LABTOPIAvideo75

07:30 T:6280  NOTICE: Running database version TV22

07:30 T:6280  NOTICE: Running database version Epg7

07:30 T:6280  NOTICE: initializing playlistplayer

07:30 T:6280  NOTICE: DONE initializing playlistplayer

07:30 T:2720  NOTICE: Thread XBPyThread start, auto delete: false

07:30 T:6280  NOTICE: CApplication::UpdateLibraries - Starting video library startup scan

07:30 T:6280  NOTICE: initialize done

07:30 T:7728  NOTICE: Thread CVideoInfoScanner start, auto delete: false

07:30 T:7728  NOTICE: VideoInfoScanner: Starting scan ..

07:30 T:2828  NOTICE: Thread XBPyThread start, auto delete: false

07:30 T:7728  NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:00

07:30 T:6448  NOTICE: Thread XBPyThread start, auto delete: false

07:30 T:2720  NOTICE: Previous line repeats 1 times.

07:30 T:2720  NOTICE: -->Python Interpreter Initialized<--

07:31 T:6280  NOTICE: Running the application...

07:31 T:6116  NOTICE: -->Python Interpreter Initialized<--

07:31 T:2828  NOTICE: -->Python Interpreter Initialized<--

07:31 T:6448  NOTICE: -->Python Interpreter Initialized<--

07:31 T:2720  NOTICE: service.libraryautoupdate: Update Library Service starting...

07:31 T:6124  NOTICE: Thread Jobworker start, auto delete: true

07:31 T:6280  NOTICE: Webserver: Starting...

07:31 T:6280  NOTICE: WebServer: Started the webserver

07:31 T:6280  NOTICE: starting upnp server

07:31 T:6280  NOTICE: starting upnp renderer

07:31 T:6116  NOTICE:  StorageServer Module loaded RUN

07:31 T:6116  NOTICE: StorageClient-1.3.0 Starting server

07:31 T:6116  NOTICE: StorageServer-1.3.0 Storage Server starting C:\Users\lab\AppData\Roaming\XBMC\userdata\Database\commoncache.db

07:31 T:6280  NOTICE: ES: Starting event server

07:31 T:8160  NOTICE: Thread CEventServer start, auto delete: false

07:31 T:8160  NOTICE: ES: Starting UDP Event server on 0.0.0.0:9777

07:31 T:8160  NOTICE: UDP: Listening on port 9777

07:31 T:6280  NOTICE: starting zeroconf publishing

07:31 T:1704  NOTICE: Thread CTCPServer start, auto delete: false

07:31 T:4364  NOTICE: Thread Jobworker start, auto delete: true

07:31 T:4624  NOTICE: Thread CRssReader start, auto delete: false

07:31 T:2720  NOTICE: service.libraryautoupdate: update timers

07:32 T:2720  NOTICE: service.libraryautoupdate: Update Video Library

07:32 T:1860  NOTICE: Thread CVideoInfoScanner start, auto delete: false

07:32 T:1860  NOTICE: VideoInfoScanner: Starting scan ..

07:32 T:1860  NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:00

07:38 T:3332  NOTICE: Thread Background Loader start, auto delete: false

07:42 T:4080  NOTICE: Previous line repeats 1 times.

07:42 T:4080  NOTICE: Thread Jobworker start, auto delete: true

07:43 T:5868  NOTICE: Thread Background Loader start, auto delete: false

07:45 T:6280   ERROR: CGUIWindowVideoBase::GetResumeItemOffset - Cannot open VideoDatabase

07:48 T:6280  NOTICE: DVDPlayer: Opening: smb://10.1.1.152/g/video/movies/'The Maxx' (1995)/'The Maxx' (1995).mp4

07:48 T:6280 WARNING: CDVDMessageQueue(player)::Put MSGQ_NOT_INITIALIZED

07:48 T:5420  NOTICE: Thread CDVDPlayer start, auto delete: false

07:48 T:5420  NOTICE: Creating InputStream

07:48 T:5420  NOTICE: Creating Demuxer

07:48 T:5420  NOTICE: Opening video stream: 0 source: 256

07:48 T:5420  NOTICE: Creating video codec with codec id: 28

07:48 T:5420  NOTICE: CDVDVideoCodecFFmpeg::Open() Using codec: H.264 / AVC / MPEG-4 AVC / MPEG-4 part 10

07:48 T:5420  NOTICE: Creating video thread

07:48 T:5420  NOTICE: Opening audio stream: 1 source: 256

07:48 T:5420  NOTICE: Finding audio codec for: 86018

07:48 T:5420  NOTICE: Creating audio thread

07:48 T:3356  NOTICE: Thread CDVDPlayerVideo start, auto delete: false

07:48 T:3356  NOTICE: running thread: video_thread

07:48 T:5420  NOTICE: Opening Subtitle stream: 2 source: 256

07:48 T:3356  NOTICE:  fps: 29.970030, pwidth: 640, pheight: 480, dwidth: 640, dheight: 480

07:48 T:3356  NOTICE: Display resolution USER : 1184x666 @ 60.00 - Full Screen #2 (17)

07:48 T:5260  NOTICE: Thread CDVDPlayerAudio start, auto delete: false

07:48 T:5260  NOTICE: running thread: CDVDPlayerAudio::Process()

07:48 T:5260  NOTICE: Creating audio stream (codec id: 86018, channels: 2, sample rate: 48000, no pass-through)

07:51 T:1928  NOTICE: Thread Background Loader start, auto delete: false

looks like the database is failing to upgrade, a downgrade to beta1, everything works fine.

any ideas-does it not like the <name> that it was originally created as? i read that might be a problem.

thank[/php]

labtopia · 2012-12-13 06:47

i found a solution after messing with it for a while, the log shows it could not upgrade the database, so i let it make the new 'libararyname75' folder in my sql program data folder, copied everything out of the 'libraryname72' folder and put it in the 75 folder. now i started xbmc and it sat and chewed for a little and everything came back up as it should. TV and Movies now show in the menu, and library is intact.

hope this helps anyone that has this issue upgrading.

not sure why this worked, or why it couldnt copy the old database to the new db folder. (maybe because i had used some nightlies here and there and that did something to the db) but running now.

dave

**Ned Scott** · 2012-12-13 06:49

If the name tag was working with beta1 then that's probably not the issue. Normally we need a log file with debugging turned on, but this might still be enough for our devs to see what's going on. Just in case you might want to throw up a full debugging log file up on pastebin.com (see debug log).

EDIT: ah, good to hear it's running now.

Monkeysweat · 2012-12-13 11:36

I have an issue that happened in beta 2 or 3 and is still there on rc1 where I can no longer see the networked share files (like to go in and manually refresh a movie that never scraped) I can only see the USB drives that are connected. But all new movies and tv shows added to the networked folders do get added to the library still so XBMC is obviously having no issue accessing the directories. The networked folders are on the hard drives located on the same machine running XBMC.

**Ned Scott** · 2012-12-13 13:38

(2012-12-13 11:36)Monkeysweat Wrote: I have an issue that happened in beta 2 or 3 and is still there on rc1 where I can no longer see the networked share files (like to go in and manually refresh a movie that never scraped) I can only see the USB drives that are connected. But all new movies and tv shows added to the networked folders do get added to the library still so XBMC is obviously having no issue accessing the directories. The networked folders are on the hard drives located on the same machine running XBMC.

Now that does sound like the sources file not being read. labtopia's issue was likely different, because as you can see, XBMC doesn't actually use the sources.xml file after it has "content set" for the library. It's kind of like an nfo file in a way, in that it's only read once or if it's been edited ("refreshed"), and then the actual network path for library updates is stored in the library DB.

Can you get us a debug log? That might tell us what's going on there.

Monkeysweat · 2012-12-17 06:49

I figured it out, when you said sources not being processed I took a look and my smb shares did not have xbmc as able to access where sources.xml file was, that corrected it once i shared sources over the network.

Thanks!

labtopia Junior Member Posts: 21 Joined: Jun 2010 Reputation: 0	2012-12-08 22:45 Post: #1 ive tried both b2 and 3 of frodo and my sources file is not being parsed. i use xbmc with multiple systems and use sources and advanced xml to make the libraries share. beta1 works fine in this scenario. any ideas?
	find quote

davilla Team-XBMC Developer Posts: 10,505 Joined: Feb 2008 Reputation: 58	2012-12-08 23:04 Post: #2 xbmc.log or it did not happen MediaInfo : http://mediainfo.sourceforge.net/ Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
	find quote

Monkeysweat Member Posts: 52 Joined: Jun 2010 Reputation: 0	2012-12-17 06:49 Post: #8 I figured it out, when you said sources not being processed I took a look and my smb shares did not have xbmc as able to access where sources.xml file was, that corrected it once i shared sources over the network. Thanks!
	find quote