2012-01-11, 00:44
thanks for the suggestions:
Attempted that code in the command line and get an error back saying:
ERROR 1054 (42S22): Unknown column `Y:\\24\\` in `field list`
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].
Attempted that code in the command line and get an error back saying:
ERROR 1054 (42S22): Unknown column `Y:\\24\\` in `field list`
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.okay I've removed that still no luck. here's my latest debug log:http://pastebin.com/eCuBTmZh
<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>