Submitted by pcfreak30 on Mon, 08/12/2013 - 06:43
When doing a CSV export, the columns in the generated SQL need to be escaped with `. I have a case with WHMCS on exporting data having an "order" column, and being a MySQL keyword, it fails.
Status:
Closed (fixed)
Comments
Submitted by JamieCameron on Mon, 08/12/2013 - 11:32 Comment #1
Can you give an example of the problematic SQL / CSV?
Also, was the output in SQL or CSV? Because the CSV format shouldn't need escaping for SQL keywords, as it isn't SQL!
Submitted by pcfreak30 on Mon, 08/12/2013 - 18:22 Comment #2
No. if you have odd columns that may be the same name as mysql keywords, they must be escaped. The MySQL query ran to generate the CSV from does not escape the column names. This will cause a SQL error on CSV export.
Try creating a table with "order" as a column name, put data in then try to export. You will see what I mean.
Submitted by JamieCameron on Mon, 08/12/2013 - 19:12 Comment #3
Ok, I see what you mean now - this will be fixed in the 1.650 Webmin release.
Submitted by Issues on Mon, 08/26/2013 - 20:12 Comment #4
Automatically closed -- issue fixed for 2 weeks with no activity.
Submitted by Issues on Mon, 08/26/2013 - 20:31 Comment #5
Automatically closed -- issue fixed for 2 weeks with no activity.