Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.10.0
-
Fix Version/s: 5.11.0-b1
-
Component/s: Plugins, Staff Interface
-
Labels:None
Description
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.
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`;'
);