When trying to install the Domain Manager plugin on an addon company, a white screen results with the following error:
{{[2024-08-12T15:13:51.858835+00:00] general.ERROR: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'registration_date' in /home/blestau/public_html/5100/vendors/minphp/db/src/PdoConnection.php:196 Stack trace: #0 /home/domain/public_html/5100/vendors/minphp/db/src/PdoConnection.php(196): PDOStatement->execute() #1 /home/domain/public_html/5100/plugins/domains/domains_plugin.php(635): Minphp\Db\PdoConnection->query() #2 /home/domain/public_html/5100/plugins/domains/domains_plugin.php(146): DomainsPlugin->upgrade1_12_0() #3 /home/domain/public_html/5100/app/models/plugin_manager.php(251): DomainsPlugin->install() #4 /home/domain/public_html/5100/app/controllers/admin_company_plugins.php(573): PluginManager->add() #5 /home/domain/public_html/5100/vendors/minphp/bridge/src/Lib/Dispatcher.php(142): AdminCompanyPlugins->install() #6 /home/domain/public_html/5100/index.php(21): Dispatcher::dispatch() #7
{main}
}}
Make sure the domain manager is installed on the 1st company, then try to install on an addon company.
Bug
Major
Paul Phillips
created issue -
Temporary solution: In plugins/domain/domains_plugin.php around line 634 comment out
$this->Record->query(
'ALTER TABLE `domains_domains` ADD `registration_date` DATETIME NULL DEFAULT NULL AFTER `service_id`;'
);