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: Installation error
Status | Resolved |
Add-on / Version | Publisher 2.7.3 |
Severity | |
EE Version | 4.0.2 |
Eric Harth
Dec 21, 2017
Description:
SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘’ for column ‘field_id_348’ at row 1:
INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id, lang_id,
status, field_id_348, field_id_389, field_id_398, field_id_416) VALUES (8345
, 1, 306, 1, ‘open’, ‘’, ‘’, ’ ‘, ’ ‘); INSERT INTO `exp_publisher_data`
(entry_id, site_id, channel_id, lang_id, status, field_id_3,
field_id_348, field_id_389) VALUES (6262, 1, 49, 1, ‘open’,
‘__SENSITIVE_DATA__’, ‘’, ‘’); INSERT INTO `exp_publisher_data` (entry_id,
site_id, channel_id, lang_id, status, field_id_5, field_id_15,
field_id_348, field_id_389, field_id_391) VALUES (15, 1, 4, 1, ‘open’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’, ‘’); INSERT INTO
`exp_publisher_data` (entry_id, site_id, channel_id, lang_id, status,
field_id_63, field_id_64, field_id_67, field_id_69, field_id_71,
field_id_73, field_id_172, field_id_186, field_id_258, field_id_348,
field_id_389) VALUES (8344, 3, 139, 1, ‘open’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘Image’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘’, ‘’); INSERT INTO `exp_publisher_data` (entry_id,
site_id, channel_id, lang_id, status, field_id_63, field_id_64,
field_id_67, field_id_69, field_id_71, field_id_73, field_id_172,
field_id_186, field_id_258, field_id_348, field_id_389) VALUES (8343, 3,
139, 1, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘Image’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘’, ‘’); INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id,
lang_id, status, field_id_147, field_id_148, field_id_348, field_id_389)
VALUES (8342, 3, 136, 1, ‘open’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘’, ‘’); INSERT INTO `exp_publisher_data` (entry_id,
site_id, channel_id, lang_id, status, field_id_104, field_id_249,
field_id_348, field_id_389) VALUES (3158, 8, 131, 1, ‘open’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’); INSERT INTO
`exp_publisher_data` (entry_id, site_id, channel_id, lang_id, status,
field_id_44, field_id_45, field_id_46, field_id_47, field_id_282,
field_id_348, field_id_389) VALUES (8341, 6, 142, 1, ‘open’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ’ ‘,
‘__SENSITIVE_DATA__’, ‘’, ‘’); INSERT INTO `exp_publisher_data` (entry_id,
site_id, channel_id, lang_id, status, field_id_6, field_id_7, field_id_8,
field_id_348, field_id_389) VALUES (27, 1, 5, 1, ‘open’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’);
INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id, lang_id,
status, field_id_5, field_id_11, field_id_15, field_id_196, field_id_348,
field_id_389, field_id_391) VALUES (28, 1, 4, 1, ‘open’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘’, ‘’, ‘’); INSERT INTO `exp_publisher_data` (
entry_id, site_id, channel_id, lang_id, status, field_id_5, field_id_11,
field_id_15, field_id_348, field_id_389, field_id_391) VALUES (29, 1, 4, 1
, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘’, ‘’, ‘’); INSERT INTO `exp_publisher_data` (entry_id, site_id,
channel_id, lang_id, status, field_id_5, field_id_15, field_id_348,
field_id_389, field_id_391) VALUES (37, 1, 4, 1, ‘open’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’, ‘’); INSERT INTO
`exp_publisher_data` (entry_id, site_id, channel_id, lang_id, status,
field_id_54, field_id_55, field_id_348, field_id_389, field_id_391) VALUES (
4822, 6, 145, 1, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’,
‘’, ‘’); INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id,
lang_id, status, field_id_7, field_id_8, field_id_327, field_id_348,
field_id_389) VALUES (41, 1, 5, 1, ‘open’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’); INSERT INTO
`exp_publisher_data` (entry_id, site_id, channel_id, lang_id, status,
field_id_6, field_id_7, field_id_8, field_id_348, field_id_389) VALUES (42,
1, 5, 1, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘’, ‘’); INSERT INTO `exp_publisher_data` (entry_id,
site_id, channel_id, lang_id, status, field_id_6, field_id_7, field_id_8,
field_id_348, field_id_389) VALUES (43, 1, 5, 1, ‘open’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘/snapshots’, ‘’, ‘’); INSERT
INTO `exp_publisher_data` (entry_id, site_id, channel_id, lang_id, status,
field_id_6, field_id_7, field_id_8, field_id_348, field_id_389) VALUES (44,
1, 5, 1, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘’, ‘’); INSERT INTO `exp_publisher_data` (entry_id,
site_id, channel_id, lang_id, status, field_id_6, field_id_7, field_id_8,
field_id_348, field_id_389) VALUES (46, 1, 5, 1, ‘open’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’);
INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id, lang_id,
status, field_id_6, field_id_7, field_id_8, field_id_348, field_id_389)
VALUES (48, 1, 5, 1, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘’, ‘’); INSERT INTO `exp_publisher_data` (entry_id,
site_id, channel_id, lang_id, status, field_id_6, field_id_7, field_id_8,
field_id_348, field_id_389) VALUES (49, 1, 5, 1, ‘open’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’);
INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id, lang_id,
status, field_id_6, field_id_7, field_id_8, field_id_348, field_id_389,
field_id_391) VALUES (51, 1, 5, 1, ‘open’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’, ‘’); INSERT INTO
`exp_publisher_data` (entry_id, site_id, channel_id, lang_id, status,
field_id_6, field_id_7, field_id_8, field_id_348, field_id_389,
field_id_391) VALUES (56, 1, 5, 1, ‘open’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’, ‘’); INSERT INTO
`exp_publisher_data` (entry_id, site_id, channel_id, lang_id, status,
field_id_125, field_id_253, field_id_348, field_id_389) VALUES (2231, 15,
162, 1, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’);
INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id, lang_id,
status, field_id_128, field_id_254, field_id_348, field_id_389,
field_id_391) VALUES (2230, 16, 160, 1, ‘open’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘’, ‘’, ‘’); INSERT INTO `exp_publisher_data` (
entry_id, site_id, channel_id, lang_id, status, field_id_18, field_id_19,
field_id_22, field_id_348, field_id_389, field_id_391) VALUES (59, 1, 6,
1, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘’, ‘’, ‘’); INSERT INTO `exp_publisher_data` (entry_id, site_id,
channel_id, lang_id, status, field_id_18, field_id_19, field_id_22,
field_id_25, field_id_26, field_id_27, field_id_348, field_id_389,
field_id_391) VALUES (61, 1, 6, 1, ‘open’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’, ‘’); INSERT INTO
`exp_publisher_data` (entry_id, site_id, channel_id, lang_id, status,
field_id_18, field_id_19, field_id_22, field_id_25, field_id_26,
field_id_27, field_id_348, field_id_389, field_id_391) VALUES (64, 1, 6, 1
, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’,
‘’); INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id,
lang_id, status, field_id_63, field_id_64, field_id_67, field_id_69,
field_id_71, field_id_73, field_id_172, field_id_175, field_id_186,
field_id_258, field_id_348, field_id_389) VALUES (6261, 3, 139, 1, ‘open’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘Image’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’);
INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id, lang_id,
status, field_id_18, field_id_19, field_id_23, field_id_24, field_id_25,
field_id_26, field_id_348, field_id_389, field_id_391) VALUES (66, 1, 6, 1
, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’,
‘’); INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id,
lang_id, status, field_id_18, field_id_19, field_id_21, field_id_22,
field_id_23, field_id_24, field_id_25, field_id_26, field_id_27,
field_id_348, field_id_389, field_id_391) VALUES (67, 1, 6, 1, ‘open’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’,
‘’); INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id,
lang_id, status, field_id_18, field_id_19, field_id_348, field_id_389,
field_id_391) VALUES (70, 1, 6, 1, ‘open’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘’, ‘’, ‘’); INSERT INTO `exp_publisher_data` (
entry_id, site_id, channel_id, lang_id, status, field_id_18, field_id_19,
field_id_348, field_id_389, field_id_391) VALUES (71, 1, 6, 1, ‘open’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’, ‘’); INSERT INTO
`exp_publisher_data` (entry_id, site_id, channel_id, lang_id, status,
field_id_18, field_id_19, field_id_348, field_id_389, field_id_391) VALUES (
72, 1, 6, 1, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’,
‘’); INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id,
lang_id, status, field_id_18, field_id_19, field_id_348, field_id_389,
field_id_391) VALUES (73, 1, 6, 1, ‘open’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘’, ‘’, ‘’); INSERT INTO `exp_publisher_data` (
entry_id, site_id, channel_id, lang_id, status, field_id_348, field_id_355
, field_id_356, field_id_389) VALUES (6260, 38, 291, 1, ‘open’, ‘’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’); INSERT INTO
`exp_publisher_data` (entry_id, site_id, channel_id, lang_id, status,
field_id_18, field_id_19, field_id_348, field_id_389, field_id_391) VALUES (
77, 1, 6, 1, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’,
‘’); INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id,
lang_id, status, field_id_18, field_id_19, field_id_348, field_id_389,
field_id_391) VALUES (78, 1, 6, 1, ‘open’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘’, ‘’, ‘’); INSERT INTO `exp_publisher_data` (
entry_id, site_id, channel_id, lang_id, status, field_id_18, field_id_19,
field_id_23, field_id_24, field_id_348, field_id_389, field_id_391) VALUES
(79, 1, 6, 1, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’, ‘’); INSERT INTO
`exp_publisher_data` (entry_id, site_id, channel_id, lang_id, status,
field_id_125, field_id_253, field_id_348, field_id_389) VALUES (2233, 15,
162, 1, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’);
INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id, lang_id,
status, field_id_125, field_id_253, field_id_348, field_id_389) VALUES (2232
, 15, 162, 1, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’
); INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id, lang_id,
status, field_id_18, field_id_19, field_id_348, field_id_389,
field_id_391) VALUES (81, 1, 6, 1, ‘open’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘’, ‘’, ‘’); INSERT INTO `exp_publisher_data` (
entry_id, site_id, channel_id, lang_id, status, field_id_18, field_id_19,
field_id_348, field_id_389, field_id_391) VALUES (82, 1, 6, 1, ‘open’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’, ‘’); INSERT INTO
`exp_publisher_data` (entry_id, site_id, channel_id, lang_id, status,
field_id_18, field_id_19, field_id_348, field_id_389, field_id_391) VALUES (
83, 1, 6, 1, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’,
‘’); INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id,
lang_id, status, field_id_18, field_id_19, field_id_348, field_id_389,
field_id_391) VALUES (84, 1, 6, 1, ‘open’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘’, ‘’, ‘’); INSERT INTO `exp_publisher_data` (
entry_id, site_id, channel_id, lang_id, status, field_id_18, field_id_19,
field_id_348, field_id_389, field_id_391) VALUES (85, 1, 6, 1, ‘open’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’, ‘’); INSERT INTO
`exp_publisher_data` (entry_id, site_id, channel_id, lang_id, status,
field_id_18, field_id_19, field_id_348, field_id_389, field_id_391) VALUES (
86, 1, 6, 1, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’,
‘’); INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id,
lang_id, status, field_id_18, field_id_19, field_id_23, field_id_24,
field_id_27, field_id_348, field_id_389, field_id_415) VALUES (87, 1, 6, 1
, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’, ‘__SENSITIVE_DATA__’);
INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id, lang_id,
status, field_id_18, field_id_19, field_id_348, field_id_389, field_id_391)
VALUES (88, 1, 6, 1, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘’, ‘’, ‘’); INSERT INTO `exp_publisher_data` (entry_id, site_id,
channel_id, lang_id, status, field_id_18, field_id_19, field_id_25,
field_id_26, field_id_27, field_id_348, field_id_389, field_id_391) VALUES (
89, 1, 6, 1, ‘open’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘__SENSITIVE_DATA__’, ‘’, ‘’,
‘’); INSERT INTO `exp_publisher_data` (entry_id, site_id, channel_id,
lang_id, status, field_id_18, field_id_19, field_id_348, field_id_389,
field_id_391) VALUES (90, 1, 6, 1, ‘open’, ‘__SENSITIVE_DATA__’,
‘__SENSITIVE_DATA__’, ‘’, ‘’, ‘’)
Stack Trace:
#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(111): CI_DB_mysqli_connection->query(‘INSERT INTO `ex…’)
#1 ee/legacy/database/DB_driver.php(269): CI_DB_mysqli_driver->_execute(‘INSERT INTO `ex…’)
#2 ee/legacy/database/DB_driver.php(179): CI_DB_driver->simple_query(‘INSERT INTO `ex…’)
#3 user/addons/publisher/legacy/models/publisher_entry.php(269): CI_DB_driver->query(‘INSERT INTO `ex…’)
#4 user/addons/publisher/legacy/libraries/Publisher_cp_events.php(87): Publisher_entry->migrate_data()
#5 user/addons/publisher/Service/Session.php(332): Publisher_cp_events->handler(Object(EE_Session))
#6 user/addons/publisher/ext.publisher.php(288): BoldMinded\Publisher\Service\Session->boot()
#7 ee/legacy/libraries/Extensions.php(227): Publisher_ext->core_boot()
#8 ee/legacy/libraries/Extensions.php(122): EE_Extensions->call_class(‘Publisher_ext’, ‘core_boot’, Array, Array)
#9 ee/legacy/core/Controller.php(90): EE_Extensions->call(‘core_boot’)
#10 ee/legacy/core/Controller.php(110): EE_Controller->__construct()
#11 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(32): CP_Controller->__construct()
#12 ee/EllisLab/ExpressionEngine/Core/Core.php(227): EllisLab\ExpressionEngine\Controller\Addons\Addons->__construct()
#13 ee/EllisLab/ExpressionEngine/Core/Core.php(109): EllisLab\ExpressionEngine\Core\Core->runController(Array)
#14 ee/EllisLab/ExpressionEngine/Boot/boot.php(146): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
#15 admin.php(147): require_once(’...’)
Detailed steps to reproduce the issue:
1. Login to EE admin panel
2. Goto: Addons list
3. For ‘Publisher 2’ click ‘Install’ button
BoldMinded (Brian)
What version of MySQL? It looks like the sensitive data you’ve redacted is the column with the error, can you share an example of that data by marking the comment private?
BoldMinded (Brian)
Comment has been marked private.
Eric Harth
Thanks i’ll this today.
Eric Harth
Hi Brian
I tried the build you had provided on Expressionengine 4.0.3 and the error is there. Any other ideas?
Thanks
BoldMinded (Brian)
Can you please reveal what the contents of the sensitive data is? Otherwise I don’t know how to debug an error with a field if I don’t know what the field contains.
BoldMinded (Brian)
Closing because there has been no response in over a month.