[jrubenol]

Hi All,

Raspbmc forced an upgrade for me to get onto Gotham. After an upgrade everything corrupted so I just started from scratch. Everything went fine until I tried populating the music list (video is fine). With that I'm getting a ton of sql errors - help appreciated. System was perfect until this

http://pastebin.com/PiB7aFBR

I hope to not be forced to downgrade mysql, I've read that gotham fixed the problem with the new mysql but this seems like the same problem.

[jmarshall]

Looks like you need to make sure it's actually created the databases properly. By the looks you have no views in the music database. I'd drop it and start again.

[jrubenol]

Already tried that twice - no good

[Aenima99x]

Your music db isn't named right....make you sure you delete all of the music ones
18:28:22 T:139702645450688 NOTICE: Running database version xbmc_music246
18:28:22 T:139702645450688 NOTICE: Running database version MyVideos78

[jrubenol]

Dangit - it's not limited to just music. Fresh install (completely fresh) - same problems now include videos. Getting errors such as the one in this pastebin:

http://pastebin.com/r0C8k7MK

Cannot scan anything at all into the db.

I have the following databases listed from mysql:
+--------------------+
| Database |
+--------------------+
| information_schema |
| MyMusic46 |
| MyVideos78 |
| mysql |
| performance_schema |
+--------------------+


Below is my advancedsettings (just taken from the how to)

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.74</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.74</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>

[jmarshall]

Drop all your databases.

Start Gotham.

Get the Debug Log from that session.

Reason: Once things are already messed up, we can't do much.

[jrubenol]

Closing - I fresh installed, dropped databases immediately, then began the scan with my pi (instead of with a remote machine) and things appear to be working. Thanks!