MySQL Error Codes
When using the MySQL extention mysqli or PDO, you may recieved an error message, or error code, back from your PHP code that looks cryptic or meaningless. This table is published to help those recieving these error to debug thier applications.
MySQL errors are generated from two sources. The first is server errors and the second is client errors. The error messages are listed the source in the errmsg.txt file. This is a dynamic file and so, you should check there if the error message you are recieving is not listed here.
Server Errors
| Error Code | SQL State | Message | End of Server Errors |
| Error: 1000 | SQLSTATE: HY000 ER_HASHCHK | Message: hashchk |
| Error: 1001 | SQLSTATE: HY000 ER_NISAMCHK | Message: isamchk |
| Error: 1002 | SQLSTATE: HY000 ER_NO | Message: NO |
| Error: 1003 | SQLSTATE: HY000 ER_YES | Message: YES |
| Error: 1004 | SQLSTATE: HY000 ER_CANT_CREATE_FILE | Message: Can't create file '%s' errno: %d |
| Error: 1005 | SQLSTATE: HY000 ER_CANT_CREATE_TABLE | Message: Can't create table '%s' errno: %d |
| Error: 1006 | SQLSTATE: HY000 ER_CANT_CREATE_DB | Message: Can't create database '%s' errno: %d |
| Error: 1007 | SQLSTATE: HY000 ER_DB_CREATE_EXISTS | Message: Can't create database '%s'; database exists |
| Error: 1008 | SQLSTATE: HY000 ER_DB_DROP_EXISTS | Message: Can't drop database '%s'; database doesn't exist |
| Error: 1009 | SQLSTATE: HY000 ER_DB_DROP_DELETE | Message: Error dropping database can't delete '%s', errno: %d |
| Error: 1010 | SQLSTATE: HY000 ER_DB_DROP_RMDIR | Message: Error dropping database can't rmdir '%s', errno: %d |
| Error: 1011 | SQLSTATE: HY000 ER_CANT_DELETE_FILE | Message: Error on delete of '%s' errno: %d |
| Error: 1012 | SQLSTATE: HY000 ER_CANT_FIND_SYSTEM_REC | Message: Can't read record in system table |
| Error: 1013 | SQLSTATE: HY000 ER_CANT_GET_STAT | Message: Can't get status of '%s' errno: %d |
| Error: 1014 | SQLSTATE: HY000 ER_CANT_GET_WD | Message: Can't get working directory errno: %d |
| Error: 1015 | SQLSTATE: HY000 ER_CANT_LOCK | Message: Can't lock file errno: %d |
| Error: 1016 | SQLSTATE: HY000 ER_CANT_OPEN_FILE | Message: Can't open file: '%s' errno: %d |
| Error: 1017 | SQLSTATE: HY000 ER_FILE_NOT_FOUND | Message: Can't find file: '%s' errno: %d |
| Error: 1018 | SQLSTATE: HY000 ER_CANT_READ_DIR | Message: Can't read dir of '%s' errno: %d |
| Error: 1019 | SQLSTATE: HY000 ER_CANT_SET_WD | Message: Can't change dir to '%s' errno: %d |
| Error: 1020 | SQLSTATE: HY000 ER_CHECKREAD | Message: Record has changed since last read in table '%s' |
| Error: 1021 | SQLSTATE: HY000 ER_DISK_FULL | Message: Disk full %s; waiting for someone to free some space... |
| Error: 1022 | SQLSTATE: 23000 ER_DUP_KEY | Message: Can't write; duplicate key in table '%s' |
| Error: 1023 | SQLSTATE: HY000 ER_ERROR_ON_CLOSE | Message: Error on close of '%s' errno: %d |
| Error: 1024 | SQLSTATE: HY000 ER_ERROR_ON_READ | Message: Error reading file '%s' errno: %d |
| Error: 1025 | SQLSTATE: HY000 ER_ERROR_ON_RENAME | Message: Error on rename of '%s' to '%s' errno: %d |
| 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' |
| Error: 1061 | SQLSTATE: 42000 ER_DUP_KEYNAME | Message: Duplicate key name '%s' |
| Error: 1062 | SQLSTATE: 23000 ER_DUP_ENTRY | Message: Duplicate entry '%s' for key %d |
| Error: 1063 | SQLSTATE: 42000 ER_WRONG_FIELD_SPEC | Message: Incorrect column specifier for column '%s' |
| Error: 1064 | SQLSTATE: 42000 ER_PARSE_ERROR | Message: %s near '%s' at line %d |
| Error: 1065 | SQLSTATE: HY000 ER_EMPTY_QUERY | Message: Query was empty |
| Error: 1066 | SQLSTATE: 42000 ER_NONUNIQ_TABLE | Message: Not unique table/alias: '%s' |
| Error: 1067 | SQLSTATE: 42000 ER_INVALID_DEFAULT | Message: Invalid default value for '%s' |
| Error: 1068 | SQLSTATE: 42000 ER_MULTIPLE_PRI_KEY | Message: Multiple primary key defined |
| Error: 1069 | SQLSTATE: 42000 ER_TOO_MANY_KEYS | Message: Too many keys specified; max %d keys allowed |
| Error: 1070 | SQLSTATE: 42000 ER_TOO_MANY_KEY_PARTS | Message: Too many key parts specified; max %d parts allowed |
| Error: 1071 | SQLSTATE: 42000 ER_TOO_LONG_KEY | Message: Specified key was too long; max key length is %d bytes |
| Error: 1072 | SQLSTATE: 42000 ER_KEY_COLUMN_DOES_NOT_EXITS | Message: Key column '%s' doesn't exist in table |
| Error: 1073 | SQLSTATE: 42000 ER_BLOB_USED_AS_KEY | Message: BLOB column '%s' can't be used in key specification with the used table type |
| Error: 1074 | SQLSTATE: 42000 ER_TOO_BIG_FIELDLENGTH | Message: Column length too big for column '%s' max = %d; use BLOB instead |
| Error: 1075 | SQLSTATE: 42000 ER_WRONG_AUTO_KEY | Message: Incorrect table definition; there can be only one auto column and it must be defined as a key |
| Error: 1076 | SQLSTATE: HY000 ER_READY | Message: %s: ready for connections. Version: '%s' socket: '%s' port: %d |
| Error: 1077 | SQLSTATE: HY000 ER_NORMAL_SHUTDOWN | Message: %s: Normal shutdown |
| Error: 1078 | SQLSTATE: HY000 ER_GOT_SIGNAL | Message: %s: Got signal %d. Aborting! |
| Error: 1079 | SQLSTATE: HY000 ER_SHUTDOWN_COMPLETE | Message: %s: Shutdown complete |
| Error: 1080 | SQLSTATE: 08S01 ER_FORCING_CLOSE | Message: %s: Forcing close of thread %ld user: '%s' |
| Error: 1081 | SQLSTATE: 08S01 ER_IPSOCK_ERROR | Message: Can't create IP socket |
| Error: 1082 | SQLSTATE: 42S12 ER_NO_SUCH_INDEX | Message: Table '%s' has no index like the one used in CREATE INDEX; recreate the table |
| Error: 1083 | SQLSTATE: 42000 ER_WRONG_FIELD_TERMINATORS | Message: Field separator argument is not what is expected; check the manual |
| Error: 1084 | SQLSTATE: 42000 ER_BLOBS_AND_NO_TERMINATED | Message: You can't use fixed rowlength with BLOBs; please use 'fields terminated by' |
| Error: 1085 | SQLSTATE: HY000 ER_TEXTFILE_NOT_READABLE | Message: The file '%s' must be in the database directory or be readable by all |
| Error: 1086 | SQLSTATE: HY000 ER_FILE_EXISTS_ERROR | Message: File '%s' already exists |
| Error: 1087 | SQLSTATE: HY000 ER_LOAD_INFO | Message: Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld |
| Error: 1088 | SQLSTATE: HY000 ER_ALTER_INFO | Message: Records: %ld Duplicates: %ld |
| Error: 1089 | SQLSTATE: HY000 ER_WRONG_SUB_KEY | Message: Incorrect sub part key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique sub keys |
| Error: 1090 | SQLSTATE: 42000 ER_CANT_REMOVE_ALL_FIELDS | Message: You can't delete all columns with ALTER TABLE; use DROP TABLE instead |
| Error: 1091 | SQLSTATE: 42000 ER_CANT_DROP_FIELD_OR_KEY | Message: Can't DROP '%s'; check that column/key exists |
| Error: 1092 | SQLSTATE: HY000 ER_INSERT_INFO | Message: Records: %ld Duplicates: %ld Warnings: %ld |
| Error: 1093 | SQLSTATE: HY000 ER_UPDATE_TABLE_USED | Message: You can't specify target table '%s' for update in FROM clause |
| Error: 1094 | SQLSTATE: HY000 ER_NO_SUCH_THREAD | Message: Unknown thread id: %lu |
| Error: 1095 | SQLSTATE: HY000 ER_KILL_DENIED_ERROR | Message: You are not owner of thread %lu |
| Error: 1096 | SQLSTATE: HY000 ER_NO_TABLES_USED | Message: No tables used |
| Error: 1097 | SQLSTATE: HY000 ER_TOO_BIG_SET | Message: Too many strings for column %s and SET |
| Error: 1098 | SQLSTATE: HY000 ER_NO_UNIQUE_LOGFILE | Message: Can't generate a unique log-filename %s.1-999 |
| Error: 1099 | SQLSTATE: HY000 ER_TABLE_NOT_LOCKED_FOR_WRITE | Message: Table '%s' was locked with a READ lock and can't be updated |
| Error: 1100 | SQLSTATE: HY000 ER_TABLE_NOT_LOCKED | Message: Table '%s' was not locked with LOCK TABLES |
| Error: 1101 | SQLSTATE: 42000 ER_BLOB_CANT_HAVE_DEFAULT | Message: BLOB/TEXT column '%s' can't have a default value |
| Error: 1102 | SQLSTATE: 42000 ER_WRONG_DB_NAME | Message: Incorrect database name '%s' |
| Error: 1103 | SQLSTATE: 42000 ER_WRONG_TABLE_NAME | Message: Incorrect table name '%s' |
| Error: 1104 | SQLSTATE: 42000 ER_TOO_BIG_SELECT | Message: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay |
| Error: 1105 | SQLSTATE: HY000 ER_UNKNOWN_ERROR | Message: Unknown error |
| Error: 1106 | SQLSTATE: 42000 ER_UNKNOWN_PROCEDURE | Message: Unknown procedure '%s' |
| Error: 1107 | SQLSTATE: 42000 ER_WRONG_PARAMCOUNT_TO_PROCEDURE | Message: Incorrect parameter count to procedure '%s' |
| Error: 1108 | SQLSTATE: HY000 ER_WRONG_PARAMETERS_TO_PROCEDURE | Message: Incorrect parameters to procedure '%s' |
| Error: 1109 | SQLSTATE: 42S02 ER_UNKNOWN_TABLE | Message: Unknown table '%s' in %s |
| Error: 1110 | SQLSTATE: 42000 ER_FIELD_SPECIFIED_TWICE | Message: Column '%s' specified twice |
| Error: 1111 | SQLSTATE: HY000 ER_INVALID_GROUP_FUNC_USE | Message: Invalid use of group function |
| Error: 1112 | SQLSTATE: 42000 ER_UNSUPPORTED_EXTENSION | Message: Table '%s' uses an extension that doesn't exist in this MySQL version |
| Error: 1113 | SQLSTATE: 42000 ER_TABLE_MUST_HAVE_COLUMNS | Message: A table must have at least 1 column |
| Error: 1114 | SQLSTATE: HY000 ER_RECORD_FILE_FULL | Message: The table '%s' is full |
| Error: 1115 | SQLSTATE: 42000 ER_UNKNOWN_CHARACTER_SET | Message: Unknown character set: '%s' |
| Error: 1116 | SQLSTATE: HY000 ER_TOO_MANY_TABLES | Message: Too many tables; MySQL can only use %d tables in a join |
| Error: 1117 | SQLSTATE: HY000 ER_TOO_MANY_FIELDS | Message: Too many columns |
| Error: 1118 | SQLSTATE: 42000 ER_TOO_BIG_ROWSIZE | Message: 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 |
| Error: 1119 | SQLSTATE: HY000 ER_STACK_OVERRUN | Message: Thread stack overrun: Used: %ld of a %ld stack. Use 'mysqld -O thread_stack=#' to specify a bigger stack if needed |
| Error: 1120 | SQLSTATE: 42000 ER_WRONG_OUTER_JOIN | Message: Cross dependency found in OUTER JOIN; examine your ON conditions |
| Error: 1121 | SQLSTATE: 42000 ER_NULL_COLUMN_IN_INDEX | Message: Column '%s' is used with UNIQUE or INDEX but is not defined as NOT NULL |
| Error: 1122 | SQLSTATE: HY000 ER_CANT_FIND_UDF | Message: Can't load function '%s' |
| Error: 1123 | SQLSTATE: HY000 ER_CANT_INITIALIZE_UDF | Message: Can't initialize function '%s'; %s |
| Error: 1124 | SQLSTATE: HY000 ER_UDF_NO_PATHS | Message: No paths allowed for shared library |
| Error: 1125 | SQLSTATE: HY000 ER_UDF_EXISTS | Message: Function '%s' already exists |
| Error: 1126 | SQLSTATE: HY000 ER_CANT_OPEN_LIBRARY | Message: Can't open shared library '%s' errno: %d %s |
| Error: 1127 | SQLSTATE: HY000 ER_CANT_FIND_DL_ENTRY | Message: Can't find function '%s' in library' |
| Error: 1128 | SQLSTATE: HY000 ER_FUNCTION_NOT_DEFINED | Message: Function '%s' is not defined |
| Error: 1129 | SQLSTATE: HY000 ER_HOST_IS_BLOCKED | Message: Host '%s' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' |
| Error: 1130 | SQLSTATE: HY000 ER_HOST_NOT_PRIVILEGED | Message: Host '%s' is not allowed to connect to this MySQL server |
| Error: 1131 | SQLSTATE: 42000 ER_PASSWORD_ANONYMOUS_USER | Message: You are using MySQL as an anonymous user and anonymous users are not allowed to change passwords |
| Error: 1132 | SQLSTATE: 42000 ER_PASSWORD_NOT_ALLOWED | Message: You must have privileges to update tables in the mysql database to be able to change passwords for others |
| Error: 1133 | SQLSTATE: 42000 ER_PASSWORD_NO_MATCH | Message: Can't find any matching row in the user table |
| Error: 1134 | SQLSTATE: HY000 ER_UPDATE_INFO | Message: Rows matched: %ld Changed: %ld Warnings: %ld |
| Error: 1135 | SQLSTATE: HY000 ER_CANT_CREATE_THREAD | Message: Can't create a new thread errno %d; if you are not out of available memory, you can consult the manual for a possible OS-dependent bug |
| Error: 1136 | SQLSTATE: 21S01 ER_WRONG_VALUE_COUNT_ON_ROW | Message: Column count doesn't match value count at row %ld |
| Error: 1137 | SQLSTATE: HY000 ER_CANT_REOPEN_TABLE | Message: Can't reopen table: '%s' |
| Error: 1138 | SQLSTATE: 22004 ER_INVALID_USE_OF_NULL | Message: Invalid use of NULL value |
| Error: 1139 | SQLSTATE: 42000 ER_REGEXP_ERROR | Message: Got error '%s' from regexp |
| Error: 1140 | SQLSTATE: 42000 ER_MIX_OF_GROUP_FUNC_AND_FIELDS | Message: Mixing of GROUP columns MIN,MAX,COUNT,... with no GROUP columns is illegal if there is no GROUP BY clause |
| Error: 1141 | SQLSTATE: 42000 ER_NONEXISTING_GRANT | Message: There is no such grant defined for user '%s' on host '%s' |
| Error: 1142 | SQLSTATE: 42000 ER_TABLEACCESS_DENIED_ERROR | Message: %s command denied to user '%s'@'%s' for table '%s' |
| Error: 1143 | SQLSTATE: 42000 ER_COLUMNACCESS_DENIED_ERROR | Message: %s command denied to user '%s'@'%s' for column '%s' in table '%s' |
| Error: 1144 | SQLSTATE: 42000 ER_ILLEGAL_GRANT_FOR_TABLE | Message: Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used |
| Error: 1145 | SQLSTATE: 42000 ER_GRANT_WRONG_HOST_OR_USER | Message: The host or user argument to GRANT is too long |
| Error: 1146 | SQLSTATE: 42S02 ER_NO_SUCH_TABLE | Message: Table '%s.%s' doesn't exist |
| Error: 1147 | SQLSTATE: 42000 ER_NONEXISTING_TABLE_GRANT | Message: There is no such grant defined for user '%s' on host '%s' on table '%s' |
| Error: 1148 | SQLSTATE: 42000 ER_NOT_ALLOWED_COMMAND | Message: The used command is not allowed with this MySQL version |
| Error: 1149 | SQLSTATE: 42000 ER_SYNTAX_ERROR | Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use |
| Error: 1150 | SQLSTATE: HY000 ER_DELAYED_CANT_CHANGE_LOCK | Message: Delayed insert thread couldn't get requested lock for table %s |
| Error: 1151 | SQLSTATE: HY000 ER_TOO_MANY_DELAYED_THREADS | Message: Too many delayed threads in use |
| Error: 1152 | SQLSTATE: 08S01 ER_ABORTING_CONNECTION | Message: Aborted connection %ld to db: '%s' user: '%s' %s |
| Error: 1153 | SQLSTATE: 08S01 ER_NET_PACKET_TOO_LARGE | Message: Got a packet bigger than 'max_allowed_packet' bytes |
| Error: 1154 | SQLSTATE: 08S01 ER_NET_READ_ERROR_FROM_PIPE | Message: Got a read error from the connection pipe |
| Error: 1155 | SQLSTATE: 08S01 ER_NET_FCNTL_ERROR | Message: Got an error from fcntl |
| Error: 1156 | SQLSTATE: 08S01 ER_NET_PACKETS_OUT_OF_ORDER | Message: Got packets out of order |
| Error: 1157 | SQLSTATE: 08S01 ER_NET_UNCOMPRESS_ERROR | Message: Couldn't uncompress communication packet |
| Error: 1158 | SQLSTATE: 08S01 ER_NET_READ_ERROR | Message: Got an error reading communication packets |
| Error: 1159 | SQLSTATE: 08S01 ER_NET_READ_INTERRUPTED | Message: Got timeout reading communication packets |
| Error: 1160 | SQLSTATE: 08S01 ER_NET_ERROR_ON_WRITE | Message: Got an error writing communication packets |
| Error: 1161 | SQLSTATE: 08S01 ER_NET_WRITE_INTERRUPTED | Message: Got timeout writing communication packets |
| Error: 1162 | SQLSTATE: 42000 ER_TOO_LONG_STRING | Message: Result string is longer than 'max_allowed_packet' bytes |
| Error: 1163 | SQLSTATE: 42000 ER_TABLE_CANT_HANDLE_BLOB | Message: The used table type doesn't support BLOB/TEXT columns |
| Error: 1164 | SQLSTATE: 42000 ER_TABLE_CANT_HANDLE_AUTO_INCREMENT | Message: The used table type doesn't support AUTO_INCREMENT columns |
| Error: 1165 | SQLSTATE: HY000 ER_DELAYED_INSERT_TABLE_LOCKED | Message: INSERT DELAYED can't be used with table '%s' because it is locked with LOCK TABLES |
| Error: 1166 | SQLSTATE: 42000 ER_WRONG_COLUMN_NAME | Message: Incorrect column name '%s' |
| Error: 1167 | SQLSTATE: 42000 ER_WRONG_KEY_COLUMN | Message: The used storage engine can't index column '%s' |
| Error: 1168 | SQLSTATE: HY000 ER_WRONG_MRG_TABLE | Message: All tables in the MERGE table are not identically defined |
| Error: 1169 | SQLSTATE: 23000 ER_DUP_UNIQUE | Message: Can't write, because of unique constraint, to table '%s' |
| Error: 1170 | SQLSTATE: 42000 ER_BLOB_KEY_WITHOUT_LENGTH | Message: BLOB/TEXT column '%s' used in key specification without a key length |
| Error: 1171 | SQLSTATE: 42000 ER_PRIMARY_CANT_HAVE_NULL | Message: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead |
| Error: 1172 | SQLSTATE: 42000 ER_TOO_MANY_ROWS | Message: Result consisted of more than one row |
| Error: 1173 | SQLSTATE: 42000 ER_REQUIRES_PRIMARY_KEY | Message: This table type requires a primary key |
| Error: 1174 | SQLSTATE: HY000 ER_NO_RAID_COMPILED | Message: This version of MySQL is not compiled with RAID support |
| Error: 1175 | SQLSTATE: HY000 ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE | Message: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column |
| Error: 1176 | SQLSTATE: HY000 ER_KEY_DOES_NOT_EXITS | Message: Key '%s' doesn't exist in table '%s' |
| Error: 1177 | SQLSTATE: 42000 ER_CHECK_NO_SUCH_TABLE | Message: Can't open table |
| Error: 1178 | SQLSTATE: 42000 ER_CHECK_NOT_IMPLEMENTED | Message: The storage engine for the table doesn't support %s |
| Error: 1179 | SQLSTATE: 25000 ER_CANT_DO_THIS_DURING_AN_TRANSACTION | Message: You are not allowed to execute this command in a transaction |
| Error: 1180 | SQLSTATE: HY000 ER_ERROR_DURING_COMMIT | Message: Got error %d during COMMIT |
| Error: 1181 | SQLSTATE: HY000 ER_ERROR_DURING_ROLLBACK | Message: Got error %d during ROLLBACK |
| Error: 1182 | SQLSTATE: HY000 ER_ERROR_DURING_FLUSH_LOGS | Message: Got error %d during FLUSH_LOGS |
| Error: 1183 | SQLSTATE: HY000 ER_ERROR_DURING_CHECKPOINT | Message: Got error %d during CHECKPOINT |
| Error: 1184 | SQLSTATE: 08S01 ER_NEW_ABORTING_CONNECTION | Message: Aborted connection %ld to db: '%s' user: '%s' host: `%s' %s |
| Error: 1185 | SQLSTATE: HY000 ER_DUMP_NOT_IMPLEMENTED | Message: The storage engine for the table does not support binary table dump |
| Error: 1186 | SQLSTATE: HY000 ER_FLUSH_MASTER_BINLOG_CLOSED | Message: Binlog closed, cannot RESET MASTER |
| Error: 1187 | SQLSTATE: HY000 ER_INDEX_REBUILD | Message: Failed rebuilding the index of dumped table '%s' |
| Error: 1188 | SQLSTATE: HY000 ER_MASTER | Message: Error from master: '%s' |
| Error: 1189 | SQLSTATE: 08S01 ER_MASTER_NET_READ | Message: Net error reading from master |
| Error: 1190 | SQLSTATE: 08S01 ER_MASTER_NET_WRITE | Message: Net error writing to master |
| Error: 1191 | SQLSTATE: HY000 ER_FT_MATCHING_KEY_NOT_FOUND | Message: Can't find FULLTEXT index matching the column list |
| Error: 1192 | SQLSTATE: HY000 ER_LOCK_OR_ACTIVE_TRANSACTION | Message: Can't execute the given command because you have active locked tables or an active transaction |
| Error: 1193 | SQLSTATE: HY000 ER_UNKNOWN_SYSTEM_VARIABLE | Message: Unknown system variable '%s' |
| Error: 1194 | SQLSTATE: HY000 ER_CRASHED_ON_USAGE | Message: Table '%s' is marked as crashed and should be repaired |
| Error: 1195 | SQLSTATE: HY000 ER_CRASHED_ON_REPAIR | Message: Table '%s' is marked as crashed and last automatic? repair failed |
| Error: 1196 | SQLSTATE: HY000 ER_WARNING_NOT_COMPLETE_ROLLBACK | Message: Some non-transactional changed tables couldn't be rolled back |
| Error: 1197 | SQLSTATE: HY000 ER_TRANS_CACHE_FULL | Message: Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again |
| Error: 1198 | SQLSTATE: HY000 ER_SLAVE_MUST_STOP | Message: This operation cannot be performed with a running slave; run STOP SLAVE first |
| Error: 1199 | SQLSTATE: HY000 ER_SLAVE_NOT_RUNNING | Message: This operation requires a running slave; configure slave and do START SLAVE |
| Error: 1200 | SQLSTATE: HY000 ER_BAD_SLAVE | Message: The server is not configured as slave; fix in config file or with CHANGE MASTER TO |
| Error: 1201 | SQLSTATE: HY000 ER_MASTER_INFO | Message: Could not initialize master info structure; more error messages can be found in the MySQL error log |
| Error: 1202 | SQLSTATE: HY000 ER_SLAVE_THREAD | Message: Could not create slave thread; check system resources |
| Error: 1203 | SQLSTATE: 42000 ER_TOO_MANY_USER_CONNECTIONS | Message: User %s has already more than 'max_user_connections' active connections |
| Error: 1204 | SQLSTATE: HY000 ER_SET_CONSTANTS_ONLY | Message: You may only use constant expressions with SET |
| Error: 1205 | SQLSTATE: HY000 ER_LOCK_WAIT_TIMEOUT | Message: Lock wait timeout exceeded; try restarting transaction |
| Error: 1206 | SQLSTATE: HY000 ER_LOCK_TABLE_FULL | Message: The total number of locks exceeds the lock table size |
| Error: 1207 | SQLSTATE: 25000 ER_READ_ONLY_TRANSACTION | Message: Update locks cannot be acquired during a READ UNCOMMITTED transaction |
| Error: 1208 | SQLSTATE: HY000 ER_DROP_DB_WITH_READ_LOCK | Message: DROP DATABASE not allowed while thread is holding global read lock |
| Error: 1209 | SQLSTATE: HY000 ER_CREATE_DB_WITH_READ_LOCK | Message: CREATE DATABASE not allowed while thread is holding global read lock |
| Error: 1210 | SQLSTATE: HY000 ER_WRONG_ARGUMENTS | Message: Incorrect arguments to %s |
| Error: 1211 | SQLSTATE: 42000 ER_NO_PERMISSION_TO_CREATE_USER | Message: '%s'@'%s' is not allowed to create new users |
| Error: 1212 | SQLSTATE: HY000 ER_UNION_TABLES_IN_DIFFERENT_DIR | Message: Incorrect table definition; all MERGE tables must be in the same database |
| Error: 1213 | SQLSTATE: 40001 ER_LOCK_DEADLOCK | Message: Deadlock found when trying to get lock; try restarting transaction |
| Error: 1214 | SQLSTATE: HY000 ER_TABLE_CANT_HANDLE_FT | Message: The used table type doesn't support FULLTEXT indexes |
| Error: 1215 | SQLSTATE: HY000 ER_CANNOT_ADD_FOREIGN | Message: Cannot add foreign key constraint |
| Error: 1216 | SQLSTATE: 23000 ER_NO_REFERENCED_ROW | Message: Cannot add or update a child row: a foreign key constraint fails |
| Error: 1217 | SQLSTATE: 23000 ER_ROW_IS_REFERENCED | Message: Cannot delete or update a parent row: a foreign key constraint fails |
| Error: 1218 | SQLSTATE: 08S01 ER_CONNECT_TO_MASTER | Message: Error connecting to master: %s |
| Error: 1219 | SQLSTATE: HY000 ER_QUERY_ON_MASTER | Message: Error running query on master: %s |
| Error: 1220 | SQLSTATE: HY000 ER_ERROR_WHEN_EXECUTING_COMMAND | Message: Error when executing command %s: %s |
| Error: 1221 | SQLSTATE: HY000 ER_WRONG_USAGE | Message: Incorrect usage of %s and %s |
| Error: 1222 | SQLSTATE: 21000 ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT | Message: The used SELECT statements have a different number of columns |
| Error: 1223 | SQLSTATE: HY000 ER_CANT_UPDATE_WITH_READLOCK | Message: Can't execute the query because you have a conflicting read lock |
| Error: 1224 | SQLSTATE: HY000 ER_MIXING_NOT_ALLOWED | Message: Mixing of transactional and non-transactional tables is disabled |
| Error: 1225 | SQLSTATE: HY000 ER_DUP_ARGUMENT | Message: Option '%s' used twice in statement |
| Error: 1226 | SQLSTATE: 42000 ER_USER_LIMIT_REACHED | Message: User '%s' has exceeded the '%s' resource current value: %ld |
| Error: 1227 | SQLSTATE: HY000 ER_SPECIFIC_ACCESS_DENIED_ERROR | Message: Access denied; you need the %s privilege for this operation |
| Error: 1228 | SQLSTATE: HY000 ER_LOCAL_VARIABLE | Message: Variable '%s' is a SESSION variable and can't be used with SET GLOBAL |
| Error: 1229 | SQLSTATE: HY000 ER_GLOBAL_VARIABLE | Message: Variable '%s' is a GLOBAL variable and should be set with SET GLOBAL |
| Error: 1230 | SQLSTATE: 42000 ER_NO_DEFAULT | Message: Variable '%s' doesn't have a default value |
| Error: 1231 | SQLSTATE: 42000 ER_WRONG_VALUE_FOR_VAR | Message: Variable '%s' can't be set to the value of '%s' |
| Error: 1232 | SQLSTATE: 42000 ER_WRONG_TYPE_FOR_VAR | Message: Incorrect argument type to variable '%s' |
| Error: 1233 | SQLSTATE: HY000 ER_VAR_CANT_BE_READ | Message: Variable '%s' can only be set, not read |
| Error: 1234 | SQLSTATE: 42000 ER_CANT_USE_OPTION_HERE | Message: Incorrect usage/placement of '%s' |
| Error: 1235 | SQLSTATE: 42000 ER_NOT_SUPPORTED_YET | Message: This version of MySQL doesn't yet support '%s' |
| Error: 1236 | SQLSTATE: HY000 ER_MASTER_FATAL_ERROR_READING_BINLOG | Message: Got fatal error %d: '%s' from master when reading data from binary log |
| Error: 1237 | SQLSTATE: HY000 ER_SLAVE_IGNORED_TABLE | Message: Slave SQL thread ignored the query because of replicate-*-table rules |
| Error: 1238 | SQLSTATE: HY000 ER_INCORRECT_GLOBAL_LOCAL_VAR | Message: Variable '%s' is a %s variable |
| Error: 1239 | SQLSTATE: 42000 ER_WRONG_FK_DEF | Message: Incorrect foreign key definition for '%s': %s |
| Error: 1240 | SQLSTATE: HY000 ER_KEY_REF_DO_NOT_MATCH_TABLE_REF | Message: Key reference and table reference don't match |
| Error: 1241 | SQLSTATE: 21000 ER_OPERAND_COLUMNS | Message: Operand should contain %d columns |
| Error: 1242 | SQLSTATE: 21000 ER_SUBQUERY_NO_1_ROW | Message: Subquery returns more than 1 row |
| Error: 1243 | SQLSTATE: HY000 ER_UNKNOWN_STMT_HANDLER | Message: Unknown prepared statement handler %.*s given to %s |
| Error: 1244 | SQLSTATE: HY000 ER_CORRUPT_HELP_DB | Message: Help database is corrupt or does not exist |
| Error: 1245 | SQLSTATE: HY000 ER_CYCLIC_REFERENCE | Message: Cyclic reference on subqueries |
| Error: 1246 | SQLSTATE: HY000 ER_AUTO_CONVERT | Message: Converting column '%s' from %s to %s |
| Error: 1247 | SQLSTATE: 42S22 ER_ILLEGAL_REFERENCE | Message: Reference '%s' not supported %s |
| Error: 1248 | SQLSTATE: 42000 ER_DERIVED_MUST_HAVE_ALIAS | Message: Every derived table must have its own alias |
| Error: 1249 | SQLSTATE: 01000 ER_SELECT_REDUCED | Message: Select %u was reduced during optimization |
| Error: 1250 | SQLSTATE: 42000 ER_TABLENAME_NOT_ALLOWED_HERE | Message: Table '%s' from one of the SELECTs cannot be used in %s |
| Error: 1251 | SQLSTATE: 08004 ER_NOT_SUPPORTED_AUTH_MODE | Message: Client does not support authentication protocol requested by server; consider upgrading MySQL client |
| Error: 1252 | SQLSTATE: 42000 ER_SPATIAL_CANT_HAVE_NULL | Message: All parts of a SPATIAL index must be NOT NULL |
| Error: 1253 | SQLSTATE: 42000 ER_COLLATION_CHARSET_MISMATCH | Message: COLLATION '%s' is not valid for CHARACTER SET '%s' |
| Error: 1254 | SQLSTATE: HY000 ER_SLAVE_WAS_RUNNING | Message: Slave is already running |
| Error: 1255 | SQLSTATE: HY000 ER_SLAVE_WAS_NOT_RUNNING | Message: Slave has already been stopped |
| Error: 1256 | SQLSTATE: HY000 ER_TOO_BIG_FOR_UNCOMPRESS | Message: Uncompressed data size too large; the maximum size is %d probably, length of uncompressed data was corrupted |
| Error: 1257 | SQLSTATE: HY000 ER_ZLIB_Z_MEM_ERROR | Message: ZLIB: Not enough memory |
| Error: 1258 | SQLSTATE: HY000 ER_ZLIB_Z_BUF_ERROR | Message: ZLIB: Not enough room in the output buffer probably, length of uncompressed data was corrupted |
| Error: 1259 | SQLSTATE: HY000 ER_ZLIB_Z_DATA_ERROR | Message: ZLIB: Input data corrupted |
| Error: 1260 | SQLSTATE: HY000 ER_CUT_VALUE_GROUP_CONCAT | Message: %d lines were cut by GROUP_CONCAT |
| Error: 1261 | SQLSTATE: 01000 ER_WARN_TOO_FEW_RECORDS | Message: Row %ld doesn't contain data for all columns |
| Error: 1262 | SQLSTATE: 01000 ER_WARN_TOO_MANY_RECORDS | Message: Row %ld was truncated; it contained more data than there were input columns |
| Error: 1263 | SQLSTATE: 22004 ER_WARN_NULL_TO_NOTNULL | Message: Column set to default value; NULL supplied to NOT NULL column '%s' at row %ld |
| Error: 1264 | SQLSTATE: 22003 ER_WARN_DATA_OUT_OF_RANGE | Message: Out of range value adjusted for column '%s' at row %ld |
| Error: 1265 | SQLSTATE: 01000 ER_WARN_DATA_TRUNCATED | Message: Data truncated for column '%s' at row %ld |
| Error: 1266 | SQLSTATE: HY000 ER_WARN_USING_OTHER_HANDLER | Message: Using storage engine %s for table '%s' |
| Error: 1267 | SQLSTATE: HY000 ER_CANT_AGGREGATE_2COLLATIONS | Message: Illegal mix of collations %s,%s and %s,%s for operation '%s' |
| Error: 1268 | SQLSTATE: HY000 ER_DROP_USER | Message: Can't drop one or more of the requested users |
| Error: 1269 | SQLSTATE: HY000 ER_REVOKE_GRANTS | Message: Can't revoke all privileges, grant for one or more of the requested users |
| Error: 1270 | SQLSTATE: HY000 ER_CANT_AGGREGATE_3COLLATIONS | Message: Illegal mix of collations %s,%s, %s,%s, %s,%s for operation '%s' |
| Error: 1271 | SQLSTATE: HY000 ER_CANT_AGGREGATE_NCOLLATIONS | Message: Illegal mix of collations for operation '%s' |
| Error: 1272 | SQLSTATE: HY000 ER_VARIABLE_IS_NOT_STRUCT | Message: Variable '%s' is not a variable component can't be used as XXXX.variable_name |
| Error: 1273 | SQLSTATE: HY000 ER_UNKNOWN_COLLATION | Message: Unknown collation: '%s' |
| Error: 1274 | SQLSTATE: HY000 ER_SLAVE_IGNORED_SSL_PARAMS | Message: SSL parameters in CHANGE MASTER are ignored because this MySQL slave was compiled without SSL support; they can be used later if MySQL slave with SSL is started |
| Error: 1275 | SQLSTATE: HY000 ER_SERVER_IS_IN_SECURE_AUTH_MODE | Message: Server is running in --secure-auth mode, but '%s'@'%s' has a password in the old format; please change the password to the new format |
| Error: 1276 | SQLSTATE: HY000 ER_WARN_FIELD_RESOLVED | Message: Field or reference '%s%s%s%s%s' of SELECT #%d was resolved in SELECT #%d |
| Error: 1277 | SQLSTATE: HY000 ER_BAD_SLAVE_UNTIL_COND | Message: Incorrect parameter or combination of parameters for START SLAVE UNTIL |
| Error: 1278 | SQLSTATE: HY000 ER_MISSING_SKIP_SLAVE | Message: It is recommended to use --skip-slave-start when doing step-by-step replication with START SLAVE UNTIL; otherwise, you will get problems if you get an unexpected slave's mysqld restart |
| Error: 1279 | SQLSTATE: HY000 ER_UNTIL_COND_IGNORED | Message: SQL thread is not to be started so UNTIL options are ignored |
| Error: 1280 | SQLSTATE: 42000 ER_WRONG_NAME_FOR_INDEX | Message: Incorrect index name '%s' |
| Error: 1281 | SQLSTATE: 42000 ER_WRONG_NAME_FOR_CATALOG | Message: Incorrect catalog name '%s' |
| Error: 1282 | SQLSTATE: HY000 ER_WARN_QC_RESIZE | Message: Query cache failed to set size %lu; new query cache size is %lu |
| Error: 1283 | SQLSTATE: HY000 ER_BAD_FT_COLUMN | Message: Column '%s' cannot be part of FULLTEXT index |
| Error: 1284 | SQLSTATE: HY000 ER_UNKNOWN_KEY_CACHE | Message: Unknown key cache '%s' |
| Error: 1285 | SQLSTATE: HY000 ER_WARN_HOSTNAME_WONT_WORK | Message: MySQL is started in --skip-name-resolve mode; you must restart it without this switch for this grant to work |
| Error: 1286 | SQLSTATE: 42000 ER_UNKNOWN_STORAGE_ENGINE | Message: Unknown table engine '%s' |
| Error: 1287 | SQLSTATE: HY000 ER_WARN_DEPRECATED_SYNTAX | Message: '%s' is deprecated; use '%s' instead |
| Error: 1288 | SQLSTATE: HY000 ER_NON_UPDATABLE_TABLE | Message: The target table %s of the %s is not updatable |
| Error: 1289 | SQLSTATE: HY000 ER_FEATURE_DISABLED | Message: The '%s' feature is disabled; you need MySQL built with '%s' to have it working |
| Error: 1290 | SQLSTATE: HY000 ER_OPTION_PREVENTS_STATEMENT | Message: The MySQL server is running with the %s option so it cannot execute this statement |
| Error: 1291 | SQLSTATE: HY000 ER_DUPLICATED_VALUE_IN_TYPE | Message: Column '%s' has duplicated value '%s' in %s |
| Error: 1292 | SQLSTATE: 22007 ER_TRUNCATED_WRONG_VALUE | Message: Truncated incorrect %s value: '%s' |
| Error: 1293 | SQLSTATE: HY000 ER_TOO_MUCH_AUTO_TIMESTAMP_COLS | Message: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause |
| Error: 1294 | SQLSTATE: HY000 ER_INVALID_ON_UPDATE | Message: Invalid ON UPDATE clause for '%s' column |
| Error: 1295 | SQLSTATE: HY000 ER_UNSUPPORTED_PS | Message: This command is not supported in the prepared statement protocol yet |
| Error: 1296 | SQLSTATE: HY000 ER_GET_ERRMSG | Message: Got error %d '%s' from %s |
| Error: 1297 | SQLSTATE: HY000 ER_GET_TEMPORARY_ERRMSG | Message: Got temporary error %d '%s' from %s |
| Error: 1298 | SQLSTATE: HY000 ER_UNKNOWN_TIME_ZONE | Message: Unknown or incorrect time zone: '%s' |
| Error: 1299 | SQLSTATE: HY000 ER_WARN_INVALID_TIMESTAMP | Message: Invalid TIMESTAMP value in column '%s' at row %ld |
| Error: 1300 | SQLSTATE: HY000 ER_INVALID_CHARACTER_STRING | Message: Invalid %s character string: '%s' |
| Error: 1301 | SQLSTATE: HY000 ER_WARN_ALLOWED_PACKET_OVERFLOWED | Message: Result of %s was larger than max_allowed_packet %ld - truncated |
| Error: 1302 | SQLSTATE: HY000 ER_CONFLICTING_DECLARATIONS | Message: Conflicting declarations: '%s%s' and '%s%s' |
| Error: 1303 | SQLSTATE: 2F003 ER_SP_NO_RECURSIVE_CREATE | Message: Can't create a %s from within another stored routine |
| Error: 1304 | SQLSTATE: 42000 ER_SP_ALREADY_EXISTS | Message: %s %s already exists |
| Error: 1305 | SQLSTATE: 42000 ER_SP_DOES_NOT_EXIST | Message: %s %s does not exist |
| Error: 1306 | SQLSTATE: HY000 ER_SP_DROP_FAILED | Message: Failed to DROP %s %s |
| Error: 1307 | SQLSTATE: HY000 ER_SP_STORE_FAILED | Message: Failed to CREATE %s %s |
| Error: 1308 | SQLSTATE: 42000 ER_SP_LILABEL_MISMATCH | Message: %s with no matching label: %s |
| Error: 1309 | SQLSTATE: 42000 ER_SP_LABEL_REDEFINE | Message: Redefining label %s |
| Error: 1310 | SQLSTATE: 42000 ER_SP_LABEL_MISMATCH | Message: End-label %s without match |
| Error: 1311 | SQLSTATE: 01000 ER_SP_UNINIT_VAR | Message: Referring to uninitialized variable %s |
| Error: 1312 | SQLSTATE: 0A000 ER_SP_BADSELECT | Message: SELECT in a stored procedure must have INTO |
| Error: 1313 | SQLSTATE: 42000 ER_SP_BADRETURN | Message: RETURN is only allowed in a FUNCTION |
| Error: 1314 | SQLSTATE: 0A000 ER_SP_BADSTATEMENT | Message: Statements like SELECT, INSERT, UPDATE and others are not allowed in a FUNCTION |
| Error: 1315 | SQLSTATE: 42000 ER_UPDATE_LOG_DEPRECATED_IGNORED | Message: The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored |
| Error: 1316 | SQLSTATE: 42000 ER_UPDATE_LOG_DEPRECATED_TRANSLATED | Message: The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been translated to SET SQL_LOG_BIN |
| Error: 1317 | SQLSTATE: 70100 ER_QUERY_INTERRUPTED | Message: Query execution was interrupted |
| Error: 1318 | SQLSTATE: 42000 ER_SP_WRONG_NO_OF_ARGS | Message: Incorrect number of arguments for %s %s; expected %u, got %u |
| Error: 1319 | SQLSTATE: 42000 ER_SP_COND_MISMATCH | Message: Undefined CONDITION: %s |
| Error: 1320 | SQLSTATE: 42000 ER_SP_NORETURN | Message: No RETURN found in FUNCTION %s |
| Error: 1321 | SQLSTATE: 2F005 ER_SP_NORETURNEND | Message: FUNCTION %s ended without RETURN |
| Error: 1322 | SQLSTATE: 42000 ER_SP_BAD_CURSOR_QUERY | Message: Cursor statement must be a SELECT |
| Error: 1323 | SQLSTATE: 42000 ER_SP_BAD_CURSOR_SELECT | Message: Cursor SELECT must not have INTO |
| Error: 1324 | SQLSTATE: 42000 ER_SP_CURSOR_MISMATCH | Message: Undefined CURSOR: %s |
| Error: 1325 | SQLSTATE: 24000 ER_SP_CURSOR_ALREADY_OPEN | Message: Cursor is already open |
| Error: 1326 | SQLSTATE: 24000 ER_SP_CURSOR_NOT_OPEN | Message: Cursor is not open |
| Error: 1327 | SQLSTATE: 42000 ER_SP_UNDECLARED_VAR | Message: Undeclared variable: %s |
| Error: 1328 | SQLSTATE: HY000 ER_SP_WRONG_NO_OF_FETCH_ARGS | Message: Incorrect number of FETCH variables |
| Error: 1329 | SQLSTATE: 02000 ER_SP_FETCH_NO_DATA | Message: No data to FETCH |
| Error: 1330 | SQLSTATE: 42000 ER_SP_DUP_PARAM | Message: Duplicate parameter: %s |
| Error: 1331 | SQLSTATE: 42000 ER_SP_DUP_VAR | Message: Duplicate variable: %s |
| Error: 1332 | SQLSTATE: 42000 ER_SP_DUP_COND | Message: Duplicate condition: %s |
| Error: 1333 | SQLSTATE: 42000 ER_SP_DUP_CURS | Message: Duplicate cursor: %s |
| Error: 1334 | SQLSTATE: HY000 ER_SP_CANT_ALTER | Message: Failed to ALTER %s %s |
| Error: 1335 | SQLSTATE: 0A000 ER_SP_SUBSELECT_NYI | Message: Subselect value not supported |
| Error: 1336 | SQLSTATE: 42000 ER_SP_NO_USE | Message: USE is not allowed in a stored procedure |
| Error: 1337 | SQLSTATE: 42000 ER_SP_VARCOND_AFTER_CURSHNDLR | Message: Variable or condition declaration after cursor or handler declaration |
| Error: 1338 | SQLSTATE: 42000 ER_SP_CURSOR_AFTER_HANDLER | Message: Cursor declaration after handler declaration |
| Error: 1339 | SQLSTATE: 20000 ER_SP_CASE_NOT_FOUND | Message: Case not found for CASE statement |
| Error: 1340 | SQLSTATE: HY000 ER_FPARSER_TOO_BIG_FILE | Message: Configuration file '%s' is too big/ |
| Error: 1341 | SQLSTATE: HY000 ER_FPARSER_BAD_HEADER | Message: Malformed file type header in file '%s' |
| Error: 1342 | SQLSTATE: HY000 ER_FPARSER_EOF_IN_COMMENT | Message: Unexpected end of file while parsing comment '%s' |
| Error: 1343 | SQLSTATE: HY000 ER_FPARSER_ERROR_IN_PARAMETER | Message: Error while parsing parameter '%s' line: '%s' |
| Error: 1344 | SQLSTATE: HY000 ER_FPARSER_EOF_IN_UNKNOWN_PARAMETER | Message: Unexpected end of file while skipping unknown parameter '%s' |
| Error: 1345 | SQLSTATE: HY000 ER_VIEW_NO_EXPLAIN | Message: EXPLAIN/SHOW can not be issued; lacking privileges for underlying table |
| Error: 1346 | SQLSTATE: HY000 ER_FRM_UNKNOWN_TYPE | Message: File '%s' has unknown type '%s' in its header |
| Error: 1347 | SQLSTATE: HY000 ER_WRONG_OBJECT | Message: '%s.%s' is not %s |
| Error: 1348 | SQLSTATE: HY000 ER_NONUPDATEABLE_COLUMN | Message: Column '%s' is not updatable |
| Error: 1349 | SQLSTATE: HY000 ER_VIEW_SELECT_DERIVED | Message: View's SELECT contains a subquery in the FROM clause |
| Error: 1350 | SQLSTATE: HY000 ER_VIEW_SELECT_CLAUSE | Message: View's SELECT contains a '%s' clause |
| Error: 1351 | SQLSTATE: HY000 ER_VIEW_SELECT_VARIABLE | Message: View's SELECT contains a variable or parameter |
| Error: 1352 | SQLSTATE: HY000 ER_VIEW_SELECT_TMPTABLE | Message: View's SELECT contains a temporary table '%s' |
| Error: 1353 | SQLSTATE: HY000 ER_VIEW_WRONG_LIST | Message: View's SELECT and view's field list have different column counts |
| Error: 1354 | SQLSTATE: HY000 ER_WARN_VIEW_MERGE | Message: View merge algorithm can't be used here for now assumed undefined algorithm |
| Error: 1355 | SQLSTATE: HY000 ER_WARN_VIEW_WITHOUT_KEY | Message: View being updated does not have complete key of underlying table in it |
| Error: 1356 | SQLSTATE: HY000 ER_VIEW_INVALID | Message: View '%s.%s' references invalid tables or columns |
| Error: 1357 | SQLSTATE: HY000 ER_SP_NO_DROP_SP | Message: Can't drop a %s from within another stored routine |
| Error: 1358 | SQLSTATE: HY000 ER_SP_GOTO_IN_HNDLR | Message: GOTO is not allowed in a stored procedure handler |
| Error: 1359 | SQLSTATE: HY000 ER_TRG_ALREADY_EXISTS | Message: Trigger already exists |
| Error: 1360 | SQLSTATE: HY000 ER_TRG_DOES_NOT_EXIST | Message: Trigger does not exist |
| Error: 1361 | SQLSTATE: HY000 ER_TRG_ON_VIEW_OR_TEMP_TABLE | Message: Trigger's '%s' is view or temporary table |
| Error: 1362 | SQLSTATE: HY000 ER_TRG_CANT_CHANGE_ROW | Message: Updating of %s row is not allowed in %strigger |
| Error: 1363 | SQLSTATE: HY000 ER_TRG_NO_SUCH_ROW_IN_TRG | Message: There is no %s row in %s trigger |
| Error: 1364 | SQLSTATE: HY000 ER_NO_DEFAULT_FOR_FIELD | Message: Field '%s' doesn't have a default value |
| Error: 1365 | SQLSTATE: 22012 ER_DIVISION_BY_ZERO | Message: Division by 0 |
| Error: 1366 | SQLSTATE: HY000 ER_TRUNCATED_WRONG_VALUE_FOR_FIELD | Message: Incorrect %s value: '%s' for column '%s' at row %ld |
| Error: 1367 | SQLSTATE: 22007 ER_ILLEGAL_VALUE_FOR_TYPE | Message: Illegal %s '%s' value found during parsing |
| Error: 1368 | SQLSTATE: HY000 ER_VIEW_NONUPD_CHECK | Message: CHECK OPTION on non-updatable view '%s.%s' |
| Error: 1369 | SQLSTATE: HY000 ER_VIEW_CHECK_FAILED | Message: CHECK OPTION failed '%s.%s' |
Client Errors
| Error Code | SQL State | Message | End of Client Errors |
| Error: 2000 | CR_UNKNOWN_ERROR | Message: Unknown MySQL error |
| Error: 2001 | CR_SOCKET_CREATE_ERROR | Message: Can't create UNIX socket %d |
| Error: 2002 | CR_CONNECTION_ERROR | Message: Can't connect to local MySQL server through socket '%s' %d |
| Error: 2003 | CR_CONN_HOST_ERROR | Message: Can't connect to MySQL server on '%s' %d |
| Error: 2004 | CR_IPSOCK_ERROR | Message: Can't create TCP/IP socket %d |
| Error: 2005 | CR_UNKNOWN_HOST | Message: Unknown MySQL server host '%s' %d |
| Error: 2006 | CR_SERVER_GONE_ERROR | Message: MySQL server has gone away |
| Error: 2007 | CR_VERSION_ERROR | Message: Protocol mismatch; server version = %d, client version = %d |
| Error: 2008 | CR_OUT_OF_MEMORY | Message: MySQL client ran out of memory |
| Error: 2009 | CR_WRONG_HOST_INFO | Message: Wrong host info |
| Error: 2010 | CR_LOCALHOST_CONNECTION | Message: Localhost via UNIX socket |
| Error: 2011 | CR_TCP_CONNECTION | Message: %s via TCP/IP |
| Error: 2012 | CR_SERVER_HANDSHAKE_ERR | Message: Error in server handshake |
| Error: 2013 | CR_SERVER_LOST | Message: Lost connection to MySQL server during query |
| Error: 2014 | CR_COMMANDS_OUT_OF_SYNC | Message: Commands out of sync; you can't run this command now |
| Error: 2015 | CR_NAMEDPIPE_CONNECTION | Message: %s via named pipe |
| Error: 2016 | CR_NAMEDPIPEWAIT_ERROR | Message: Can't wait for named pipe to host: %s pipe: %s %lu |
| Error: 2017 | CR_NAMEDPIPEOPEN_ERROR | Message: Can't open named pipe to host: %s pipe: %s %lu |
| Error: 2018 | CR_NAMEDPIPESETSTATE_ERROR | Message: Can't set state of named pipe to host: %s pipe: %s %lu |
| Error: 2019 | CR_CANT_READ_CHARSET | Message: Can't initialize character set %s path: %s |
| Error: 2020 | CR_NET_PACKET_TOO_LARGE | Message: Got packet bigger than 'max_allowed_packet' bytes |
| Error: 2021 | CR_EMBEDDED_CONNECTION | Message: Embedded server |
| Error: 2022 | CR_PROBE_SLAVE_STATUS | Message: Error on SHOW SLAVE STATUS: |
| Error: 2023 | CR_PROBE_SLAVE_HOSTS | Message: Error on SHOW SLAVE HOSTS: |
| Error: 2024 | CR_PROBE_SLAVE_CONNECT | Message: Error connecting to slave: |
| Error: 2025 | CR_PROBE_MASTER_CONNECT | Message: Error connecting to master: |
| Error: 2026 | CR_SSL_CONNECTION_ERROR | Message: SSL connection error |
| Error: 2027 | CR_MALFORMED_PACKET | Message: Malformed packet |
| Error: 2028 | CR_WRONG_LICENSE | Message: This client library is licensed only for use with MySQL servers having '%s' license |
| Error: 2029 | CR_NULL_POINTER | Message: Invalid use of null pointer |
| Error: 2030 | CR_NO_PREPARE_STMT | Message: Statement not prepared |
| Error: 2031 | CR_PARAMS_NOT_BOUND | Message: No data supplied for parameters in prepared statement |
| Error: 2032 | CR_DATA_TRUNCATED | Message: Data truncated |
| Error: 2033 | CR_NO_PARAMETERS_EXISTS | Message: No parameters exist in the statement |
| Error: 2034 | CR_INVALID_PARAMETER_NO | Message: Invalid parameter number |
| Error: 2035 | CR_INVALID_BUFFER_USE | Message: Can't send long data for non-string/non-binary data types parameter: %d |
| Error: 2036 | CR_UNSUPPORTED_PARAM_TYPE | Message: Using unsupported buffer type: %d parameter: %d |
| Error: 2037 | CR_SHARED_MEMORY_CONNECTION | Message: Shared memory %lu |
| Error: 2038 | CR_SHARED_MEMORY_CONNECT_REQUEST_ERROR | Message: Can't open shared memory; client could not create request event %lu |
| Error: 2039 | CR_SHARED_MEMORY_CONNECT_ANSWER_ERROR | Message: Can't open shared memory; no answer event received from server %lu |
| Error: 2040 | CR_SHARED_MEMORY_CONNECT_FILE_MAP_ERROR | Message: Can't open shared memory; server could not allocate file mapping %lu |
| Error: 2041 | CR_SHARED_MEMORY_CONNECT_MAP_ERROR | Message: Can't open shared memory; server could not get pointer to file mapping %lu |
| Error: 2042 | CR_SHARED_MEMORY_FILE_MAP_ERROR | Message: Can't open shared memory; client could not allocate file mapping %lu |
| Error: 2043 | CR_SHARED_MEMORY_MAP_ERROR | Message: Can't open shared memory; client could not get pointer to file mapping %lu |
| Error: 2044 | CR_SHARED_MEMORY_EVENT_ERROR | Message: Can't open shared memory; client could not create %s event %lu |
| Error: 2045 | CR_SHARED_MEMORY_CONNECT_ABANDONED_ERROR | Message: Can't open shared memory; no answer from server %lu |
| Error: 2046 | CR_SHARED_MEMORY_CONNECT_SET_ERROR | Message: Can't open shared memory; cannot send request event to server %lu |
| Error: 2047 | CR_CONN_UNKNOW_PROTOCOL | Message: Wrong or unknown protocol |
| Error: 2048 | CR_INVALID_CONN_HANDLE | Message: Invalid connection handle |
| Error: 2049 | CR_SECURE_AUTH | Message: Connection using old pre-4.1.1 authentication protocol refused client option 'secure_auth' enabled |
| Error: 2050 | CR_FETCH_CANCELED | Message: Row retrieval was canceled by mysql_stmt_close call |
| Error: 2051 | CR_NO_DATA | Message: Attempt to read column without prior row fetch |