Issue the following command
mysqldump -p --no-data -e DATABASE_NAME | sed 's/^CREATE TABLE /CREATE TABLE IF NOT EXISTS /' > DATABASE_NAME.sql
Daily Archives: January 2, 2019
Magento 2 Requested store is not found
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();
}
}
Magento 2 css not working
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);
vi editor replace all
The syntax for replacing one string with another string in the current line is
:s/pattern/replace/
Here “pattern” represents the old string and “replace” represents the new string. For example, to replace each occurrence of the word “lemon” in a line with “orange,” type:
:s/phpcode/phpcodez/
The syntax for replacing every occurrence of a string in the entire text is similar. The only difference is the addition of a “%” in front of the “s”:
:%s/pattern/replace/
Thus repeating the previous example for the entire text instead of just for a single line would be:
:%s/phpcode/phpcodez/
We can’t find the role for the user you wanted.
Edit the file vendor/magento/module-authorization/Model/Acl/AclRetriever.php at line# 85 and replace the below code
if (!$role) {
throw new AuthorizationException(
__('We can\'t find the role for the user you wanted.')
);
}
$allowedResources = $this->getAllowedResourcesByRole($role->getId());
With this one
if (!$role) {
$allowedResources = array();
}
Once success, please revert back the file.