[silencery]

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.

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].

If that works with no errors, that means your database setup is ok and something isn't right with your library. In that case, I would suggest checking your source settings in the library setup, or checking if the export included duplicates for some reason.

If it does work, you'll probably also want to run the following to remove the row of fake data you put in for testing:

Code:

DELETE FROM path ORDER BY idPath DESC LIMIT 1;