beta 2/3 not reading 'sources' xml file

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
labtopia Offline
Junior Member
Posts: 26
Joined: Jun 2010
Reputation: 0
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 Offline
Retired-Team-XBMC Developer
Posts: 11,508
Joined: Feb 2008
Reputation: 64
Post: #2
xbmc.log or it did not happen Smile


MediaInfo : http://mediainfo.sourceforge.net/
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
find quote
labtopia Offline
Junior Member
Posts: 26
Joined: Jun 2010
Reputation: 0
Post: #3
(2012-12-08 23:04)davilla Wrote:  xbmc.log or it did not happen Smile

Code:
20:07:28 T:6280  NOTICE: -----------------------------------------------------------------------
20: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)

20:07:28 T:6280  NOTICE: Loaded settings file from special://profile/advancedsettings.xml
20: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>

20:07:29 T:6280  NOTICE: Running database version Addons15
20:07:29 T:6280  NOTICE: Running database version ViewModes4
20:07:29 T:6280  NOTICE: Running database version Textures13
20:07:29 T:6280  NOTICE: Running database version LABTOPIAmusic32
20:07:29 T:6280  NOTICE: Attempting to update the database LABTOPIAvideo75 from version 72 to 75
20: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
20:07:30 T:6280   ERROR: Exception updating database LABTOPIAvideo75 from version 72 to 75
20:07:30 T:6280   ERROR: Error updating database LABTOPIAvideo75 from version 72 to 75
20:07:30 T:6280   ERROR: Unable to open database: LABTOPIAvideo74 [1049](Unknown database 'labtopiavideo74')
20:07:30 T:6280   ERROR: Unable to open database: LABTOPIAvideo73 [1049](Unknown database 'labtopiavideo73')
20:07:30 T:6280  NOTICE: Old database found - updating from version 72 to 75
20:07:30 T:6280   ERROR: SQL: Can't create database for copy: 'LABTOPIAvideo72' (1007)
20:07:30 T:6280   ERROR: Unable to copy old database LABTOPIAvideo72 to new version LABTOPIAvideo75
20:07:30 T:6280  NOTICE: Running database version TV22
20:07:30 T:6280  NOTICE: Running database version Epg7
20:07:30 T:6280  NOTICE: initializing playlistplayer
20:07:30 T:6280  NOTICE: DONE initializing playlistplayer
20:07:30 T:2720  NOTICE: Thread XBPyThread start, auto delete: false
20:07:30 T:6280  NOTICE: CApplication::UpdateLibraries - Starting video library startup scan
20:07:30 T:6280  NOTICE: initialize done
20:07:30 T:7728  NOTICE: Thread CVideoInfoScanner start, auto delete: false
20:07:30 T:7728  NOTICE: VideoInfoScanner: Starting scan ..
20:07:30 T:2828  NOTICE: Thread XBPyThread start, auto delete: false
20:07:30 T:7728  NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:00
20:07:30 T:6448  NOTICE: Thread XBPyThread start, auto delete: false
20:07:30 T:2720  NOTICE: Previous line repeats 1 times.
20:07:30 T:2720  NOTICE: -->Python Interpreter Initialized<--
20:07:31 T:6280  NOTICE: Running the application...
20:07:31 T:6116  NOTICE: -->Python Interpreter Initialized<--
20:07:31 T:2828  NOTICE: -->Python Interpreter Initialized<--
20:07:31 T:6448  NOTICE: -->Python Interpreter Initialized<--
20:07:31 T:2720  NOTICE: service.libraryautoupdate: Update Library Service starting...
20:07:31 T:6124  NOTICE: Thread Jobworker start, auto delete: true
20:07:31 T:6280  NOTICE: Webserver: Starting...
20:07:31 T:6280  NOTICE: WebServer: Started the webserver
20:07:31 T:6280  NOTICE: starting upnp server
20:07:31 T:6280  NOTICE: starting upnp renderer
20:07:31 T:6116  NOTICE:  StorageServer Module loaded RUN
20:07:31 T:6116  NOTICE: StorageClient-1.3.0 Starting server
20:07:31 T:6116  NOTICE: StorageServer-1.3.0 Storage Server starting C:\Users\lab\AppData\Roaming\XBMC\userdata\Database\commoncache.db
20:07:31 T:6280  NOTICE: ES: Starting event server
20:07:31 T:8160  NOTICE: Thread CEventServer start, auto delete: false
20:07:31 T:8160  NOTICE: ES: Starting UDP Event server on 0.0.0.0:9777
20:07:31 T:8160  NOTICE: UDP: Listening on port 9777
20:07:31 T:6280  NOTICE: starting zeroconf publishing
20:07:31 T:1704  NOTICE: Thread CTCPServer start, auto delete: false
20:07:31 T:4364  NOTICE: Thread Jobworker start, auto delete: true
20:07:31 T:4624  NOTICE: Thread CRssReader start, auto delete: false
20:07:31 T:2720  NOTICE: service.libraryautoupdate: update timers
20:07:32 T:2720  NOTICE: service.libraryautoupdate: Update Video Library
20:07:32 T:1860  NOTICE: Thread CVideoInfoScanner start, auto delete: false
20:07:32 T:1860  NOTICE: VideoInfoScanner: Starting scan ..
20:07:32 T:1860  NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:00
20:07:38 T:3332  NOTICE: Thread Background Loader start, auto delete: false
20:07:42 T:4080  NOTICE: Previous line repeats 1 times.
20:07:42 T:4080  NOTICE: Thread Jobworker start, auto delete: true
20:07:43 T:5868  NOTICE: Thread Background Loader start, auto delete: false
20:07:45 T:6280   ERROR: CGUIWindowVideoBase::GetResumeItemOffset - Cannot open VideoDatabase
20:07:48 T:6280  NOTICE: DVDPlayer: Opening: smb://10.1.1.152/g/video/movies/'The Maxx' (1995)/'The Maxx' (1995).mp4
20:07:48 T:6280 WARNING: CDVDMessageQueue(player)::Put MSGQ_NOT_INITIALIZED
20:07:48 T:5420  NOTICE: Thread CDVDPlayer start, auto delete: false
20:07:48 T:5420  NOTICE: Creating InputStream
20:07:48 T:5420  NOTICE: Creating Demuxer
20:07:48 T:5420  NOTICE: Opening video stream: 0 source: 256
20:07:48 T:5420  NOTICE: Creating video codec with codec id: 28
20:07:48 T:5420  NOTICE: CDVDVideoCodecFFmpeg::Open() Using codec: H.264 / AVC / MPEG-4 AVC / MPEG-4 part 10
20:07:48 T:5420  NOTICE: Creating video thread
20:07:48 T:5420  NOTICE: Opening audio stream: 1 source: 256
20:07:48 T:5420  NOTICE: Finding audio codec for: 86018
20:07:48 T:5420  NOTICE: Creating audio thread
20:07:48 T:3356  NOTICE: Thread CDVDPlayerVideo start, auto delete: false
20:07:48 T:3356  NOTICE: running thread: video_thread
20:07:48 T:5420  NOTICE: Opening Subtitle stream: 2 source: 256
20:07:48 T:3356  NOTICE:  fps: 29.970030, pwidth: 640, pheight: 480, dwidth: 640, dheight: 480
20:07:48 T:3356  NOTICE: Display resolution USER : 1184x666 @ 60.00 - Full Screen #2 (17)
20:07:48 T:5260  NOTICE: Thread CDVDPlayerAudio start, auto delete: false
20:07:48 T:5260  NOTICE: running thread: CDVDPlayerAudio::Process()
20:07:48 T:5260  NOTICE: Creating audio stream (codec id: 86018, channels: 2, sample rate: 48000, no pass-through)
20: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]
find quote
labtopia Offline
Junior Member
Posts: 26
Joined: Jun 2010
Reputation: 0
Post: #4
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
find quote
Ned Scott Offline
Team-Kodi Wiki Guy
Posts: 21,202
Joined: Jan 2011
Reputation: 276
Location: Arizona, USA
Post: #5
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.

You can make easy links to the XBMC wiki using double brackets around common XBMC words: [[debug log]] = debug log, [[Video library]] = Video library, [[SMB]] = SMB , [[userdata]] = userdata, etc
(This post was last modified: 2012-12-13 06:50 by Ned Scott.)
find quote
Monkeysweat Offline
Member
Posts: 53
Joined: Jun 2010
Reputation: 0
Post: #6
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.
find quote
Ned Scott Offline
Team-Kodi Wiki Guy
Posts: 21,202
Joined: Jan 2011
Reputation: 276
Location: Arizona, USA
Post: #7
(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.

You can make easy links to the XBMC wiki using double brackets around common XBMC words: [[debug log]] = debug log, [[Video library]] = Video library, [[SMB]] = SMB , [[userdata]] = userdata, etc
find quote
Monkeysweat Offline
Member
Posts: 53
Joined: Jun 2010
Reputation: 0
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