MySQL Common 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:42000
(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 already has 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 column(s)
-
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 already has 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 line(s) 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
(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: Cannot 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: LOCK and UNLOCK tables are not allowed in stored procedures
-
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 table(s) or column(s) or function(s)
-
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'
-
Error:
1370
SQLSTATE:42000
(ER_PROCACCESS_DENIED_ERROR
)Message: %s command denied to user '%s'@'%s' for routine '%s'
-
Error:
1371
SQLSTATE:HY000
(ER_RELAY_LOG_FAIL
)Message: Failed purging old relay logs: %s
-
Error:
1372
SQLSTATE:HY000
(ER_PASSWD_LENGTH
)Message: Password hash should be a %d-digit hexadecimal number
-
Error:
1373
SQLSTATE:HY000
(ER_UNKNOWN_TARGET_BINLOG
)Message: Target log not found in binlog index
-
Error:
1374
SQLSTATE:HY000
(ER_IO_ERR_LOG_INDEX_READ
)Message: I/O error reading log index file
-
Error:
1375
SQLSTATE:HY000
(ER_BINLOG_PURGE_PROHIBITED
)Message: Server configuration does not permit binlog purge
-
Error:
1376
SQLSTATE:HY000
(ER_FSEEK_FAIL
)Message: Failed on fseek()
-
Error:
1377
SQLSTATE:HY000
(ER_BINLOG_PURGE_FATAL_ERR
)Message: Fatal error during log purge
-
Error:
1378
SQLSTATE:HY000
(ER_LOG_IN_USE
)Message: A purgeable log is in use, will not purge
-
Error:
1379
SQLSTATE:HY000
(ER_LOG_PURGE_UNKNOWN_ERR
)Message: Unknown error during log purge
-
Error:
1380
SQLSTATE:HY000
(ER_RELAY_LOG_INIT
)Message: Failed initializing relay log position: %s
-
Error:
1381
SQLSTATE:HY000
(ER_NO_BINARY_LOGGING
)Message: You are not using binary logging
-
Error:
1382
SQLSTATE:HY000
(ER_RESERVED_SYNTAX
)Message: The '%s' syntax is reserved for purposes internal to the MySQL server
-
Error:
1383
SQLSTATE:HY000
(ER_WSAS_FAILED
)Message: WSAStartup Failed
-
Error:
1384
SQLSTATE:HY000
(ER_DIFF_GROUPS_PROC
)Message: Can't handle procedures with differents groups yet
-
Error:
1385
SQLSTATE:HY000
(ER_NO_GROUP_FOR_PROC
)Message: Select must have a group with this procedure
-
Error:
1386
SQLSTATE:HY000
(ER_ORDER_WITH_PROC
)Message: Can't use ORDER clause with this procedure
-
Error:
1387
SQLSTATE:HY000
(ER_LOGGING_PROHIBIT_CHANGING_OF
)Message: Binary logging and replication forbid changing the global server %s
-
Error:
1388
SQLSTATE:HY000
(ER_NO_FILE_MAPPING
)Message: Can't map file: %s, errno: %d
-
Error:
1389
SQLSTATE:HY000
(ER_WRONG_MAGIC
)Message: Wrong magic in %s
-
Error:
1390
SQLSTATE:HY000
(ER_PS_MANY_PARAM
)Message: Prepared statement contains too many placeholders
-
Error:
1391
SQLSTATE:HY000
(ER_KEY_PART_0
)Message: Key part '%s' length cannot be 0
-
Error:
1392
SQLSTATE:HY000
(ER_VIEW_CHECKSUM
)Message: View text checksum failed
-
Error:
1393
SQLSTATE:HY000
(ER_VIEW_MULTIUPDATE
)Message: Can not modify more than one base table through a join view '%s.%s'
-
Error:
1394
SQLSTATE:HY000
(ER_VIEW_NO_INSERT_FIELD_LIST
)Message: Can not insert into join view '%s.%s' without fields list
-
Error:
1395
SQLSTATE:HY000
(ER_VIEW_DELETE_MERGE_VIEW
)Message: Can not delete from join view '%s.%s'
-
Error:
1396
SQLSTATE:HY000
(ER_CANNOT_USER
)Message: Operation %s failed for %s
-
Error:
1397
SQLSTATE:XAE04
(ER_XAER_NOTA
)Message: XAER_NOTA: Unknown XID
-
Error:
1398
SQLSTATE:XAE05
(ER_XAER_INVAL
)Message: XAER_INVAL: Invalid arguments (or unsupported command)
-
Error:
1399
SQLSTATE:XAE07
(ER_XAER_RMFAIL
)Message: XAER_RMFAIL: The command cannot be executed in the %s state
-
Error:
1400
SQLSTATE:XAE09
(ER_XAER_OUTSIDE
)Message: XAER_OUTSIDE: Some work is done outside global transaction
-
Error:
1401
SQLSTATE:XAE03
(ER_XAER_RMERR
)Message: XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency
-
Error:
1402
SQLSTATE:XA100
(ER_XA_RBROLLBACK
)Message: XA_RBROLLBACK: Transaction branch was rolled back
-
Error:
1403
SQLSTATE:42000
(ER_NONEXISTING_PROC_GRANT
)Message: There is no such grant defined for user '%s' on host '%s' on routine '%s'
-
Error:
1404
SQLSTATE:HY000
(ER_PROC_AUTO_GRANT_FAIL
)Message: Failed to grant EXECUTE and ALTER ROUTINE privileges
-
Error:
1405
SQLSTATE:HY000
(ER_PROC_AUTO_REVOKE_FAIL
)Message: Failed to revoke all privileges to dropped routine
-
Error:
1406
SQLSTATE:22001
(ER_DATA_TOO_LONG
)Message: Data too long for column '%s' at row %ld
Client error information comes from the following files:
-
The Error values and the symbols in parentheses correspond to definitions in the
include/errmsg.h
MySQL source file. -
The Message values correspond to the error messages that are listed in the
libmysql/errmsg.c
file. %d or %s represent numbers or strings that are substituted into the messages %when they are displayed.
Because updates are frequent, it is possible that these files contain additional error information not listed here.
-
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: Named pipe: %s
-
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: %s
-
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
-
Error:
2052
(CR_NO_STMT_METADATA
)Message: Prepared statement contains no metadata