[refinedmusic]

Hi all.

We have just moved house and got given a new ISP router (Netgear CG3100) which runs on 192.168.0.x subnet where as our old router was 192.168.1.x. I've manually changed sources.xml to just point to the new IP for the Synology NAS used to host our files (share over smb) but it won't play anything. I can browse the files on the smb share via the file explorer but not play anything. I also get a 'Preparing...' box for a very long time. I did an update from 12.2 to 12.3 but that didnt solve anything. Any Tips on what I can do here?

Looking at the log it looks like its still trying to open the file from the old IP:
21:44:22 T:100827136 ERROR: XBMC.PlayMedia could not play media: smb://xxx:[email protected]/video/Movies/Kick-Ass (2010)/Kick.Ass.mp4

I've tried to do a path substitution in advancesettings.xml but that didnt work:
<pathsubstitution>
<substitute>
<from>smb://xxx:[email protected]/video/Movies/</from>
<to>smb://xxx:[email protected]/video/Movies/</to>
</substitute>
<substitute>
<from>smb://xxx:[email protected]/video/Tv/</from>
<to>smb://xxx:[email protected]/video/Tv/</to>
</substitute>
</pathsubstitution>

[live4ever]

The old 192.168.1.x IP addresses would still be in the sqlite videodb.

See here:
http://forum.xbmc.org/showthread.php?tid=72740

[refinedmusic]

The old 192.168.1.x IP addresses would still be in the sqlite videodb.

See here:
http://forum.xbmc.org/showthread.php?tid=72740

Can someone one recommend how to edit and update the SQL database on OS X?

Thanks!!

[Ned Scott]

I'm not sure if it's the best too or notl, but I seem to have a copy of this on my computer that I've used before: http://sourceforge.net/projects/sqlitebrowser/

I forget what the exact steps are, but if you poke around and look for something about "path" you should see entries that contain your old source path, and you just need to update those to the new path and save. I think.

[refinedmusic]

I'm not sure if it's the best too or notl, but I seem to have a copy of this on my computer that I've used before: http://sourceforge.net/projects/sqlitebrowser/

I forget what the exact steps are, but if you poke around and look for something about "path" you should see entries that contain your old source path, and you just need to update those to the new path and save. I think.

I downloaded the app but not quite sure how to do a search and replace in it for all the entries...

[jata]

I had a similar issue. I solved this by changing the ip range on the router and used assigned reserved dhcp addresses to my servers. This will be easier and less risky than changing the paths in xbmc.

Good luck

[00b5]

Why don't you just clean the library, remove all the sources, and then readd them, and rescrape all the data?

Sure, it might take a few hours, but its probably easier than editing sqldbs.

**Personally, i'd just change the local lan ip as jata suggested, but that might be as much work for you as just resetting the library.