EE4 compatibility updates:

Publisher is EE4 and EE5 compatible, but it does not currently support the Fluid field (it's in the works).
Reel is EE4 and EE5 compatible, but it does not currently support the Fluid field.

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).

BoldMinded (Brian)

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

Nick Johnson

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('...')

Nick Johnson

Comment has been marked private.

BoldMinded (Brian)

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

Nick Johnson

Yes, 3.0.0

BoldMinded (Brian)

Comment has been marked private.

Nick Johnson

That works, thank you Brian!

BoldMinded (Brian)

Excellent. I pushed that version out publicly for others.