Import CSV - SyntaxError: Unexpected token ( in JSON at position 1
5 posts by 2 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: October 16, 2018 (RSS)
By zip222 - October 16, 2018
I am getting an error when attempting to import a CSV file using the CSV import plugin.
- "Status: Error: There was an error sending the request! (200 OK) parsererror - SyntaxError: Unexpected token ( in JSON at position 1"
- CMSB 3.14
- CSV Import 1.11
- It works totally fine on the dev server, but errors out on the live server.
By daniel - October 16, 2018
Hi,
To help troubleshoot this issue, I have a few questions:
- At what point in the CSV import process do you see this error?
- Do any errors show up in the Developer Log (under Admin Menu in CMSB) when you attempt the import?
Thanks,
Technical Lead
interactivetools.com
By zip222 - October 16, 2018
- At what point in the CSV import process do you see this error?
Import CSV = ok
Upload file = ok
Select target table = ok
Analyze Data = error
Do any errors show up in the Developer Log (under Admin Menu in CMSB) when you attempt the import?
Yes...
Error:
E_WARNING: count(): Parameter must be an array or an object that implements Countable
URL:
/cmsb/admin.php?_plugin=csvImport_v111/csvImport_functions.php&_pluginAction=csvImport_analyseForm_ajax&num=19&offset=0&rowNum=1&menu
Filepath:
/var/www/html/cmsb/plugins/csvImport_v111/csvImport_functions.php
Line num
500
Backtrace
#0 _errorlog_logErrorRecord() called at [/var/www/html/cmsb/lib/errorlog_functions.php:64]
#1 _errorlog_catchRuntimeErrors() called at [/var/www/html/cmsb/plugins/csvImport_v111/csvImport_functions.php:500]
#2 csvImport_analyseForm_ajax() called at [/var/www/html/cmsb/plugins/csvImport_v111/csvImport.php:105]
#3 csvImport_init() called at [/var/www/html/cmsb/lib/plugin_functions.php:312]
#4 doAction() called at [/var/www/html/cmsb/admin.php:32]
By daniel - October 16, 2018
Hello,
It looks likely that there's a difference in PHP version between your dev and live servers; that error shows up only in PHP 7.2+, so I'd guess that your live server is running a newer version. The latest version of the CSV Import plugin (https://www.interactivetools.com/add-ons/csv-import/) has been updated to fix the error - my recommendation would be to update the plugin.
Let me know any other questions!
Thanks,
Technical Lead
interactivetools.com