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