search

xbianonpi / xbian

XBMC on Raspberry Pi, Bleeding Edge
https://xbian.org
GNU General Public License v3.0
294 stars 46 forks source link

Newest update breaks SQL database on Raspberry PI #799

Closed LauWs closed 8 years ago

LauWs commented 8 years ago

I thought this was an issue with my PI, so i reinstalled with latest image, created advancedsettings.xml and filled out the same details i always do. Restarted the PI and everything looked fine. Saw there was updates in xbian-config, so i installed those. Rebooted and now all shows and movies are gone.

The model is Raspberry PI B.

mkreisl commented 8 years ago

@LauwS Which version of xbian-package-xbmc are you using? And which repos do you have enabled (stable, staging, devel) ?

LauWs commented 8 years ago

Ehm... where / how do i check that?

-------- Oprindelig meddelelse -------- Fra: Manfred Kreisl notifications@github.com Dato: 04/01/2016 18.54 (GMT+01:00) Til: xbianonpi/xbian xbian@noreply.github.com Cc: "René M. Laursen" mester_lauw@hotmail.com Emne: Re: [xbian] Newest update breaks SQL database on Raspberry PI (#799)

@LauwShttps://github.com/LauwS Which version of xbian-package-xbmc are you using? And which repos do you have enabled (stable, staging, devel) ?

Reply to this email directly or view it on GitHubhttps://github.com/xbianonpi/xbian/issues/799#issuecomment-168750951.

mkreisl commented 8 years ago

Enabled repo's: cat /etc/apt/sources.list.d/xbian.list Installed package: dpkg-query -l xbian-package-xbmc

Your mysql server is running?

LauWs commented 8 years ago

Enabled repo´s: deb mirror://apt.xbian.org/mirror.txt stable main rpi-jessie

deb mirror://apt.xbian.org/mirror.txt staging main rpi-jessie

deb mirror://apt.xbian.org/mirror.txt devel main rpi-jessie

Installed package: ii xbian-package-xbmc 15.2-1449270576 armhf XBMC (rpi/isengard)

And yes the SQL runs, it works on another PI and on my PC :-)

LauWs commented 8 years ago

Just did the same on the PI where it works, and it´s the same. Difference in those 2 PI´s are: Failing one - Model B Revision 2.0 - Mounting holes Working one - Model B+

According to http://www.raspberrypi-spy.co.uk/2012/09/checking-your-raspberry-pi-board-version/

LauWs commented 8 years ago

Did some more testing... and if i clean install and add a video smb folder and choose TV series, it can fine update library. As soon as i add my advancedsettings.xml and reboot. Then there is no library and i cannot update the added folder.

LauWs commented 8 years ago

Okay, nevermind. It was an mysql issue, had to do a mysqladmin flush-hosts. Now it works like a charm, as before :+1: