WampServer

I can't get to understand why the query doesn't update the registration record. Also how can I change the message displayed by Apache, Wampserver to English?

I have added, or inserted a record but my update doesn't work.

my $sql variable displays ... UPDATE members WHERE id = '1' SET firstname = 'Kobus', lastname = 'Dippenaar', idno = '5407115049084', cellno = '0823469098'

and then something about Erreur de syntaxe pr?s de {then the above} ? la ligne 1

Please help,

Much appreciated.

Blessings.

Kobus Dippenaar

Hi Kobus,

You can configure your MySQL errors language to many languages.

To set them to English do the following

Edit my.ini, using the wampmanager menus i.e.

left click wampmanager -> MYSQL -> my.ini

Find these lines

lc-messages-dir=d:/wamp/bin/mysql/mysql5.5.28/share
# Change your locale here !
lc-messages=fr_FR

and chnage this parameter to

lc-messages=en_GB

Or

lc-messages=en_US

if you prefer

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Thank you and God Bless.
How do we close it?