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: not working SQL error

Status Resolved
Add-on / Version DataGrab 5.2
Severity
EE Version 7.3

HAMAD AL GAHTANI

Jan 27, 2024

hi
I made only one grab
then it stopped of reading data from any format json,csv

SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘’ for column ‘migration’ at row 1:
INSERT INTO `exp_datagrab` (`name`, `description`, `passkey`, `migration`, `last_run`, `settings`, `site_id`, `status`) VALUES (‘tttt’, ‘3’, ‘’, ‘’, 1706399780, ‘a:5:{s:6:\"import\";a:3:{s:4:\"type\";s:3:\"csv\";s:7:\"channel\";s:1:\"4\";s:5:\"limit\";s:2:\"50\";}s:8:\“datatype\”;a:4:{s:8:\"filename\";s:19:\"{base_url}/data.csv\”;s:9:\“delimiter\”;s:1:\”,\”;s:8:\“encloser\”;s:0:\”\”;s:4:\“skip\”;s:1:\“1\”;}s:6:\“config\”;a:24:{s:6:\"update\";s:1:\"n\";s:6:\"unique\";a:1:{i:0;s:0:\"\";}s:6:\“author\”;s:1:\“1\”;s:12:\“author_field\”;s:0:\”\”;s:12:\“author_check\”;s:11:\“screen_name\”;s:6:\“offset\”;s:1:\“0\”;s:5:\“title\”;s:1:\“0\”;s:12:\“title_suffix\”;s:0:\”\”;s:9:\“url_title\”;s:0:\”\”;s:16:\“url_title_suffix\”;s:0:\”\”;s:4:\“date\”;s:0:\”\”;s:11:\“expiry_date\”;s:0:\”\”;s:9:\“timestamp\”;s:0:\”\”;s:10:\“delete_old\”;s:1:\“n\”;s:11:\“soft_delete\”;s:1:\“n\”;s:6:\“status\”;s:7:\“default\”;s:13:\“update_status\”;s:0:\”\”;s:8:\“c_groups\”;s:1:\“1\”;s:16:\“update_edit_date\”;s:1:\“n\”;s:13:\“cat_default_1\”;s:1:\“5\”;s:11:\“cat_field_1\”;s:0:\”\”;s:15:\“cat_delimiter_1\”;s:1:\”,\”;s:19:\“cat_sub_delimiter_1\”;s:1:\”/\”;s:25:\“cat_allow_numeric_names_1\”;s:1:\“0\”;}s:2:\“cf\”;a:21:{s:11:\"title_title\";s:1:\"0\";s:17:\"title_description\";s:1:\"2\";s:18:\"title_single_image\";s:1:\"1\";s:26:\"title_single_image_filedir\";s:3:\"6.0\";s:24:\"title_single_image_fetch\";s:1:\"1\";s:29:\"title_single_image_makesubdir\";s:1:\"0\";s:11:\"description\";s:1:\"3\";s:6:\"person\";s:0:\"\";s:14:\"person_filedir\";s:0:\"\";s:12:\"person_fetch\";s:1:\"0\";s:17:\"person_makesubdir\";s:1:\"0\";s:7:\"contact\";i:1;s:15:\"contact_columns\";a:2:{i:21;s:0:\"\";i:22;s:0:\"\";}s:14:\“contact_unique\”;s:1:\“0\”;s:15:\“people_position\”;s:0:\”\”;s:21:\“people_career_history\”;i:1;s:29:\“people_career_history_columns\”;a:3:{i:23;s:0:\"\";i:24;s:0:\"\";i:25;s:0:\"\";}s:28:\“people_career_history_unique\”;s:1:\“0\”;s:24:\“people_education_history\”;i:1;s:32:\“people_education_history_columns\”;a:3:{i:26;s:0:\"\";i:27;s:0:\"\";i:28;s:0:\"\";}s:31:\“people_education_history_unique\”;s:1:\“0\”;}s:2:\“cm\”;a:1:{s:5:\"pages\";a:4:{s:17:\"execute_on_action\";s:0:\"\";s:5:\"pages\";s:0:\"\";s:9:\"pages_url\";s:0:\"\";s:14:\"pages_template\";s:0:\"\";}}}’, 1, ‘NEW’)


it stopped for no reason

#1

HAMAD AL GAHTANI

I have noted the description field at the end has some auto string likee description , 33,

#2

BoldMinded (Brian)

Comment has been marked private.

#3

BoldMinded (Brian)

I’m going to close this ticket b/c I’m pretty sure the build I sent will fix the issue, and I also just released it officially as 5.2.1. If you’re still getting this error after upgrading just re-open this ticket.

Login to reply