Exception thrown in MySQL.php on line 147
Error executing query: SELECT c.id AS chart_id, c.date_published, ci.rank, ci.artist_song_id, wism.title AS song_title, wism.artist, ci.spins, ci.spins_lw, wism.locations, wism.impressions
FROM chart AS c
JOIN chart_items AS ci ON ci.chart_id = c.id
JOIN wism_import AS wism ON ci.chart_id = wism.chart_id AND ci.artist_song_id = wism.song_id AND ci.rank = wism.rank
JOIN artist_song AS s ON ci.artist_song_id = s.id
JOIN artist AS a ON s.artist_id = a.id
WHERE c.id = (SELECT MAX(id) AS id FROM chart WHERE chart_type_id = 9)
ORDER BY ci.rank
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wism.impressions' in 'field list'
Debug info
- TRACE #0: MySQL->query() on line 143 in /var/www/sites/allaccess.com/versions/3/tags/current/staging/3.0.110.3964/html/framework/db/DB.php
- TRACE #1: DB->getData() on line 107 in /var/www/sites/allaccess.com/versions/3/tags/current/staging/3.0.110.3964/html/framework/db/DB.php
- TRACE #2: DB->fetchAll() on line 32 in /var/www/sites/allaccess.com/versions/3/tags/current/staging/3.0.110.3964/html/modules/_charts/WhatsInStoreMusic/WhatsInStoreMusicHelper.php
- TRACE #3: WhatsInStoreMusicHelper::getChart() on line 75 in /var/www/sites/allaccess.com/versions/3/tags/current/staging/3.0.110.3964/html/modules/_charts/WhatsInStoreMusic/WhatsInStoreMusicView.php
- TRACE #4: WhatsInStoreMusicView->getDefaultHTML() on line 157 in /var/www/sites/allaccess.com/versions/3/tags/current/staging/3.0.110.3964/html/framework/mvc/View.php
- TRACE #5: View->render() on line 25 in /var/www/sites/allaccess.com/versions/3/tags/current/staging/3.0.110.3964/html/modules/_charts/WhatsInStoreMusic/WhatsInStoreMusicController.php
- TRACE #6: WhatsInStoreMusicController->renderView() on line 324 in /var/www/sites/allaccess.com/versions/3/tags/current/staging/3.0.110.3964/html/framework/template/Template.php
- TRACE #7: Template->renderModules() on line 167 in /var/www/sites/allaccess.com/versions/3/tags/current/staging/3.0.110.3964/html/framework/mvc/View.php
- TRACE #8: View->render() on line 41 in /var/www/sites/allaccess.com/versions/3/tags/current/staging/3.0.110.3964/html/framework/modules/Content/ContentController.php
- TRACE #9: ContentController->renderView() on line 324 in /var/www/sites/allaccess.com/versions/3/tags/current/staging/3.0.110.3964/html/framework/template/Template.php
- TRACE #10: Template->renderModules() on line 167 in /var/www/sites/allaccess.com/versions/3/tags/current/staging/3.0.110.3964/html/framework/mvc/View.php
- TRACE #11: View->render() on line 38 in /var/www/sites/allaccess.com/versions/3/tags/current/staging/3.0.110.3964/html/framework/modules/BodyLayout/BodyLayoutController.php
- TRACE #12: BodyLayoutController->renderView() on line 75 in /var/www/sites/allaccess.com/versions/3/tags/current/staging/3.0.110.3964/html/framework/controller/SiteFrontController.php
- TRACE #13: SiteFrontController->render() on line 269 in /var/www/sites/allaccess.com/versions/3/tags/current/staging/3.0.110.3964/html/framework/controller/FrontController.php
- TRACE #14: FrontController->render() on line 24 in /var/www/sites/allaccess.com/versions/3/tags/current/staging/3.0.110.3964/html/site/index.php