sql errors Given in French - Need English
Posted by:
wc.smith
(---.cust.wildblue.net)
Date: April 18, 2015 01:10AM
I can't seem to figure out how to change the language from French to English for Sql errors.
I have modified the lc-messages in my.ini to lc-messages=en_US but still get sql errors in french.
On the home page of phpmyadmin English is the language chosen and all the screens show up in english.
But when I go into and SQL: query and force a syntax error (for example) I get the error in French not English.
Here is an example:
Error
SQL query:
dafimfad
a
f
ad
fa
MySQL said: Documentation
#1064 - Erreur de syntaxe près de 'dafimfad
a
f
ad
fa' Ã la ligne 1
Here is a dump of a portion of the my.ini:
[wampmysqld]
port = 3306
socket = /tmp/mysql.sock
key_buffer_size = 16M
max_allowed_packet = 1M
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
basedir=c:/wamp2-5/bin/mysql/mysql5.6.17
log-error=c:/wamp2-5/logs/mysql.log
datadir=c:/wamp2-5/bin/mysql/mysql5.6.17/data
#datadir=c:/wamp-2-2/bin/mysql/mysql5.0.51b/data
lc-messages-dir=c:/wamp2-5/bin/mysql/mysql5.6.17/share
# Change your locale here !
lc-messages=en_US
# Avoid warning
explicit_defaults_for_timestamp = TRUE
The lc-messages-dir is correct.
Here is a snippet from the home page of phpmyadmin that shows mysql5.16.17 is the version of msql running:
Database server
Server: mysql wampserver (127.0.0.1 via TCP/IP)
Server type: MySQL
Server version: 5.6.17 - MySQL Community Server (GPL)
Protocol version: 10
User: root@localhost
Server charset: UTF-8 Unicode (utf8)
Web server
Apache/2.4.9 (Win32) PHP/5.5.12
Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id:
I don't have any other versions of mysql loaded on the laptop...
Any help would be greatly appreciated.
Warren