Error: Error: Unknown column 'status' in 'where clause' Error No: 1054

Error: Error: Unknown column 'status' in 'where clause'
Error No: 1054
SELECT * FROM `oc_theme` WHERE `store_id` = '0' AND `route` = 'common/column_left' AND `status` = '1' File: /home/store4phone/public_html/system/library/db/mysqli.php Line: 122 Backtrace: 0 File: /home/store4phone/public_html/system/library/db.php Line: 54 Class: Opencart\System\Library\DB\MySQLi Function: query Backtrace: 1 File: /home/store4phone/public_html/catalog/model/design/theme.php Line: 27 Class: Opencart\System\Library\DB Function: query Backtrace: 2 File: /home/store4phone/public_html/system/engine/loader.php Line: 343 Class: Opencart\Catalog\Model\Design\Theme Function: getTheme Backtrace: 3 File: /home/store4phone/public_html/system/engine/proxy.php Line: 87 Class: Opencart\System\Engine\Loader Function: Opencart\System\Engine\{closure} Backtrace: 4 File: /home/store4phone/public_html/catalog/controller/event/theme.php Line: 22 Class: Opencart\System\Engine\Proxy Function: __call Backtrace: 5 File: /home/store4phone/public_html/system/engine/action.php Line: 96 Class: Opencart\Catalog\Controller\Event\Theme Function: index Backtrace: 6 File: /home/store4phone/public_html/system/engine/event.php Line: 72 Class: Opencart\System\Engine\Action Function: execute Backtrace: 7 File: /home/store4phone/public_html/system/engine/loader.php Line: 183 Class: Opencart\System\Engine\Event Function: trigger Backtrace: 8 File: /home/store4phone/public_html/catalog/controller/common/column_left.php Line: 110 Class: Opencart\System\Engine\Loader Function: view Backtrace: 9 File: /home/store4phone/public_html/system/engine/loader.php Line: 112 Class: Opencart\Catalog\Controller\Common\ColumnLeft Function: index Backtrace: 10 File: /home/store4phone/public_html/catalog/controller/common/home.php Line: 26 Class: Opencart\System\Engine\Loader Function: controller Backtrace: 11 File: /home/store4phone/public_html/system/engine/action.php Line: 96 Class: Opencart\Catalog\Controller\Common\Home Function: index Backtrace: 12 File: /home/store4phone/public_html/system/framework.php Line: 259 Class: Opencart\System\Engine\Action Function: execute Backtrace: 13 File: /home/store4phone/public_html/index.php Line: 20 Function: require_once

