Posts: 3
Joined: Nov 2012
Reputation:
0
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?
Posts: 5
Joined: Mar 2009
Reputation:
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!