[SOLVED] Adding products VQMOD error

Hi

OC 3.0.2

I've suddenly become unable to succesfully add products. Any attempt to add and save a product creates the following error:-

Notice: Undefined variable: product_id in /var/www/vhosts/gpzzone.co.uk/httpsdocs/opencart/vqmod/vqcache/vq2-_var_www_vhosts_gpzzone.co.uk_opencart_storage_modification_admin_model_catalog_product.php on line 21

Notice: Undefined variable: product_id in /var/www/vhosts/gpzzone.co.uk/httpsdocs/opencart/vqmod/vqcache/vq2-_var_www_vhosts_gpzzone.co.uk_opencart_storage_modification_admin_model_catalog_product.php on line 25

The product IS created in the database, but is not accessible to the store.

Line 25 from that file is..

$this->db->query("INSERT INTO " . DB_PREFIX . "product_description SET product_id = '" . (int)$product_id . "', language_id = '" . (int)$language_id . "', name = '" . $this->db->escape($value['name']) . "', description = '" . $this->db->escape($value['description']) . "', tag = '" . $this->db->escape($value['tag']) . "', meta_title = '" . $this->db->escape($value['meta_title']) . "', meta_description = '" . $this->db->escape($value['meta_description']) . "', meta_keyword = '" . $this->db->escape($value['meta_keyword']) . "'");

Has anyone any wisdom as to what may be causing this behaviour?

Thanks in advance

CD

Clear vqmod cache, refresh ocmod an try again.

Thanks for the reply, it gives the same outcome I'm afraid.

vqcache cleared via FTP (all files deleted) and modifcations refreshed.

Same error message.

See if work with that extension disabled.

It would appear that there are 2 instances of VQMOD installed and the extensions are being served by them both!

"..............2018-12-29 17:20:14 - Another VQmod 2.4.0 or later is already installed.
The files from vqmod/xml/*.xml are processed by the other VQmod!......"

V2.6.3 was manually installed and there's also the integrated VQMOD.

Deleting VQMOD v2.6.3 and relying on the integrated version resolves my initial problem, which is a major plus, but it also breaks some extensions as they seem to be being served by the manually installed v2.6.3!

So I now have to uninstall / reinstall etc. I'll post an update later.

It would appear that there were two versions of VQMod installed which became interconnected and interdependant.

I uninstalled everything reinstalled VQmod v2.6.3 and my extensions and everything now seems to be playing nicely.

Thank you for your input.

I am really sorry for the troubles you had.
But - as always, I am sorry - it is always the same bug: UIFOS

Means, why are you using any extension which relies on VQMod?
OpenCart since 2.x has an already integrated version of this, called OCMod.
Really no reason to install VQMod additionally.

Now you may complain that you need this extension and it requires VQMod.
No, clearly no!
Nowadays not one extension needs VQMod anymore.
And if the developer argue that his extension wont work without, leave it and use another extension.

And if no other extension working with OCMod is existing, talk to this developer and request a OCMOd compatible version - otherwise the developer is only lazy or stupid or anything else - but not trustworthy.

The Integrated VQmod is just a modified OCmod which allows VQmod XML syntax in addition to OCmod XML. And if it detects QPhoria's VQmod then it delegates VQmod XML on to the latter.

Having said that: XML-based modifications will always be a horror story, and are a far cry from proper IT design patterns, of which there are many better alternatives, such as events, class decorators, object-oriented class extensions with overridden methods etc.