Menu

#87 WebPA 2: Import data does not allow quotes

open
nobody
5
2012-09-03
2012-09-03
S Vickers
No

When importing CSV data files, single quotation marks are not being escaped. The following changes should be applied to the admin\load\simple.php file to fix this issue:

199c199
< $els[] = "$key = '$val'";
---
> $els[] = "$key = '" . $DB->escape_str($val) . '\'';
251c251
< $els[] = "$key = '$val'";
---
> $els[] = "$key = '" . $DB->escape_str($val) . '\'';
259c259
< $els[] = "$key = '$val'";
---
> $els[] = "$key = '" . $DB->escape_str($val) . '\'';

(NB there is no group for the WebPA 2.0.0.9 release.)

Discussion


Log in to post a comment.

MongoDB Logo MongoDB