• 2x on a Mac: (XBMC 11.0-PRE GIT:20111213
  
• 1x on Windows 7: (XBMC 11.0 PRE-11.0 Git:20111210)
  
• 1x on yaVDR 0.4, Ubuntu 11.04: (XBMC 2:11.0-pvr+pipelka-eden~git20111022)

Klyde Wrote:Thought I would give this another go, uninstalled sql, removed all registry entrys. Reinstalled using Latest MySQL Community Server 5.5.19, and the XBMC 11.0 Eden: Beta, Computer Running Windows 7 Ultimate.

Once its all setup, when I try to scan items into the library it will only allow me to scan 1 episode of the first tv show then stops.

Here is My Debug Log
*You may notice it connects with the root login, was just testing that to make sure it wasn't a permission issue with the xbmc user

I've also tried setting this up (installing mysql pointing the advancedsettings.xml to laptop etc.) temporarily on my laptop instead of on the mediaserver and experience the same issue.
Tried Following this Guide

I notice when I log into mysql and "show databases;" there is an xbmc_video58 which I've also tried changing the name to, but no luck.

*edit: Latest Debug log with hopefully a more helpful error

Any suggestions would be greatly appreciated.

silencery Wrote:Looks like something's not right with your original library setup.

Your setup is having trouble inserting records into the table. MySQL error 1062 usually indicates duplicate values on a column designed to be unique. In this case, my guess would be the 'strpath' column since your log is showing the following repeats and the strpath column is set as unique:

insert into path (idPath, strPath, strContent, strScraper) values (NULL,'Y:\\24\\','','');
insert into path (idPath, strPath, strContent, strScraper) values (NULL,'Y:\\24\\','','');

The first step would be to see if you can insert anything into the table at all. To do so, just fire up the mysql console (login with the same credentials used in advancedsettings.xml) and run the following:

Code:

use database xbmc_video58;
insert into path (idPath, strPath, strContent, strScraper) values (NULL,'Y:\\24\\','','');

If it doesn't work, that means you may be running into some permission errors on your database (your last debug log says you logged in with xbmc)[ah, nevermind, saw your entry with the root login attempt].

jwdv22 Wrote:silencery, it looks like the problem is actually before that. It says the tables do not exist. Anyway since Eden the first thing I check is whether the as.xml has the db name listed. if so, delete it. then post your log.
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>172.16.1.202</host>
<port>3306</port>
<user>root</user>
<pass>password</pass>
<name>xbmc_video</name>
</videodatabase>
</advancedsettings>

hjid Wrote:All movies in the database are automatically visible in the second client but no thumbnails/fanart is presented. Is it possible to make XBMC automatically get the missing thumbnails/fanart in the second client?

Ray_N Wrote:Check out: http://wiki.xbmc.org/index.php?title=HOW-TO:Synchronize_multiple_XBMC_libraries

Look towards the bottom of the page (Syncing thumbnails and fanart )

Quote:Since I am using Dharma (and want to wait for a stable Eden) it is not be possible to share thumbnails and fanart.

svenh Wrote:I got this working today with the instructions from the original post at lifehacker, however at first it would not work. I had installed the 32 bit MSI version of MySQL (mysql-5.5.9). Created the tables etc.

Upon launching, the UI would lag really bad and nothing would get scanned in if I tried to add content Looking at the xbmc.log I got errors such as this:

"Can't get hostname for your address"

I found you have to go into your mysql directory and add "skip-name-resolve
" to your my.ini file. Afterward I restarted the MySQL service and it worked.

I am pretty sure I saw this somewhere else because the fix sounded really familiar, but if anyone else tries this and runs into the problem maybe this post will help them!

bill55 Wrote:I am having issues exactly like you describe. Main Menu of the interface is SUPER SLOW. Once I am off the main menu everything moves quickly. Library not really functioning either. Going to try this fix tonight.

Does "skip-name-resolve" need to be in any special place in the my.ini file?

Thanks!
Bill