Win Cannot update library (MySQL)
#1
Running Windows 7 32 bit with XBMC and MySQL with this config.

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.2.2</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<host>192.168.2.2</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>
</advancedsettings>

Been working great for the past few months but i accidently copied that settings file onto my MacBook and updated my library from my MacBook and now i cannot seem to update my XBMC library on my HTPC running XBMC but i can update it on my MacBook.

Anyway to get this fixed? And is all my progress gone as i been watching a lot of shows this week but didn't make a backup. Confused
Reply
#2
random guess.....permissions issue? before anyone else jumps in, post a debug log so the experts can figure it out.
Reply
#3
Windows xbmc.log

http://pastebin.com/XTZziALT
Reply
#4
What's in your sources.xml ? Are all your sources network paths or local?
If I have been of help, please add to my reputation as a way of saying thanks, it's free.
Reply
#5
Everything is stored on my server so its local.
For my MBP and other devices they connect through SMB, but i accidently copied the advancedsettings from my HTPC onto my MBP and now i can only update the library on my MBP and not on my HTPC.
Reply
#6
sources.xml NEEDS to be identical on all installs and also needs to have network paths even on the machine hosting the library. Make a sources.xml on a network machine and copy it to all other installs. You can try cleaning the library and then scanning but it would probably be easier to just drop the library and rescan depending on if you have local metadata or not. advancedsettings.xml should also be identical on all machines
If I have been of help, please add to my reputation as a way of saying thanks, it's free.
Reply
#7
No easier fix?

Been using that advancedsettings.xml for months on my HTPC which has all the media and runs the MySQL database.
Hence that simple advancedsettings.xml

Other devices are connected via this advancedsettings.xml
http://pastebin.com/hcwry3ph
Before i accidentally copied the advancedsettings.xml onto my MacBook Pro i was able to update the library on all PC's and now only on my MBP.
The problems started by that and when i cleaned up my library on my HTPC it started to erase the entire library and updating doesn't work.
Reply
#8
(2012-09-24, 20:56)RoyalMess Wrote: No easier fix?

Been using that advancedsettings.xml for months on my HTPC which has all the media and runs the MySQL database.
Hence that simple advancedsettings.xml

Other devices are connected via this advancedsettings.xml
http://pastebin.com/hcwry3ph
Before i accidentally copied the advancedsettings.xml onto my MacBook Pro i was able to update the library on all PC's and now only on my MBP.
The problems started by that and when i cleaned up my library on my HTPC it started to erase the entire library and updating doesn't work.

Please read the guide - http://wiki.xbmc.org/index.php?title=HOW..._libraries and set things up accordingly. You will end up with a simpler configuration in the end and adding another device will be as simple as installing XBMC on it and copying the advancedsettings.xml file to its userdata directory. It will also make it easier to troubleshoot if needed.
Reply
#9
(2012-09-24, 21:08)drpizznock Wrote:
(2012-09-24, 20:56)RoyalMess Wrote: No easier fix?

Been using that advancedsettings.xml for months on my HTPC which has all the media and runs the MySQL database.
Hence that simple advancedsettings.xml

Other devices are connected via this advancedsettings.xml
http://pastebin.com/hcwry3ph
Before i accidentally copied the advancedsettings.xml onto my MacBook Pro i was able to update the library on all PC's and now only on my MBP.
The problems started by that and when i cleaned up my library on my HTPC it started to erase the entire library and updating doesn't work.

Please read the guide - http://wiki.xbmc.org/index.php?title=HOW..._libraries and set things up accordingly. You will end up with a simpler configuration in the end and adding another device will be as simple as installing XBMC on it and copying the advancedsettings.xml file to its userdata directory. It will also make it easier to troubleshoot if needed.

That is what i have, but the problem is that i accidentally copied the advancedsettings.xml that are on my HTPC and not the proper one that contains this information: http://pastebin.com/hcwry3ph

Now that went wrong so now i need to troubleshoot, i hope you did read this topic thoroughly as your reaction makes it seem like you didn't.
Reply
#10
(2012-09-24, 21:12)RoyalMess Wrote:
(2012-09-24, 21:08)drpizznock Wrote:
(2012-09-24, 20:56)RoyalMess Wrote: No easier fix?

Been using that advancedsettings.xml for months on my HTPC which has all the media and runs the MySQL database.
Hence that simple advancedsettings.xml

