2019-08-19, 09:39
(2019-08-19, 03:26)OtheA Wrote: Hello. I'm starting a clean install and I think I'm messing up step 3. It's making the sub... databases? But SQL is responding with the below. Is this normal and should be ignored? Thanks.
Quote:Code:Error
SQL query:
-- FILES VIEW FOR _U04 -- CREATE ALGORITHM=MERGE DEFINER=`kodi`@`%` SQL SECURITY DEFINER VIEW `files` AS SELECT `Kodi_U01_Video_116`.`global_files`.`idFile` AS `idFile`, `Kodi_U01_Video_116`.`global_files`.`idPath` AS `idPath`, `Kodi_U01_Video_116`.`global_files`.`strFilename` AS `strFilename`, `Kodi_U01_Video_116`.`global_files`.`playCount_U04` AS `playCount`, `Kodi_U01_Video_116`.`global_files`.`lastPlayed_U04` AS `lastPlayed`, `Kodi_U01_Video_116`.`global_files`.`dateAdded` AS `dateAdded` FROM `Kodi_U01_Video_116`.`global_files`
MySQL said:
#1050 - Table 'files' already exists
looks like the view "files" is already created for user 4.
did it work fine for when creating user 2 and 3?
If it did you can just drop Kodi_U04_Video_116 and re-run the code from step 3