You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Hi Nick
You previously helped me here: https://forum.kryptronic.com/viewtopic.php?id=33306
and advised to create a product option and change the fieldinclude value via raw admin.
It worked as expected.
Since you recent update, it has stopped working.
I have narrowed down the problem to this code change in ECOM.php around line 1716
if (empty($pmdata['xinvid'])) {continue;} if (empty($pmdata['xinvid']['xprodoptions'])) {$odata['xaddons'][$pmid]['xinvid']['xprodoptions'] = array(); continue;} if (!($this->list_has($pmdata['xinvid']['xprodoptionsdisp'],'ADDON'))) {$odata['xaddons'][$pmid]['xinvid']['xprodoptions'] = array(); continue;}
Any ideas?
Offline
Check all of your inventory items to ensure that post-update they have 'DEFAULT, ADDON' as the value for xprodoptionsdisp. If not, run:
UPDATE ecom_inventory SET xprodoptionsdisp='DEFAULT, ADDON'
You may have missed making the post-database update changes detailed here:
https://central.kryptronic.com/public/n … PT901.html
When you applied the update. There were a few to do.
Offline
That will be the problem.
However, when I run the installer, the table database definitions(step 13) errors out.
When I don't auto submit I get these updates
Table Updates: ecom_prod-home-office Table Updates: ecom_prodcatdisp-home-office-home-office Table Updates: ecom_prodcatdisp-home-office Table Updates: ecom_prodcatdisp Table Updates: ecom_proddetdisp-home-office-home-office Table Updates: ecom_proddetdisp-home-office Table Updates: ecom_proddetdisp Table Updates: ecom_prodfilter-home-office-home-office Table Updates: ecom_prodfilter-home-office Table Updates: ecom_prodoptions-home-office-home-office Table Updates: ecom_prodoptions-home-office Table Updates: ecom_prodoptionsel-home-office-home-office Table Updates: ecom_prodoptionsel-home-office Table Updates: ecom_prodoptionsel
It seems to be trying to update tables that don't exist and has added '-home-office' to the table names.
Offline
Start checking your filesystem for files with the names 'home-office' in them, and delete them. Specifically .xml files. Look in {private}/apps/ecom/ECOM_Prod. I bet something backed up copies there.
Offline
problem solved. There were a few back up xml files confusing the installer.
Offline