Extension, Module

Archived
Forum
(read-only)


For official support, visit the official support site »

Smart SEO

ExpressionEngine 4, ExpressionEngine 5, ExpressionEngine 6

Back to this add-on's main page
View Other Add-ons From ZealousWeb

     

Error message when clicking the channel menu

General

Werner Gusset
Werner Gusset

When I click the menu “Channel” in the left main menu and select a channel on the eye-icon the I get

Exception Caught
SQLSTATE[42S22]
Column not found1054 Unknown column 'exp_channels.field_group' in 'on clause':
SELECT `field_id`, `field_name`, `field_label`, `field_type`, `field_requiredFROM (`exp_channel_fields`) LEFT JOIN `exp_channelsON `exp_channels`.`field_group` = `exp_channel_fields`.`group_idWHERE `channel_id` = '20'
ee/legacy/database/drivers/mysqli/mysqli_connection.php:117

Stack Trace
Please include when reporting this error
#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(112): CI_DB_mysqli_connection->query('SELECT `field_i...')
#1 ee/legacy/database/DB_driver.php(270): CI_DB_mysqli_driver->_execute('SELECT `field_i...')
#2 ee/legacy/database/DB_driver.php(180): CI_DB_driver->simple_query('SELECT `field_i...')
#3 ee/legacy/database/DB_active_rec.php(1138): CI_DB_driver->query('SELECT `field_i...')
#4 user/addons/smart_seo/libraries/smart_seo_lib.php(3848): CI_DB_active_record->get('channel_fields')
#5 user/addons/smart_seo/libraries/smart_seo_lib.php(2389): Smart_seo_lib->_get_custom_fields('20')
#6 user/addons/smart_seo/mcp.smart_seo.php(614): Smart_seo_lib->handleLinkChannelFields(Array)
#7 [internal function]: Smart_seo_mcp->linkChannelFields('20')
#8 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(1662): call_user_func_array(Array, Array)
#9 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(946): EllisLab\ExpressionEngine\Controller\Addons\Addons->getModuleSettings('smart_seo', 'linkChannelFiel...', Array)
#10 [internal function]: EllisLab\ExpressionEngine\Controller\Addons\Addons->settings('smart_seo', 'link_channel_fi...', '20')
#11 ee/EllisLab/ExpressionEngine/Core/Core.php(241): call_user_func_array(Array, Array)
#12 ee/EllisLab/ExpressionEngine/Core/Core.php(110): EllisLab\ExpressionEngine\Core\Core->runController(Array)
#13 ee/EllisLab/ExpressionEngine/Boot/boot.php(151): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
#14 admin.php(147): require_once('...')
#14 admin.php(147): require_once('...') 

This may relate to the other error report from today.

ZealousWeb
# 1
Developer
ZealousWeb

Hello

Which version of the EE and Smart SEO are you using?

Thanks,
Himanshu

Werner Gusset
# 2
Werner Gusset

EE 5.2.3

I had Smart SEO 1.0.0 and now I have updated to 1.0.2

But I still have the error.

ZealousWeb
# 3
Developer
ZealousWeb

Hello

I have just checked your error and I assume that you have the wrong version of Smart SEO maybe you downloaded the EE3 version of Smart SEO and installed in EE5 environment.
Select the version which I have marked in below screenshot.
ScreenShot

let me know if you have a further issue related to smart SEO.

Thanks,
Himanshu

Werner Gusset
# 4
Werner Gusset

Thanks a lot

I really had the wrong version uploaded. Now everything works perfect.

I appreciate very much this fast and kind support. Very professional!