Error 1140: Mixing of GROUP columns with no GROUP columns

Error Code	SQLSTATE	Error	Description
1140	42000	ER_MIX_OF_GROUP_FUNC_AND_FIELDS	Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Possible Causes and Solutions

Possible Causes and Solutions

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

Comments

Comments loading...

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 1100 to 1199 ↑
Error 1100: Table was not locked with LOCK TABLES
Error 1101: You should never see it
Error 1102: Incorrect database name
Error 1103: Incorrect table name
Error 1104: The SELECT would examine more than MAX_JOIN_SIZE rows
Error 1105: Unknown error
Error 1106: Unknown procedure
Error 1107: Incorrect parameter count to procedure
Error 1108: Incorrect parameters to procedure
Error 1109: Unknown table
Error 1110: Column specified twice
Error 1111: Invalid use of group function
Error 1112: Table uses an extension that doesn't exist in this MariaDB version
Error 1113: A table must have at least 1 column
Error 1114: The table is full
Error 1115: Unknown character set
Error 1116: Too many tables; MariaDB can only use tables in a join
Error 1117: Too many columns
Error 1118: Row size too large
Error 1119: Thread stack overrun
Error 1120: Cross dependency found in OUTER JOIN; examine your ON conditions
Error 1121: Table handler doesn't support NULL in given index
Error 1122: Can't load function
Error 1123: Can't initialize function
Error 1124: No paths allowed for shared library
Error 1125: Function already exists
Error 1126: Can't open shared library
Error 1127: Can't find symbol in library
Error 1128: Function is not defined
Error 1129: Host is blocked because of many connection errors
Error 1130: Host is not allowed to connect to this MariaDB server
Error 1131: You are using MariaDB as an anonymous user
Error 1132: You must have privileges to update tables in the mysql database
Error 1133: Can't find any matching row in the user table
Error 1134: Rows matched Changed Warnings
Error 1135: Can't create a new thread
Error 1136: Column count doesn't match value count at row
Error 1137: Can't reopen table
Error 1138: Invalid use of NULL value
Error 1139: Got error from regexp
Error 1140: Mixing of GROUP columns with no GROUP columns
Error 1141: There is no such grant defined for user on host
Error 1142: command denied to user for table
Error 1143: command denied to user for column in table
Error 1144: Illegal GRANT/REVOKE command
Error 1145: The host or user argument to GRANT is too long
Error 1146: Table doesn't exist
Error 1147: There is no such grant defined for user on host on table
Error 1148: The used command is not allowed with this MariaDB version
Error 1149: You have an error in your SQL syntax
Error 1150: Delayed insert thread couldn't get requested lock for table
Error 1151: Too many delayed threads in use
Error 1152: Aborted connection to db user
Error 1153: Got a packet bigger than 'max_allowed_packet' bytes
Error 1154: Got a read error from the connection pipe
Error 1155: Got an error from fcntl()
Error 1156: Got packets out of order
Error 1157: Couldn't uncompress communication packet
Error 1158: Got an error reading communication packets
Error 1159: Got timeout reading communication packets
Error 1160: Got an error writing communication packets
Error 1161: Got timeout writing communication packets
Error 1162: Result string is longer than 'max_allowed_packet' bytes
Error 1163: The used table type doesn't support BLOB/TEXT columns
Error 1164: The used table type doesn't support AUTO_INCREMENT columns
Error 1165: INSERT DELAYED can't be used with table because it is locked
Error 1166: Incorrect column name
Error 1167: The used storage engine can't index column
Error 1168: Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist
Error 1169: Can't write, because of unique constraint, to table
Error 1170: BLOB/TEXT column used in key specification without a key length
Error 1171: All parts of a PRIMARY KEY must be NOT NULL
Error 1172: Result consisted of more than one row
Error 1173: This table type requires a primary key
Error 1174: This version of MariaDB is not compiled with RAID support
Error 1175: You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
Error 1176: Key doesn't exist in table
Error 1177: Can't open table
Error 1178: The storage engine for the table doesn't support
Error 1179: You are not allowed to execute this command in a transaction
Error 1180: Got error during COMMIT
Error 1181: Got error during ROLLBACK
Error 1182: Got error during FLUSH_LOGS
Error 1183: Got error during CHECKPOINT
Error 1184: Aborted connection to db user host
Error 1185: You should never see it
Error 1186: Binlog closed, cannot RESET MASTER
Error 1187: Failed rebuilding the index of dumped table
Error 1188: Error from master
Error 1189: Net error reading from master
Error 1190: Net error writing to master
Error 1191: Can't find FULLTEXT index matching the column list
Error 1192: Can't execute the given command because you have active locked tables or an active transaction
Error 1193: Unknown system variable
Error 1194: Table is marked as crashed and should be repaired
Error 1195: Table is marked as crashed and last (automatic?) repair failed
Error 1196: Some non-transactional changed tables couldn't be rolled back
Error 1197: Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage
Error 1198: This operation cannot be performed with a running slave; run STOP SLAVE first
Error 1199: This operation requires a running slave; configure slave and do START SLAVE

Error 1140: Mixing of GROUP columns with no GROUP columns

Contents

Possible Causes and Solutions

Comments

Products

Services

Pricing

Resources

About Us

Download MariaDB