EE compatibility updates:

  • Publisher is EE5 compatible, but it does not currently support the Fluid field.

ExpressionEngine.com licenses:

  • 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: MySQL error when saving entry after upgrading to Publisher 3.1.1

Status Resolved
Add-on / Version Publisher 3.1.1
Severity
EE Version 5.3.0

Nick Johnson

Jan 16, 2020

We recently upgraded a client site to:
- ExpressionEngine 5.3.0
- Publisher 3.1.1
- Bloqs 4.2.1

Since then, every time an entry is saved the following MySQL error is shown:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd.field_id_23' in 'field list':
SELECT `t`.`entry_id`, `t`.`title` AS field_id_0, `d`.`field_id_23`, `d`.`field_id_35`, `d`.`field_id_79`, `d`.`field_id_81`, `t`.`lang_id`, `t`.`status` FROM (`exp_publisher_titles` t) INNER JOIN `exp_publisher_data` d ON `t`.`entry_id` = `d`.`entry_id` AND t.lang_id = d.lang_id AND t.status = d.status WHERE `t`.`channel_id` IN (5) AND `t`.`entry_id` IN (3)

There is an `exp_publisher_data` data, but it only contains the columns: id, site_id, channel_id, entry_id, lang_id, and status. Otherwise, I now have `exp_publisher_data_field_X` tables (where X is anywhere from 1 to 103).

#1

BoldMinded (Brian)

Jan 16, 2020

Is there more to that stack trace? E.g. what file and line of code is generating that error?

#2

Nick Johnson

Jan 20, 2020

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('SELECT `t`.`ent…')
#1 ee/legacy/database/DB_driver.php(270): CI_DB_mysqli_driver->_execute('SELECT `t`.`ent…')
#2 ee/legacy/database/DB_driver.php(180): CI_DB_driver->simple_query('SELECT `t`.`ent…')
#3 ee/legacy/database/DB_active_rec.php(1138): CI_DB_driver->query('SELECT `t`.`ent…')
#4 user/addons/publisher_low_search/ext.publisher_low_search.php(204): CI_DB_active_record->get()
#5 ee/legacy/libraries/Extensions.php(222): Publisher_low_search_ext->low_search_get_index_entries(Array, Array)
#6 ee/legacy/libraries/Extensions.php(117): EE_Extensions->call_class('Publisher_low_s…', 'low_search_get_…', Array, Array)
#7 user/addons/low_search/libraries/Low_search_index.php(224): EE_Extensions->call('low_search_get_…', Array, Array)
#8 user/addons/low_search/libraries/Low_search_index.php(83): Low_search_index->build_by_collection(1, Array)
#9 user/addons/low_search/ext.low_search.php(95): Low_search_index->build_by_entry(Array)
#10 user/addons/low_search/ext.low_search.php(121): Low_search_ext->after_channel_entry_save(Object(EllisLab\ExpressionEngine\Model\Channel\ChannelEntry), Array)
#11 ee/legacy/libraries/Extensions.php(222): Low_search_ext->after_channel_entry_update(Object(EllisLab\ExpressionEngine\Model\Channel\ChannelEntry), Array, Array)
#12 ee/legacy/libraries/Extensions.php(117): EE_Extensions->call_class('Low_search_ext', 'after_channel_e…', Array, Array)
#13 [internal function]: EE_Extensions->call('after_channel_e…', Object(EllisLab\ExpressionEngine\Model\Channel\ChannelEntry), Array, Array)
#14 ee/EllisLab/ExpressionEngine/Service/Model/Model.php(635): call_user_func_array(Array, Array)
#15 [internal function]: EllisLab\ExpressionEngine\Service\Model\Model->EllisLab\ExpressionEngine\Service\Model\{closure}('after_channel_e…', Object(EllisLab\ExpressionEngine\Model\Channel\ChannelEntry), Array, Array)
#16 ee/EllisLab/ExpressionEngine/Service/Model/Model.php(608): call_user_func_array(Object(Closure), Array)
#17 [internal function]: EllisLab\ExpressionEngine\Service\Model\Model->EllisLab\ExpressionEngine\Service\Model\{closure}(Array)
#18 ee/EllisLab/ExpressionEngine/Service/Event/Emitter.php(141): call_user_func_array(Object(Closure), Array)
#19 [internal function]: EllisLab\ExpressionEngine\Service\Event\Emitter->emit('afterUpdate', Array)
#20 ee/EllisLab/ExpressionEngine/Library/Data/Entity.php(654): call_user_func_array(Array, Array)
#21 [internal function]: EllisLab\ExpressionEngine\Library\Data\Entity->emit('afterUpdate', Array)
#22 ee/EllisLab/ExpressionEngine/Service/Model/Model.php(828): call_user_func_array('parent::emit', Array)
#23 ee/EllisLab/ExpressionEngine/Service/Model/Query/Update.php(52): EllisLab\ExpressionEngine\Service\Model\Model->emit('afterUpdate', Array)
#24 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(282): EllisLab\ExpressionEngine\Service\Model\Query\Update->run()
#25 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(248): EllisLab\ExpressionEngine\Service\Model\DataStore->runQuery('Update', Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#26 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(71): EllisLab\ExpressionEngine\Service\Model\DataStore->updateQuery(Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#27 ee/EllisLab/ExpressionEngine/Service/Model/Model.php(361): EllisLab\ExpressionEngine\Service\Model\Query\Builder->update()
#28 ee/EllisLab/ExpressionEngine/Model/Content/ContentModel.php(225): EllisLab\ExpressionEngine\Service\Model\Model->save()
#29 ee/EllisLab/ExpressionEngine/Controller/Publish/AbstractPublish.php(376): EllisLab\ExpressionEngine\Model\Content\ContentModel->save()
#30 ee/EllisLab/ExpressionEngine/Controller/Publish/Edit.php(527): EllisLab\ExpressionEngine\Controller\Publish\AbstractPublish->saveEntryAndRedirect(Object(EllisLab\ExpressionEngine\Model\Channel\ChannelEntry))
#31 [internal function]: EllisLab\ExpressionEngine\Controller\Publish\Edit->entry('3')
#32 ee/EllisLab/ExpressionEngine/Core/Core.php(241): call_user_func_array(Array, Array)
#33 ee/EllisLab/ExpressionEngine/Core/Core.php(110): EllisLab\ExpressionEngine\Core\Core->runController(Array)
#34 ee/EllisLab/ExpressionEngine/Boot/boot.php(151): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
#35 admin.php(153): require_once('...')
#35 admin.php(153): require_once('...')
#3

Nick Johnson

Jan 20, 2020

Comment has been marked private.

#4

BoldMinded (Brian)

Jan 20, 2020

Are you sure you have the latest version of Publisher low search installed?

#5

Nick Johnson

Jan 20, 2020

Yes, 3.0.0

#6

BoldMinded (Brian)

Jan 20, 2020

Comment has been marked private.

#7

Nick Johnson

Jan 20, 2020

That works, thank you Brian!

#8

BoldMinded (Brian)

Jan 20, 2020

Excellent. I pushed that version out publicly for others.

Login to reply

For add-on support, please use the Support section. General inquries and pre-sale questions can be sent to support@boldminded.com.