2010-04-30, 15:59
lestat1977uk Wrote:i now get this did i do it right?Yes, but I don't know why you were receiving an 1142 error while trying to create the same trigger from XBMC.
You can try to drop the xbmc_music db (one more time... ) and then run XBMC on the same machine hosting the MySQL server to see if that solves the trigger creation error and finally XBMC is able to create the full music db (including views and triggers), then you can access it from anywhere.