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)

Jan 16, 2020

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

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

Nick Johnson

Jan 20, 2020

Comment has been marked private.

BoldMinded (Brian)

Jan 20, 2020

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

Nick Johnson

Jan 20, 2020

Yes, 3.0.0

BoldMinded (Brian)

Jan 20, 2020

Comment has been marked private.

Nick Johnson

Jan 20, 2020

That works, thank you Brian!

BoldMinded (Brian)

Jan 20, 2020

Excellent. I pushed that version out publicly for others.