Other devices are connected via this advancedsettings.xml
http://pastebin.com/hcwry3ph
Before i accidentally copied the advancedsettings.xml onto my MacBook Pro i was able to update the library on all PC's and now only on my MBP.
The problems started by that and when i cleaned up my library on my HTPC it started to erase the entire library and updating doesn't work.

Please read the guide - http://wiki.xbmc.org/index.php?title=HOW..._libraries and set things up accordingly. You will end up with a simpler configuration in the end and adding another device will be as simple as installing XBMC on it and copying the advancedsettings.xml file to its userdata directory. It will also make it easier to troubleshoot if needed.

That is what i have, but the problem is that i accidentally copied the advancedsettings.xml that are on my HTPC and not the proper one that contains this information: http://pastebin.com/hcwry3ph

Now that went wrong so now i need to troubleshoot, i hope you did read this topic thoroughly as your reaction makes it seem like you didn't.

I read the thread and the solution has been provided. But you want easier, what's easier? Two lines of code and a plug-in? Configure your HTPC and MBP the same way with a shared database and path subs for shared sources, thumbnails and add-ons. There will be no problems once it's done right and you're using a final or stable release of XBMC.
Reply
#11
Whay I told you is the easier way. It will eliminate half of your path substitutions and make the files the same on all installs.
If I have been of help, please add to my reputation as a way of saying thanks, it's free.
Reply
#12
(2012-09-24, 21:26)drpizznock Wrote:
(2012-09-24, 21:12)RoyalMess Wrote:
(2012-09-24, 21:08)drpizznock Wrote: Please read the guide - http://wiki.xbmc.org/index.php?title=HOW..._libraries and set things up accordingly. You will end up with a simpler configuration in the end and adding another device will be as simple as installing XBMC on it and copying the advancedsettings.xml file to its userdata directory. It will also make it easier to troubleshoot if needed.

That is what i have, but the problem is that i accidentally copied the advancedsettings.xml that are on my HTPC and not the proper one that contains this information: http://pastebin.com/hcwry3ph

Now that went wrong so now i need to troubleshoot, i hope you did read this topic thoroughly as your reaction makes it seem like you didn't.

I read the thread and the solution has been provided. But you want easier, what's easier? Two lines of code and a plug-in? Configure your HTPC and MBP the same way with a shared database and path subs for shared sources, thumbnails and add-ons. There will be no problems once it's done right and you're using a final or stable release of XBMC.

So what would i have to edit in my advancedsettings then?
I already had 6 devices working with this advancedsettings: http://pastebin.com/hcwry3ph for the past few months.
But now i made a mistake and didn't copy that advancedsettings onto my MBP but the one from my HTPC which is shown in my first post.

Now how /shouldwould i troubleshoot this?
(2012-09-24, 21:42)Dilligaf Wrote: Whay I told you is the easier way. It will eliminate half of your path substitutions and make the files the same on all installs.

Even crossplatform? So even on my iPad, iPhone, 2 Ubuntu machines, 3 Windows machines and on my MacBook?
Reply
#13
(2012-09-24, 21:44)RoyalMess Wrote: Even crossplatform? So even on my iPad, iPhone, 2 Ubuntu machines, 3 Windows machines and on my MacBook?

Yes, advanced settings and sources should be identical on all installs. pathsubstitution for thumbnails is going away in Frodo (V12) so if you're using monthly/nightly builds don't put that in either

If I have been of help, please add to my reputation as a way of saying thanks, it's free.
Reply
#14
(2012-09-24, 22:23)Dilligaf Wrote:
(2012-09-24, 21:44)RoyalMess Wrote: Even crossplatform? So even on my iPad, iPhone, 2 Ubuntu machines, 3 Windows machines and on my MacBook?

Yes, advanced settings and sources should be identical on all installs. pathsubstitution for thumbnails is going away in Frodo (V12) so if you're using monthly/nightly builds don't put that in either

I recommend against using nightly builds. If you must have Frodo go with Alpha3.
Reply
#15
Just renamed the advancedsettings on the HTPC and my entire library is back with all my movies, progress etc.
Gonna try renaming it back and see what it will do.


Mmmm now it seems everything is connected to the MySQL but the main HTPC, should i load it with this file and replace SMB with the local paths?
http://pastebin.com/hcwry3ph
Reply

Logout Mark Read Team Forum Stats Members Help
Cannot update library (MySQL)0