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, 2018

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

#1

BoldMinded (Brian)

Go to Publisher > Utilities > Database Cleanup. Does it say “Your database looks good, no columns are out of sync.” or something else?

#2

BoldMinded (Brian)

Comment has been marked private.

#3

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

#4

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.

#5

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)

#6

BoldMinded (Brian)

Yeah, Visitor may have done something out of the ordinary, hard to tell. Anyway, glad its sorted out 😊

Login to reply