MySQL CSV Export Column Escape

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

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!

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.

Ok, I see what you mean now - this will be fixed in the 1.650 Webmin release.

Automatically closed -- issue fixed for 2 weeks with no activity.

Automatically closed -- issue fixed for 2 weeks with no activity.