[cmc0619]

Hi. I'm new here. If this is in the wrong area, apologies in advance. I think I've found a bug.

Kodi Version 14.2-BETA1 Git:20150217-2259d0b). Platform: Windows NT x86 32-bit (All my crashes are fixed! yay! Thank you!)
mySQL 5.5.40


I was re-importing my movies and some weren't importing, I found the error somewhere else but while looking thru the logs to troubleshoot I found these errors repeating during the TV scan:
17:10:29 T:8636 NOTICE: Thread BackgroundLoader start, auto delete: false
17:11:17 T:9852 NOTICE: Previous line repeats 7 times.
17:11:17 T:9852 ERROR: SQL: The table does not exist
Query: SELECT strPath FROM tvshow_view WHERE idShow=1
17:11:17 T:9852 ERROR: CVideoDatabase::GetPathsForTvShow error during query: SELECT strPath FROM tvshow_view WHERE idShow=1
17:11:17 T:9852 ERROR: SQL: The table does not exist

I use XEM as my scraper so I switched to TheTVDB and re-ran the scrape. The errors persisted.

I then went into mySQL and ran: 'show tables from myvideos90;' and there was a table named tvsshowview but not tvshow_view. Thinking I may have had an incomplete database upgrade I then dropped all of my old databases (been upgrading over the top since 11-ish.) to ensure nothing tried to upgrade from an older version. At this point I had three databases left, information_schema & performance_schema & mysql

I then re-ran Kodi and the database myvideos90 was recreated

I still do not have a tvshow_view table in mysql. Just tvshowview and the errors persist on scanning

I don't appear to have any mal effects but figured someone would want to know. I have two RaspPi clients and they all see the shared database just fine

Before reporting this bug I searched this forum for tvshow_view and a forum rssing.com that came up on google with no applicable hits. I also went here (http://kodi.wiki/view/Databases) to see that the current table name should be tvshowview

[jeffski10]

I just noticed the same - was trying to clear out errors from the log. Seems to only throw this error on clean up for me.

[goldenpipes]

upgraded from mysql 5.6.x to 5.7.7 and this started happening to me. also happening on mariadb-10.0.19-winx64

i sorta don't want to roll back to 5.6

i am using smb:\\xxx.xxx.xxx.xxx shares and its worked before.

its almost as if kodi isnt making the tvshow_view table right?

[jainoxi]

I'm facing the same issues with a MySQL upgrade from 5.6 to 5.7.

I tried a couple of things, actually; one of which was migrating the databases from a MySQL 5.6 to a different MySQL 5.7 server. And migrate across servers from 5.6 to 5.6.

No matter what migration I try, I get these errors:

ERROR: Error executing '
CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`xbmc`@`%` SQL SECURITY DEFINER VIEW `myvideos93`.`season_view` AS select `myvideos93`.`seasons`.`idSeason` AS `idSeason`,`myvideos93`.`seasons`.`idShow` AS `idShow`,`myvideos93`.`seasons`.`season` AS `season`,`tvshow_view`.`strPath` AS `strPath`,`tvshow_view`.`c00` AS `showTitle`,`tvshow_view`.`c01` AS `plot`,`tvshow_view`.`c05` AS `premiered`,`tvshow_view`.`c08` AS `genre`,`tvshow_view`.`c14` AS `studio`,`tvshow_view`.`c13` AS `mpaa`,count(distinct `episode_view`.`idEpisode`) AS `episodes`,count(`myvideos93`.`files`.`playCount`) AS `playCount` from (((`myvideos93`.`seasons` join `myvideos93`.`tvshow_view` on((`tvshow_view`.`idShow` = `myvideos93`.`seasons`.`idShow`))) join `myvideos93`.`episode_view` on(((`episode_view`.`idShow` = `myvideos93`.`seasons`.`idShow`) and (`episode_view`.`c12` = `myvideos93`.`seasons`.`season`)))) join `myvideos93`.`files` on((`myvideos93`.`files`.`idFile` = `episode_view`.`idFile`))) group by `myvideos93`.`seasons`.`idSeason`'
Table 'myvideos93.tvshow_view' doesn't exist.
SQL Error: 1146

and

ERROR: Error executing '
CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`xbmc`@`%` SQL SECURITY DEFINER VIEW `myvideos93`.`tvshow_view` AS select `myvideos93`.`tvshow`.`idShow` AS `idShow`,`myvideos93`.`tvshow`.`c00` AS `c00`,`myvideos93`.`tvshow`.`c01` AS `c01`,`myvideos93`.`tvshow`.`c02` AS `c02`,`myvideos93`.`tvshow`.`c03` AS `c03`,`myvideos93`.`tvshow`.`c04` AS `c04`,`myvideos93`.`tvshow`.`c05` AS `c05`,`myvideos93`.`tvshow`.`c06` AS `c06`,`myvideos93`.`tvshow`.`c07` AS `c07`,`myvideos93`.`tvshow`.`c08` AS `c08`,`myvideos93`.`tvshow`.`c09` AS `c09`,`myvideos93`.`tvshow`.`c10` AS `c10`,`myvideos93`.`tvshow`.`c11` AS `c11`,`myvideos93`.`tvshow`.`c12` AS `c12`,`myvideos93`.`tvshow`.`c13` AS `c13`,`myvideos93`.`tvshow`.`c14` AS `c14`,`myvideos93`.`tvshow`.`c15` AS `c15`,`myvideos93`.`tvshow`.`c16` AS `c16`,`myvideos93`.`tvshow`.`c17` AS `c17`,`myvideos93`.`tvshow`.`c18` AS `c18`,`myvideos93`.`tvshow`.`c19` AS `c19`,`myvideos93`.`tvshow`.`c20` AS `c20`,`myvideos93`.`tvshow`.`c21` AS `c21`,`myvideos93`.`tvshow`.`c22` AS `c22`,`myvideos93`.`tvshow`.`c23` AS `c23`,`myvideos93`.`path`.`idParentPath` AS `idParentPath`,`myvideos93`.`path`.`strPath` AS `strPath`,`tvshowcounts`.`dateAdded` AS `dateAdded`,`tvshowcounts`.`lastPlayed` AS `lastPlayed`,`tvshowcounts`.`totalCount` AS `totalCount`,`tvshowcounts`.`watchedcount` AS `watchedcount`,`tvshowcounts`.`totalSeasons` AS `totalSeasons` from (((`myvideos93`.`tvshow` left join `myvideos93`.`tvshowlinkpath` on((`myvideos93`.`tvshowlinkpath`.`idShow` = `myvideos93`.`tvshow`.`idShow`))) left join `myvideos93`.`path` on((`myvideos93`.`path`.`idPath` = `myvideos93`.`tvshowlinkpath`.`idPath`))) join `myvideos93`.`tvshowcounts` on((`myvideos93`.`tvshow`.`idShow` = `tvshowcounts`.`idShow`))) group by `myvideos93`.`tvshow`.`idShow`'
Table 'myvideos93.tvshowcounts' doesn't exist.
SQL Error: 1146