Troubleshooting MYSQL or MariaDB Errors from Error 1171 to 1180

SQLServerF1

MariaDB ERROR Code 1171
MySQL SQL State 42000
ER_PRIMARY_CANT_HAVE_NULL
All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
MariaDB ERROR Code 1172
MySQL SQL State 42000
ER_TOO_MANY_ROWS
Result consisted of more than one row
MariaDB ERROR Code 1173
MySQL SQL State 42000
ER_REQUIRES_PRIMARY_KEY
This table type requires a primary key

MariaDB ERROR Code 1174
MySQL SQL State HY000
ER_NO_RAID_COMPILED
This version of MariaDB is not compiled with RAID support
MariaDB ERROR Code 1175
MySQL SQL State HY000
ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
MariaDB ERROR Code 1176
MySQL SQL State 42000
ER_KEY_DOES_NOT_EXITS
Key ‘%s’ doesn’t exist in table ‘%s’

MariaDB ERROR Code 1177
MySQL SQL State 42000
ER_CHECK_NO_SUCH_TABLE
Can’t open table
MariaDB ERROR Code 1178
MySQL SQL State 42000
ER_CHECK_NOT_IMPLEMENTED
The storage engine for the table doesn’t support %s
MariaDB ERROR Code 1179
MySQL SQL State 25000
ER_CANT_DO_THIS_DURING_AN_TRANSACTION
You are not allowed to execute this command in a transaction
MariaDB ERROR Code 1180
MySQL SQL State HY000
ER_ERROR_DURING_COMMIT
Got error %d during COMMIT

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