2015-09-03, 00:20
I'm about to try this on my Windows box (not the Ubuntu primary machine) first so that if it doesn't work properly I can revert. Easier to revert to Kodi 14.2 in Windows than messing around downgrading.deb packages in Ubuntu... I don't see why it wouldn't work? I have path substitution setup for the Thumbnails to the main server anyways, and I backed up the .kodi directory as well as the SQL database to be safe.
EDIT: I'm noticing all of your non-primary (2,3,4) user scripts have this reference (below) to Jaide, which is User4? what is that actually supposed to be? Also I got this error:
/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TRIGGER IF EXISTS `a93`.`delete_person`' at line 6 */
EDIT 2: OK so I assume that I change Jaide to b c and d for user1 user2 and user3 scripts, respectively. (Please correct me if I'm wrong.)
That still leaves the SQL Error (1064) that I can't get past. I'm using HeidiSQL 8.3.0.4694
EDIT: I'm noticing all of your non-primary (2,3,4) user scripts have this reference (below) to Jaide, which is User4? what is that actually supposed to be? Also I got this error:
/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TRIGGER IF EXISTS `a93`.`delete_person`' at line 6 */
Code:
CREATE VIEW `b93`.`files`
AS SELECT
`globalfiles`.`idFile` AS `idFile`,
`globalfiles`.`idPath` AS `idPath`,
`globalfiles`.`strFilename` AS `strFilename`,
`globalfiles`.`playCountJaide` AS `playCount`,
`globalfiles`.`lastPlayedJaide` AS `lastPlayed`,
`globalfiles`.`dateAdded` AS `dateAdded`
FROM `a93`.`globalfiles`;
EDIT 2: OK so I assume that I change Jaide to b c and d for user1 user2 and user3 scripts, respectively. (Please correct me if I'm wrong.)
That still leaves the SQL Error (1064) that I can't get past. I'm using HeidiSQL 8.3.0.4694