Win MySQL database will not populate - RESOLVED
#1
I've been trying to get MySQL up and running for awhile now...

I can see where the MyVideos60 database has been created, but the database will not populate with any entries, it seems. When i return into the library view, I only have access to 20 or so movies out of the 400, and around 50 tv episodes out of thousands. I can access all the movies and tv shows with the file browser though.

If i then go into the AS.xml and remove the text referencing the mysql database, all the videos reappear in my library without an import or scan. I set up the AS.xml as listed in the wiki - though I didn't include the music database.

I just cannot figure this out! I have a debug log here, and there are lot of "error code (1062)" messages....

http://pastebin.ca/2131958

I had to chop a bunch out of the log to get it under 500k!
Quick Links: debug log (wiki) | userdata (wiki) | advancedsettings (wiki) | adding videos to the library (wiki)
Reply
#2
You're using Win32 paths which is not supported in Eden (nor was it supported in Dharma either).

They will be supported in Frodo.
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply
#3
How do i need to be sharing the library then? Map a network drive?

I just saw this thread with the exact same error. So when adding adding the sources and setting the content on the source machine, I should refer to the network share? And then on any client xbmc machines, also refer the network shares for the sources?

Is the adding a network location dialog, and mapping a network drive the same?
Quick Links: debug log (wiki) | userdata (wiki) | advancedsettings (wiki) | adding videos to the library (wiki)
Reply
#4
Read the wiki: http://wiki.xbmc.org/index.php?title=HOW..._libraries
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply
#5
Success!

The clue about the Win32 paths was the key!

For those who may run into this problem in the future...

1. Add your library as a network location, using the add network location dialogue, on your server machine.
2. Point all your sources to this network location using the "Windows network location (smb:\\)" option in xbmc. Do this for each machine you run the xbmc instance on.
3. Set and scan the content
4. export the library
5. exit xbmc and change your advancedsettings.xml
6. restart xbmc and import your library
7. If your MySQL was setup correctly with permissions and ports, you're golden!

Now to add the 3rd and 4th HTPCs to the network! Smile
Quick Links: debug log (wiki) | userdata (wiki) | advancedsettings (wiki) | adding videos to the library (wiki)
Reply
#6
And for those on the cutting edge that wish to test fixes in this regard, checkout 804

Cheers,
Jonathan
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply
#7


Hi how do i export my existing Media files to mysql

is it a line of script i shoudl add in advancedsettings.xml

im refering to step 5 above

5. exit xbmc and change your advancedsettings.xml
Reply
#8

Do i need to add this in the advance settings script ?

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>***.***.***.***</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<host>***.***.***.***</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
</advancedsettings>

I FOUND THIS

http://lifehacker.com/5634515/how-to-syn...eedfetcher


Reply
#9
Don't follow outdated articles.

Read the wiki instead HOW-TO:Synchronize_multiple_XBMC_libraries (wiki)
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply
#10
After spending two days clawing my eyes out with this problem, I could seriously kiss the feet of the contributors to this thread.


Thanks.
Reply

Logout Mark Read Team Forum Stats Members Help
MySQL database will not populate - RESOLVED0