All add-ons currently require PHP 7.4 or greater.

On July 4th 2024 PHP 8.2 will be the new minimum requirement for all add-ons. Expect any add-on released after that date to require 8.2 or greater. Some releases may not immediately take advantage of 8.x specific features in PHP, which means you might, be able to continue using new releases in PHP 7.4, however, if you experience an error the first thing you should do is update to PHP 8.2 then create a support ticket if the error persists.

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, 2023

Upon 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(’...’)

#1

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.

#2

BoldMinded (Brian)

Also, that is a really old version of Bloqs and Publisher, so you’d need to update before I can assist further.

#3

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.

#4

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.

Login to reply