Following are the fields you need to set 0 or 1 in core_config_data table to merge / unmergae css/js files.
dev/js/merge_files - Merge Js
update core_config_data set value=0 where path='dev/js/merge_files';
dev/css/merge_css_files - Merge css
update core_config_data set value=0 where path='dev/css/merge_css_files' limit 20;
I have encountered this issue while community to enterprise migration and it was happening since the base table ‘oauth_consumer‘ was not available.
CREATE TABLEoauth_consumer(entity_idint(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
created_attimestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
updated_attimestamp NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
namevarchar(255) NOT NULL COMMENT 'Name of consumer',
keyvarchar(32) NOT NULL COMMENT 'Key code',
secretvarchar(32) NOT NULL COMMENT 'Secret code',
callback_urltext COMMENT 'Callback URL',
rejected_callback_urltext NOT NULL COMMENT 'Rejected callback URL',
PRIMARY KEY (entity_id),
UNIQUE KEYOAUTH_CONSUMER_KEY(key),
UNIQUE KEYOAUTH_CONSUMER_SECRET(secret),
KEYOAUTH_CONSUMER_CREATED_AT(created_at),
KEYOAUTH_CONSUMER_UPDATED_AT(updated_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OAuth Consumers';
This issue can be fixed by issuing the following queries
UPDATEstoreSET store_id = 0 WHERE code='admin';
UPDATEstore_groupSET group_id = 0 WHERE name='Default';
UPDATEstore_websiteSET website_id = 0 WHERE code='admin';
It can also be solved by modify StoreManager.php (/vendor/magento/module-store/Model/StoreManager.php)
If $storeId is not defined: It retrive data from COOKIE first, otherwise return the default store code.
if (!isset($storeId) || '' === $storeId || $storeId === true) {
if (null === $this->currentStoreId) {
\Magento\Framework\Profiler::start('store.resolve');
$this->currentStoreId = $this->storeResolver->getCurrentStoreId(); \Magento\Framework\Profiler::stop('store.resolve');
}
$storeId = $this->currentStoreId;
}
To
if(!$storeId) {
if(isset($_COOKIE['store']) && $_COOKIE['store'] !== ''){
$storeId = $_COOKIE['store'];
} else {
$storeId = $this->getDefaultStoreView()->getCode();
}
}
I have fixed the issue by modifying option in config Stores>Configuration -> Advanced -> Developer ->Sign Static Files (dev_static_sign) -> No.
As the admin panel was not accessible I made this change at DB level.
insert into core_config_data (config_id, scope, scope_id, path, value) values (null, 'default', 0, 'dev/static/sign', 0);
The custom option variants can not be managed in the inventry.
You can not controll if there are various custom options like color, size etc.
You have limited options like only few colors. Where as in configurable products huge number of product variation is possible.
You can not sell custom option variant separately.
It is easy to create product with custom options compare to configurable products.
Run the following command
php bin/magento deploy:mode:showJust set is_used_in_grid as false.
map $http_host $MAGE_RUN_CODE {
in.phpcodez.com default;
}
map $http_host $MAGE_RUN_TYPE {
in.phpcodez.com store;
}
server {
listen 80;
server_name in.phpcodez.com;
set $MAGE_ROOT /usr/share/nginx/html/phpcodez;
set $MAGE_MODE developer;
include /usr/share/nginx/html/phpcodez/nginx.conf.sample;
}
Make sure that URL ends with a /(slash) .
example : http://phpcodez.com/