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