Edit report at https://bugs.php.net/bug.php?id=28631&edit=1
ID: 28631
Comment by: darrenraleigh26207107 at gmail dot com
Reported by: g dot m dot seed at hw dot ac dot uk
Summary: mysql load data query
Status: No Feedback
Type: Bug
Package: MySQL related
Operating System: Windows98
PHP Version: 4.3.4
Block user comment: N
Private report: N
New Comment:
Was this how nudists felt she wondered. The freedom of being naked in the forest alone was a special
feeling. It was quite cool now. The chill of the mountain air would be seeping into her bones before
too long. An early hunter of the night winged past like a dark shadow in the dimming light its broad
wings almost soundless. The insects had gone quiet and the day birds were settling in for the night,
their final noisy chatter subsided and all was quiet. If she didn't know there were eight other
people just sixty meters away she might be forgiven for thinking she was the only person in the
world https://sexcam.bar .
The moon was already above the horizon and that was a comforting ball shimmering through the trees.
Without fire or lamp, it was going to be her only light. Lindsey knew that total darkness would be
the scariest of situations even with people close by. Already her pulse rate was elevated. She tried
to overlook her tensions as she scouted her immediate surroundings for the tiny orchard-like flowers
that grew close the forest floor. The soft earth pressed between her toes as she walked. The flowers
were most numerous near two large sandstone boulders that had parted from the escarpment thousands
of years before and now nurtured the most delicate of bush flora.
If she had looked up at that moment she may have been very afraid. Between the twin boulders,
unnoticed by anyone who had set up the trip wires and infrared beams at the last moment before
departing was a well-concealed bundle of fur. Lindsey had smelled the Yowie's scent like the
others had and presumed, like they had, that it was the lingering odor that she and the others had
detected earlier. The two big pools of brown looked at the naked girl with unrequited lust.
As Lindsey moved back to her bedroll the Yowie's eyes followed her. She was different too his
female, she had no fur except on the top of her head and between her legs. Her breasts were firm and
not sagging like those of most Yowie females. She probably had not given birth he observed. What he
had seen were many males paying attention to her and following her all day. He could smell her
female scent, not strong but unmistakable when she was close, perhaps she was in season, he would
find out soon.
The last time he had seen this female was many moons ago when she was in her cave. She had tried to
came to him then but something had come between them, something the fur-less ones used on their
caves. This time the fur-less female would be his, this was his environment and he could outsmart
the other puny males, if that is what they were, that was following her like a dingo bitch in heat.
As Lindsey settled on her bedroll the Yowie unfolded himself from his hiding place and in the fading
light moved silently, using his abundant stalking skills, in getting close to the naked girl who was
now partly covered by the rug. His mastery at silent movement and concealment kept him hidden from
view. He had seen the humans with strange things, placing them at different locations. They took
many hours to do what they were doing and they had even stretched a long thread around the place
where the female now rested. That puzzled him.
Lindsey thought the smell of Yowie was stronger as she stared into the gloom but could not be sure.
She looked about nervously but saw nothing. Lindsey realised she was getting jumpy and her nerves
were on edge.
A short time later she was sure she was not becoming overwrought. The smell, beyond question, grew
stronger each second and she knew that the Yowie was defiantly here somewhere. She looked all around
pausing on anything that looked out of place but Lindsey couldn't see anything suspicious. She
strained her eyes in the moonlight but still saw nothing. It couldn't be too close, the
tripwire, although not originally planned, and infrared beams would be broken if anything passed
through them. There was no unusual sound coming from the camp to indicate that they had any
concerns. She relaxed.
Previous Comments:
------------------------------------------------------------------------
[2004-06-13 01:00:03] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2004-06-04 17:27:42] iliaa@php.net
Do you have safe_mode or open_basedir enabled?
------------------------------------------------------------------------
[2004-06-04 15:59:36] g dot m dot seed at hw dot ac dot uk
Description:
------------
The "load data" with "local infile" is supported in MySQL4, and has been since
version 3.22. However, when an SQL query is submitted using mysql_query() the error returned by
mysql_error() states "The used command is not allowed with this MySQL version"?
I have read through the php manual, mysql manual, php's bug search facilities and checked a
mailing group and can't find any reference that states the "load data" command is not
supported when using php4 and mysql4?
Incidentally, the query executes as expected if run at the mysql> command line prompt.
Comments on rebported bug #7244 state:
"LOAD DATA INFILE (without LOCAL) seems to be ok."
and it appears that the use of "local" is the problem. If so, then this is contrary to the
MySQL manual which clearly states the use of "local".
Furthermore, if you don't consider the omission of "local" to be a bug then it should
be documented since it is extremely difficult to pin this one down.
Reproduce code:
---------------
$sqlQuery = "load data local infile 'filename.csv' into table exams fields terminated
by ',' enclosed by '\"' lines terminated by '\\r\\n'";
$result = mysql_query($sqlQuery)
or die("query failed, error=" . mysql_error() . "\n");
Expected result:
----------------
To insert the data from filename.csv
Actual result:
--------------
query failed, error=The used command is not allowed with this MySQL version
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=28631&edit=1