How do I deal with activating MySQL mistake messages.

I'm presently running 3 Solaris web servers running MySQL 4.0.20 and also PHPMyAdmin 2.11.5 and also on one web server, when I run a MySQL question via PHPMyAdmin with a mistake in it, I get a handy mistake message along the lines of

MySQL said: 
#1054 - Unknown column 'name' in 'field list' 

Whereas on the major internet server I get this from the very same question on the very same table.

MySQL said: 
#1054 - 

I get the mistake code yet no message informing me where the mistake is that makes debugging questions a whole lot even more time consuming.

I've contrasted the mysql init documents and also mysql daemon and also can not see where the mistake coverage is set up. Any kind of suggestions?

0
2019-12-02 02:57:00
Source Share
Answers: 1

you do not state running system you are making use of, my solution thinks it is linux/ debian. yet those tips could be convenient with home windows too.

contrast both web servers - check if mysql has the very same language setup. run in mysql :

mysql> SHOW VARIABLES LIKE '%lang%';
+---------------+---------------------------+
| Variable_name | Value                     |
+---------------+---------------------------+
| language      | /usr/share/mysql/english/ |
+---------------+---------------------------+

it can be transformed in/ etc/mysql/my. cnf :

[mysqld]
language        = /usr/share/mysql/english

is it the very same on both equipments? on debian mysql is textual description of mistakes is maintained in/ usr/share/mysql.

check local setups if both equipments have the very same default language. you can check/change default places by running enter code heredpkg - reconfigure places

0
2019-12-03 04:39:03
Source