OpenCart Community

Code: Select all

Fatal error: Uncaught exception 'Exception' with message 'Error: Unknown column 'status' in 'order clause'<br />Error No: 1054<br />SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT os.name FROM sydf_order_status os WHERE os.order_status_id = o.order_status_id AND os.language_id = '1') AS order_status, o.shipping_code, o.total, o.currency_code, o.currency_value, o.date_added, o.date_modified FROM `sydf_order` o WHERE o.order_status_id > '0' ORDER BY status ASC LIMIT 0,100' in /home/site/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/site/public_html/system/library/db.php(16): DB\MySQLi->query('SELECT o.order_...', Array) #1 /home/site/public_html/admin/model/sale/order.php(229): DB->query('SELECT o.order_...') #2 [internal function]: ModelSaleOrder->getOrders(Array) #3 /home/site/public_html/vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php(161): call_user_func_array(Array, Array) #4 [internal function]: Loader->{closure}(Array) #5 /home/es in /home/site/public_html/system/library/db/mysqli.php on line 40

Code: Select all

		$sort_data = array(
			'o.order_id',
			'customer',
			'status',
			'o.date_added',
			'o.date_modified',
			'o.total'
		);

Code: Select all

		$sort_data = array(
			'o.order_id',
			'customer',
			'order_status',
			'o.date_added',
			'o.date_modified',
			'o.total'
		);

Code: Select all

..... o.currency_value, o.date_added, o.date_modified FROM `sydf_order` o WHERE o.order_status_id > '0' ORDER BY status ASC LIMIT 0,100' 

Code: Select all

..... o.currency_value, o.date_added, o.date_modified FROM `sydf_order` o WHERE o.order_status_id > '0' ORDER BY o.status ASC LIMIT 0,100' 

Code: Select all

/home/site/public_html/vqmod/vqcache/.....