Troubleshooting MYSQL or MariaDB Errors from Error 1311 to 1320

SQLServerF1

MariaDB ERROR Code 1311
MySQL SQL State 01000
ER_SP_UNINIT_VAR
Referring to uninitialized variable %s
MariaDB ERROR Code 1312
MySQL SQL State 0A000
ER_SP_BADSELECTPROCEDURE
%s can’t return a result set in the given context
MariaDB ERROR Code 1313
MySQL SQL State 42000
ER_SP_BADRETURN RETURN
is only allowed in a FUNCTION

MariaDB ERROR Code 1314
MySQL SQL State 0A000
ER_SP_BADSTATEMENT
%s is not allowed in stored procedures
MariaDB ERROR Code 1315
MySQL SQL State 42000
ER_UPDATE_LOG_DEPRECATED_IGNORED
The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored. This option will be removed in MariaDB 5.6.
MariaDB ERROR Code 1316
MySQL SQL State 42000
ER_UPDATE_LOG_DEPRECATED_TRANSLATED
The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been translated to SET SQL_LOG_BIN. This option will be removed in MariaDB 5.6.

MariaDB ERROR Code 1317
MySQL SQL State 70100
ER_QUERY_INTERRUPTED
Query execution was interrupted
MariaDB ERROR Code 1318
MySQL SQL State 42000
ER_SP_WRONG_NO_OF_ARGS
Incorrect number of arguments for %s %s; expected %u, got %u
MariaDB ERROR Code 1319
MySQL SQL State 42000
ER_SP_COND_MISMATCH
Undefined CONDITION: %s
MariaDB ERROR Code 1320
MySQL SQL State 42000
ER_SP_NORETURN
No RETURN found in FUNCTION %s

Above are the list of shared MySQL and MariaDB Error Codes and their Description including SQL state and exact error code from Error 1311 to 1320 which performing certain operations against MySQL or MariaDB.

What are MYSQL/MariaDB Errors?

MySQL and MariaDB programs have access to several types of common error information when the server returns an error.

The MYSQL/MariaDB message displayed contains three types of information:
A numeric error code. This number is MySQL-specific and is not portable to other database systems.
A five-character SQLSTATE value. The values are specified by ANSI SQL and ODBC and are more standardized. Not all MySQL error numbers are mapped to SQLSTATE error codes.
A message string that provides a textual description of the error.
When an error occurs, you can access the MySQL error code, the SQLSTATE value, and the message string using C API functions:
MySQL error code: Call mysql_errno()
SQLSTATE value: Call mysql_sqlstate()
Error message: Call mysql_error()

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about MYSQL and MariaDB Error Codes and Error Messages or Warnings on Windows, Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *