MintJoomlaMintJoomla

CSV Import - Error decoding JSON data: Syntax error

Problem Problem | Solved Solved | Cobalt 8 | Просмотров: 843 | Комментарии: 3 | В закладках: 0 | Следят: 8

nblgeoweb VIP
Total posts: 178
26 Сен 2018 20:17

I'm doing a CSV import that has worked fine in the past but now I get the following error at the last stage: Error decoding JSON data: Syntax error This is with Cobalt 8.762 that I just installed a couple weeks ago. I haven't tracked down in the code where this is happening yet but it's almost like it's thinking it's json data instead of csv even though it seems to read it properly in stage 2. Any ideas where the problem is?

Последние изменения: 04 Окт 2018

Цитата

pepperstreet VIP
Total posts: 3,837
30 Сен 2018 23:35

Hello, did you add any new field type? Maybe that message is not referring to the entire import process but a single field. Or its multiple values.

Цитата

nblgeoweb VIP
Total posts: 178
01 Окт 2018 12:07

Thanks for the suggestion. That got me on the right track. I was using a previously saved import settings. When I created a new one, the process worked. I tried creating new import settings, which were actually identical to the settings that were saved, and it worked.

I looked in the js_res_import table and verified that they were identical. I think the problem is in the crossids column of that table. It looks like it has something to do with the unique id checking for updates. It's a json string and the last value was truncated for some reason. It might have been a strange character in a file I loaded last time that might have caused the problem.

Цитата

pepperstreet VIP
Total posts: 3,837
04 Окт 2018 01:38

nblgeoweb Thanks for the suggestion. That got me on the right track.

Phew! Lucky me ;)

Работает на Cobalt