|
When i try to get into system, settings then click edit, I’m getting the following fatal error. Everything was fine until I updated the theme.
Fatal error: ‘Error: Duplicate column name ‘related_category’
Error No: 1060
ALTER TABLE `ocu3_product` ADD `related_category` varchar(255) NOT NULL’
in /home/reptiles/landoflizards.co.uk/system/database/mysqli.php:41
Stack trace:
#0 vqmod/vqcache/vq2-system_library_db.php(20): DBMySQLi->query(‘ALTER TABLE `oc…’)
#1 vqmod/vqcache/vq2-admin_controller_setting_setting.php(11): DB->query(‘ALTER TABLE `oc…’)
#2 [internal function]: ControllerSettingSetting->index()
#3 vqmod/vqcache/vq2-system_engine_front.php(53): call_user_func_array(Array, Array)
#4 vqmod/vqcache/vq2-system_engine_front.php(40): Front->execute(Object(Action))
#5 admin/index.php(166): Front->dispatch(Object(Action), Object(Action))
#6 {main}
Site is supposed to be https for ssl
|
|
|
Can support please look at this. Im having this issue from the 2nd of November and its still unresolved. I really need it sorted.
Thanks
|
|
|
Hi Themeburn Support,
Id really appreciate a response to this problem. Its been nearly a week now and still no reply. I need to access settings.
Thanks
Glenn
|
|
|
It seems to be the vqmod that is causing the conflict with the theme update.
Ive upgraded to the latest vqmod but its still giving the same error.
I really appreciate some help
thanks
|
|
|
Sorry, that you are the only one I cannot help 
—
I’m spamming until I get an answer 
http://support.themeburn.com/topic/quickview-not-working-on-ios-10-3-11
|
|
|
I updated the vqmod and now it has the following error when i try to select system, settings, edit.
Fatal error: ‘Error: Too many keys specified; max 64 keys allowed
Error No: 1069
ALTER TABLE `ocu3_url_alias` ADD INDEX (`query`)’
in /home/reptiles/landoflizards.co.uk/system/database/mysqli.php:41
Stack trace:
#0 vqmod/vqcache/vq2-system_library_db.php(20): DBMySQLi->query(‘ALTER TABLE `oc…’)
#1 vqmod/vqcache/vq2-admin_controller_setting_setting.php(9): DB->query(‘ALTER TABLE `oc…’)
#2 [internal function]: ControllerSettingSetting->index()
#3 vqmod/vqcache/vq2-system_engine_front.php(53): call_user_func_array(Array, Array)
#4 vqmod/vqcache/vq2-system_engine_front.php(40): Front->execute(Object(Action))
#5 admin/index.php(166): Front->dispatch(Object(Action), Object(Action))
#6 {main}
|
|
|
Well, lets give it a try^^
I’m board and still waiting for a reply from ThemBurn.
If you like you can send me a part of your config.php and admin/config.php to info@pi-case-designer.com, I would still guess that it has something to do with your ssl.
—
I’m spamming until I get an answer
http://support.themeburn.com/topic/quickview-not-working-on-ios-10-3-11
|
|
|
Btw:
Telephone as a required field is forbidden in the EU!
Either wait for the Brexit or alter it
___
I’m spamming until I get an answer
http://support.themeburn.com/topic/quickview-not-working-on-ios-10-3-11
|
|
|
Your config.php’s are correct.
Got a stupid idea, have you checked System -> Users -> User Groups -> Top Administrator
Access Permission & Modify Permission?
|
|
|
all permissions are ticked
|
|
|
Are you sure, that this has to do with BurnEngine?
The error message tells you, that some function tries to alter your database table and tries to add a column called “related_category”. This column is already there, hence the duplicate… error.
The altering process is called from line 11 in the modified version of admin/controller/setting/setting.php – you can find the actual file in your web directory in vqmod/vqcache/vq2-admin_controller_setting_setting.php
Now, afaik BurnEngine doesn’t do this, neither adding these columns nor altering the setting.php.
Maybe one of your extensions is causing the problem?
|
|
|
Everything worked fine until i upgraded the burn engine theme and then i got this error
|
|
|
i then updated the vqmod version and the error changed to the following:
Fatal error: ‘Error: Too many keys specified; max 64 keys allowed
Error No: 1069
ALTER TABLE `ocu3_url_alias` ADD INDEX (`query`)’
in /home/reptiles/landoflizards.co.uk/system/database/mysqli.php:41
Stack trace:
#0 vqmod/vqcache/vq2-system_library_db.php(20): DBMySQLi->query(‘ALTER TABLE `oc…’)
#1 vqmod/vqcache/vq2-admin_controller_setting_setting.php(9): DB->query(‘ALTER TABLE `oc…’)
#2 [internal function]: ControllerSettingSetting->index()
#3 vqmod/vqcache/vq2-system_engine_front.php(53): call_user_func_array(Array, Array)
#4 vqmod/vqcache/vq2-system_engine_front.php(40): Front->execute(Object(Action))
#5 admin/index.php(166): Front->dispatch(Object(Action), Object(Action))
#6 {main}
|
|
|
Something is really wrong with your installation. It keeps adding and changing the database structure all the time, hence the other error message with the too many keys. Some script tries to add keys to your url_alias table, which is responsible for SEO urls.
BurnEngine doesn’t change existing tables. It adds its own tables.
What kind of other extensions are you using? And what OC version are you using?
|
|
|
It was an seo extension that was the issue. It was fine until i updated the BurnEngine theme. I just removed it.
|
|
