Post by Milan989 » 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

Newbie

Posts

Joined
Mon Sep 10, 2018 6:48 am

Post by IP_CAM » Fri Sep 14, 2018 11:36 pm

o.agechecked_ageverificationid
This Custom Extension is in charge of this Problem!
Ernie

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by Milan989 » Sat Sep 15, 2018 3:50 am

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

Newbie

Posts

Joined
Mon Sep 10, 2018 6:48 am

Post by Milan989 » 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

Newbie

Posts

Joined
Mon Sep 10, 2018 6:48 am

Post by IP_CAM » 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');
	}
---

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland
Who is online

Users browsing this forum: Majestic-12 [Bot] and 15 guests