AW: Re: Subject: LOAD DATA LOCAL INFILE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 +0000, you wrote:
>
>>From: "Daniel Kradolfer" <ml@xxxxxxxxxxxxxxxxx>
>>To: <php-db@xxxxxxxxxxxxx>
>>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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux