open the file
vendor/magento/module-authorization/Model/Acl/AclRetriever.php and replaced 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
if (!$role) {
$allowedResources = array();
}
and revert it on sucess.
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';
Magento 2 provide us the uninstall module feature which will remove all of the table, data like it hadn’t installed yet.
File: app/code/PHPCodez/First/Setup/Uninstall.php Continue reading Uninstall Setup Script Magento 2
Recurring script can be used to run some script that need to executed whenever we issue php bin/magento setup:upgrade irrespective of version change.
The recurring script will be run after the module setup script every time the command line
php bin/magento setup:upgrade
This script will be defined same as InstallSchema class but difference in name of the class. The example for this class you can see in vendor/magento/module-indexer/Setup/Recurring.php
The UpgradeData will be run during module upgrade and its used to alter the table structure.
The module upgrade script will run when you run the following command line Continue reading UpgradeData Magento 2
The UpgradeSchema will be run during module upgrade and its used to alter the table structure.
The module upgrade script will run when you run the following command line Continue reading UpgradeSchema Magento 2
The InstallData will be run during the module install and its used to load initial data to DB table.
The module install script will run when you run the following command line
php bin/magento setup:upgrade
File : app/code/PHPCodez/First/Setup/InstallData.php
<?php
namespace PHPCodez\First\Setup;
use Magento\Framework\Setup\InstallDataInterface;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\ModuleDataSetupInterface;
class InstallData implements InstallDataInterface {
public function install(ModuleDataSetupInterface $setup, ModuleContextInterface $context) {
$setup->startSetup();
$setup->getConnection()->query("INSERT INTO phpcodez_post SET name = 'Post 1'");
$setup->endSetup();
}
}