Jump to content


Photo

SQL error lc_messages 'es_ES'

sql error lc_messages es_ES

  • Please log in to reply
5 replies to this topic

#1 fr3d3r1ck

fr3d3r1ck

    Newbie

  • Member
  • Pip
  • 9 posts
  • Gender:Male
  • Location:127.0.0.1
  • Interests:< / >
  • Main OS: Other

Posted 18 May 2016 - 03:57 PM

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


#2 fr3d3r1ck

fr3d3r1ck

    Newbie

  • Member
  • Pip
  • 9 posts
  • Gender:Male
  • Location:127.0.0.1
  • Interests:< / >
  • Main OS: Other

Posted 28 May 2016 - 07:59 PM

It seems that this has not been resolved in version 12.4.1.  :(


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


#3 Obsdark

Obsdark

    Junior Member

  • Member
  • Pip
  • 21 posts
  • Main OS: Windows 7

Posted 07 July 2016 - 03:15 PM

Same here but your solution doesn't work :S

Any other idea of how to fix this?


LgqjWn6.png?1



#4 display

display

    Junior Member

  • Member
  • Pip
  • 12 posts
  • Main OS: Other

Posted 08 July 2016 - 02:45 PM

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!



#5 Obsdark

Obsdark

    Junior Member

  • Member
  • Pip
  • 21 posts
  • Main OS: Windows 7

Posted 02 August 2016 - 10:44 AM

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.



#6 fr3d3r1ck

fr3d3r1ck

    Newbie

  • Member
  • Pip
  • 9 posts
  • Gender:Male
  • Location:127.0.0.1
  • Interests:< / >
  • Main OS: Other

Posted 11 August 2016 - 06:45 PM

version 13.0.1 already has solved this problem.  ^_^


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






Also tagged with one or more of these keywords: sql, error, lc_messages, es_ES

1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users