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

 

#1

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?

#2

BoldMinded (Brian)

Comment has been marked private.

#3

Eric Harth

Thanks i’ll this today.

#4

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

#5

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.

#6

BoldMinded (Brian)

Closing because there has been no response in over a month.

Login to reply