Exception thrown in MySQL.php on line 147
Error executing query: SELECT c.id AS chart_id, c.date_published, ci.rank, ci.rank_movement, ci.artist_song_id,
s.song_title, CASE WHEN a.name = 'Various Artists' THEN bc.artist ELSE a.name END AS artist,
s.url, l.name AS label, au.audio_id, au.stream_only, bc.artist_image
FROM chart AS c
JOIN chart_items AS ci ON ci.chart_id = c.id
JOIN big_champagne_import AS bc ON ci.chart_id = bc.chart_id AND ci.artist_song_id = bc.song_id AND ci.rank = bc.rank
JOIN artist_song AS s ON ci.artist_song_id = s.id
JOIN artist AS a ON s.artist_id = a.id
JOIN label AS l ON s.label_id = l.id
LEFT JOIN (
SELECT audio_id, song_id, stream_only
FROM audio_uploads
WHERE hide = 0
AND (expire_date IS NULL OR expire_date >= NOW())
AND (release_date IS NOT NULL AND release_date <= NOW())
) AS au ON au.song_id = ci.artist_song_id
WHERE c.id = (SELECT MAX(id) AS id FROM chart WHERE chart_type_id = 7)
ORDER BY ci.rank
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'aaSiteV3.big_champagne_import' doesn't exist
Debug info
- TRACE #0: MySQL->query() on line 143 in /var/www/sites/dev3.allaccess.com/html/framework/db/DB.php
- TRACE #1: DB->getData() on line 107 in /var/www/sites/dev3.allaccess.com/html/framework/db/DB.php
- TRACE #2: DB->fetchAll() on line 50 in /var/www/sites/dev3.allaccess.com/html/modules/_charts/BigChampagne/BigChampagneHelper.php
- TRACE #3: BigChampagneHelper::getChart() on line 37 in /var/www/sites/dev3.allaccess.com/html/modules/_charts/BigChampagne/BigChampagneView.php
- TRACE #4: BigChampagneView->getDefaultHTML() on line 156 in /var/www/sites/dev3.allaccess.com/html/framework/mvc/View.php
- TRACE #5: View->render() on line 28 in /var/www/sites/dev3.allaccess.com/html/modules/_charts/BigChampagne/BigChampagneController.php
- TRACE #6: BigChampagneController->renderView() on line 324 in /var/www/sites/dev3.allaccess.com/html/framework/template/Template.php
- TRACE #7: Template->renderModules() on line 166 in /var/www/sites/dev3.allaccess.com/html/framework/mvc/View.php
- TRACE #8: View->render() on line 41 in /var/www/sites/dev3.allaccess.com/html/framework/modules/Content/ContentController.php
- TRACE #9: ContentController->renderView() on line 324 in /var/www/sites/dev3.allaccess.com/html/framework/template/Template.php
- TRACE #10: Template->renderModules() on line 166 in /var/www/sites/dev3.allaccess.com/html/framework/mvc/View.php
- TRACE #11: View->render() on line 38 in /var/www/sites/dev3.allaccess.com/html/framework/modules/BodyLayout/BodyLayoutController.php
- TRACE #12: BodyLayoutController->renderView() on line 75 in /var/www/sites/dev3.allaccess.com/html/framework/controller/SiteFrontController.php
- TRACE #13: SiteFrontController->render() on line 122 in /var/www/sites/dev3.allaccess.com/html/framework/controller/FrontController.php
- TRACE #14: FrontController->render() on line 24 in /var/www/sites/dev3.allaccess.com/html/site/index.php