CMS MADE SIMPLE FORGE

LISE

 
Back Back to List

[#12614] SQL error when importing item

avatar
Created By: antibart (Steph)
Date Submitted: Mon May 15 10:00:57 -0400 2023

Assigned To:
Version: 1.5.4
CMSMS Version: 2.2.16
Severity: Trivial
Resolution: Accepted
State: Open
Summary:
SQL error when importing item
Detailed Description:
Trying to import items into an instance causes folling error report

--------

Error 1064: You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to use near
'FROM temp_lise_csv_import_data' at line 1

SQL: SELECT FROM temp_lise_csv_import_data

--------


History

Comments
avatar 
Date: 2023-05-18 07:05
Posted By: antibart (Steph)

the error reportings a little misleading so it seem to me to be a bug. But it
may be not.

Default seperator of exporting is ';', default seperator of importing is ','.
That causes syntax error.

Sorry for this spam.
Updates

Updated: 2023-05-18 07:05
resolution_id: => 6
severity_id: 1 => 4