Error when Update of Geo IP
dhawal at NETMAGICSOLUTIONS.COM
Thu Sep 29 10:28:09 IST 2005
[ The following text is in the "ISO-8859-1" character set. ]
[ Your display is set for the "US-ASCII" character set. ]
[ Some characters may be displayed incorrectly. ]
Leif Neland wrote:
>> There are security limitations with the 'load data infile' command but
>> thats another story.
> I get this:
> Error executing query:
> The used command is not allowed with this MySQL version
> LOAD DATA LOCAL INFILE
> '/usr/local/www/data/mailscanner/temp/GeoIPCountryWhois.csv' INTO TABLE
> geoip_country FIELDS TERMINATED BY ',' ENCLOSED BY '"'If I remove
> "LOCAL", ie LOAD DATA INFILE it works.mysql Ver 14.7 Distrib 4.1.14,
> for portbld-freebsd7.0 (i386) using 5.0Leif
The original code used 'LOAD DATA INFILE' but was changed later to 'LOAD
DATA LOCAL INFILE' based on feedback by beta testers.
However if 'LOCAL' isn't required on freebsd, then probably Steve could
make a change in the php code to provision for this as well. Could you
report your complete observations this to the mailwatch-users list?
------------------------ MailScanner list ------------------------
To unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
'leave mailscanner' in the body of the email.
Before posting, read the Wiki (http://wiki.mailscanner.info/) and
the archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).
Support MailScanner development - buy the book off the website!
More information about the MailScanner