When using MySql XBMC does not mark movies as watched
#1
I Just finished setting up my xbmc to use MySql database. After importing and testing everything, i noticed that when i mark a movie as watched XBMC does not save that. Is anyone else having this trouble with using the MySql Database? Is there a fix for this?
Reply
#2
Sounds like you do not have permissions to update the streamdetails in the database. To fix this run the following on your XBMC MySQL database. Since I am not sure which version you are running, I posted the updates for Eden and Frodo RC3.

For Eden:
GRANT ALL ON files to `xbmc`;
GRANT ALL ON streamdetails to `xbmc`;
ALTER TABLE `xbmc_video60`.`settings` CHANGE COLUMN `VerticalShift` `VerticalShift` FLOAT NULL DEFAULT 0.0 ;

For Frodo RC 3:
GRANT ALL ON files to `xbmc`;
GRANT ALL ON streamdetails to `xbmc`;
ALTER TABLE `xbmc_video75`.`settings` CHANGE COLUMN `VerticalShift` `VerticalShift` FLOAT NULL DEFAULT 0.0 ;

I also bet your bookmarks are not working either. To fix that run the following:

GRANT ALL ON bookmark TO `xbmc`;

Hope this helps!
Reply

Logout Mark Read Team Forum Stats Members Help
When using MySql XBMC does not mark movies as watched0