Publisher does not support the Fluid field type. Please do not contact asking when support will be available.
If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.
Ticket: Error on uninstall attempt: Syntax error or access violation: 1072 Key column ‘publisher_status’ doesn’t exist in table:
| Status | Resolved |
| Add-on / Version | Publisher 3.1.5 |
| Severity | |
| EE Version | 5.4.3 |
Paul Larson
Feb 01, 2023Upon uninstalling Publisher, I get this error.
Is this an issue where I might need to first update _from_ 3.1.5 to the latest, so the uninstaller works?
Site uses bloqs, but that’s on v 4.12.5
Exception Caught
SQLSTATE[42000]: Syntax error or access violation: 1072 Key column ‘publisher_status’ doesn’t exist in table:
ALTER TABLE `exp_blocks_atom` DROP `publisher_status`
ee/legacy/database/drivers/mysqli/mysqli_connection.php:117
Stack Trace: Please include when reporting this error
#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(112): CI_DB_mysqli_connection->query()
#1 ee/legacy/database/DB_driver.php(270): CI_DB_mysqli_driver->_execute()
#2 ee/legacy/database/DB_driver.php(180): CI_DB_driver->simple_query()
#3 ee/legacy/database/DB_forge.php(293): CI_DB_driver->query()
#4 user/addons/publisher/Service/Field/Type/BloqsType.php(146): CI_DB_forge->drop_column()
#5 [internal function]: BoldMinded\Publisher\Service\Field\Type\BloqsType->uninstall()
#6 user/addons/publisher/Service/Handler/FieldHandler.php(242): call_user_func_array()
#7 user/addons/publisher/upd.publisher.php(167): BoldMinded\Publisher\Service\Handler\FieldHandler->call()
#8 ee/legacy/libraries/addons/Addons_installer.php(88): Publisher_upd->uninstall()
#9 ee/legacy/libraries/addons/Addons_installer.php(386): Addons_installer->uninstall_module()
#10 ee/legacy/libraries/addons/Addons_installer.php(50): Addons_installer->_update_addon()
#11 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(1551): Addons_installer->uninstall()
#12 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(872): EllisLab\ExpressionEngine\Controller\Addons\Addons->uninstallModule()
#13 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(172): EllisLab\ExpressionEngine\Controller\Addons\Addons->remove()
#14 [internal function]: EllisLab\ExpressionEngine\Controller\Addons\Addons->index()
#15 ee/EllisLab/ExpressionEngine/Core/Core.php(268): call_user_func_array()
#16 ee/EllisLab/ExpressionEngine/Core/Core.php(118): EllisLab\ExpressionEngine\Core\Core->runController()
#17 ee/EllisLab/ExpressionEngine/Boot/boot.php(156): EllisLab\ExpressionEngine\Core\Core->run()
#18 httpdocs/admin.php(153): require_once(’...’)
#18 httpdocs/admin.php(153): require_once(’...’)
BoldMinded (Brian)
I’m going to guess that this isn’t the first time the installer has been run and it likely deleted the publisher_status column from the exp_blocks_atom table already, or that column was manually removed somehow?
It might be easiest to just edit that table and add the column, then try to re-run the uninstall. I can run the uninstall successfully locally without error when Bloqs is installed, so I have to assume something got out of whack with your environment.
BoldMinded (Brian)
Also, that is a really old version of Bloqs and Publisher, so you’d need to update before I can assist further.
Paul Larson
Yeah, the table it actually is yelling about (publisher_status) exists in exp_blocks_atom.
What’s the latest bloqs for EE5.4.3? Let me get everything current to EE5 then I can move it to EE64.
BoldMinded (Brian)
I honestly don’t know which is the latest version that worked in EE 5. You’ll have to review the change log.
I suggest you do what I mentioned in the first comment, just add the column manually, then run the Publisher un-install.