This is a setting in MySQL that you have to explicitly turn on at compile time.
--enable-local-infile Enable LOAD DATA LOCAL INFILE (default: disabled)
I suspect that's what _might_ be happening.
On Mon, 16 Aug 2004 15:33:37 +0200, Daniel Kradolfer
[EMAIL PROTECTED] wrote:
mysql_error() says:
1148:The used command is not allowed with this MySQL version
The same Script worked fine before we updated PHP and MySQL.
The query works at the mysql shell prompt. But here it is:
LOAD DATA LOCAL INFILE '/[Path]/inc/../in/wbsuser.src'
REPLACE INTO TABLE user fields terminated by ';' LINES TERMINATED BY '\r\n'
(userid,username,gruppe,knr,anrede,vorname,name,firma,firma2,strasse,plz,ort
,
land,telefon,telefax,email,www,kennwort,zahlbed,la_anrede,la_vorname,la_name
,
la_firma,la_firma2,la_strasse,la_plz,la_ort,la_land,la_telefon,la_telefax,
onlineupd,bank,blz,kontonr,kontoinh,aktiv,loeschen,zusatz,ustid) ;
(I replaced [Path] for security reasons)
This php code is generated by a Windows App and i don't have the possibilty
to change some thing.
Thanks Dani
I often had trouble getting the syntaxt just right with PHP, it's easy to
end up with the wrong number of slashes around the -lines terminated by
'- parts of this.
When you ran your query, what did mysql_error() say about it ?
That would be a line you add directly after the line
mysql_query($link,$query)
Usually this will tell you immediately if you have an error in your SQL,
and echoing the $query string you passed to MySQL is a good idea too, it
can be more obvious to diagnose when it's printed on screen.
Cheers - Neil
At 12:41 16/08/2004 +, you wrote:
From: Daniel Kradolfer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Mon, 16 Aug 2004 14:40:49 +0200
MIME-Version: 1.0
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: 7bit
Subject: LOAD DATA LOCAL INFILE
Hello
I'm new to this list. I diden't found anything in the archive and by
googleing to solve my problem.
We have updated our server to PHP 4.3.8 and MySQL 4.0.2. Some of our
clients run a shop software that need 'LOAD DATA LOCAL INFILE' to store
its data to MySQL. MySQL itself supports the command. I can run it from
mysql-client. That works. I have read about the fix on php.net
(http://www.php.net/ChangeLog-4.php / http://bugs.php.net/28632).
Until now, i couldn't find a solution to get it work.
Is there way to get it work?
Regards
Dani
CaptionKit http://www.captionkit.com : Production tools
for accessible subtitled internet media, transcripts
and searchable video. Supports Real Player, Quicktime
and Windows Media Player.
VideoChat with friends online, get Freshly Toasted every
day at http://www.fresh-toast.net : NetMeeting solutions
for a connected world.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
randy [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
