MySQL Error Codes- Part II
MySQL Error Codes, continued from earlier post:
Error: 1026 SQLSTATE: HY000 ER_ERROR_ON_WRITE Message: Error writing file ‘%s’ errno: %d
Error: 1027 SQLSTATE: HY000 ER_FILE_USED Message: ‘%s’ is locked against change
Error: 1028 SQLSTATE: HY000 ER_FILSORT_ABORT Message: Sort aborted
Error: 1029 SQLSTATE: HY000 ER_FORM_NOT_FOUND Message: View ‘%s’ doesn’t exist for ‘%s’
Error: 1030 SQLSTATE: HY000 ER_GET_ERRNO Message: Got error %d from storage engine
Error: 1031 SQLSTATE: HY000 ER_ILLEGAL_HA Message: Table storage engine for ‘%s’ doesn’t have this option
Error: 1032 SQLSTATE: HY000 ER_KEY_NOT_FOUND Message: Can’t find record in ‘%s’
Error: 1033 SQLSTATE: HY000 ER_NOT_FORM_FILE Message: Incorrect information in file: ‘%s’
Error: 1034 SQLSTATE: HY000 ER_NOT_KEYFILE Message: Incorrect key file for table ‘%s’; try to repair it
Error: 1035 SQLSTATE: HY000 ER_OLD_KEYFILE Message: Old key file for table ‘%s’; repair it!
Error: 1036 SQLSTATE: HY000 ER_OPEN_AS_READONLY Message: Table ‘%s’ is read only
Error: 1037 SQLSTATE: HY001 ER_OUTOFMEMORY Message: Out of memory; restart server and try again needed %d bytes
Error: 1038 SQLSTATE: HY001 ER_OUT_OF_SORTMEMORY Message: Out of sort memory; increase server sort buffer size
Error: 1039 SQLSTATE: HY000 ER_UNEXPECTED_EOF Message: Unexpected EOF found when reading file ‘%s’ errno: %d
Error: 1040 SQLSTATE: 08004 ER_CON_COUNT_ERROR Message: Too many connections
Error: 1041 SQLSTATE: HY000 ER_OUT_OF_RESOURCES Message: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use ‘ulimit’ to allow mysqld to use more memory or you can add more swap space
Error: 1042 SQLSTATE: 08S01 ER_BAD_HOST_ERROR Message: Can’t get hostname for your address
Error: 1043 SQLSTATE: 08S01 ER_HANDSHAKE_ERROR Message: Bad handshake
Error: 1044 SQLSTATE: 42000 ER_DBACCESS_DENIED_ERROR Message: Access denied for user ‘%s’@’%s’ to database ‘%s’
Error: 1045 SQLSTATE: 28000 ER_ACCESS_DENIED_ERROR Message: Access denied for user ‘%s’@’%s’ using password: %s
Error: 1046 SQLSTATE: 3D000 ER_NO_DB_ERROR Message: No database selected
Error: 1047 SQLSTATE: 08S01 ER_UNKNOWN_COM_ERROR Message: Unknown command
Error: 1048 SQLSTATE: 23000 ER_BAD_NULL_ERROR Message: Column ‘%s’ cannot be null
Error: 1049 SQLSTATE: 42000 ER_BAD_DB_ERROR Message: Unknown database ‘%s’
Error: 1050 SQLSTATE: 42S01 ER_TABLE_EXISTS_ERROR Message: Table ‘%s’ already exists
Error: 1051 SQLSTATE: 42S02 ER_BAD_TABLE_ERROR Message: Unknown table ‘%s’
Error: 1052 SQLSTATE: 23000 ER_NON_UNIQ_ERROR Message: Column ‘%s’ in %s is ambiguous
Error: 1053 SQLSTATE: 08S01 ER_SERVER_SHUTDOWN Message: Server shutdown in progress
Error: 1054 SQLSTATE: 42S22 ER_BAD_FIELD_ERROR Message: Unknown column ‘%s’ in ‘%s’
Error: 1055 SQLSTATE: 42000 ER_WRONG_FIELD_WITH_GROUP Message: ‘%s’ isn’t in GROUP BY
Error: 1056 SQLSTATE: 42000 ER_WRONG_GROUP_FIELD Message: Can’t group on ‘%s’
Error: 1057 SQLSTATE: 42000 ER_WRONG_SUM_SELECT Message: Statement has sum functions and columns in same statement
Error: 1058 SQLSTATE: 21S01 ER_WRONG_VALUE_COUNT Message: Column count doesn’t match value count
Error: 1059 SQLSTATE: 42000 ER_TOO_LONG_IDENT Message: Identifier name ‘%s’ is too long
Error: 1060 SQLSTATE: 42S21 ER_DUP_FIELDNAME Message: Duplicate column name ‘%s’


Leave a Reply