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: Exception Caught on saving of an entry
Status | Resolved |
Add-on / Version | Publisher 2.8.3 build c996c438 |
Severity | |
EE Version | 3.5.16 |
pixi
Jul 16, 2018Grrrr I come with a new one (sorry…)
When editing an entry (or just open it) (via CP) and trying to save it, I got this now :
Exception Caught
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘field_id_67’ in ‘field list’:
UPDATE `exp_channel_data` SET `field_id_3` = ‘ass_pro|ass_pla’, `field_id_4` = ‘’, `field_id_5` = ‘’, `field_id_6` = ‘’, `field_id_7` = ‘’, `field_id_42` = ‘’, `field_id_8` = ‘’, `field_id_10` = ‘’, `field_id_11` = ‘’, `field_id_12` = ‘’, `field_id_13` = ‘’, `field_id_14` = ‘’, `field_id_15` = 0, `field_id_16` = ‘’, `field_id_39` = ‘’, `field_id_17` = ‘’, `field_id_18` = ‘’, `field_id_19` = ‘’, `field_id_20` = ‘’, `field_id_45` = ‘’, `field_id_21` = ‘’, `field_id_22` = ‘’, `field_id_23` = ‘’, `field_id_24` = ‘’, `field_id_25` = ‘’, `field_id_31` = ‘’, `field_id_32` = ‘’, `field_id_41` = ‘’, `field_id_26` = ‘’, `field_id_27` = ‘’, `field_id_28` = ‘’, `field_id_29` = ‘’, `field_id_46` = ‘’, `field_id_33` = ‘’, `field_id_44` = ‘’, `field_id_47` = ‘’, `field_id_50` = ‘’, `field_id_51` = ‘’, `field_id_52` = ‘’, `field_id_53` = ‘’, `field_id_54` = ‘’, `field_id_55` = ‘’, `field_id_56` = ‘’, `field_id_57` = ‘’, `field_id_58` = 0, `field_id_59` = ‘’, `field_id_60` = ‘’, `field_id_61` = ‘’, `field_id_63` = ‘’, `field_id_64` = ‘’, `field_id_65` = ‘’, `field_id_66` = ‘’, `field_id_67` = ‘’, `field_id_68` = ‘’, `field_id_69` = ‘’, `field_id_70` = ‘’, `field_id_71` = 0, `field_id_72` = ‘’, `field_id_73` = ‘’, `field_id_74` = ‘’, `field_id_75` = ‘’, `field_id_76` = ‘’, `field_id_77` = ‘’, `field_id_78` = ‘’, `field_id_79` = ‘’, `field_id_80` = ‘’, `field_id_81` = ‘’, `field_id_82` = ‘’, `field_id_83` = ‘’, `field_id_84` = 0, `field_id_85` = ‘’, `field_id_86` = ‘’, `field_id_87` = ‘’ WHERE `entry_id` = 1
ee/legacy/database/drivers/mysqli/mysqli_connection.php:122
Stack Trace: hide details
#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(137): CI_DB_mysqli_connection->query(‘UPDATE `exp_cha…’)
#1 ee/legacy/database/DB_driver.php(297): CI_DB_mysqli_driver->_execute(‘UPDATE `exp_cha…’)
#2 ee/legacy/database/DB_driver.php(203): CI_DB_driver->simple_query(‘UPDATE `exp_cha…’)
#3 ee/legacy/database/DB_active_rec.php(1572): CI_DB_driver->query(‘UPDATE `exp_cha…’)
#4 user/addons/publisher/Service/Entry/Entry.php(526): CI_DB_active_record->update(‘channel_data’, Array)
#5 user/addons/publisher/Service/Entry/Entry.php(284): BoldMinded\Publisher\Service\Entry\Entry->cleanup(Object(BoldMinded\Publisher\Model\EntryTranslation))
#6 user/addons/publisher/ext.publisher.php(458): BoldMinded\Publisher\Service\Entry\Entry->save(Object(EllisLab\ExpressionEngine\Model\Channel\ChannelEntry), Array)
#7 ee/legacy/libraries/Extensions.php(243): Publisher_ext->after_channel_entry_save(Object(EllisLab\ExpressionEngine\Model\Channel\ChannelEntry), Array)
#8 ee/legacy/libraries/Extensions.php(138): EE_Extensions->call_class(‘Publisher_ext’, ‘after_channel_e…’, Array, Array)
#9 [internal function]: EE_Extensions->call(‘after_channel_e…’, Object(EllisLab\ExpressionEngine\Model\Channel\ChannelEntry), Array)
#10 ee/EllisLab/ExpressionEngine/Service/Model/Model.php(642): call_user_func_array(Array, Array)
#11 [internal function]: EllisLab\ExpressionEngine\Service\Model\Model->EllisLab\ExpressionEngine\Service\Model\{closure}(‘after_channel_e…’, Object(EllisLab\ExpressionEngine\Model\Channel\ChannelEntry), Array)
#12 ee/EllisLab/ExpressionEngine/Service/Model/Model.php(615): call_user_func_array(Object(Closure), Array)
#13 [internal function]: EllisLab\ExpressionEngine\Service\Model\Model->EllisLab\ExpressionEngine\Service\Model\{closure}()
#14 ee/EllisLab/ExpressionEngine/Service/Event/Emitter.php(153): call_user_func_array(Object(Closure), Array)
#15 [internal function]: EllisLab\ExpressionEngine\Service\Event\Emitter->emit(‘afterSave’)
#16 ee/EllisLab/ExpressionEngine/Library/Data/Entity.php(630): call_user_func_array(Array, Array)
#17 [internal function]: EllisLab\ExpressionEngine\Library\Data\Entity->emit(‘afterSave’)
#18 ee/EllisLab/ExpressionEngine/Service/Model/Model.php(834): call_user_func_array(‘parent::emit’, Array)
#19 ee/EllisLab/ExpressionEngine/Service/Model/Query/Update.php(60): EllisLab\ExpressionEngine\Service\Model\Model->emit(‘afterSave’)
#20 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(294): EllisLab\ExpressionEngine\Service\Model\Query\Update->run()
#21 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(260): EllisLab\ExpressionEngine\Service\Model\DataStore->runQuery(‘Update’, Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#22 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(83): EllisLab\ExpressionEngine\Service\Model\DataStore->updateQuery(Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#23 ee/EllisLab/ExpressionEngine/Service/Model/Model.php(366): EllisLab\ExpressionEngine\Service\Model\Query\Builder->update()
#24 ee/EllisLab/ExpressionEngine/Model/Content/ContentModel.php(198): EllisLab\ExpressionEngine\Service\Model\Model->save()
#25 ee/EllisLab/ExpressionEngine/Controller/Publish/AbstractPublish.php(296): EllisLab\ExpressionEngine\Model\Content\ContentModel->save()
#26 ee/EllisLab/ExpressionEngine/Controller/Publish/Edit.php(483): EllisLab\ExpressionEngine\Controller\Publish\AbstractPublish->saveEntryAndRedirect(Object(EllisLab\ExpressionEngine\Model\Channel\ChannelEntry))
#27 [internal function]: EllisLab\ExpressionEngine\Controller\Publish\Edit->entry(‘1’)
#28 ee/EllisLab/ExpressionEngine/Core/Core.php(189): call_user_func_array(Array, Array)
#29 ee/EllisLab/ExpressionEngine/Core/Core.php(94): EllisLab\ExpressionEngine\Core\Core->runController(Array)
#30 ee/EllisLab/ExpressionEngine/Boot/boot.php(151): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
#31 admin_panel.php(143): require_once(’...’)
#31 admin_panel.php(143): require_once(’...’)
Maybe is it due to the last change we did to RelationshipType.php (ticket 1787) ?
Thanks in advance for your help.
BoldMinded (Brian)
Go to Publisher > Utilities > Database Cleanup. Does it say “Your database looks good, no columns are out of sync.” or something else?
BoldMinded (Brian)
Comment has been marked private.
pixi
Database Cleanup did the job. To be honnest I always go to Database Cleanup in the first place but as it always tells “Your database looks good, no columns are out of sync.” I didn’t go this time…I feel sorry :-s
BoldMinded (Brian)
Weird. The cleanup is generally only for sites after an upgrade. If you wanted to explore this a bit, try making a new field, then saving an entry. Then delete that field, and save again to see if the same error crops up.
pixi
Just tried and no it doesn’t cause the issue.
Maybe it could be after visitor uninstall (I know visitor creates custom fields on installation process)? But I don’t know how visitor could interfere here and it is similar to just create a custom field and delete it so…
By the way now you know that your cleanup database tool works for that too :D (I’m trying to be forgiven here)
BoldMinded (Brian)
Yeah, Visitor may have done something out of the ordinary, hard to tell. Anyway, glad its sorted out 😊