MySQL programs have access to several types of error information when the server returns an error. For example, the mysql client program displays errors using the following format: The message displayed contains three types of information: A numeric error code ( A five-character SQLSTATE value ( A string that provides a textual description of the error. Server error information comes from the following source files. For details about the way that error information is defined, see the MySQL Internals manual, available at http://dev.mysql.com/doc/. Error message information is listed in the The Error values listed in The SQLSTATE values listed in MySQL Enterprise. MySQL Enterprise subscribers will find numerous articles about server error messages at, Error Messages. For information about subscribing to MySQL Enterprise see http://www.mysql.com/products/enterprise/advisors.html. Because updates are frequent, it is possible that those files will contain additional error information not listed here. Error: Message: hashchk Error: Message: isamchk Error: Message: NO Error: Message: YES Error: Message: Can't create file '%s' (errno: %d) Error: Message: Can't create table '%s' (errno: %d) Error: Message: Can't create database '%s' (errno: %d) Error: Message: Can't create database '%s'; database exists Error: Message: Can't drop database '%s'; database doesn't exist Error: Message: Error dropping database (can't delete '%s', errno: %d) Error: Message: Error dropping database (can't rmdir '%s', errno: %d) Error: Message: Error on delete of '%s' (errno: %d) Error: Message: Can't read record in system table Error: Message: Can't get status of '%s' (errno: %d) Error: Message: Can't get working directory (errno: %d) Error: Message: Can't lock file (errno: %d) Error: Message: Can't open file: '%s' (errno: %d) Error: Message: Can't find file: '%s' (errno: %d) Error: Message: Can't read dir of '%s' (errno: %d) Error: Message: Can't change dir to '%s' (errno: %d) Error: Message: Record has changed since last read in table '%s' Error: Message: Disk full (%s); waiting for someone to free some space... Error: Message: Can't write; duplicate key in table '%s' Error: Message: Error on close of '%s' (errno: %d) Error: Message: Error reading file '%s' (errno: %d) Error: Message: Error on rename of '%s' to '%s' (errno: %d) Error: Message: Error writing file '%s' (errno: %d) Error: Message: '%s' is locked against change Error: Message: Sort aborted Error: Message: View '%s' doesn't exist for '%s' Error: Message: Got error %d from storage engine Error: Message: Table storage engine for '%s' doesn't have this option Error: Message: Can't find record in '%s' Error: Message: Incorrect information in file: '%s' Error: Message: Incorrect key file for table '%s'; try to repair it Error: Message: Old key file for table '%s'; repair it! Error: Message: Table '%s' is read only Error: Message: Out of memory; restart server and try again (needed %d bytes) Error: Message: Out of sort memory; increase server sort buffer size Error: Message: Unexpected EOF found when reading file '%s' (errno: %d) Error: Message: Too many connections Error: 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: Message: Can't get hostname for your address Error: Message: Bad handshake Error: Message: Access denied for user '%s'@'%s' to database '%s' Error: Message: Access denied for user '%s'@'%s' (using password: %s) Error: Message: No database selected Error: Message: Unknown command Error: Message: Column '%s' cannot be null Error: Message: Unknown database '%s' Error: Message: Table '%s' already exists Error: Message: Unknown table '%s' Error: Message: Column '%s' in %s is ambiguous Error: Message: Server shutdown in progress Error: Message: Unknown column '%s' in '%s' Error: Message: '%s' isn't in GROUP BY Error: Message: Can't group on '%s' Error: Message: Statement has sum functions and columns in same statement Error: Message: Column count doesn't match value count Error: Message: Identifier name '%s' is too long Error: Message: Duplicate column name '%s' Error: Message: Duplicate key name '%s' Error: Message: Duplicate entry '%s' for key %d Error: Message: Incorrect column specifier for column '%s' Error: Message: %s near '%s' at line %d Error: Message: Query was empty Error: Message: Not unique table/alias: '%s' Error: Message: Invalid default value for '%s' Error: Message: Multiple primary key defined Error: Message: Too many keys specified; max %d keys allowed Error: Message: Too many key parts specified; max %d parts allowed Error: Message: Specified key was too long; max key length is %d bytes Error: Message: Key column '%s' doesn't exist in table Error: Message: BLOB column '%s' can't be used in key specification with the used table type Error: Message: Column length too big for column '%s' (max = %lu); use BLOB or TEXT instead Error: Message: Incorrect table definition; there can be only one auto column and it must be defined as a key Error: Message: %s: ready for connections. Version: '%s' socket: '%s' port: %d Error: Message: %s: Normal shutdown Error: Message: %s: Got signal %d. Aborting! Error: Message: %s: Shutdown complete Error: Message: %s: Forcing close of thread %ld user: '%s' Error: Message: Can't create IP socket Error: Message: Table '%s' has no index like the one used in CREATE INDEX; recreate the table Error: Message: Field separator argument is not what is expected; check the manual Error: Message: You can't use fixed rowlength with BLOBs; please use 'fields terminated by' Error: Message: The file '%s' must be in the database directory or be readable by all Error: Message: File '%s' already exists Error: Message: Records: %ld Deleted: %ld Skipped: %ld Warnings: %ld Error: Message: Records: %ld Duplicates: %ld Error: 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: Message: You can't delete all columns with ALTER TABLE; use DROP TABLE instead Error: Message: Can't DROP '%s'; check that column/key exists Error: Message: Records: %ld Duplicates: %ld Warnings: %ld Error: Message: You can't specify target table '%s' for update in FROM clause Error: Message: Unknown thread id: %lu Error: Message: You are not owner of thread %lu Error: Message: No tables used Error: Message: Too many strings for column %s and SET Error: Message: Can't generate a unique log-filename %s.(1-999) Error: Message: Table '%s' was locked with a READ lock and can't be updated Error: Message: Table '%s' was not locked with LOCK TABLES Error: Message: BLOB/TEXT column '%s' can't have a default value Error: Message: Incorrect database name '%s' Error: Message: Incorrect table name '%s' Error: 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: Message: Unknown error Error: Message: Unknown procedure '%s' Error: Message: Incorrect parameter count to procedure '%s' Error: Message: Incorrect parameters to procedure '%s' Error: Message: Unknown table '%s' in %s Error: Message: Column '%s' specified twice Error: Message: Invalid use of group function Error: Message: Table '%s' uses an extension that doesn't exist in this MySQL version Error: Message: A table must have at least 1 column Error: Message: The table '%s' is full Error: Message: Unknown character set: '%s' Error: Message: Too many tables; MySQL can only use %d tables in a join Error: Message: Too many columns Error: 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: Message: Thread stack overrun: Used: %ld of a %ld stack. Use 'mysqld -O thread_stack=#' to specify a bigger stack if needed Error: Message: Cross dependency found in OUTER JOIN; examine your ON conditions Error: Message: Column '%s' is used with UNIQUE or INDEX but is not defined as NOT NULL Error: Message: Can't load function '%s' Error: Message: Can't initialize function '%s'; %s Error: Message: No paths allowed for shared library Error: Message: Function '%s' already exists Error: Message: Can't open shared library '%s' (errno: %d %s) Error: Message: Can't find function '%s' in library Error: Message: Function '%s' is not defined Error: Message: Host '%s' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' Error: Message: Host '%s' is not allowed to connect to this MySQL server Error: Message: You are using MySQL as an anonymous user and anonymous users are not allowed to change passwords Error: Message: You must have privileges to update tables in the mysql database to be able to change passwords for others Error: Message: Can't find any matching row in the user table Error: Message: Rows matched: %ld Changed: %ld Warnings: %ld Error: 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: Message: Column count doesn't match value count at row %ld Error: Message: Can't reopen table: '%s' Error: Message: Invalid use of NULL value Error: Message: Got error '%s' from regexp Error: Message: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause Error: Message: There is no such grant defined for user '%s' on host '%s' Error: Message: %s command denied to user '%s'@'%s' for table '%s' Error: Message: %s command denied to user '%s'@'%s' for column '%s' in table '%s' Error: Message: Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used Error: Message: The host or user argument to GRANT is too long Error: Message: Table '%s.%s' doesn't exist Error: Message: There is no such grant defined for user '%s' on host '%s' on table '%s' Error: Message: The used command is not allowed with this MySQL version 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: Message: Delayed insert thread couldn't get requested lock for table %s Error: Message: Too many delayed threads in use Error: Message: Aborted connection %ld to db: '%s' user: '%s' (%s) Error: Message: Got a packet bigger than 'max_allowed_packet' bytes Error: Message: Got a read error from the connection pipe Error: Message: Got an error from fcntl() Error: Message: Got packets out of order Error: Message: Couldn't uncompress communication packet Error: Message: Got an error reading communication packets Error: Message: Got timeout reading communication packets Error: Message: Got an error writing communication packets Error: Message: Got timeout writing communication packets Error: Message: Result string is longer than 'max_allowed_packet' bytes Error: Message: The used table type doesn't support BLOB/TEXT columns Error: Message: The used table type doesn't support AUTO_INCREMENT columns Error: Message: INSERT DELAYED can't be used with table '%s' because it is locked with LOCK TABLES Error: Message: Incorrect column name '%s' Error: Message: The used storage engine can't index column '%s' Error: Message: Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist Error: Message: Can't write, because of unique constraint, to table '%s' Error: Message: BLOB/TEXT column '%s' used in key specification without a key length Error: Message: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead Error: Message: Result consisted of more than one row Error: Message: This table type requires a primary key Error: Message: This version of MySQL is not compiled with RAID support Error: Message: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column Error: Message: Key '%s' doesn't exist in table '%s' Error: Message: Can't open table Error: Message: The storage engine for the table doesn't support %s Error: Message: You are not allowed to execute this command in a transaction Error: Message: Got error %d during COMMIT Error: Message: Got error %d during ROLLBACK Error: Message: Got error %d during FLUSH_LOGS Error: Message: Got error %d during CHECKPOINT Error: Message: Aborted connection %ld to db: '%s' user: '%s' host: '%s' (%s) Error: Message: The storage engine for the table does not support binary table dump Error: Message: Binlog closed, cannot RESET MASTER Error: Message: Failed rebuilding the index of dumped table '%s' Error: Message: Error from master: '%s' Error: Message: Net error reading from master Error: Message: Net error writing to master Error: Message: Can't find FULLTEXT index matching the column list Error: Message: Can't execute the given command because you have active locked tables or an active transaction Error: Message: Unknown system variable '%s' Error: Message: Table '%s' is marked as crashed and should be repaired Error: Message: Table '%s' is marked as crashed and last (automatic?) repair failed Error: Message: Some non-transactional changed tables couldn't be rolled back Error: Message: Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage; increase this mysqld variable and try again Error: Message: This operation cannot be performed with a running slave; run STOP SLAVE first Error: Message: This operation requires a running slave; configure slave and do START SLAVE Error: Message: The server is not configured as slave; fix in config file or with CHANGE MASTER TO Error: Message: Could not initialize master info structure; more error messages can be found in the MySQL error log Error: Message: Could not create slave thread; check system resources Error: Message: User %s already has more than 'max_user_connections' active connections Error: Message: You may only use constant expressions with SET Error: Message: Lock wait timeout exceeded; try restarting transaction Error: Message: The total number of locks exceeds the lock table size Error: Message: Update locks cannot be acquired during a READ UNCOMMITTED transaction Error: Message: DROP DATABASE not allowed while thread is holding global read lock Error: Message: CREATE DATABASE not allowed while thread is holding global read lock Error: Message: Incorrect arguments to %s Error: Message: '%s'@'%s' is not allowed to create new users Error: Message: Incorrect table definition; all MERGE tables must be in the same database Error: Message: Deadlock found when trying to get lock; try restarting transaction Error: Message: The used table type doesn't support FULLTEXT indexes Error: Message: Cannot add foreign key constraint Error: Message: Cannot add or update a child row: a foreign key constraint fails Error: Message: Cannot delete or update a parent row: a foreign key constraint fails Error: Message: Error connecting to master: %s Error: Message: Error running query on master: %s Error: Message: Error when executing command %s: %s Error: Message: Incorrect usage of %s and %s Error: Message: The used SELECT statements have a different number of columns Error: Message: Can't execute the query because you have a conflicting read lock Error: Message: Mixing of transactional and non-transactional tables is disabled Error: Message: Option '%s' used twice in statement Error: Message: User '%s' has exceeded the '%s' resource (current value: %ld) Error: Message: Access denied; you need the %s privilege for this operation Error: Message: Variable '%s' is a SESSION variable and can't be used with SET GLOBAL Error: Message: Variable '%s' is a GLOBAL variable and should be set with SET GLOBAL Error: Message: Variable '%s' doesn't have a default value Error: Message: Variable '%s' can't be set to the value of '%s' Error: Message: Incorrect argument type to variable '%s' Error: Message: Variable '%s' can only be set, not read Error: Message: Incorrect usage/placement of '%s' Error: Message: This version of MySQL doesn't yet support '%s' Error: Message: Got fatal error %d: '%s' from master when reading data from binary log Error: Message: Slave SQL thread ignored the query because of replicate-*-table rules Error: Message: Variable '%s' is a %s variable Error: Message: Incorrect foreign key definition for '%s': %s Error: Message: Key reference and table reference don't match Error: Message: Operand should contain %d column(s) Error: Message: Subquery returns more than 1 row Error: Message: Unknown prepared statement handler (%.*s) given to %s Error: Message: Help database is corrupt or does not exist Error: Message: Cyclic reference on subqueries Error: Message: Converting column '%s' from %s to %s Error: Message: Reference '%s' not supported (%s) Error: Message: Every derived table must have its own alias Error: Message: Select %u was reduced during optimization Error: Message: Table '%s' from one of the SELECTs cannot be used in %s Error: Message: Client does not support authentication protocol requested by server; consider upgrading MySQL client Error: Message: All parts of a SPATIAL index must be NOT NULL Error: Message: COLLATION '%s' is not valid for CHARACTER SET '%s' Error: Message: Slave is already running Error: Message: Slave already has been stopped Error: Message: Uncompressed data size too large; the maximum size is %d (probably, length of uncompressed data was corrupted) Error: Message: ZLIB: Not enough memory Error: Message: ZLIB: Not enough room in the output buffer (probably, length of uncompressed data was corrupted) Error: Message: ZLIB: Input data corrupted Error: Message: %d line(s) were cut by GROUP_CONCAT() Error: Message: Row %ld doesn't contain data for all columns Error: Message: Row %ld was truncated; it contained more data than there were input columns Error: Message: Column was set to data type implicit default; NULL supplied for NOT NULL column '%s' at row %ld Error: Message: Out of range value adjusted for column '%s' at row %ld Error: Message: Data truncated for column '%s' at row %ld Error: Message: Using storage engine %s for table '%s' Error: Message: Illegal mix of collations (%s,%s) and (%s,%s) for operation '%s' Error: Message: Cannot drop one or more of the requested users Error: Message: Can't revoke all privileges for one or more of the requested users Error: Message: Illegal mix of collations (%s,%s), (%s,%s), (%s,%s) for operation '%s' Error: Message: Illegal mix of collations for operation '%s' Error: Message: Variable '%s' is not a variable component (can't be used as XXXX.variable_name) Error: Message: Unknown collation: '%s' Error: 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: 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: Message: Field or reference '%s%s%s%s%s' of SELECT #%d was resolved in SELECT #%d Error: Message: Incorrect parameter or combination of parameters for START SLAVE UNTIL Error: 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: Message: SQL thread is not to be started so UNTIL options are ignored Error: Message: Incorrect index name '%s' Error: Message: Incorrect catalog name '%s' Error: Message: Query cache failed to set size %lu; new query cache size is %lu Error: Message: Column '%s' cannot be part of FULLTEXT index Error: Message: Unknown key cache '%s' Error: Message: MySQL is started in --skip-name-resolve mode; you must restart it without this switch for this grant to work Error: Message: Unknown table engine '%s' Error: Message: '%s' is deprecated; use '%s' instead Error: Message: The target table %s of the %s is not updatable Error: Message: The '%s' feature is disabled; you need MySQL built with '%s' to have it working Error: Message: The MySQL server is running with the %s option so it cannot execute this statement Error: Message: Column '%s' has duplicated value '%s' in %s Error: Message: Truncated incorrect %s value: '%s' Error: Message: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause Error: Message: Invalid ON UPDATE clause for '%s' column Error: Message: This command is not supported in the prepared statement protocol yet Error: Message: Got error %d '%s' from %s Error: Message: Got temporary error %d '%s' from %s Error: Message: Unknown or incorrect time zone: '%s' Error: Message: Invalid TIMESTAMP value in column '%s' at row %ld Error: Message: Invalid %s character string: '%s' Error: Message: Result of %s() was larger than max_allowed_packet (%ld) - truncated Error: Message: Conflicting declarations: '%s%s' and '%s%s' Error: Message: Can't create a %s from within another stored routine Error: Message: %s %s already exists Error: Message: %s %s does not exist Error: Message: Failed to DROP %s %s Error: Message: Failed to CREATE %s %s Error: Message: %s with no matching label: %s Error: Message: Redefining label %s Error: Message: End-label %s without match Error: Message: Referring to uninitialized variable %s Error: Message: PROCEDURE %s can't return a result set in the given context Error: Message: RETURN is only allowed in a FUNCTION Error: Message: %s is not allowed in stored procedures Error: Message: The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored Error: 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: Message: Query execution was interrupted Error: Message: Incorrect number of arguments for %s %s; expected %u, got %u Error: Message: Undefined CONDITION: %s Error: Message: No RETURN found in FUNCTION %s Error: Message: FUNCTION %s ended without RETURN Error: Message: Cursor statement must be a SELECT Error: Message: Cursor SELECT must not have INTO Error: Message: Undefined CURSOR: %s Error: Message: Cursor is already open Error: Message: Cursor is not open Error: Message: Undeclared variable: %s Error: Message: Incorrect number of FETCH variables Error: Message: No data - zero rows fetched, selected, or processed Error: Message: Duplicate parameter: %s Error: Message: Duplicate variable: %s Error: Message: Duplicate condition: %s Error: Message: Duplicate cursor: %s Error: Message: Failed to ALTER %s %s Error: Message: Subselect value not supported Error: Message: %s is not allowed in stored function or trigger Error: Message: Variable or condition declaration after cursor or handler declaration Error: Message: Cursor declaration after handler declaration Error: Message: Case not found for CASE statement Error: Message: Configuration file '%s' is too big Error: Message: Malformed file type header in file '%s' Error: Message: Unexpected end of file while parsing comment '%s' Error: Message: Error while parsing parameter '%s' (line: '%s') Error: Message: Unexpected end of file while skipping unknown parameter '%s' Error: Message: EXPLAIN/SHOW can not be issued; lacking privileges for underlying table Error: Message: File '%s' has unknown type '%s' in its header Error: Message: '%s.%s' is not %s Error: Message: Column '%s' is not updatable Error: Message: View's SELECT contains a subquery in the FROM clause Error: Message: View's SELECT contains a '%s' clause Error: Message: View's SELECT contains a variable or parameter Error: Message: View's SELECT refers to a temporary table '%s' Error: Message: View's SELECT and view's field list have different column counts Error: Message: View merge algorithm can't be used here for now (assumed undefined algorithm) Error: Message: View being updated does not have complete key of underlying table in it Error: Message: View '%s.%s' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Error: Message: Can't drop or alter a %s from within another stored routine Error: Message: GOTO is not allowed in a stored procedure handler Error: Message: Trigger already exists Error: Message: Trigger does not exist Error: Message: Trigger's '%s' is view or temporary table Error: Message: Updating of %s row is not allowed in %strigger Error: Message: There is no %s row in %s trigger Error: Message: Field '%s' doesn't have a default value Error: Message: Division by 0 Error: Message: Incorrect %s value: '%s' for column '%s' at row %ld Error: Message: Illegal %s '%s' value found during parsing Error: Message: CHECK OPTION on non-updatable view '%s.%s' Error: Message: CHECK OPTION failed '%s.%s' Error: Message: %s command denied to user '%s'@'%s' for routine '%s' Error: Message: Failed purging old relay logs: %s Error: Message: Password hash should be a %d-digit hexadecimal number Error: Message: Target log not found in binlog index Error: Message: I/O error reading log index file Error: Message: Server configuration does not permit binlog purge Error: Message: Failed on fseek() Error: Message: Fatal error during log purge Error: Message: A purgeable log is in use, will not purge Error: Message: Unknown error during log purge Error: Message: Failed initializing relay log position: %s Error: Message: You are not using binary logging Error: Message: The '%s' syntax is reserved for purposes internal to the MySQL server Error: Message: WSAStartup Failed Error: Message: Can't handle procedures with different groups yet Error: Message: Select must have a group with this procedure Error: Message: Can't use ORDER clause with this procedure Error: Message: Binary logging and replication forbid changing the global server %s Error: Message: Can't map file: %s, errno: %d Error: Message: Wrong magic in %s Error: Message: Prepared statement contains too many placeholders Error: Message: Key part '%s' length cannot be 0 Error: Message: View text checksum failed Error: Message: Can not modify more than one base table through a join view '%s.%s' Error: Message: Can not insert into join view '%s.%s' without fields list Error: Message: Can not delete from join view '%s.%s' Error: Message: Operation %s failed for %s Error: Message: XAER_NOTA: Unknown XID Error: Message: XAER_INVAL: Invalid arguments (or unsupported command) Error: Message: XAER_RMFAIL: The command cannot be executed when global transaction is in the %s state Error: Message: XAER_OUTSIDE: Some work is done outside global transaction Error: Message: XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency Error: Message: XA_RBROLLBACK: Transaction branch was rolled back Error: Message: There is no such grant defined for user '%s' on host '%s' on routine '%s' Error: Message: Failed to grant EXECUTE and ALTER ROUTINE privileges Error: Message: Failed to revoke all privileges to dropped routine Error: Message: Data too long for column '%s' at row %ld Error: Message: Bad SQLSTATE: '%s' Error: Message: %s: ready for connections. Version: '%s' socket: '%s' port: %d %s Error: Message: Can't load value from file with fixed size rows to variable Error: Message: You are not allowed to create a user with GRANT Error: Message: Incorrect %s value: '%s' for function %s Error: Message: Table definition has changed, please retry transaction Error: Message: Duplicate handler declared in the same block Error: Message: OUT or INOUT argument %d for routine %s is not a variable or NEW pseudo-variable in BEFORE trigger Error: Message: Not allowed to return a result set from a %s Error: Message: Cannot get geometry object from data you send to the GEOMETRY field Error: Message: A routine failed and has neither NO SQL nor READS SQL DATA in its declaration and binary logging is enabled; if non-transactional tables were updated, the binary log will miss their changes Error: Message: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) Error: Message: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) Error: Message: You can't execute a prepared statement which has an open cursor associated with it. Reset the statement to re-execute it. Error: Message: The statement (%lu) has no open cursor. Error: Message: Explicit or implicit commit is not allowed in stored function or trigger. Error: Message: Field of view '%s.%s' underlying table doesn't have a default value Error: Message: Recursive stored functions and triggers are not allowed. Error: Message: Too big scale %lu specified for column '%s'. Maximum is %d. Error: Message: Too big precision %lu specified for column '%s'. Maximum is %lu. Error: Message: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column '%s'). Error: Message: You can't combine write-locking of system '%s.%s' table with other tables Error: Message: Unable to connect to foreign data source: %s Error: Message: There was a problem processing the query on the foreign data source. Data source error: %s Error: Message: The foreign data source you are trying to reference does not exist. Data source error: %s Error: Message: Can't create federated table. The data source connection string '%s' is not in the correct format Error: Message: The data source connection string '%s' is not in the correct format Error: Message: Can't create federated table. Foreign data src error: %s Error: Message: Trigger in wrong schema Error: Message: Thread stack overrun: %ld bytes used of a %ld byte stack, and %ld bytes needed. Use 'mysqld -O thread_stack=#' to specify a bigger stack. Error: Message: Routine body for '%s' is too long Error: Message: Cannot drop default keycache Error: Message: Display width out of range for column '%s' (max = %lu) Error: Message: XAER_DUPID: The XID already exists Error: Message: Datetime function: %s field overflow Error: Message: Can't update table '%s' in stored function/trigger because it is already used by statement which invoked this stored function/trigger. Error: Message: The definition of table '%s' prevents operation %s on table '%s'. Error: Message: The prepared statement contains a stored routine call that refers to that same statement. It's not allowed to execute a prepared statement in such a recursive manner Error: Message: Not allowed to set autocommit from a stored function or trigger Error: Message: Definer is not fully qualified Error: Message: View '%s'.'%s' has no definer information (old table format). Current user is used as definer. Please recreate the view! Error: Message: You need the SUPER privilege for creation view with '%s'@'%s' definer Error: Message: There is no '%s'@'%s' registered Error: Message: Changing schema from '%s' to '%s' is not allowed. Error: Message: Cannot delete or update a parent row: a foreign key constraint fails (%s) Error: Message: Cannot add or update a child row: a foreign key constraint fails (%s) Error: Message: Variable '%s' must be quoted with `...`, or renamed Error: Message: No definer attribute for trigger '%s'.'%s'. The trigger will be activated under the authorization of the invoker, which may have insufficient privileges. Please recreate the trigger. Error: Message: '%s' has an old format, you should re-create the '%s' object(s) Error: Message: Recursive limit %d (as set by the max_sp_recursion_depth variable) was exceeded for routine %s Error: Message: Failed to load routine %s. The table mysql.proc is missing, corrupt, or contains bad data (internal code %d) Error: Message: Incorrect routine name '%s' Error: Message: Table upgrade required. Please do "REPAIR TABLE `%s`" to fix it! Error: Message: AGGREGATE is not supported for stored functions Error: Message: Can't create more than max_prepared_stmt_count statements (current value: %lu) Error: Message: `%s`.`%s` contains view recursion Error: Message: non-grouping field '%s' is used in %s clause Error: Message: The used table type doesn't support SPATIAL indexes Error: Message: Triggers can not be created on system tables Error: Message: Leading spaces are removed from name '%s' Error: Message: Failed to read auto-increment value from storage engine Error: Message: user name Error: Message: host name Error: Message: String '%s' is too long for %s (should be no longer than %d) Error: Message: The target table %s of the %s is not insertable-into Error: Message: Table '%s' is differently defined or of non-MyISAM type or doesn't exist Error: Message: Too high level of nesting for select Error: Message: Name '%s' has become '' Error: Message: First character of the FIELDS TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS ENCLOSED BY Error: Message: Invalid column reference (%s) in LOAD DATA Error: Message: Being purged log %s was not found Error: Message: XA_RBTIMEOUT: Transaction branch was rolled back: took too long Error: Message: XA_RBDEADLOCK: Transaction branch was rolled back: deadlock was detectedshell>
SELECT * FROM no_such_table;
ERROR 1146 (42S02): Table 'test.no_such_table' doesn't exist 1146
). This number is MySQL-specific and is not portable to other database systems.'42S02'
). The values are specified by ANSI SQL and ODBC and are more standardized. Not all MySQL error numbers are mapped to SQLSTATE error codes. The value 'HY000'
(general error) is used for unmapped errors.share/errmsg.txt
file. %d
and %s
represent numbers and strings, respectively, that are substituted into the Message values when they are displayed.share/errmsg.txt
are used to generate the definitions in theinclude/mysqld_error.h
and include/mysqld_ername.h
MySQL source files.share/errmsg.txt
are used to generate the definitions in theinclude/sql_state.h
MySQL source file.1000
SQLSTATE: HY000
(ER_HASHCHK
)1001
SQLSTATE: HY000
(ER_NISAMCHK
)1002
SQLSTATE: HY000
(ER_NO
)1003
SQLSTATE: HY000
(ER_YES
)1004
SQLSTATE: HY000
(ER_CANT_CREATE_FILE
)1005
SQLSTATE: HY000
(ER_CANT_CREATE_TABLE
)1006
SQLSTATE: HY000
(ER_CANT_CREATE_DB
)1007
SQLSTATE: HY000
(ER_DB_CREATE_EXISTS
)1008
SQLSTATE: HY000
(ER_DB_DROP_EXISTS
)1009
SQLSTATE: HY000
(ER_DB_DROP_DELETE
)1010
SQLSTATE: HY000
(ER_DB_DROP_RMDIR
)1011
SQLSTATE: HY000
(ER_CANT_DELETE_FILE
)1012
SQLSTATE: HY000
(ER_CANT_FIND_SYSTEM_REC
)1013
SQLSTATE: HY000
(ER_CANT_GET_STAT
)1014
SQLSTATE: HY000
(ER_CANT_GET_WD
)1015
SQLSTATE: HY000
(ER_CANT_LOCK
)1016
SQLSTATE: HY000
(ER_CANT_OPEN_FILE
)1017
SQLSTATE: HY000
(ER_FILE_NOT_FOUND
)1018
SQLSTATE: HY000
(ER_CANT_READ_DIR
)1019
SQLSTATE: HY000
(ER_CANT_SET_WD
)1020
SQLSTATE: HY000
(ER_CHECKREAD
)1021
SQLSTATE: HY000
(ER_DISK_FULL
)1022
SQLSTATE: 23000
(ER_DUP_KEY
)1023
SQLSTATE: HY000
(ER_ERROR_ON_CLOSE
)1024
SQLSTATE: HY000
(ER_ERROR_ON_READ
)1025
SQLSTATE: HY000
(ER_ERROR_ON_RENAME
)1026
SQLSTATE: HY000
(ER_ERROR_ON_WRITE
)1027
SQLSTATE: HY000
(ER_FILE_USED
)1028
SQLSTATE: HY000
(ER_FILSORT_ABORT
)1029
SQLSTATE: HY000
(ER_FORM_NOT_FOUND
)1030
SQLSTATE: HY000
(ER_GET_ERRNO
)1031
SQLSTATE: HY000
(ER_ILLEGAL_HA
)1032
SQLSTATE: HY000
(ER_KEY_NOT_FOUND
)1033
SQLSTATE: HY000
(ER_NOT_FORM_FILE
)1034
SQLSTATE: HY000
(ER_NOT_KEYFILE
)1035
SQLSTATE: HY000
(ER_OLD_KEYFILE
)1036
SQLSTATE: HY000
(ER_OPEN_AS_READONLY
)1037
SQLSTATE: HY001
(ER_OUTOFMEMORY
)1038
SQLSTATE: HY001
(ER_OUT_OF_SORTMEMORY
)1039
SQLSTATE: HY000
(ER_UNEXPECTED_EOF
)1040
SQLSTATE: 08004
(ER_CON_COUNT_ERROR
)1041
SQLSTATE: HY000
(ER_OUT_OF_RESOURCES
)1042
SQLSTATE: 08S01
(ER_BAD_HOST_ERROR
)1043
SQLSTATE: 08S01
(ER_HANDSHAKE_ERROR
)1044
SQLSTATE: 42000
(ER_DBACCESS_DENIED_ERROR
)1045
SQLSTATE: 28000
(ER_ACCESS_DENIED_ERROR
)1046
SQLSTATE: 3D000
(ER_NO_DB_ERROR
)1047
SQLSTATE: 08S01
(ER_UNKNOWN_COM_ERROR
)1048
SQLSTATE: 23000
(ER_BAD_NULL_ERROR
)1049
SQLSTATE: 42000
(ER_BAD_DB_ERROR
)1050
SQLSTATE: 42S01
(ER_TABLE_EXISTS_ERROR
)1051
SQLSTATE: 42S02
(ER_BAD_TABLE_ERROR
)1052
SQLSTATE: 23000
(ER_NON_UNIQ_ERROR
)1053
SQLSTATE: 08S01
(ER_SERVER_SHUTDOWN
)1054
SQLSTATE: 42S22
(ER_BAD_FIELD_ERROR
)1055
SQLSTATE: 42000
(ER_WRONG_FIELD_WITH_GROUP
)1056
SQLSTATE: 42000
(ER_WRONG_GROUP_FIELD
)1057
SQLSTATE: 42000
(ER_WRONG_SUM_SELECT
)1058
SQLSTATE: 21S01
(ER_WRONG_VALUE_COUNT
)1059
SQLSTATE: 42000
(ER_TOO_LONG_IDENT
)1060
SQLSTATE: 42S21
(ER_DUP_FIELDNAME
)1061
SQLSTATE: 42000
(ER_DUP_KEYNAME
)1062
SQLSTATE: 23000
(ER_DUP_ENTRY
)1063
SQLSTATE: 42000
(ER_WRONG_FIELD_SPEC
)1064
SQLSTATE: 42000
(ER_PARSE_ERROR
)1065
SQLSTATE: 42000
(ER_EMPTY_QUERY
)1066
SQLSTATE: 42000
(ER_NONUNIQ_TABLE
)1067
SQLSTATE: 42000
(ER_INVALID_DEFAULT
)1068
SQLSTATE: 42000
(ER_MULTIPLE_PRI_KEY
)1069
SQLSTATE: 42000
(ER_TOO_MANY_KEYS
)1070
SQLSTATE: 42000
(ER_TOO_MANY_KEY_PARTS
)1071
SQLSTATE: 42000
(ER_TOO_LONG_KEY
)1072
SQLSTATE: 42000
(ER_KEY_COLUMN_DOES_NOT_EXITS
)1073
SQLSTATE: 42000
(ER_BLOB_USED_AS_KEY
)1074
SQLSTATE: 42000
(ER_TOO_BIG_FIELDLENGTH
)1075
SQLSTATE: 42000
(ER_WRONG_AUTO_KEY
)1076
SQLSTATE: HY000
(ER_READY
)1077
SQLSTATE: HY000
(ER_NORMAL_SHUTDOWN
)1078
SQLSTATE: HY000
(ER_GOT_SIGNAL
)1079
SQLSTATE: HY000
(ER_SHUTDOWN_COMPLETE
)1080
SQLSTATE: 08S01
(ER_FORCING_CLOSE
)1081
SQLSTATE: 08S01
(ER_IPSOCK_ERROR
)1082
SQLSTATE: 42S12
(ER_NO_SUCH_INDEX
)1083
SQLSTATE: 42000
(ER_WRONG_FIELD_TERMINATORS
)1084
SQLSTATE: 42000
(ER_BLOBS_AND_NO_TERMINATED
)1085
SQLSTATE: HY000
(ER_TEXTFILE_NOT_READABLE
)1086
SQLSTATE: HY000
(ER_FILE_EXISTS_ERROR
)1087
SQLSTATE: HY000
(ER_LOAD_INFO
)1088
SQLSTATE: HY000
(ER_ALTER_INFO
)1089
SQLSTATE: HY000
(ER_WRONG_SUB_KEY
)1090
SQLSTATE: 42000
(ER_CANT_REMOVE_ALL_FIELDS
)1091
SQLSTATE: 42000
(ER_CANT_DROP_FIELD_OR_KEY
)1092
SQLSTATE: HY000
(ER_INSERT_INFO
)1093
SQLSTATE: HY000
(ER_UPDATE_TABLE_USED
)1094
SQLSTATE: HY000
(ER_NO_SUCH_THREAD
)1095
SQLSTATE: HY000
(ER_KILL_DENIED_ERROR
)1096
SQLSTATE: HY000
(ER_NO_TABLES_USED
)1097
SQLSTATE: HY000
(ER_TOO_BIG_SET
)1098
SQLSTATE: HY000
(ER_NO_UNIQUE_LOGFILE
)1099
SQLSTATE: HY000
(ER_TABLE_NOT_LOCKED_FOR_WRITE
)1100
SQLSTATE: HY000
(ER_TABLE_NOT_LOCKED
)1101
SQLSTATE: 42000
(ER_BLOB_CANT_HAVE_DEFAULT
)1102
SQLSTATE: 42000
(ER_WRONG_DB_NAME
)1103
SQLSTATE: 42000
(ER_WRONG_TABLE_NAME
)1104
SQLSTATE: 42000
(ER_TOO_BIG_SELECT
)1105
SQLSTATE: HY000
(ER_UNKNOWN_ERROR
)1106
SQLSTATE: 42000
(ER_UNKNOWN_PROCEDURE
)1107
SQLSTATE: 42000
(ER_WRONG_PARAMCOUNT_TO_PROCEDURE
)1108
SQLSTATE: HY000
(ER_WRONG_PARAMETERS_TO_PROCEDURE
)1109
SQLSTATE: 42S02
(ER_UNKNOWN_TABLE
)1110
SQLSTATE: 42000
(ER_FIELD_SPECIFIED_TWICE
)1111
SQLSTATE: HY000
(ER_INVALID_GROUP_FUNC_USE
)1112
SQLSTATE: 42000
(ER_UNSUPPORTED_EXTENSION
)1113
SQLSTATE: 42000
(ER_TABLE_MUST_HAVE_COLUMNS
)1114
SQLSTATE: HY000
(ER_RECORD_FILE_FULL
)1115
SQLSTATE: 42000
(ER_UNKNOWN_CHARACTER_SET
)1116
SQLSTATE: HY000
(ER_TOO_MANY_TABLES
)1117
SQLSTATE: HY000
(ER_TOO_MANY_FIELDS
)1118
SQLSTATE: 42000
(ER_TOO_BIG_ROWSIZE
)1119
SQLSTATE: HY000
(ER_STACK_OVERRUN
)1120
SQLSTATE: 42000
(ER_WRONG_OUTER_JOIN
)1121
SQLSTATE: 42000
(ER_NULL_COLUMN_IN_INDEX
)1122
SQLSTATE: HY000
(ER_CANT_FIND_UDF
)1123
SQLSTATE: HY000
(ER_CANT_INITIALIZE_UDF
)1124
SQLSTATE: HY000
(ER_UDF_NO_PATHS
)1125
SQLSTATE: HY000
(ER_UDF_EXISTS
)1126
SQLSTATE: HY000
(ER_CANT_OPEN_LIBRARY
)1127
SQLSTATE: HY000
(ER_CANT_FIND_DL_ENTRY
)1128
SQLSTATE: HY000
(ER_FUNCTION_NOT_DEFINED
)1129
SQLSTATE: HY000
(ER_HOST_IS_BLOCKED
)1130
SQLSTATE: HY000
(ER_HOST_NOT_PRIVILEGED
)1131
SQLSTATE: 42000
(ER_PASSWORD_ANONYMOUS_USER
)1132
SQLSTATE: 42000
(ER_PASSWORD_NOT_ALLOWED
)1133
SQLSTATE: 42000
(ER_PASSWORD_NO_MATCH
)1134
SQLSTATE: HY000
(ER_UPDATE_INFO
)1135
SQLSTATE: HY000
(ER_CANT_CREATE_THREAD
)1136
SQLSTATE: 21S01
(ER_WRONG_VALUE_COUNT_ON_ROW
)1137
SQLSTATE: HY000
(ER_CANT_REOPEN_TABLE
)1138
SQLSTATE: 22004
(ER_INVALID_USE_OF_NULL
)1139
SQLSTATE: 42000
(ER_REGEXP_ERROR
)1140
SQLSTATE: 42000
(ER_MIX_OF_GROUP_FUNC_AND_FIELDS
)1141
SQLSTATE: 42000
(ER_NONEXISTING_GRANT
)1142
SQLSTATE: 42000
(ER_TABLEACCESS_DENIED_ERROR
)1143
SQLSTATE: 42000
(ER_COLUMNACCESS_DENIED_ERROR
)1144
SQLSTATE: 42000
(ER_ILLEGAL_GRANT_FOR_TABLE
)1145
SQLSTATE: 42000
(ER_GRANT_WRONG_HOST_OR_USER
)1146
SQLSTATE: 42S02
(ER_NO_SUCH_TABLE
)1147
SQLSTATE: 42000
(ER_NONEXISTING_TABLE_GRANT
)1148
SQLSTATE: 42000
(ER_NOT_ALLOWED_COMMAND
)1149
SQLSTATE: 42000
(ER_SYNTAX_ERROR
)1150
SQLSTATE: HY000
(ER_DELAYED_CANT_CHANGE_LOCK
)1151
SQLSTATE: HY000
(ER_TOO_MANY_DELAYED_THREADS
)1152
SQLSTATE: 08S01
(ER_ABORTING_CONNECTION
)1153
SQLSTATE: 08S01
(ER_NET_PACKET_TOO_LARGE
)1154
SQLSTATE: 08S01
(ER_NET_READ_ERROR_FROM_PIPE
)1155
SQLSTATE: 08S01
(ER_NET_FCNTL_ERROR
)1156
SQLSTATE: 08S01
(ER_NET_PACKETS_OUT_OF_ORDER
)1157
SQLSTATE: 08S01
(ER_NET_UNCOMPRESS_ERROR
)1158
SQLSTATE: 08S01
(ER_NET_READ_ERROR
)1159
SQLSTATE: 08S01
(ER_NET_READ_INTERRUPTED
)1160
SQLSTATE: 08S01
(ER_NET_ERROR_ON_WRITE
)1161
SQLSTATE: 08S01
(ER_NET_WRITE_INTERRUPTED
)1162
SQLSTATE: 42000
(ER_TOO_LONG_STRING
)1163
SQLSTATE: 42000
(ER_TABLE_CANT_HANDLE_BLOB
)1164
SQLSTATE: 42000
(ER_TABLE_CANT_HANDLE_AUTO_INCREMENT
)1165
SQLSTATE: HY000
(ER_DELAYED_INSERT_TABLE_LOCKED
)1166
SQLSTATE: 42000
(ER_WRONG_COLUMN_NAME
)1167
SQLSTATE: 42000
(ER_WRONG_KEY_COLUMN
)1168
SQLSTATE: HY000
(ER_WRONG_MRG_TABLE
)1169
SQLSTATE: 23000
(ER_DUP_UNIQUE
)1170
SQLSTATE: 42000
(ER_BLOB_KEY_WITHOUT_LENGTH
)1171
SQLSTATE: 42000
(ER_PRIMARY_CANT_HAVE_NULL
)1172
SQLSTATE: 42000
(ER_TOO_MANY_ROWS
)1173
SQLSTATE: 42000
(ER_REQUIRES_PRIMARY_KEY
)1174
SQLSTATE: HY000
(ER_NO_RAID_COMPILED
)1175
SQLSTATE: HY000
(ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE
)1176
SQLSTATE: HY000
(ER_KEY_DOES_NOT_EXITS
)1177
SQLSTATE: 42000
(ER_CHECK_NO_SUCH_TABLE
)1178
SQLSTATE: 42000
(ER_CHECK_NOT_IMPLEMENTED
)1179
SQLSTATE: 25000
(ER_CANT_DO_THIS_DURING_AN_TRANSACTION
)1180
SQLSTATE: HY000
(ER_ERROR_DURING_COMMIT
)1181
SQLSTATE: HY000
(ER_ERROR_DURING_ROLLBACK
)1182
SQLSTATE: HY000
(ER_ERROR_DURING_FLUSH_LOGS
)1183
SQLSTATE: HY000
(ER_ERROR_DURING_CHECKPOINT
)1184
SQLSTATE: 08S01
(ER_NEW_ABORTING_CONNECTION
)1185
SQLSTATE: HY000
(ER_DUMP_NOT_IMPLEMENTED
)1186
SQLSTATE: HY000
(ER_FLUSH_MASTER_BINLOG_CLOSED
)1187
SQLSTATE: HY000
(ER_INDEX_REBUILD
)1188
SQLSTATE: HY000
(ER_MASTER
)1189
SQLSTATE: 08S01
(ER_MASTER_NET_READ
)1190
SQLSTATE: 08S01
(ER_MASTER_NET_WRITE
)1191
SQLSTATE: HY000
(ER_FT_MATCHING_KEY_NOT_FOUND
)1192
SQLSTATE: HY000
(ER_LOCK_OR_ACTIVE_TRANSACTION
)1193
SQLSTATE: HY000
(ER_UNKNOWN_SYSTEM_VARIABLE
)1194
SQLSTATE: HY000
(ER_CRASHED_ON_USAGE
)1195
SQLSTATE: HY000
(ER_CRASHED_ON_REPAIR
)1196
SQLSTATE: HY000
(ER_WARNING_NOT_COMPLETE_ROLLBACK
)1197
SQLSTATE: HY000
(ER_TRANS_CACHE_FULL
)1198
SQLSTATE: HY000
(ER_SLAVE_MUST_STOP
)1199
SQLSTATE: HY000
(ER_SLAVE_NOT_RUNNING
)1200
SQLSTATE: HY000
(ER_BAD_SLAVE
)1201
SQLSTATE: HY000
(ER_MASTER_INFO
)1202
SQLSTATE: HY000
(ER_SLAVE_THREAD
)1203
SQLSTATE: 42000
(ER_TOO_MANY_USER_CONNECTIONS
)1204
SQLSTATE: HY000
(ER_SET_CONSTANTS_ONLY
)1205
SQLSTATE: HY000
(ER_LOCK_WAIT_TIMEOUT
)1206
SQLSTATE: HY000
(ER_LOCK_TABLE_FULL
)1207
SQLSTATE: 25000
(ER_READ_ONLY_TRANSACTION
)1208
SQLSTATE: HY000
(ER_DROP_DB_WITH_READ_LOCK
)1209
SQLSTATE: HY000
(ER_CREATE_DB_WITH_READ_LOCK
)1210
SQLSTATE: HY000
(ER_WRONG_ARGUMENTS
)1211
SQLSTATE: 42000
(ER_NO_PERMISSION_TO_CREATE_USER
)1212
SQLSTATE: HY000
(ER_UNION_TABLES_IN_DIFFERENT_DIR
)1213
SQLSTATE: 40001
(ER_LOCK_DEADLOCK
)1214
SQLSTATE: HY000
(ER_TABLE_CANT_HANDLE_FT
)1215
SQLSTATE: HY000
(ER_CANNOT_ADD_FOREIGN
)1216
SQLSTATE: 23000
(ER_NO_REFERENCED_ROW
)1217
SQLSTATE: 23000
(ER_ROW_IS_REFERENCED
)1218
SQLSTATE: 08S01
(ER_CONNECT_TO_MASTER
)1219
SQLSTATE: HY000
(ER_QUERY_ON_MASTER
)1220
SQLSTATE: HY000
(ER_ERROR_WHEN_EXECUTING_COMMAND
)1221
SQLSTATE: HY000
(ER_WRONG_USAGE
)1222
SQLSTATE: 21000
(ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT
)1223
SQLSTATE: HY000
(ER_CANT_UPDATE_WITH_READLOCK
)1224
SQLSTATE: HY000
(ER_MIXING_NOT_ALLOWED
)1225
SQLSTATE: HY000
(ER_DUP_ARGUMENT
)1226
SQLSTATE: 42000
(ER_USER_LIMIT_REACHED
)1227
SQLSTATE: 42000
(ER_SPECIFIC_ACCESS_DENIED_ERROR
)1228
SQLSTATE: HY000
(ER_LOCAL_VARIABLE
)1229
SQLSTATE: HY000
(ER_GLOBAL_VARIABLE
)1230
SQLSTATE: 42000
(ER_NO_DEFAULT
)1231
SQLSTATE: 42000
(ER_WRONG_VALUE_FOR_VAR
)1232
SQLSTATE: 42000
(ER_WRONG_TYPE_FOR_VAR
)1233
SQLSTATE: HY000
(ER_VAR_CANT_BE_READ
)1234
SQLSTATE: 42000
(ER_CANT_USE_OPTION_HERE
)1235
SQLSTATE: 42000
(ER_NOT_SUPPORTED_YET
)1236
SQLSTATE: HY000
(ER_MASTER_FATAL_ERROR_READING_BINLOG
)1237
SQLSTATE: HY000
(ER_SLAVE_IGNORED_TABLE
)1238
SQLSTATE: HY000
(ER_INCORRECT_GLOBAL_LOCAL_VAR
)1239
SQLSTATE: 42000
(ER_WRONG_FK_DEF
)1240
SQLSTATE: HY000
(ER_KEY_REF_DO_NOT_MATCH_TABLE_REF
)1241
SQLSTATE: 21000
(ER_OPERAND_COLUMNS
)1242
SQLSTATE: 21000
(ER_SUBQUERY_NO_1_ROW
)1243
SQLSTATE: HY000
(ER_UNKNOWN_STMT_HANDLER
)1244
SQLSTATE: HY000
(ER_CORRUPT_HELP_DB
)1245
SQLSTATE: HY000
(ER_CYCLIC_REFERENCE
)1246
SQLSTATE: HY000
(ER_AUTO_CONVERT
)1247
SQLSTATE: 42S22
(ER_ILLEGAL_REFERENCE
)1248
SQLSTATE: 42000
(ER_DERIVED_MUST_HAVE_ALIAS
)1249
SQLSTATE: 01000
(ER_SELECT_REDUCED
)1250
SQLSTATE: 42000
(ER_TABLENAME_NOT_ALLOWED_HERE
)1251
SQLSTATE: 08004
(ER_NOT_SUPPORTED_AUTH_MODE
)1252
SQLSTATE: 42000
(ER_SPATIAL_CANT_HAVE_NULL
)1253
SQLSTATE: 42000
(ER_COLLATION_CHARSET_MISMATCH
)1254
SQLSTATE: HY000
(ER_SLAVE_WAS_RUNNING
)1255
SQLSTATE: HY000
(ER_SLAVE_WAS_NOT_RUNNING
)1256
SQLSTATE: HY000
(ER_TOO_BIG_FOR_UNCOMPRESS
)1257
SQLSTATE: HY000
(ER_ZLIB_Z_MEM_ERROR
)1258
SQLSTATE: HY000
(ER_ZLIB_Z_BUF_ERROR
)1259
SQLSTATE: HY000
(ER_ZLIB_Z_DATA_ERROR
)1260
SQLSTATE: HY000
(ER_CUT_VALUE_GROUP_CONCAT
)1261
SQLSTATE: 01000
(ER_WARN_TOO_FEW_RECORDS
)1262
SQLSTATE: 01000
(ER_WARN_TOO_MANY_RECORDS
)1263
SQLSTATE: 22004
(ER_WARN_NULL_TO_NOTNULL
)1264
SQLSTATE: 22003
(ER_WARN_DATA_OUT_OF_RANGE
)1265
SQLSTATE: 01000
(WARN_DATA_TRUNCATED
)1266
SQLSTATE: HY000
(ER_WARN_USING_OTHER_HANDLER
)1267
SQLSTATE: HY000
(ER_CANT_AGGREGATE_2COLLATIONS
)1268
SQLSTATE: HY000
(ER_DROP_USER
)1269
SQLSTATE: HY000
(ER_REVOKE_GRANTS
)1270
SQLSTATE: HY000
(ER_CANT_AGGREGATE_3COLLATIONS
)1271
SQLSTATE: HY000
(ER_CANT_AGGREGATE_NCOLLATIONS
)1272
SQLSTATE: HY000
(ER_VARIABLE_IS_NOT_STRUCT
)1273
SQLSTATE: HY000
(ER_UNKNOWN_COLLATION
)1274
SQLSTATE: HY000
(ER_SLAVE_IGNORED_SSL_PARAMS
)1275
SQLSTATE: HY000
(ER_SERVER_IS_IN_SECURE_AUTH_MODE
)1276
SQLSTATE: HY000
(ER_WARN_FIELD_RESOLVED
)1277
SQLSTATE: HY000
(ER_BAD_SLAVE_UNTIL_COND
)1278
SQLSTATE: HY000
(ER_MISSING_SKIP_SLAVE
)1279
SQLSTATE: HY000
(ER_UNTIL_COND_IGNORED
)1280
SQLSTATE: 42000
(ER_WRONG_NAME_FOR_INDEX
)1281
SQLSTATE: 42000
(ER_WRONG_NAME_FOR_CATALOG
)1282
SQLSTATE: HY000
(ER_WARN_QC_RESIZE
)1283
SQLSTATE: HY000
(ER_BAD_FT_COLUMN
)1284
SQLSTATE: HY000
(ER_UNKNOWN_KEY_CACHE
)1285
SQLSTATE: HY000
(ER_WARN_HOSTNAME_WONT_WORK
)1286
SQLSTATE: 42000
(ER_UNKNOWN_STORAGE_ENGINE
)1287
SQLSTATE: HY000
(ER_WARN_DEPRECATED_SYNTAX
)1288
SQLSTATE: HY000
(ER_NON_UPDATABLE_TABLE
)1289
SQLSTATE: HY000
(ER_FEATURE_DISABLED
)1290
SQLSTATE: HY000
(ER_OPTION_PREVENTS_STATEMENT
)1291
SQLSTATE: HY000
(ER_DUPLICATED_VALUE_IN_TYPE
)1292
SQLSTATE: 22007
(ER_TRUNCATED_WRONG_VALUE
)1293
SQLSTATE: HY000
(ER_TOO_MUCH_AUTO_TIMESTAMP_COLS
)1294
SQLSTATE: HY000
(ER_INVALID_ON_UPDATE
)1295
SQLSTATE: HY000
(ER_UNSUPPORTED_PS
)1296
SQLSTATE: HY000
(ER_GET_ERRMSG
)1297
SQLSTATE: HY000
(ER_GET_TEMPORARY_ERRMSG
)1298
SQLSTATE: HY000
(ER_UNKNOWN_TIME_ZONE
)1299
SQLSTATE: HY000
(ER_WARN_INVALID_TIMESTAMP
)1300
SQLSTATE: HY000
(ER_INVALID_CHARACTER_STRING
)1301
SQLSTATE: HY000
(ER_WARN_ALLOWED_PACKET_OVERFLOWED
)1302
SQLSTATE: HY000
(ER_CONFLICTING_DECLARATIONS
)1303
SQLSTATE: 2F003
(ER_SP_NO_RECURSIVE_CREATE
)1304
SQLSTATE: 42000
(ER_SP_ALREADY_EXISTS
)1305
SQLSTATE: 42000
(ER_SP_DOES_NOT_EXIST
)1306
SQLSTATE: HY000
(ER_SP_DROP_FAILED
)1307
SQLSTATE: HY000
(ER_SP_STORE_FAILED
)1308
SQLSTATE: 42000
(ER_SP_LILABEL_MISMATCH
)1309
SQLSTATE: 42000
(ER_SP_LABEL_REDEFINE
)1310
SQLSTATE: 42000
(ER_SP_LABEL_MISMATCH
)1311
SQLSTATE: 01000
(ER_SP_UNINIT_VAR
)1312
SQLSTATE: 0A000
(ER_SP_BADSELECT
)1313
SQLSTATE: 42000
(ER_SP_BADRETURN
)1314
SQLSTATE: 0A000
(ER_SP_BADSTATEMENT
)1315
SQLSTATE: 42000
(ER_UPDATE_LOG_DEPRECATED_IGNORED
)1316
SQLSTATE: 42000
(ER_UPDATE_LOG_DEPRECATED_TRANSLATED
)1317
SQLSTATE: 70100
(ER_QUERY_INTERRUPTED
)1318
SQLSTATE: 42000
(ER_SP_WRONG_NO_OF_ARGS
)1319
SQLSTATE: 42000
(ER_SP_COND_MISMATCH
)1320
SQLSTATE: 42000
(ER_SP_NORETURN
)1321
SQLSTATE: 2F005
(ER_SP_NORETURNEND
)1322
SQLSTATE: 42000
(ER_SP_BAD_CURSOR_QUERY
)1323
SQLSTATE: 42000
(ER_SP_BAD_CURSOR_SELECT
)1324
SQLSTATE: 42000
(ER_SP_CURSOR_MISMATCH
)1325
SQLSTATE: 24000
(ER_SP_CURSOR_ALREADY_OPEN
)1326
SQLSTATE: 24000
(ER_SP_CURSOR_NOT_OPEN
)1327
SQLSTATE: 42000
(ER_SP_UNDECLARED_VAR
)1328
SQLSTATE: HY000
(ER_SP_WRONG_NO_OF_FETCH_ARGS
)1329
SQLSTATE: 02000
(ER_SP_FETCH_NO_DATA
)1330
SQLSTATE: 42000
(ER_SP_DUP_PARAM
)1331
SQLSTATE: 42000
(ER_SP_DUP_VAR
)1332
SQLSTATE: 42000
(ER_SP_DUP_COND
)1333
SQLSTATE: 42000
(ER_SP_DUP_CURS
)1334
SQLSTATE: HY000
(ER_SP_CANT_ALTER
)1335
SQLSTATE: 0A000
(ER_SP_SUBSELECT_NYI
)1336
SQLSTATE: 0A000
(ER_STMT_NOT_ALLOWED_IN_SF_OR_TRG
)1337
SQLSTATE: 42000
(ER_SP_VARCOND_AFTER_CURSHNDLR
)1338
SQLSTATE: 42000
(ER_SP_CURSOR_AFTER_HANDLER
)1339
SQLSTATE: 20000
(ER_SP_CASE_NOT_FOUND
)1340
SQLSTATE: HY000
(ER_FPARSER_TOO_BIG_FILE
)1341
SQLSTATE: HY000
(ER_FPARSER_BAD_HEADER
)1342
SQLSTATE: HY000
(ER_FPARSER_EOF_IN_COMMENT
)1343
SQLSTATE: HY000
(ER_FPARSER_ERROR_IN_PARAMETER
)1344
SQLSTATE: HY000
(ER_FPARSER_EOF_IN_UNKNOWN_PARAMETER
)1345
SQLSTATE: HY000
(ER_VIEW_NO_EXPLAIN
)1346
SQLSTATE: HY000
(ER_FRM_UNKNOWN_TYPE
)1347
SQLSTATE: HY000
(ER_WRONG_OBJECT
)1348
SQLSTATE: HY000
(ER_NONUPDATEABLE_COLUMN
)1349
SQLSTATE: HY000
(ER_VIEW_SELECT_DERIVED
)1350
SQLSTATE: HY000
(ER_VIEW_SELECT_CLAUSE
)1351
SQLSTATE: HY000
(ER_VIEW_SELECT_VARIABLE
)1352
SQLSTATE: HY000
(ER_VIEW_SELECT_TMPTABLE
)1353
SQLSTATE: HY000
(ER_VIEW_WRONG_LIST
)1354
SQLSTATE: HY000
(ER_WARN_VIEW_MERGE
)1355
SQLSTATE: HY000
(ER_WARN_VIEW_WITHOUT_KEY
)1356
SQLSTATE: HY000
(ER_VIEW_INVALID
)1357
SQLSTATE: HY000
(ER_SP_NO_DROP_SP
)1358
SQLSTATE: HY000
(ER_SP_GOTO_IN_HNDLR
)1359
SQLSTATE: HY000
(ER_TRG_ALREADY_EXISTS
)1360
SQLSTATE: HY000
(ER_TRG_DOES_NOT_EXIST
)1361
SQLSTATE: HY000
(ER_TRG_ON_VIEW_OR_TEMP_TABLE
)1362
SQLSTATE: HY000
(ER_TRG_CANT_CHANGE_ROW
)1363
SQLSTATE: HY000
(ER_TRG_NO_SUCH_ROW_IN_TRG
)1364
SQLSTATE: HY000
(ER_NO_DEFAULT_FOR_FIELD
)1365
SQLSTATE: 22012
(ER_DIVISION_BY_ZERO
)1366
SQLSTATE: HY000
(ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
)1367
SQLSTATE: 22007
(ER_ILLEGAL_VALUE_FOR_TYPE
)1368
SQLSTATE: HY000
(ER_VIEW_NONUPD_CHECK
)1369
SQLSTATE: HY000
(ER_VIEW_CHECK_FAILED
)1370
SQLSTATE: 42000
(ER_PROCACCESS_DENIED_ERROR
)1371
SQLSTATE: HY000
(ER_RELAY_LOG_FAIL
)1372
SQLSTATE: HY000
(ER_PASSWD_LENGTH
)1373
SQLSTATE: HY000
(ER_UNKNOWN_TARGET_BINLOG
)1374
SQLSTATE: HY000
(ER_IO_ERR_LOG_INDEX_READ
)1375
SQLSTATE: HY000
(ER_BINLOG_PURGE_PROHIBITED
)1376
SQLSTATE: HY000
(ER_FSEEK_FAIL
)1377
SQLSTATE: HY000
(ER_BINLOG_PURGE_FATAL_ERR
)1378
SQLSTATE: HY000
(ER_LOG_IN_USE
)1379
SQLSTATE: HY000
(ER_LOG_PURGE_UNKNOWN_ERR
)1380
SQLSTATE: HY000
(ER_RELAY_LOG_INIT
)1381
SQLSTATE: HY000
(ER_NO_BINARY_LOGGING
)1382
SQLSTATE: HY000
(ER_RESERVED_SYNTAX
)1383
SQLSTATE: HY000
(ER_WSAS_FAILED
)1384
SQLSTATE: HY000
(ER_DIFF_GROUPS_PROC
)1385
SQLSTATE: HY000
(ER_NO_GROUP_FOR_PROC
)1386
SQLSTATE: HY000
(ER_ORDER_WITH_PROC
)1387
SQLSTATE: HY000
(ER_LOGGING_PROHIBIT_CHANGING_OF
)1388
SQLSTATE: HY000
(ER_NO_FILE_MAPPING
)1389
SQLSTATE: HY000
(ER_WRONG_MAGIC
)1390
SQLSTATE: HY000
(ER_PS_MANY_PARAM
)1391
SQLSTATE: HY000
(ER_KEY_PART_0
)1392
SQLSTATE: HY000
(ER_VIEW_CHECKSUM
)1393
SQLSTATE: HY000
(ER_VIEW_MULTIUPDATE
)1394
SQLSTATE: HY000
(ER_VIEW_NO_INSERT_FIELD_LIST
)1395
SQLSTATE: HY000
(ER_VIEW_DELETE_MERGE_VIEW
)1396
SQLSTATE: HY000
(ER_CANNOT_USER
)1397
SQLSTATE: XAE04
(ER_XAER_NOTA
)1398
SQLSTATE: XAE05
(ER_XAER_INVAL
)1399
SQLSTATE: XAE07
(ER_XAER_RMFAIL
)1400
SQLSTATE: XAE09
(ER_XAER_OUTSIDE
)1401
SQLSTATE: XAE03
(ER_XAER_RMERR
)1402
SQLSTATE: XA100
(ER_XA_RBROLLBACK
)1403
SQLSTATE: 42000
(ER_NONEXISTING_PROC_GRANT
)1404
SQLSTATE: HY000
(ER_PROC_AUTO_GRANT_FAIL
)1405
SQLSTATE: HY000
(ER_PROC_AUTO_REVOKE_FAIL
)1406
SQLSTATE: 22001
(ER_DATA_TOO_LONG
)1407
SQLSTATE: 42000
(ER_SP_BAD_SQLSTATE
)1408
SQLSTATE: HY000
(ER_STARTUP
)1409
SQLSTATE: HY000
(ER_LOAD_FROM_FIXED_SIZE_ROWS_TO_VAR
)1410
SQLSTATE: 42000
(ER_CANT_CREATE_USER_WITH_GRANT
)1411
SQLSTATE: HY000
(ER_WRONG_VALUE_FOR_TYPE
)1412
SQLSTATE: HY000
(ER_TABLE_DEF_CHANGED
)1413
SQLSTATE: 42000
(ER_SP_DUP_HANDLER
)1414
SQLSTATE: 42000
(ER_SP_NOT_VAR_ARG
)1415
SQLSTATE: 0A000
(ER_SP_NO_RETSET
)1416
SQLSTATE: 22003
(ER_CANT_CREATE_GEOMETRY_OBJECT
)1417
SQLSTATE: HY000
(ER_FAILED_ROUTINE_BREAK_BINLOG
)1418
SQLSTATE: HY000
(ER_BINLOG_UNSAFE_ROUTINE
)1419
SQLSTATE: HY000
(ER_BINLOG_CREATE_ROUTINE_NEED_SUPER
)1420
SQLSTATE: HY000
(ER_EXEC_STMT_WITH_OPEN_CURSOR
)1421
SQLSTATE: HY000
(ER_STMT_HAS_NO_OPEN_CURSOR
)1422
SQLSTATE: HY000
(ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG
)1423
SQLSTATE: HY000
(ER_NO_DEFAULT_FOR_VIEW_FIELD
)1424
SQLSTATE: HY000
(ER_SP_NO_RECURSION
)1425
SQLSTATE: 42000
(ER_TOO_BIG_SCALE
)1426
SQLSTATE: 42000
(ER_TOO_BIG_PRECISION
)1427
SQLSTATE: 42000
(ER_M_BIGGER_THAN_D
)1428
SQLSTATE: HY000
(ER_WRONG_LOCK_OF_SYSTEM_TABLE
)1429
SQLSTATE: HY000
(ER_CONNECT_TO_FOREIGN_DATA_SOURCE
)1430
SQLSTATE: HY000
(ER_QUERY_ON_FOREIGN_DATA_SOURCE
)1431
SQLSTATE: HY000
(ER_FOREIGN_DATA_SOURCE_DOESNT_EXIST
)1432
SQLSTATE: HY000
(ER_FOREIGN_DATA_STRING_INVALID_CANT_CREATE
)1433
SQLSTATE: HY000
(ER_FOREIGN_DATA_STRING_INVALID
)1434
SQLSTATE: HY000
(ER_CANT_CREATE_FEDERATED_TABLE
)1435
SQLSTATE: HY000
(ER_TRG_IN_WRONG_SCHEMA
)1436
SQLSTATE: HY000
(ER_STACK_OVERRUN_NEED_MORE
)1437
SQLSTATE: 42000
(ER_TOO_LONG_BODY
)1438
SQLSTATE: HY000
(ER_WARN_CANT_DROP_DEFAULT_KEYCACHE
)1439
SQLSTATE: 42000
(ER_TOO_BIG_DISPLAYWIDTH
)1440
SQLSTATE: XAE08
(ER_XAER_DUPID
)1441
SQLSTATE: 22008
(ER_DATETIME_FUNCTION_OVERFLOW
)1442
SQLSTATE: HY000
(ER_CANT_UPDATE_USED_TABLE_IN_SF_OR_TRG
)1443
SQLSTATE: HY000
(ER_VIEW_PREVENT_UPDATE
)1444
SQLSTATE: HY000
(ER_PS_NO_RECURSION
)1445
SQLSTATE: HY000
(ER_SP_CANT_SET_AUTOCOMMIT
)1446
SQLSTATE: HY000
(ER_MALFORMED_DEFINER
)1447
SQLSTATE: HY000
(ER_VIEW_FRM_NO_USER
)1448
SQLSTATE: HY000
(ER_VIEW_OTHER_USER
)1449
SQLSTATE: HY000
(ER_NO_SUCH_USER
)1450
SQLSTATE: HY000
(ER_FORBID_SCHEMA_CHANGE
)1451
SQLSTATE: 23000
(ER_ROW_IS_REFERENCED_2
)1452
SQLSTATE: 23000
(ER_NO_REFERENCED_ROW_2
)1453
SQLSTATE: 42000
(ER_SP_BAD_VAR_SHADOW
)1454
SQLSTATE: HY000
(ER_TRG_NO_DEFINER
)1455
SQLSTATE: HY000
(ER_OLD_FILE_FORMAT
)1456
SQLSTATE: HY000
(ER_SP_RECURSION_LIMIT
)1457
SQLSTATE: HY000
(ER_SP_PROC_TABLE_CORRUPT
)1458
SQLSTATE: 42000
(ER_SP_WRONG_NAME
)1459
SQLSTATE: HY000
(ER_TABLE_NEEDS_UPGRADE
)1460
SQLSTATE: 42000
(ER_SP_NO_AGGREGATE
)1461
SQLSTATE: 42000
(ER_MAX_PREPARED_STMT_COUNT_REACHED
)1462
SQLSTATE: HY000
(ER_VIEW_RECURSIVE
)1463
SQLSTATE: 42000
(ER_NON_GROUPING_FIELD_USED
)1464
SQLSTATE: HY000
(ER_TABLE_CANT_HANDLE_SPKEYS
)1465
SQLSTATE: HY000
(ER_NO_TRIGGERS_ON_SYSTEM_SCHEMA
)1466
SQLSTATE: HY000
(ER_REMOVED_SPACES
)1467
SQLSTATE: HY000
(ER_AUTOINC_READ_FAILED
)1468
SQLSTATE: HY000
(ER_USERNAME
)1469
SQLSTATE: HY000
(ER_HOSTNAME
)1470
SQLSTATE: HY000
(ER_WRONG_STRING_LENGTH
)1471
SQLSTATE: HY000
(ER_NON_INSERTABLE_TABLE
)1472
SQLSTATE: HY000
(ER_ADMIN_WRONG_MRG_TABLE
)1473
SQLSTATE: HY000
(ER_TOO_HIGH_LEVEL_OF_NESTING_FOR_SELECT
)1474
SQLSTATE: HY000
(ER_NAME_BECOMES_EMPTY
)1475
SQLSTATE: HY000
(ER_AMBIGUOUS_FIELD_TERM
)1476
SQLSTATE: HY000
(ER_LOAD_DATA_INVALID_COLUMN
)1477
SQLSTATE: HY000
(ER_LOG_PURGE_NO_FILE
)1478
SQLSTATE: XA106
(ER_XA_RBTIMEOUT
)1479
SQLSTATE: XA102
(ER_XA_RBDEADLOCK
)
Thursday, March 26, 2009
Server Error Codes and Messages (mySQL)
Posted by
lc marshal
at
5:30 AM
Subscribe to:
Post Comments (Atom)
Search Articles
Study Categories
- 3D (1)
- actionscript (3)
- Activity (5)
- Articles (1)
- Blog (1)
- browser (5)
- CMS (1)
- Computing (1)
- css (1)
- database (6)
- Designer Guidelines (2)
- dreamweaver (4)
- Editor's Pick (1)
- Events (2)
- flash (9)
- Games (1)
- google (2)
- Graphic (4)
- html (2)
- IIS (2)
- javascript (7)
- Joomla (3)
- Lazacode (2)
- menu navigation (2)
- Mobile (1)
- MySQL (5)
- Online Tools (1)
- Open Source Development Kit (11)
- OS (5)
- pdf (1)
- PHP (7)
- PHP. Server (1)
- Powerpoint (1)
- Ruby (1)
- Server (5)
- Software/Tools (8)
- tracker (1)
- video (1)
- Vista (2)
- VMS (1)
- Web Editor (5)
- Web Idea (2)
- Website tricks (2)
- What is? (6)
- Windows (2)
- Wordpress (1)
0 comments:
Post a Comment