RSS errors after upgrade - template issue or bug?
News and General
7 years ago
It took me a few days to realise because of the holidays, but after my upgrade from 3 to 4 none of my RSS feeds are working. Visiting one of them results in what’s quoted below. Is this likely to be a bug or a template/config issue on my end?
Exception Caught
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'm.url' in 'field list':
SELECT `c`.`channel_id`, `c`.`channel_title`, `c`.`channel_url`, `c`.`channel_lang`, `c`.`channel_description`, `ct`.`entry_date`, `m`.`email`, `m`.`username`, `m`.`screen_name`, `m`.`url` FROM (`exp_channel_titles` ct) LEFT JOIN `exp_channels` c ON `ct`.`channel_id` = `c`.`channel_id` LEFT JOIN `exp_members` m ON `m`.`member_id` = `ct`.`author_id` WHERE `ct`.`entry_id` = 15679 AND `c`.`site_id` IN ('1')
ee/legacy/database/drivers/mysqli/mysqli_connection.php:116
Stack Trace: Please include when reporting this error
#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(111): CI_DB_mysqli_connection->query('SELECT `c`.`cha...')
#1 ee/legacy/database/DB_driver.php(269): CI_DB_mysqli_driver->_execute('SELECT `c`.`cha...')
#2 ee/legacy/database/DB_driver.php(179): CI_DB_driver->simple_query('SELECT `c`.`cha...')
#3 ee/legacy/database/DB_active_rec.php(1137): CI_DB_driver->query('SELECT `c`.`cha...')
#4 ee/EllisLab/Addons/rss/mod.rss.php(330): CI_DB_active_record->get()
#5 ee/EllisLab/Addons/rss/mod.rss.php(62): Rss->_feed_vars_query('15679')
#6 ee/legacy/libraries/Template.php(1810): Rss->feed()
#7 ee/legacy/libraries/Template.php(1449): EE_Template->process_tags()
#8 ee/legacy/libraries/Template.php(545): EE_Template->tags()
#9 ee/legacy/libraries/Template.php(229): EE_Template->parse('{!-- ra:0000000...', true, '1', false)
#10 ee/legacy/libraries/Template.php(1102): EE_Template->fetch_and_parse('Westeros', 'Template_RSS20', true, '1')
#11 ee/legacy/libraries/Template.php(1110): EE_Template->process_sub_templates('{!-- ra:0000000...')
#12 ee/legacy/libraries/Template.php(593): EE_Template->process_sub_templates('{!-- ra:0000000...')
#13 ee/legacy/libraries/Template.php(229): EE_Template->parse('{!-- ra:0000000...', false, '1', false)
#14 ee/legacy/libraries/Template.php(162): EE_Template->fetch_and_parse('', Array, false)
#15 ee/legacy/libraries/Core.php(657): EE_Template->run_template_engine('', '')
#16 ee/legacy/controllers/ee.php(62): EE_Core->generate_page()
#17 [internal function]: EE->index()
#18 ee/EllisLab/ExpressionEngine/Core/Core.php(229): call_user_func_array(Array, Array)
#19 ee/EllisLab/ExpressionEngine/Core/Core.php(109): EllisLab\ExpressionEngine\Core\Core->runController(Array)
#20 ee/EllisLab/ExpressionEngine/Boot/boot.php(146): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
#21 teros.org/www/html/GoT/index.php(182): require_once('...')
#21 teros.org/www/html/GoT/index.php(182): require_once('...')
7 years ago
Hey Linda, sorry looks like a bug that’s already been fixed internally, so it will be in the next update. But if you open system/ee/EllisLab/Addons/rss/mod.rss.php, you can patch this by changing line 324 from:
m.screen_name, m.url')to:
m.screen_name)
7 years ago
Thank you, all fixed. 😊