Ajax 500 error importing data.

Created on 2 August 2024, 4 months ago
Updated 5 August 2024, 4 months ago

Problem/Motivation

Exported a sample cvs for a content type I have called us_state. I populated the file with data. I select import and receive the error

An AJAX HTTP error occurred.
HTTP Result Code: 500
Debugging information follows.
Path: /batch?id=9&op=do_nojs&op=do
StatusText: 500 Service unavailable (with message)
ResponseText: The website encountered an unexpected error. Try again later.

In the console I see
POST https://xxx/batch?id=7&op=do_nojs&op=do&_format=json 500
(500 Service unavailable (with message))
send @ js_ifbPvvK-juD1qWoKHinTqHjAmRhVT5aJky9mK8o69vw.js?scope=footer&delta=0&language=en&theme=claro&include=eJxLzs8rSa0oKU3M0U8pKi1IzNFLhovo5mTmZRfrJOcXpcIkE5NLMstSwRIo4kmJJckZOiX5-TlJiUX6UFonGZ_hMEVomvRSi5MTC1IdU3Iz8wD3Ej1Y:3
ajax @ js_ifbPvvK-juD1qWoKHinTqHjAmRhVT5aJky9mK8o69vw.js?scope=footer&delta=0&language=en&theme=claro&include=eJxLzs8rSa0oKU3M0U8pKi1IzNFLhovo5mTmZRfrJOcXpcIkE5NLMstSwRIo4kmJJckZOiX5-TlJiUX6UFonGZ_hMEVomvRSi5MTC1IdU3Iz8wD3Ej1Y:3
sendPing @ js_ifbPvvK-juD1qWoKHinTqHjAmRhVT5aJky9mK8o69vw.js?scope=footer&delta=0&language=en&theme=claro&include=eJxLzs8rSa0oKU3M0U8pKi1IzNFLhovo5mTmZRfrJOcXpcIkE5NLMstSwRIo4kmJJckZOiX5-TlJiUX6UFonGZ_hMEVomvRSi5MTC1IdU3Iz8wD3Ej1Y:39
startMonitoring @ js_ifbPvvK-juD1qWoKHinTqHjAmRhVT5aJky9mK8o69vw.js?scope=footer&delta=0&language=en&theme=claro&include=eJxLzs8rSa0oKU3M0U8pKi1IzNFLhovo5mTmZRfrJOcXpcIkE5NLMstSwRIo4kmJJckZOiX5-TlJiUX6UFonGZ_hMEVomvRSi5MTC1IdU3Iz8wD3Ej1Y:39
attach @ batch.js?1722630367:39
(anonymous) @ js_ifbPvvK-juD1qWoKHinTqHjAmRhVT5aJky9mK8o69vw.js?scope=footer&delta=0&language=en&theme=claro&include=eJxLzs8rSa0oKU3M0U8pKi1IzNFLhovo5mTmZRfrJOcXpcIkE5NLMstSwRIo4kmJJckZOiX5-TlJiUX6UFonGZ_hMEVomvRSi5MTC1IdU3Iz8wD3Ej1Y:22
Drupal.attachBehaviors @ js_ifbPvvK-juD1qWoKHinTqHjAmRhVT5aJky9mK8o69vw.js?scope=footer&delta=0&language=en&theme=claro&include=eJxLzs8rSa0oKU3M0U8pKi1IzNFLhovo5mTmZRfrJOcXpcIkE5NLMstSwRIo4kmJJckZOiX5-TlJiUX6UFonGZ_hMEVomvRSi5MTC1IdU3Iz8wD3Ej1Y:22
(anonymous) @ js_ifbPvvK-juD1qWoKHinTqHjAmRhVT5aJky9mK8o69vw.js?scope=footer&delta=0&language=en&theme=claro&include=eJxLzs8rSa0oKU3M0U8pKi1IzNFLhovo5mTmZRfrJOcXpcIkE5NLMstSwRIo4kmJJckZOiX5-TlJiUX6UFonGZ_hMEVomvRSi5MTC1IdU3Iz8wD3Ej1Y:23
listener @ js_ifbPvvK-juD1qWoKHinTqHjAmRhVT5aJky9mK8o69vw.js?scope=footer&delta=0&language=en&theme=claro&include=eJxLzs8rSa0oKU3M0U8pKi1IzNFLhovo5mTmZRfrJOcXpcIkE5NLMstSwRIo4kmJJckZOiX5-TlJiUX6UFonGZ_hMEVomvRSi5MTC1IdU3Iz8wD3Ej1Y:23

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

💬 Support request
Status

Active

Version

10.0

Component

Module

Created by

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • I figured out what happened. There was an error a SQL error in the logs showing langcode cannot be null. I looked at the header of my csv file and the column titles langcode and body were concatenated into the langcode column header. I fixed that and the import worked!

    Note
    the "Click Here and Download Sample CSV" butting creates a file with this issue. There is no body column, and the word body is appended to the langcode field [langcodebody]

Production build 0.71.5 2024