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.

Please read about the changes to BoldMinded add-on licensing.

Ticket: Error when removing entry from Structure

Status	Resolved
Add-on / Version	Publisher 3.11.2
Severity
EE Version	7.4.11

Kevin Chatel

Jul 22, 2024

Description of the problem When you try to remove an entry from Structure when Publisher is installed you get the following error.

Error Messages


SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'url_title' cannot be null:
UPDATE `exp_channel_titles` SET `title` = '', `url_title` = NULL, `entry_date` = 0, `expiration_date` = 0, `comment_expiration_date` = 0 WHERE `entry_id` = 1348

ee/legacy/database/drivers/mysqli/mysqli_connection.php:146
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(262): CI_DB_mysqli_driver->_execute()
    #2 ee/legacy/database/DB_driver.php(177): CI_DB_driver->simple_query()
    #3 ee/legacy/database/DB_active_rec.php(1396): CI_DB_driver->query()
    #4 user/addons/publisher/Service/Entry/Entry.php(551): CI_DB_active_record->update()
    #5 user/addons/publisher/ext.publisher.php(546): BoldMinded\Publisher\Service\Entry\Entry->cleanup()
    #6 ee/legacy/libraries/Extensions.php(232): Publisher_ext->after_channel_entry_update()
    #7 ee/legacy/libraries/Extensions.php(110): EE_Extensions->call_class()
    #8 [internal function]: EE_Extensions->call()
    #9 ee/ExpressionEngine/Service/Model/Model.php(664): call_user_func_array()
    #10 [internal function]: ExpressionEngine\Service\Model\Model->ExpressionEngine\Service\Model\{closure}()
    #11 ee/ExpressionEngine/Service/Model/Model.php(610): call_user_func_array()
    #12 [internal function]: ExpressionEngine\Service\Model\Model->ExpressionEngine\Service\Model\{closure}()
    #13 ee/ExpressionEngine/Service/Event/Emitter.php(132): call_user_func_array()
    #14 [internal function]: ExpressionEngine\Service\Event\Emitter->emit()
    #15 ee/ExpressionEngine/Library/Data/Entity.php(649): call_user_func_array()
    #16 [internal function]: ExpressionEngine\Library\Data\Entity->emit()
    #17 ee/ExpressionEngine/Service/Model/Model.php(843): call_user_func_array()
    #18 ee/ExpressionEngine/Service/Model/Query/Update.php(50): ExpressionEngine\Service\Model\Model->emit()
    #19 ee/ExpressionEngine/Service/Model/DataStore.php(275): ExpressionEngine\Service\Model\Query\Update->run()
    #20 ee/ExpressionEngine/Service/Model/DataStore.php(240): ExpressionEngine\Service\Model\DataStore->runQuery()
    #21 ee/ExpressionEngine/Service/Model/Query/Builder.php(72): ExpressionEngine\Service\Model\DataStore->updateQuery()
    #22 ee/ExpressionEngine/Service/Model/Model.php(370): ExpressionEngine\Service\Model\Query\Builder->update()
    #23 ee/ExpressionEngine/Model/Content/ContentModel.php(219): ExpressionEngine\Service\Model\Model->save()
    #24 ee/ExpressionEngine/Addons/structure/mod.structure.php(1964): ExpressionEngine\Model\Content\ContentModel->save()
    #25 ee/ExpressionEngine/Addons/structure/mcp.structure.php(857): Structure->delete_data()
    #26 [internal function]: Structure_mcp->delete()
    #27 ee/ExpressionEngine/Controller/Addons/Addons.php(1592): call_user_func_array()
    #28 ee/ExpressionEngine/Controller/Addons/Addons.php(868): ExpressionEngine\Controller\Addons\Addons->getModuleSettings()
    #29 [internal function]: ExpressionEngine\Controller\Addons\Addons->settings()
    #30 ee/ExpressionEngine/Core/Core.php(268): call_user_func_array()
    #31 ee/ExpressionEngine/Core/Core.php(124): ExpressionEngine\Core\Core->runController()
    #32 ee/ExpressionEngine/Boot/boot.php(184): ExpressionEngine\Core\Core->run()
    #33 index.php(143): require_once('...')
    #33 index.php(143): require_once('...')

Screenshots / Videos / Template Code

Environment Details: - PHP Version [e.g. 8.0.30] - Server API - FPM/FastCGI - Web Server & OS: Linux vm35.x6lab.com 5.14.0-362.24.1.el9_3.0.1.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Apr 4 22:31:43 UTC 2024 x86_64

BoldMinded (Brian)

Hi, Kevin. You said when you remove it from Structure, can you share a screenshot of what you’re clicking to do this?

BoldMinded (Brian)

Comment has been marked private.

Kevin Chatel

Comment has been marked private.