Magento database tables – where is EAN stored
I am working on a Magento project and to complete an import to ebay process I may need to do a bulk update on EAN numbers. I am reviewing the database and the tables - and I haven't found or…
Can't disable ONLY_FULL_GROUP_BY – Magento
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',''));…
Magento 1.9 – cannot login to admin after renamed Document Root
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…
CSS in magento getting rid of hover effects on my products
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…
How to remove directory path form image url using htaccess? – Magento
http://example.com/abc/media TO http://example.com/media How to set this URL with use of .htaccess?
Composer fails [UnexpectedValueException] – Magento
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": ...,…
Does anyone knowhow to set a live magento site to the local one?
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.
Magento 2.2.1 Checkout 500 (Internal Server Error)
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…
Error Creating Custom table in Magento 1.9 for Custom Module
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…
Magento 2 EE elasticsearch Content-Type header is not supported
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…