MySQL 5.7 – Resolving Meaningless Error Messages

errorsMySQL

When I select from a table that doesn't exist:

When I select a nonexistent column from an existing table:

I used to receive meaningful error messages (ie 'Error Code: 1054. Unknown column 'column' in 'table''), but now only the error number is returned, without an explanation of what happened. This happens to everyone that connect to this particular MySQL database.

Does anyone know how I can fix this without reinstalling MySQL? I'm running MySQL 5.7.9 Community Server (64-bit) on Windows Server 2012.

Best Answer

Looking through the MySQL error log, I noticed the following line: Can't find error-message file '\share\errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive. That file did not exist, however \share\english\errmsg.sys did exist. I found out from here that this error message is not entirely accurate, since MySQL does not actually look in the \share\ directory - it looks in the \share\*YOUR LANGUAGE*\ directory.

I looked in my my.ini and discovered that I had a line that said basedir = (that's all that the line said - there was no path after basedir). I'm not entirely sure how that configuration came to be, but I commented out that line and everything works great now!

Related Solutions

Mysql – Not able to update MySQL table using Oracle: Unknown column in ‘where clause’ {42S22,NativeErr = 1054}

by experience sometimes creating oracle tables by using ODBC produce errors.

so please try to do the following:

create the table manually on oracle db by using sql plus.
try to use capital letters for table and column names without double quotes (example: use TABLE_NAME not table_name or Table_Name)
try to run your application to check if any errors appears.

also in where clause you have to check it. try:

WHERE SRC."INT_ID" = REC.MYSQL_INT_ID;

does it works?

Mysql – To find out the sum total of GRNQty and GRNValue of particular item from column 1

To fix the error: You exposed Qty AS GRNQty; use the latter outside.

If there is a question about Q1, I missed it.

I recommend using some extra parens when doing UNION:

( SELECT ... )
UNION ALL
( SELECT ... )

Without these parens, you might add a clause (eg LIMIT) and have it mysteriously apply to the second SELECT instead of the UNION.

Best Answer

Related Solutions

Mysql – Not able to update MySQL table using Oracle: Unknown column in ‘where clause’ {42S22,NativeErr = 1054}

Mysql – To find out the sum total of GRNQty and GRNValue of particular item from column 1

Related Question