Troubleshooting MYSQL or MariaDB Errors from Error 1281 to 1290

SQLServerF1

MariaDB ERROR Code 1281
MySQL SQL State 42000
ER_WRONG_NAME_FOR_CATALOG
Incorrect catalog name ‘%s’
MariaDB ERROR Code 1282
MySQL SQL State HY000
ER_WARN_QC_RESIZE
Query cache failed to set size %lu; new query cache size is %lu
MariaDB ERROR Code 1283
MySQL SQL State HY000
ER_BAD_FT_COLUMN
Column ‘%s’ cannot be part of FULLTEXT index

MariaDB ERROR Code 1284
MySQL SQL State HY000
ER_UNKNOWN_KEY_CACHE
Unknown key cache ‘%s’
MariaDB ERROR Code 1285
MySQL SQL State HY000
ER_WARN_HOSTNAME_WONT_WORK
MariaDB is started in –skip-name-resolve mode; you must restart it without this switch for this grant to work
MariaDB ERROR Code 1286
MySQL SQL State 42000
ER_UNKNOWN_STORAGE_ENGINE
Unknown storage engine ‘%s’

MariaDB ERROR Code 1287
MySQL SQL State HY000
ER_WARN_DEPRECATED_SYNTAX
‘%s’ is deprecated and will be removed in a future release. Please use %s instead
MariaDB ERROR Code 1288
MySQL SQL State HY000
ER_NON_UPDATABLE_TABLE
The target table %s of the %s is not updatable
MariaDB ERROR Code 1289
MySQL SQL State HY000
ER_FEATURE_DISABLED
The ‘%s’ feature is disabled; you need MariaDB built with ‘%s’ to have it working
MariaDB ERROR Code 1290
MySQL SQL State HY000
ER_OPTION_PREVENTS_STATEMENT
The MariaDB server is running with the %s option so it cannot execute this statement

Above are the list of shared MySQL and MariaDB Error Codes and their Description including SQL state and exact error code from Error 1281 to 1290 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 *