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: Error on field creation (Column already exists: 1060 Duplicate column name) and on Entry Save (Colum

Status Resolved
Add-on / Version Publisher 2.6.5
Severity
EE Version 3.5.9

Gregory Maher

Nov 10, 2017

Hi Brian,
We’re running into an issue that seems to have two parts. First, when creating new fields we get the following error although the field gets created correctly. Sorry in advance for the long error messages but I wanted to include everything incase it’s helpful. It almost looks as though something is out of sync. Could an auto-increment value be off?

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name ‘field_id_668’:
ALTER TABLE `exp_publisher_data` ADD `field_id_668` text

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(‘ALTER TABLE `ex…’)
#1 ee/legacy/database/DB_driver.php(297): CI_DB_mysqli_driver->_execute(‘ALTER TABLE `ex…’)
#2 ee/legacy/database/DB_driver.php(203): CI_DB_driver->simple_query(‘ALTER TABLE `ex…’)
#3 ee/legacy/database/DB_forge.php(282): CI_DB_driver->query(‘ALTER TABLE `ex…’)
#4 user/addons/publisher/Service/Schema/AbstractSchema.php(165): CI_DB_forge->add_column(‘publisher_data’, Array)
#5 user/addons/publisher/ext.publisher.php(479): BoldMinded\Publisher\Service\Schema\AbstractSchema->saveField(‘field_id_668’)
#6 ee/legacy/libraries/Extensions.php(243): Publisher_ext->after_channel_field_update(Object(EllisLab\ExpressionEngine\Model\Channel\ChannelField), Array, Array)
#7 ee/legacy/libraries/Extensions.php(138): EE_Extensions->call_class(‘Publisher_ext’, ‘after_channel_f…’, Array, Array)
#8 [internal function]: EE_Extensions->call(‘after_channel_f…’, Object(EllisLab\ExpressionEngine\Model\Channel\ChannelField), Array, Array)
#9 ee/EllisLab/ExpressionEngine/Service/Model/Model.php(642): call_user_func_array(Array, Array)
#10 [internal function]: EllisLab\ExpressionEngine\Service\Model\Model->EllisLab\ExpressionEngine\Service\Model\{closure}(‘after_channel_f…’, Object(EllisLab\ExpressionEngine\Model\Channel\ChannelField), Array, Array)
#11 ee/EllisLab/ExpressionEngine/Service/Model/Model.php(615): call_user_func_array(Object(Closure), Array)
#12 [internal function]: EllisLab\ExpressionEngine\Service\Model\Model->EllisLab\ExpressionEngine\Service\Model\{closure}(Array)
#13 ee/EllisLab/ExpressionEngine/Service/Event/Emitter.php(153): call_user_func_array(Object(Closure), Array)
#14 [internal function]: EllisLab\ExpressionEngine\Service\Event\Emitter->emit(‘afterUpdate’, Array)
#15 ee/EllisLab/ExpressionEngine/Library/Data/Entity.php(630): call_user_func_array(Array, Array)
#16 [internal function]: EllisLab\ExpressionEngine\Library\Data\Entity->emit(‘afterUpdate’, Array)
#17 ee/EllisLab/ExpressionEngine/Service/Model/Model.php(834): call_user_func_array(‘parent::emit’, Array)
#18 ee/EllisLab/ExpressionEngine/Service/Model/Query/Update.php(61): EllisLab\ExpressionEngine\Service\Model\Model->emit(‘afterUpdate’, Array)
#19 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(294): EllisLab\ExpressionEngine\Service\Model\Query\Update->run()
#20 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(260): EllisLab\ExpressionEngine\Service\Model\DataStore->runQuery(‘Update’, Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#21 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(83): EllisLab\ExpressionEngine\Service\Model\DataStore->updateQuery(Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#22 ee/EllisLab/ExpressionEngine/Service/Model/Model.php(366): EllisLab\ExpressionEngine\Service\Model\Query\Builder->update()
#23 ee/EllisLab/ExpressionEngine/Model/Content/FieldModel.php(121): EllisLab\ExpressionEngine\Service\Model\Model->save()
#24 ee/EllisLab/ExpressionEngine/Controller/Channels/Fields/Fields.php(228): EllisLab\ExpressionEngine\Model\Content\FieldModel->save()
#25 [internal function]: EllisLab\ExpressionEngine\Controller\Channels\Fields\Fields->edit(‘668’)
#26 ee/EllisLab/ExpressionEngine/Core/Core.php(189): call_user_func_array(Array, Array)
#27 ee/EllisLab/ExpressionEngine/Core/Core.php(94): EllisLab\ExpressionEngine\Core\Core->runController(Array)
#28 ee/EllisLab/ExpressionEngine/Boot/boot.php(151): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
#29 httpdocs/admin.php(145): require_once(’...’)
#29 httpdocs/admin.php(145): require_once(’...’)

Then, when editing (or creating new) content we’re getting another error:

Exception Caught

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘field_id_669’ in ‘field list’:
UPDATE `exp_channel_data` SET `field_id_1` = ‘’, `field_id_2` = ‘’, `field_id_3` = ‘’, `field_id_13` = ‘’, `field_id_21` = ‘’, `field_id_26` = ‘’, `field_id_27` = ‘’, `field_id_29` = ‘’, `field_id_30` = ‘’, `field_id_31` = ‘’, `field_id_32` = ‘’, `field_id_33` = ‘’, `field_id_34` = ‘’, `field_id_63` = ‘’, `field_id_64` = ‘’, `field_id_65` = ‘’, `field_id_66` = ‘’, `field_id_67` = ‘’, `field_id_70` = ‘’, `field_id_71` = ‘’, `field_id_72` = ‘’, `field_id_73` = ‘’, `field_id_74` = ‘’, `field_id_77` = ‘’, `field_id_82` = ‘’, `field_id_83` = ‘’, `field_id_84` = ‘’, `field_id_85` = ‘’, `field_id_86` = ‘’, `field_id_87` = ‘’, `field_id_88` = ‘’, `field_id_89` = ‘’, `field_id_90` = ‘’, `field_id_92` = ‘’, `field_id_93` = ‘’, `field_id_94` = ‘’, `field_id_95` = ‘’, `field_id_96` = ‘’, `field_id_97` = ‘’, `field_id_98` = ‘’, `field_id_99` = ‘Test’, `field_id_100` = ‘Test’, `field_id_101` = ‘’, `field_id_102` = ‘’, `field_id_103` = ‘’, `field_id_105` = ‘’, `field_id_110` = ‘’, `field_id_127` = ‘’, `field_id_128` = ‘’, `field_id_129` = ‘’, `field_id_130` = ‘Test’, `field_id_131` = ‘’, `field_id_132` = ‘’, `field_id_133` = ‘’, `field_id_134` = ‘’, `field_id_135` = ‘’, `field_id_136` = ‘’, `field_id_137` = ‘’, `field_id_138` = ‘’, `field_id_139` = ‘’, `field_id_140` = ‘’, `field_id_141` = ‘’, `field_id_142` = ‘’, `field_id_143` = ‘’, `field_id_144` = ‘’, `field_id_145` = ‘’, `field_id_146` = ‘’, `field_id_147` = ‘’, `field_id_148` = ‘’, `field_id_149` = ‘’, `field_id_205` = ‘’, `field_id_210` = ‘’, `field_id_211` = ‘’, `field_id_212` = ‘’, `field_id_213` = ‘’, `field_id_214` = ‘’, `field_id_215` = ‘’, `field_id_216` = ‘’, `field_id_217` = ‘’, `field_id_218` = ‘’, `field_id_219` = ‘’, `field_id_220` = ‘’, `field_id_221` = ‘’, `field_id_223` = ‘’, `field_id_224` = ‘’, `field_id_225` = ‘’, `field_id_226` = ‘’, `field_id_227` = ‘’, `field_id_229` = ‘’, `field_id_230` = ‘’, `field_id_231` = 0, `field_id_232` = ‘’, `field_id_233` = ‘’, `field_id_234` = ‘’, `field_id_235` = 0, `field_id_236` = ‘’, `field_id_237` = ‘’, `field_id_238` = ‘’, `field_id_239` = ‘’, `field_id_240` = ‘’, `field_id_241` = ‘’, `field_id_242` = ‘’, `field_id_243` = ‘’, `field_id_244` = ‘’, `field_id_245` = ‘’, `field_id_246` = ‘’, `field_id_247` = ‘’, `field_id_248` = ‘’, `field_id_249` = ‘’, `field_id_250` = ‘’, `field_id_251` = ‘’, `field_id_252` = ‘’, `field_id_253` = ‘’, `field_id_254` = ‘’, `field_id_255` = ‘’, `field_id_256` = ‘’, `field_id_257` = ‘’, `field_id_258` = ‘’, `field_id_259` = ‘’, `field_id_260` = ‘’, `field_id_261` = ‘’, `field_id_262` = ‘’, `field_id_263` = ‘’, `field_id_264` = ‘’, `field_id_265` = ‘’, `field_id_266` = ‘’, `field_id_267` = ‘’, `field_id_268` = ‘’, `field_id_269` = ‘’, `field_id_270` = ‘’, `field_id_271` = ‘’, `field_id_272` = ‘’, `field_id_273` = ‘’, `field_id_274` = 0, `field_id_275` = 0, `field_id_276` = 0, `field_id_277` = ‘’, `field_id_278` = ‘’, `field_id_279` = 0, `field_id_280` = ‘’, `field_id_281` = ‘’, `field_id_282` = ‘’, `field_id_283` = ‘’, `field_id_284` = ‘’, `field_id_285` = 0, `field_id_286` = ‘’, `field_id_287` = 0, `field_id_288` = 0, `field_id_289` = ‘’, `field_id_290` = ‘’, `field_id_291` = ‘’, `field_id_292` = ‘’, `field_id_293` = ‘’, `field_id_294` = ‘’, `field_id_295` = ‘’, `field_id_296` = ‘’, `field_id_297` = ‘’, `field_id_298` = ‘’, `field_id_299` = ‘’, `field_id_300` = ‘’, `field_id_301` = ‘’, `field_id_302` = ‘’, `field_id_303` = ‘’, `field_id_304` = ‘’, `field_id_305` = ‘’, `field_id_306` = ‘’, `field_id_307` = ‘’, `field_id_308` = 0, `field_id_309` = 0, `field_id_310` = ‘’, `field_id_311` = ‘’, `field_id_312` = ‘’, `field_id_313` = ‘’, `field_id_314` = ‘’, `field_id_315` = 0, `field_id_316` = ‘’, `field_id_317` = ‘’, `field_id_318` = ‘’, `field_id_319` = 0, `field_id_320` = ‘’, `field_id_321` = ‘’, `field_id_322` = ‘’, `field_id_323` = ‘’, `field_id_324` = ‘’, `field_id_325` = ‘’, `field_id_326` = ‘’, `field_id_327` = ‘’, `field_id_328` = ‘’, `field_id_329` = ‘’, `field_id_330` = ‘’, `field_id_331` = ‘’, `field_id_332` = ‘’, `field_id_333` = ‘’, `field_id_334` = ‘’, `field_id_335` = ‘’, `field_id_336` = ‘’, `field_id_337` = ‘’, `field_id_338` = ‘’, `field_id_339` = ‘’, `field_id_340` = ‘’, `field_id_341` = ‘’, `field_id_342` = ‘’, `field_id_343` = ‘’, `field_id_344` = ‘’, `field_id_345` = ‘’, `field_id_346` = ‘’, `field_id_347` = ‘’, `field_id_348` = ‘’, `field_id_349` = ‘’, `field_id_350` = ‘’, `field_id_351` = ‘’, `field_id_352` = ‘’, `field_id_353` = ‘’, `field_id_354` = ‘’, `field_id_355` = ‘’, `field_id_356` = ‘’, `field_id_357` = ‘’, `field_id_358` = 0, `field_id_359` = 0, `field_id_360` = 0, `field_id_361` = ‘’, `field_id_362` = ‘’, `field_id_363` = 0, `field_id_364` = ‘’, `field_id_365` = ‘’, `field_id_366` = ‘’, `field_id_367` = ‘’, `field_id_368` = ‘’, `field_id_369` = 0, `field_id_370` = ‘’, `field_id_371` = 0, `field_id_372` = 0, `field_id_373` = ‘’, `field_id_376` = ‘’, `field_id_377` = ‘’, `field_id_378` = ‘’, `field_id_379` = ‘’, `field_id_380` = ‘’, `field_id_381` = ‘’, `field_id_382` = ‘’, `field_id_383` = ‘’, `field_id_384` = ‘’, `field_id_385` = ‘’, `field_id_386` = ‘’, `field_id_387` = ‘’, `field_id_388` = ‘’, `field_id_389` = ‘’, `field_id_390` = ‘’, `field_id_391` = ‘’, `field_id_392` = 0, `field_id_393` = 0, `field_id_394` = ‘’, `field_id_395` = ‘’, `field_id_396` = ‘’, `field_id_397` = 0, `field_id_398` = ‘’, `field_id_399` = ‘’, `field_id_400` = ‘’, `field_id_401` = 0, `field_id_402` = ‘’, `field_id_403` = ‘’, `field_id_404` = ‘’, `field_id_405` = ‘’, `field_id_406` = ‘’, `field_id_407` = ‘’, `field_id_408` = ‘’, `field_id_409` = ‘’, `field_id_410` = ‘’, `field_id_411` = ‘’, `field_id_412` = ‘’, `field_id_413` = ‘’, `field_id_414` = ‘’, `field_id_415` = ‘’, `field_id_416` = ‘’, `field_id_417` = ‘’, `field_id_418` = ‘’, `field_id_419` = ‘’, `field_id_420` = ‘’, `field_id_421` = ‘’, `field_id_422` = ‘’, `field_id_423` = ‘’, `field_id_424` = ‘’, `field_id_425` = ‘’, `field_id_426` = ‘’, `field_id_427` = ‘’, `field_id_428` = ‘’, `field_id_429` = ‘’, `field_id_431` = ‘’, `field_id_432` = ‘’, `field_id_433` = ‘’, `field_id_434` = ‘’, `field_id_435` = ‘’, `field_id_436` = ‘’, `field_id_437` = ‘’, `field_id_438` = ‘’, `field_id_439` = ‘’, `field_id_440` = 0, `field_id_441` = 0, `field_id_442` = 0, `field_id_443` = ‘’, `field_id_444` = ‘’, `field_id_445` = 0, `field_id_446` = ‘’, `field_id_447` = ‘’, `field_id_448` = ‘’, `field_id_449` = ‘’, `field_id_450` = ‘’, `field_id_451` = 0, `field_id_452` = ‘’, `field_id_453` = 0, `field_id_454` = 0, `field_id_455` = ‘’, `field_id_456` = ‘’, `field_id_457` = ‘’, `field_id_458` = ‘’, `field_id_459` = ‘’, `field_id_460` = ‘’, `field_id_461` = ‘’, `field_id_462` = ‘’, `field_id_463` = ‘’, `field_id_464` = ‘’, `field_id_465` = ‘’, `field_id_466` = ‘’, `field_id_467` = ‘’, `field_id_468` = ‘’, `field_id_469` = ‘’, `field_id_470` = ‘’, `field_id_471` = ‘’, `field_id_472` = ‘’, `field_id_473` = ‘’, `field_id_474` = 0, `field_id_475` = 0, `field_id_476` = ‘’, `field_id_477` = ‘’, `field_id_478` = ‘’, `field_id_479` = ‘’, `field_id_480` = ‘’, `field_id_481` = ‘’, `field_id_482` = ‘’, `field_id_483` = ‘’, `field_id_484` = ‘’, `field_id_485` = ‘’, `field_id_486` = ‘’, `field_id_487` = ‘’, `field_id_488` = ‘’, `field_id_489` = ‘’, `field_id_490` = ‘’, `field_id_491` = ‘’, `field_id_492` = ‘’, `field_id_493` = ‘’, `field_id_495` = ‘’, `field_id_496` = ‘’, `field_id_497` = ‘’, `field_id_498` = ‘’, `field_id_499` = ‘’, `field_id_500` = ‘’, `field_id_501` = ‘’, `field_id_502` = ‘’, `field_id_503` = ‘’, `field_id_504` = ‘’, `field_id_505` = ‘’, `field_id_506` = ‘’, `field_id_507` = ‘’, `field_id_508` = ‘’, `field_id_509` = ‘’, `field_id_510` = ‘’, `field_id_511` = ‘’, `field_id_512` = ‘’, `field_id_516` = ‘’, `field_id_517` = ‘’, `field_id_518` = ‘’, `field_id_519` = ‘’, `field_id_525` = ‘’, `field_id_526` = ‘’, `field_id_527` = ‘’, `field_id_528` = ‘’, `field_id_529` = ‘’, `field_id_530` = ‘’, `field_id_531` = ‘’, `field_id_533` = ‘’, `field_id_534` = ‘’, `field_id_535` = ‘’, `field_id_536` = ‘’, `field_id_537` = ‘’, `field_id_538` = ‘’, `field_id_539` = ‘’, `field_id_540` = ‘’, `field_id_541` = ‘’, `field_id_542` = ‘’, `field_id_543` = ‘’, `field_id_544` = ‘’, `field_id_545` = ‘’, `field_id_546` = ‘’, `field_id_547` = ‘’, `field_id_548` = ‘’, `field_id_549` = ‘’, `field_id_550` = ‘’, `field_id_551` = ‘’, `field_id_552` = ‘’, `field_id_553` = ‘’, `field_id_554` = ‘’, `field_id_555` = ‘’, `field_id_556` = ‘’, `field_id_557` = ‘’, `field_id_558` = ‘’, `field_id_559` = ‘’, `field_id_560` = ‘’, `field_id_561` = ‘’, `field_id_562` = ‘’, `field_id_563` = ‘’, `field_id_564` = ‘’, `field_id_565` = ‘’, `field_id_566` = ‘’, `field_id_567` = ‘’, `field_id_568` = ‘’, `field_id_569` = ‘’, `field_id_570` = ‘’, `field_id_571` = ‘’, `field_id_572` = ‘’, `field_id_573` = ‘’, `field_id_574` = ‘’, `field_id_575` = ‘’, `field_id_576` = ‘’, `field_id_577` = ‘’, `field_id_578` = ‘’, `field_id_579` = ‘’, `field_id_580` = ‘’, `field_id_581` = ‘’, `field_id_582` = ‘’, `field_id_583` = ‘’, `field_id_590` = ‘’, `field_id_591` = ‘’, `field_id_592` = ‘’, `field_id_593` = ‘’, `field_id_594` = ‘’, `field_id_596` = ‘’, `field_id_597` = ‘’, `field_id_598` = ‘’, `field_id_599` = ‘’, `field_id_600` = ‘’, `field_id_601` = ‘’, `field_id_602` = ‘’, `field_id_603` = ‘’, `field_id_604` = ‘’, `field_id_605` = ‘’, `field_id_606` = ‘’, `field_id_607` = ‘’, `field_id_608` = ‘’, `field_id_609` = ‘’, `field_id_610` = ‘’, `field_id_611` = ‘’, `field_id_612` = ‘’, `field_id_613` = ‘’, `field_id_614` = ‘’, `field_id_615` = ‘’, `field_id_616` = ‘’, `field_id_617` = ‘’, `field_id_618` = ‘’, `field_id_619` = ‘’, `field_id_620` = ‘’, `field_id_621` = ‘’, `field_id_622` = ‘’, `field_id_623` = ‘’, `field_id_626` = ‘’, `field_id_630` = ‘’, `field_id_633` = ‘’, `field_id_634` = ‘’, `field_id_635` = ‘’, `field_id_636` = ‘’, `field_id_637` = ‘’, `field_id_638` = ‘’, `field_id_639` = ‘’, `field_id_640` = ‘’, `field_id_641` = ‘’, `field_id_642` = ‘’, `field_id_643` = ‘’, `field_id_644` = ‘’, `field_id_645` = ‘’, `field_id_646` = ‘’, `field_id_649` = ‘’, `field_id_650` = ‘’, `field_id_651` = ‘’, `field_id_652` = ‘’, `field_id_653` = ‘’, `field_id_654` = ‘’, `field_id_655` = ‘’, `field_id_656` = ‘’, `field_id_657` = ‘’, `field_id_658` = ‘’, `field_id_659` = ‘’, `field_id_660` = ‘’, `field_id_661` = ‘’, `field_id_662` = ‘’, `field_id_663` = ‘’, `field_id_664` = ‘’, `field_id_665` = ‘’, `field_id_666` = ‘’, `field_id_667` = ‘’, `field_id_668` = ‘’, `field_id_669` = ‘’ WHERE `entry_id` = ‘11341’

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(434): CI_DB_active_record->update(‘channel_data’, Array)
·      #5 user/addons/publisher/Service/Entry/Entry.php(263): BoldMinded\Publisher\Service\Entry\Entry->cleanup(Object(BoldMinded\Publisher\Model\EntryTranslation))
·      #6 user/addons/publisher/ext.publisher.php(432): 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/Insert.php(43): EllisLab\ExpressionEngine\Service\Model\Model->emit(‘afterSave’)
·      #20 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(294): EllisLab\ExpressionEngine\Service\Model\Query\Insert->run()
·      #21 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(250): EllisLab\ExpressionEngine\Service\Model\DataStore->runQuery(‘Insert’, Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
·      #22 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(91): EllisLab\ExpressionEngine\Service\Model\DataStore->insertQuery(Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
·      #23 ee/EllisLab/ExpressionEngine/Service/Model/Model.php(361): EllisLab\ExpressionEngine\Service\Model\Query\Builder->insert()
·      #24 ee/EllisLab/ExpressionEngine/Model/Content/ContentModel.php(198): EllisLab\ExpressionEngine\Service\Model\Model->save()
·      #25 ee/EllisLab/ExpressionEngine/Controller/Publish/AbstractPublish.php(295): EllisLab\ExpressionEngine\Model\Content\ContentModel->save()
·      #26 ee/EllisLab/ExpressionEngine/Controller/Publish/Publish.php(257): EllisLab\ExpressionEngine\Controller\Publish\AbstractPublish->saveEntryAndRedirect(Object(EllisLab\ExpressionEngine\Model\Channel\ChannelEntry))
·      #27 [internal function]: EllisLab\ExpressionEngine\Controller\Publish\Publish->create(‘2’)
·      #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 httpdocs/admin.php(145): require_once(’...’)
·      #31 httpdocs/admin.php(145): require_once(’...’)

#1

BoldMinded (Brian)

In Publisher’s settings page there is a Utilities > Database Cleanup tool. Try running it to see what it says.

#2

BoldMinded (Brian)

My guess is there used to be a field with the ID of 668, it was deleted, and now you’re adding a new field and it wants to assign 668 to it but Publisher’s table still has the old column.

#3

Gregory Maher

Hi Brian, That seems to have fixed things on the Edit side. However, I’m still getting the error when creating new fields or deleting existing fields.

Are these issues maybe related?

Thanks!

Greg

#4

BoldMinded (Brian)

Try clearing all the caches.

#5

Gregory Maher

OK, I cleared all caches and ran the database cleanup tool. Then, I created a new field and got an error on field creation, although the field was created. Then, I got another error when I tried to save to the field, but the data saved. Then, I got another error when I tried to again delete the field, but the field was deleted. And all of the errors are of the same type of Exception Caught and something to do with duplicate columns or cannot find field.

You can follow those same steps on the development site I shared credentials to and see it for yourself.

Happy to provide more detail if necessary. Just let me know.

Thanks and talk soon!

Greg

#6

BoldMinded (Brian)

I tried to add a field and got the following error. There isn’t any Publisher code in the stack trace and the error is on the exp_channel_data table. So…. not sure whats happening there.

https://www.dropbox.com/s/tghdjban1dm7z5z/Screenshot 2017-11-10 15.35.34.png?dl=0

#7

Gregory Maher

Ok, great Brian. I’ll followup with ExpressionEngine and see if they have any ideas.

Thanks and I’ll keep you posted!

Greg

#8

BoldMinded (Brian)

I would make a backup of the database, then uninstall Publisher, then try adding a new field to see if the error still happens. If it doesn’t, then somehow it is a Publisher issue.

#9

Gregory Maher

Thank, Brian! Trying this now.

Talk soon!

Greg

#10

Gregory Maher

Hi Brian, Just to followup, we tried uninstalling Publisher and the error persists. I have followed up with Ellis Lab and will keep you posted.

Thanks for your help and sorry for the time spent.

Talk soon!

Greg

#11

BoldMinded (Brian)

No worries about time, just want to help you get it sorted out. One thought I had was to note what the highest field_id was in the channel_fields table, and the highest field_id_# in channel_data, then try to add a new field and see if its trying to assign the same id, or if its actually incrementing.

#12

BoldMinded (Brian)

I don’t know what the next step would be depending on the result of that test, but it may lead to something? ¯_(ツ)_/¯

#13

BoldMinded (Brian)

Greg, did you ever figure anything out from EL about this?

#14

BoldMinded (Brian)

Closing this issue b/c I haven’t heard back.

Login to reply