[josecuervo]

Noob here (>.<)/ Please bear my English. I'm a native Spanish speaker XD

As the title says Xbmc crashes every time I try to connect to my MySQL server in my raspberry pi, everything was just fine for about 1year, but now it suddenly won't connect , I tried deleting the old database and recreate it from scratch but now it won't update at all.

My client:
Ubuntu 12.04 , xbmc 12.2 Git:32b1a5e

My server:
5.5.31-0+wheezy1 (Debian)
^^^ Not sure is you need that XD

And here is my log :
http://pastebin.com/sUDL16U0

Thanks in advance XD

[forkless]

It looks like your database structure is missing (some) views. You may want to check out this thread http://forum.xbmc.org/showthread.php?tid=173974

[josecuervo]

Thanks for replying!!!!!

I' ll check out your link and report back

[josecuervo]

It worked !!!!!

I followed your instructions in the last post of that link and my library was nicely populated, after that I was able to play my videos, thanks forkles!! \(>.<)/

- Remove the MyVideos75.db and MyMusic32.db files from .xbmc/userdata/Database (client)
- Drop MyVideos75.db and MyMusic32.db from MySQ L( server)
- Disable the common cache plugin in addons if you were using that (I was)
- Reboot/Restart the client
- Recreate my library from scratch and exported it
- Reboot/Restart the client ( this time connected to MySQL )
- Import back my library.