search

ninacoder-info / music-engine-web-wiki

11 stars 6 forks source link

If you add a channel to genre and if you visit the genre page the pafe doesnt load. #11

Open insane2subro opened 2 years ago

insane2subro commented 2 years ago

Steps to reproduce:

  • Create a Channel
  • Add songs
  • Publish on the genres page section
  • Visit the genere then page doesnt load

Error SQLSTATE[42S22]: Column not found: 1054 Unknown column 'popular.genre' in 'where clause' (SQL: select count() as aggregate from songs where popular.genre REGEXP (^|,)(5)(,|$) and songs.id in (18, 20, 23) and songs.visibility = 1 and songs.approved = 1 and songs.created_at < 2021-07-04 14:16:22) {"userId":1,"exception":"[object] (Illuminate\Database\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'popular.genre' in 'where clause' (SQL: select count() as aggregate from songs where popular.genre REGEXP (^|,)(5)(,|$) and songs.id in (18, 20, 23) and songs.visibility = 1 and songs.approved = 1 and songs.created_at < 2021-07-04 14:16:22) at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671)