[Phpmyadmin-devel] load data bug
bigredlinux at yahoo.com
Tue Aug 14 22:16:55 CEST 2001
I came across a bug today in the load data from
infile. I had data in a text file that had rows
terminated with a line feed (\n). When the query
was executed, it echoed
...LINES TERMINATED BY "\\n"
however, that is incorrect because it is escaping
the \ so that it is not interpreted as a line fed
but literately as "\n"
The problem is, when the line termination
varibable goes into ldi_check.php, it strips the
slashes if magic quote are enabled...and then it
runs the sql_addslashes function, however, this
is not correct...it should only add slashes for
the single quotes and not for the backslashes if
it is backslash \n \r or both...Anyway...check
out the patch to the CVS version
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 1020 bytes
More information about the Developers