Jump to content
The Uniform Server Community

SQL error lc_messages 'es_ES'


fr3d3r1ck
 Share

Recommended Posts

Hi, I was using version 12.2.0 and everything worked perfectly, but after upgrading to the 12.4.0 and trying to access phpMyAdmin, I got this error:

 

Error

consulta SQL: Editar
SET lc_messages = 'es_ES';
MySQL ha dicho:
#1231 - Variable 'lc_messages' can't be set to the value of 'es_ES'

 

I didn't have another option rather than go to the path UniServerZ\home\us_opt1\locale and try to change the name of the folder 'es' by 'es_ES' and it worked well.

 

My native language is Spanish.

Unless someone like you cares a whole awful lot, nothing is going to get better. It's not. – Dr. Seuss

Link to comment
Share on other sites

  • 2 weeks later...
  • 1 month later...

Remove this mistake is easy how difficult is it going to show you when you indicate the language. That mistake I could not fix it.

 

you need to change the my.ini file as follows.

source directory: UniServerZ\core\mysql

 

Find this line;

character-set-server=utf8

 

and this adds up:

# Change your locale here !
lc-messages=es_ES

 

A greeting!

Link to comment
Share on other sites

  • 4 weeks later...

I already try it, after i do that the next time i open UniController it send me a message asking to change the mysql password, i change it and it can't complete the process, sending me a message saying "failed to change mysql password" and then it send another message saying than UniController must close due to an error.

and because of that, in practice, i can't use it.

 

Plz, have in mind i just download the latest version up-to-date from the webpage, and i just install it in one clean folder.

in brief, your solution works @display, but opens a new error.

Any ideas?, i'm all read.

 

 

Thanks in advance.

Link to comment
Share on other sites

  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...