Hello,
I recently purchased this extension from the opencart marketplace ( https://www.opencart.com/index.php?rout ... n_id=31196 however I seem to be having issues.
I had to install VQmod to get this extension to work and it does work in terms of allowing me to set minimum and maximum character lengths using TEXT and TEXTAREA options.
The issue I have is that all my existing options using SELECT have had their sub-options deleted and when trying to re-add them or add ac completely new option with SELECT I get the following error:
------------------------------------------------------------------------------------------------------------------------------------------------
EDIT - For some reason the image is silly small once uploaded so here is a copy of the text;
------------------------------------------------------------------------------------------------------------------------------------------------
Fatal error: Uncaught Exception: Error: Unknown column 'o_min' in 'field list'<br />Error No: 1054<br />INSERT INTO oc_option_value_description SET option_value_id = '255', language_id = '1', option_id = '235', name = '1', o_min = '0', o_max = '0' in /shop/system/library/db/mysqli.php:40
Stack trace:
#0 /shop/system/library/db.php(16): DB\MySQLi->query('INSERT INTO oc_...', Array)
#1 /shop/vqmod/vqcache/vq2-admin_model_catalog_option.php(62): DB->query('INSERT INTO oc_...')
#2 /shop/vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php(178): ModelCatalogOption->editOption('235', Array)
#3 /shop/system/library/db/mysqli.php on line 40
------------------------------------------------------------------------------------------------------------------------------------------------
The error on line 40 (assuming its just 40 down key arrows) show the text - " return $result; ".
I'm not an expert in coding and I have tried changing the modified simpleone theme I am using back to default to see if the error still remains, which it does.
I can still add and save TEXT and TEXTAREA options but I cant get SELECT options to work.
I am using opencart version 2.3.0.2 and I don't have a test server
Here is an example of an option I am trying to save before the error appears;
Thanks
I recently purchased this extension from the opencart marketplace ( https://www.opencart.com/index.php?rout ... n_id=31196 however I seem to be having issues.
I had to install VQmod to get this extension to work and it does work in terms of allowing me to set minimum and maximum character lengths using TEXT and TEXTAREA options.
The issue I have is that all my existing options using SELECT have had their sub-options deleted and when trying to re-add them or add ac completely new option with SELECT I get the following error:
------------------------------------------------------------------------------------------------------------------------------------------------
EDIT - For some reason the image is silly small once uploaded so here is a copy of the text;
------------------------------------------------------------------------------------------------------------------------------------------------
Fatal error: Uncaught Exception: Error: Unknown column 'o_min' in 'field list'<br />Error No: 1054<br />INSERT INTO oc_option_value_description SET option_value_id = '255', language_id = '1', option_id = '235', name = '1', o_min = '0', o_max = '0' in /shop/system/library/db/mysqli.php:40
Stack trace:
#0 /shop/system/library/db.php(16): DB\MySQLi->query('INSERT INTO oc_...', Array)
#1 /shop/vqmod/vqcache/vq2-admin_model_catalog_option.php(62): DB->query('INSERT INTO oc_...')
#2 /shop/vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php(178): ModelCatalogOption->editOption('235', Array)
#3 /shop/system/library/db/mysqli.php on line 40
------------------------------------------------------------------------------------------------------------------------------------------------
The error on line 40 (assuming its just 40 down key arrows) show the text - " return $result; ".
I'm not an expert in coding and I have tried changing the modified simpleone theme I am using back to default to see if the error still remains, which it does.
I can still add and save TEXT and TEXTAREA options but I cant get SELECT options to work.
I am using opencart version 2.3.0.2 and I don't have a test server
Here is an example of an option I am trying to save before the error appears;
Thanks
Last edited by Mountune on Wed Feb 21, 2018 7:03 pm, edited 3 times in total.
-----
Opencart Version = v2.3.0.2
Theme = SimpleONE Boxed
As part of installing this, were you supposed to manually update the oc_option_value_description table to include fields o_min and o_max? If it was to be automatically done, did it get done? Check with phpMyAdmin to browse around the database. It sounds like at least o_min is missing from the table.
Hello MrPhil,
I checked the database and both oc_options_description o_min and o_max are set to INT3
I checked the database and both oc_options_description o_min and o_max are set to INT3
Last edited by Mountune on Wed Feb 21, 2018 7:03 pm, edited 1 time in total.
-----
Opencart Version = v2.3.0.2
Theme = SimpleONE Boxed
Take a backup or provide the developer with access to a copy of the site, problem solved.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
what is the best way to make a backup to then make a working copy of opencart on my computer?
I don't believe handing over FTP to strangers is the best thing in terms of security.
I don't believe handing over FTP to strangers is the best thing in terms of security.
-----
Opencart Version = v2.3.0.2
Theme = SimpleONE Boxed
Don't make it on your computer. Make it on your hosting. You must have a web developer who could do this for you? Some web hosts would even do this.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Without giving up your FTP this can't be done. Moreover, an access to your DB might be required as well.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
As I said, you need a dev server if you don't want to give live access.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Well I managed to resolve it with help of the developer. So for future reference to anyone else who encounters this / uses the search bar.
turns out that o_min and o_max didn't appear in a secondary place in the database.
- oc_options_description - This did appear and was the first thing I checked
- oc_options_value_description - They did not appear here, so after adding them the extension started to work as it should.
You have to access the database and manually add them
o_min - INT 3 - As Defined 0 - NULL
o_max - INT3 - As Defined 0 - NULL
I hope this helps others if they encounter this who also don't like giving out FTP access for security reasons. Its also a good way of learning how Opencart works and extensions integrate.
turns out that o_min and o_max didn't appear in a secondary place in the database.
- oc_options_description - This did appear and was the first thing I checked
- oc_options_value_description - They did not appear here, so after adding them the extension started to work as it should.
You have to access the database and manually add them
o_min - INT 3 - As Defined 0 - NULL
o_max - INT3 - As Defined 0 - NULL
I hope this helps others if they encounter this who also don't like giving out FTP access for security reasons. Its also a good way of learning how Opencart works and extensions integrate.
-----
Opencart Version = v2.3.0.2
Theme = SimpleONE Boxed
Who is online
Users browsing this forum: No registered users and 96 guests