This is a read-only copy of the MariaDB Knowledgebase generated on 2024-12-22. For the latest, interactive version please visit https://mariadb.com/kb/.

Created: 10 months, 4 weeks ago
Modified: 10 months, 4 weeks ago
Type: article
Status: active
License: CC BY-SA / Gnu FDL

Attachments

No attachments exist

Error 1067: Invalid default value for

Error Code	SQLSTATE	Error	Description
1067	42000	ER_INVALID_DEFAULT	Invalid default value for '%s'

Possible Causes and Solutions

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

↑ MariaDB Error Codes 1000 to 1099 ↑
Error 1000: hashchk
Error 1001: isamchk
Error 1002: NO
Error 1003: YES
Error 1004: Can't create file
Error 1005: Can't create table
Error 1006: Can't create database
Error 1007: Can't create database, database exists
Error 1008: Can't drop database; database doesn't exist
Error 1009: Error dropping database (can't delete)
Error 1010: Error dropping database (can't rmdir)
Error 1011: Error on delete of
Error 1012: Can't read record in system table
Error 1013: Can't get status of
Error 1014: Can't get working directory
Error 1015: Can't lock file
Error 1016: Can't open file
Error 1017: Can't find file
Error 1018: Can't read dir of
Error 1019: Can't change dir to
Error 1020: Record has changed since last read in table
Error 1021: Disk full (%s); waiting for someone to free some space
Error 1022: Can't write; duplicate key in table
Error 1023: Error on close of
Error 1024: Error reading file
Error 1025: Error on rename of
Error 1026: Error writing file
Error 1027: is locked against change
Error 1028: Sort aborted
Error 1029: View doesn't exist for
Error 1030: Got error from storage engine
Error 1031: Table storage engine doesn't have this option
Error 1032: Can't find record in
Error 1033: Incorrect information in file
Error 1034: Incorrect key file for table; try to repair it
Error 1035: Old key file for table; repair it!
Error 1036: Table is read only
Error 1037: Out of memory; restart server and try again
Error 1038: Out of sort memory, consider increasing server sort buffer size
Error 1039: Unexpected EOF found when reading file
Error 1040: Too many connections
Error 1041: Out of memory
Error 1042: Can't get hostname for your address
Error 1043: Bad handshake
Error 1044: Access denied for user
Error 1045: Access denied for user (using password)
Error 1046: No database selected
Error 1047: Unknown command
Error 1048: Column cannot be null
Error 1049: Unknown database
Error 1050: Table already exists
Error 1051: Unknown table
Error 1052: Column is ambiguous
Error 1053: Server shutdown in progress
Error 1054: Unknown column
Error 1055: isn't in GROUP BY
Error 1056: Can't group on
Error 1057: Statement has sum functions and columns in same statement
Error 1058: Column count doesn't match value count
Error 1059: Identifier name is too long
Error 1060: Duplicate column name
Error 1061: Duplicate key name
Error 1062: Duplicate entry for key
Error 1063: Incorrect column specifier for column
Error 1064: near at line
Error 1065: Query was empty
Error 1066: Not unique table/alias
Error 1067: Invalid default value for
Error 1068: Multiple primary key defined
Error 1069: Too many keys specified; max keys allowed
Error 1070: Too many key parts specified; max parts allowed
Error 1071: Specified key was too long; max key length is
Error 1072: Key column doesn't exist in table
Error 1073: BLOB column can't be used in key specification with the used table type
Error 1074: Column length too big for column; use BLOB or TEXT instead
Error 1075: Incorrect table definition; there can be only one auto column and it must be defined as a key
Error 1076: ready for connections
Error 1077: Normal shutdown
Error 1078: Got signal. Aborting!
Error 1079: Shutdown complete
Error 1080: Forcing close of thread
Error 1081: Can't create IP socket
Error 1082: Table has no index like the one used in CREATE INDEX; recreate the table
Error 1083: Field separator argument is not what is expected; check the manual
Error 1084: You can't use fixed rowlength with BLOBs; please use 'fields terminated by'
Error 1085: The file must be in the database directory or be readable by all
Error 1086: File already exists
Error 1087: Records Deleted Skipped Warnings
Error 1088: Records Duplicates
Error 1089: Incorrect prefix 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 prefix keys
Error 1090: You can't delete all columns with ALTER TABLE; use DROP TABLE instead
Error 1091: Can't DROP; check that column/key exists
Error 1092: Records Duplicates Warnings
Error 1093: You can't specify target table for update in FROM clause
Error 1094: Unknown thread id
Error 1095: You are not owner of thread
Error 1096: No tables used
Error 1097: Too many strings for column and SET
Error 1098: Can't generate a unique log-filename
Error 1099: Table was locked with a READ lock and can't be updated

Error 1067: Invalid default value for

Contents

Possible Causes and Solutions

Products

Services

Pricing

Resources

About Us

Download MariaDB