I am having an issue with ONLY_FULL_GROUP_BY on MySQL 5.7.14 where I can't seem to disable it even though I've set the SQL mode. I have set both @@sql_mode to remove ONLY_FULL_GROUP_BY by running this command: SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));…
I have a subdomain say dev.domain.com that points to document root public_html/dev. Worked fine, but for good reasons I renamed the folder dev to devm19, also modified the subdomain to point to public_html/devm19. Problem is I can't login to the…
In my magento store when my products is hovered on the background changes color, and there is a shadow effect. When you remove your mouse, it should go back to exactly as it was before. What is causing the background…
http://example.com/abc/media TO http://example.com/media How to set this URL with use of .htaccess?
After installing a new version of a Magento 2 module composer fails on every command. Also the backend of Magento isn't working anymore: 1 exception(s): Exception #0 (UnexpectedValueException): Package magento/composer's source key should be specified as {"type": ..., "url": ...,…
I'm a beginner to a magento. Kindly help me I'm stuck with this.I have source files and database. But I don't know how to setup.
Using Magento 2.2.1 freshly installed I use php 7.1.1 I am using Adyen payment gateway https://github.com/Adyen/adyen-magento2 the extension developer says its not due to their extension. I have enabled every php extension on server side thats needed. So now it…
I've created a custom Magento plugin, and everything is working fine, except the database creation. Here is my SQL code. <?php $installer = $this; $installer->startSetup(); $installer->run(" -- DROP TABLE IF EXISTS {$this->getTable('store_city')}; CREATE TABLE '{$installer->getTable('store_city')}'( `city_id` int(11) unsigned NOT NULL…
I have successfully integrated elastic search(Elasticsearch 6.0) with Magento Enterprise Edition 2.1. As per their documentation, I have tried to reindex calalog by using magento cli command bin/magento indexer:reindex catalogsearch_fulltext But it throws an error like Catalog Search indexer process…
I am trying to update the configuration of my Magento store. It shows me a message that the configuration was updated, but when I check the setting again, they are not updated. I thought the config file might not have…