2023-01-28 16:59:35 - PHP Warning: Undefined array key "captcha" in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-01-28 16:59:35 - PHP Unknown: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-01-28 16:59:35 - PHP Warning: Undefined array key "captcha" in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-01-28 16:59:35 - PHP Unknown: imagestring(): Passing null to parameter #5 ($string) of type string is deprecated in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-01-28 16:59:35 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/store4phone/public_html/catalog/controller/startup/error.php:40) in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 48
2023-01-28 16:59:35 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/store4phone/public_html/catalog/controller/startup/error.php:40) in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 49
2023-01-28 16:59:35 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/store4phone/public_html/catalog/controller/startup/error.php:40) in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 50
2023-01-29 01:50:13 - PHP Warning: Undefined array key "captcha" in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-01-29 01:50:13 - PHP Unknown: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-01-29 01:50:13 - PHP Warning: Undefined array key "captcha" in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-01-29 01:50:13 - PHP Unknown: imagestring(): Passing null to parameter #5 ($string) of type string is deprecated in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-01-29 01:50:13 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/store4phone/public_html/catalog/controller/startup/error.php:40) in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 48
2023-01-29 01:50:13 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/store4phone/public_html/catalog/controller/startup/error.php:40) in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 49
2023-01-29 01:50:13 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/store4phone/public_html/catalog/controller/startup/error.php:40) in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 50
2023-01-31 10:06:53 - TypeError: Opencart\Catalog\Model\Catalog\Manufacturer::getLayoutId(): Argument #1 ($manufacturer_id) must be of type int, string given in /home/store4phone/public_html/catalog/model/catalog/manufacturer.php on line 61
2023-01-31 10:06:54 - TypeError: Opencart\Catalog\Model\Catalog\Review::getTotalReviewsByProductId(): Argument #1 ($product_id) must be of type int, string given in /home/store4phone/public_html/catalog/model/catalog/review.php on line 24
2023-01-31 10:06:55 - TypeError: Opencart\Catalog\Model\Catalog\Information::getLayoutId(): Argument #1 ($information_id) must be of type int, string given in /home/store4phone/public_html/catalog/model/catalog/information.php on line 16
2023-02-01 01:10:17 - TypeError: Opencart\Catalog\Model\Catalog\Review::getTotalReviewsByProductId(): Argument #1 ($product_id) must be of type int, string given in /home/store4phone/public_html/catalog/model/catalog/review.php on line 24
2023-02-01 01:19:49 - TypeError: Opencart\Catalog\Model\Catalog\Review::getTotalReviewsByProductId(): Argument #1 ($product_id) must be of type int, string given in /home/store4phone/public_html/catalog/model/catalog/review.php on line 24
2023-02-04 07:20:29 - TypeError: Opencart\Catalog\Model\Catalog\Review::getTotalReviewsByProductId(): Argument #1 ($product_id) must be of type int, string given in /home/store4phone/public_html/catalog/model/catalog/review.php on line 24
2023-02-05 03:22:27 - PHP Warning: Undefined array key "captcha" in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-02-05 03:22:27 - PHP Unknown: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-02-05 03:22:27 - PHP Warning: Undefined array key "captcha" in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-02-05 03:22:27 - PHP Unknown: imagestring(): Passing null to parameter #5 ($string) of type string is deprecated in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-02-05 03:22:27 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/store4phone/public_html/catalog/controller/startup/error.php:40) in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 48
2023-02-05 03:22:27 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/store4phone/public_html/catalog/controller/startup/error.php:40) in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 49
2023-02-05 03:22:27 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/store4phone/public_html/catalog/controller/startup/error.php:40) in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 50
2023-02-06 05:58:10 - TypeError: Opencart\Catalog\Model\Catalog\Review::getTotalReviewsByProductId(): Argument #1 ($product_id) must be of type int, string given in /home/store4phone/public_html/catalog/model/catalog/review.php on line 24
2023-02-06 06:05:21 - PHP Warning: Undefined array key "captcha" in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-02-06 06:05:21 - PHP Unknown: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-02-06 06:05:21 - PHP Warning: Undefined array key "captcha" in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-02-06 06:05:21 - PHP Unknown: imagestring(): Passing null to parameter #5 ($string) of type string is deprecated in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-02-06 06:05:21 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/store4phone/public_html/catalog/controller/startup/error.php:40) in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 48
2023-02-06 06:05:21 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/store4phone/public_html/catalog/controller/startup/error.php:40) in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 49
2023-02-06 06:05:21 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/store4phone/public_html/catalog/controller/startup/error.php:40) in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 50
2023-02-06 06:05:55 - PHP Warning: Undefined array key "captcha" in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-02-06 06:05:55 - PHP Unknown: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-02-06 06:05:55 - PHP Warning: Undefined array key "captcha" in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-02-06 06:05:55 - PHP Unknown: imagestring(): Passing null to parameter #5 ($string) of type string is deprecated in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-02-06 06:05:55 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/store4phone/public_html/catalog/controller/startup/error.php:40) in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 48
2023-02-06 06:05:55 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/store4phone/public_html/catalog/controller/startup/error.php:40) in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 49
2023-02-06 06:05:55 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/store4phone/public_html/catalog/controller/startup/error.php:40) in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 50
2023-02-06 13:34:31 - TypeError: Opencart\Catalog\Model\Catalog\Review::getTotalReviewsByProductId(): Argument #1 ($product_id) must be of type int, string given in /home/store4phone/public_html/catalog/model/catalog/review.php on line 24
2023-02-07 04:41:46 - TypeError: Opencart\Catalog\Model\Catalog\Review::getTotalReviewsByProductId(): Argument #1 ($product_id) must be of type int, string given in /home/store4phone/public_html/catalog/model/catalog/review.php on line 24
2023-02-07 04:41:46 - TypeError: Opencart\Catalog\Model\Catalog\Review::getTotalReviewsByProductId(): Argument #1 ($product_id) must be of type int, string given in /home/store4phone/public_html/catalog/model/catalog/review.php on line 24
2023-02-10 03:14:37 - PHP Warning: Undefined array key "captcha" in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-02-10 03:14:37 - PHP Unknown: strlen(): Passing null to parameter #1 ($string) of type string is deprecated in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-02-10 03:14:37 - PHP Warning: Undefined array key "captcha" in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-02-10 03:14:37 - PHP Unknown: imagestring(): Passing null to parameter #5 ($string) of type string is deprecated in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 46
2023-02-10 03:14:37 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/store4phone/public_html/catalog/controller/startup/error.php:40) in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 48
2023-02-10 03:14:37 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/store4phone/public_html/catalog/controller/startup/error.php:40) in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 49
2023-02-10 03:14:37 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/store4phone/public_html/catalog/controller/startup/error.php:40) in /home/store4phone/public_html/extension/opencart/catalog/controller/captcha/basic.php on line 50
2023-02-11 09:27:59 - TypeError: Opencart\Catalog\Model\Catalog\Review::getTotalReviewsByProductId(): Argument #1 ($product_id) must be of type int, string given in /home/store4phone/public_html/catalog/model/catalog/review.php on line 24
2023-02-12 05:13:20 - TypeError: Opencart\Catalog\Model\Catalog\Review::getTotalReviewsByProductId(): Argument #1 ($product_id) must be of type int, string given in /home/store4phone/public_html/catalog/model/catalog/review.php on line 24
2023-02-12 05:13:20 - TypeError: Opencart\Catalog\Model\Catalog\Review::getTotalReviewsByProductId(): Argument #1 ($product_id) must be of type int, string given in /home/store4phone/public_html/catalog/model/catalog/review.php on line 24
2023-02-23 10:28:24 - TypeError: Opencart\Catalog\Model\Catalog\Information::getLayoutId(): Argument #1 ($information_id) must be of type int, string given in /home/store4phone/public_html/catalog/model/catalog/information.php on line 16
2023-02-23 11:29:11 - TypeError: Opencart\Catalog\Model\Catalog\Information::getLayoutId(): Argument #1 ($information_id) must be of type int, string given in /home/store4phone/public_html/catalog/model/catalog/information.php on line 16
2023-02-23 13:51:17 - TypeError: Opencart\Catalog\Model\Catalog\Review::getTotalReviewsByProductId(): Argument #1 ($product_id) must be of type int, string given in /home/store4phone/public_html/catalog/model/catalog/review.php on line 24
2023-02-26 15:42:00 - TypeError: Opencart\Catalog\Model\Catalog\Review::getTotalReviewsByProductId(): Argument #1 ($product_id) must be of type int, string given in /home/store4phone/public_html/catalog/model/catalog/review.php on line 24
2023-02-26 17:28:52 - PHP Warning: Undefined array key "captcha" in /home/store4phone/public_html/extension/opencart/catalog/controller/captc

Please read the forum rules, and then try again, with some appropriate details, such as OC version used, PHP version, OC extensions installed, etc.

link pls ? how to fix ?

Patch 2 has been applied (2 of 9)

BACK UP/ MAKE A COPY THIS FILE BEFORE EDITING;

The error you're seeing in OpenCart:
Error: Unknown column 'status' in 'where clause'
Error No: 1054

means that the SQL query is trying to filter results using a column named status, but the status column does not exist in the oc_theme table.

Remove the status filter from the code
Open the file:
/catalog/model/design/theme.php

Go to around line 27, where the query is made.
Look for a line like:
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "theme WHERE store_id = '" . (int)$store_id . "' AND route = '" . $this->db->escape($route) . "' AND status = '1'");

Modify it to:
$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "theme WHERE store_id = '" . (int)$store_id . "' AND route = '" . $this->db->escape($route) . "'");

Why? According to https://github.com/opencart/opencart/bl ... schema.php the status column should exist in the oc_theme DB table, it was a bug in OC 4.1.0.3, but is already fixed in the master branch.