OpenCart Community

Posted: **Fri Sep 14, 2018 10:25 am**

Nakon logovanja u admin panel, dobijem gresku

Kada se ukljuci error log, vidi se

Fatal error: Uncaught exception 'Exception' with message 'Error: Unknown column 'o.agechecked_ageverificationid' in 'field list'<br />Error No: 1054<br />SELECT o.order_id, CONCAT(o.firstname, ' ', o.lastname) AS customer, (SELECT os.name FROM oc_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, o.agechecked_ageverificationid FROM `oc_order` o WHERE o.order_status_id > '0' ORDER BY o.date_added DESC LIMIT 0,5' in /home/username/public_html/system/library/db/mysqli.php:40 Stack trace: #0 /home/username/public_html/system/library/db.php(16): DB\MySQLi->query('SELECT o.order_...', Array) #1 /home/username/public_html/vqmod/vqcache/vq2-admin_model_sale_order.php(244): DB->query('SELECT o.order_...') #2 [internal function]: ModelSaleOrder->getOrders(Array) #3 /home/username/public_html/vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php(189): call_user_func_array(A in /home/username/public_html/system/library/db/mysqli.php on line 40

Da li neko zna sta moze da bude problem?

hvala

Posted: **Fri Sep 14, 2018 11:36 pm**

o.agechecked_ageverificationid

This Custom Extension is in charge of this Problem!
Ernie

Posted: **Sat Sep 15, 2018 3:50 am**

problem is o.agechecked_ageverificationid ? how to disable or fix?

Posted: **Sat Sep 15, 2018 5:07 am**

Problem is AgeChecked age verification ? how to disable this plugin from mysql or shell/cPanel? or how to fix this problem?

thanks

Posted: **Sat Sep 15, 2018 7:21 am**

It's either a VqMod or an OcMod Extension supported Installation. Download the corresponding Extension,
and compare it's content with your corresponding subdirectories, to later remove the files from your
OC Subdirectories. But first remove the vqmod-File, if you installed it as VqMod, or de-install the OcMod
Content, (Also unInstall the Agechecked Age Verification MODULE) before then manually remove all other
files involved, from the different subdirectories.
Then, clean out all of your Cache Sections Content, and try again.
Ernie
---
https://www.opencart.com/index.php?rout ... n_id=31716
---
This DB-related install Function seemengly did not work, as planned, therefore, you have this error:

Code: Select all

public function install(){
		$check = $this->db->query("SHOW COLUMNS FROM `" . DB_PREFIX . "order` LIKE 'agechecked_ageverificationid'");
		if(!$check->num_rows){
			$this->db->query("ALTER TABLE `" . DB_PREFIX . "order` ADD `agechecked_ageverificationid` VARCHAR(255) NULL");
		}
	}

	public function uninstall(){
		$this->load->model('setting/setting');

		$this->model_setting_setting->deleteSetting('agechecked');
	}

---

OpenCart Community

admin panel login , error

admin panel login , error

Re: admin panel login , error

Re: admin panel login , error

Re: admin panel login , error

Re: admin panel login , error