Troubleshooting MYSQL or MariaDB Errors from Error 1111 to 1120


MariaDB ERROR Code 1111
MySQL SQL State HY000
Invalid use of group function
MariaDB ERROR Code 1112
MySQL SQL State 42000
Table ‘%s’ uses an extension that doesn’t exist in this MariaDB version
MariaDB ERROR Code 1113
MySQL SQL State 42000
A table must have at least 1 column

MariaDB ERROR Code 1114
MySQL SQL State HY000
The table ‘%s’ is full
MariaDB ERROR Code 1115
MySQL SQL State 42000
Unknown character set: ‘%s’
MariaDB ERROR Code 1116
MySQL SQL State HY000
Too many tables; MariaDB can only use %d tables in a join

MariaDB ERROR Code 1117
MySQL SQL State HY000
Too many columns
MariaDB ERROR Code 1118
MySQL SQL State 42000
Row size too large. The maximum row size for the used table type, not counting BLOBs, is %ld. You have to change some columns to TEXT or BLOBs
MariaDB ERROR Code 1119
MySQL SQL State HY000
Thread stack overrun: Used: %ld of a %ld stack. Use ‘mysqld –thread_stack=#’ to specify a bigger stack if needed
MariaDB ERROR Code 1120
MySQL SQL State 42000
Cross dependency found in OUTER JOIN; examine your ON conditions

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

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 *