CMS page is not loading

iakwebsolution

Hi , my bagisto cms listing page is not loading , i checked the error logs and i found this error

"[2024-08-06 11:33:34] production.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'channels.code' in 'field list' (Connection: mysql, SQL: select count() as aggregate from (select iakcms_pages.id, iakcms_page_translations.page_title, iakcms_page_translations.url_key, iakcms_page_translations.locale, GROUP_CONCAT(DISTINCT channels.code) as channel from iakcms_pages inner join iakcms_page_translations on iakcms_pages.id = iakcms_page_translations.cms_page_id and iakcms_page_translations.locale = en left join iakcms_page_channels on iakcms_pages.id = iakcms_page_channels.cms_page_id left join iakchannels on iakcms_page_channels.channel_id = iakchannels.id group by iakcms_pages.id, iakcms_page_translations.locale) as aggregate_table) {"exception":"[object] (Illuminate\Database\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'channels.code' in 'field list' (Connection: mysql, SQL: select count() as aggregate from (select iakcms_pages.id, iakcms_page_translations.page_title, iakcms_page_translations.url_key, iakcms_page_translations.locale, GROUP_CONCAT(DISTINCT channels.code) as channel from iakcms_pages inner join iakcms_page_translations on iakcms_pages.id = iakcms_page_translations.cms_page_id and iakcms_page_translations.locale = en left join iakcms_page_channels on iakcms_pages.id = iakcms_page_channels.cms_page_id left join iakchannels on iakcms_page_channels.channel_id = iakchannels.id group by iakcms_pages.id, iakcms_page_translations.locale) as aggregate_table) at /home/cil9db2na2hb/public_html/iakshop.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:822)

Rishabh-Webkul

Hello @iakwebsolution

After checking your error there is an issue with the column and it is not getting it.

This means that in the SQL query being executed by your application, it's trying to select channels. code from the channels table, but the column code doesn't exist in the channels table as expected.

xz x z.png

Kindly run hope this below command will resolve your query

php artisan migrate

Thanks & regards