1 of 100

MariaDB Error Codes 1300 to 1399

Error 1300: Invalid character string

Error Code

SQLSTATE

Error

Description

1300

HY000

ER_INVALID_CHARACTER_STRING

Invalid %s character string: '%s'

Possible Causes and Solutions

Error 1302: Conflicting declarations

Error Code

SQLSTATE

Error

Description

Error 1303: Can't create from within another stored routine

Error Code

SQLSTATE

Error

Description

Error 1304: already exists

Error Code

SQLSTATE

Error

Description

1304

42000

ER_SP_ALREADY_EXISTS

%s %s already exists

Possible Causes and Solutions

Error 1306: Failed to DROP

Error Code

SQLSTATE

Error

Description

1306

HY000

ER_SP_DROP_FAILED

Failed to DROP %s %s

Possible Causes and Solutions

Error 1307: Failed to CREATE

Error Code

SQLSTATE

Error

Description

1307

HY000

ER_SP_STORE_FAILED

Failed to CREATE %s %s

Possible Causes and Solutions

Error 1308: with no matching label

Error Code

SQLSTATE

Error

Description

1308

42000

ER_SP_LILABEL_MISMATCH

%s with no matching label: %s

Possible Causes and Solutions

Error 1309: Redefining label

Error Code

SQLSTATE

Error

Description

1309

42000

ER_SP_LABEL_REDEFINE

Redefining label %s

Possible Causes and Solutions

Error 1310: End-label without match

Error Code

SQLSTATE

Error

Description

1310

42000

ER_SP_LABEL_MISMATCH

End-label %s without match

Possible Causes and Solutions

Error 1311: Referring to uninitialized variable

Error Code

SQLSTATE

Error

Description

Error 1312: PROCEDURE can't return a result set in the given context

Error Code

SQLSTATE

Error

Description

1312

0A000

ER_SP_BADSELECT

PROCEDURE %s can't return a result set in the given context

Possible Causes and Solutions

Error 1313: RETURN is only allowed in a FUNCTION

Error Code

SQLSTATE

Error

Description

Error 1314: is not allowed in stored procedures

Error Code

SQLSTATE

Error

Description

1314

0A000

ER_SP_BADSTATEMENT

%s is not allowed in stored procedures

Possible Causes and Solutions

Error 1315: The update log is deprecated and replaced by the binary log

Error Code

SQLSTATE

Error

Description

Error 1316: The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been

Error Code

SQLSTATE

Error

Description

Error 1317: Query execution was interrupted

Error Code

SQLSTATE

Error

Description

Error 1318: Incorrect number of arguments; expected, got

Error Code

SQLSTATE

Error

Description

1318

42000

ER_SP_WRONG_NO_OF_ARGS

Incorrect number of arguments for %s %s; expected %u, got %u

Possible Causes and Solutions

Error 1319: Undefined CONDITION

Error Code

SQLSTATE

Error

Description

Error 1321: FUNCTION ended without RETURN

Error Code

SQLSTATE

Error

Description

1321

2F005

ER_SP_NORETURNEND

FUNCTION %s ended without RETURN

Possible Causes and Solutions

Error 1322: Cursor statement must be a SELECT

Error Code

SQLSTATE

Error

Description

1322

42000

ER_SP_BAD_CURSOR_QUERY

Cursor statement must be a SELECT

Possible Causes and Solutions

Error 1323: Cursor SELECT must not have INTO

Error Code

SQLSTATE

Error

Description

Error 1324: Undefined CURSOR

Error Code

SQLSTATE

Error

Description

1324

42000

ER_SP_CURSOR_MISMATCH

Undefined CURSOR: %s

Possible Causes and Solutions

Error 1325: Cursor is already open

Error Code

SQLSTATE

Error

Description

1325

24000

ER_SP_CURSOR_ALREADY_OPEN

Cursor is already open

Possible Causes and Solutions

Error 1326: Cursor is not open

Error Code

SQLSTATE

Error

Description

1326

24000

ER_SP_CURSOR_NOT_OPEN

Cursor is not open

Possible Causes and Solutions

Error 1327: Undeclared variable

Error Code

SQLSTATE

Error

Description

1327

42000

ER_SP_UNDECLARED_VAR

Undeclared variable: %s

Possible Causes and Solutions

Error 1328: Incorrect number of FETCH variables

Error Code

SQLSTATE

Error

Description

Error 1329: No data - zero rows fetched, selected, or processed

Error Code

SQLSTATE

Error

Description

1329

02000

ER_SP_FETCH_NO_DATA

No data - zero rows fetched, selected, or processed

Possible Causes and Solutions

Error 1330: Duplicate parameter

Error Code

SQLSTATE

Error

Description

1330

42000

ER_SP_DUP_PARAM

Duplicate parameter: %s

Possible Causes and Solutions

Error 1331: Duplicate variable

Error Code

SQLSTATE

Error

Description

Error 1332: Duplicate condition

Error Code

SQLSTATE

Error

Description

1332

42000

ER_SP_DUP_COND

Duplicate condition: %s

Possible Causes and Solutions

Error 1333: Duplicate cursor

Error Code

SQLSTATE

Error

Description

1333

42000

ER_SP_DUP_CURS

Duplicate cursor: %s

Possible Causes and Solutions

Error 1334: Failed to ALTER

Error Code

SQLSTATE

Error

Description

Error 1335: Subquery value not supported

Error Code

SQLSTATE

Error

Description

Error 1336: is not allowed in stored function or trigger

Error Code

SQLSTATE

Error

Description

Error 1337: Variable or condition declaration after cursor or handler declaration

Error Code

SQLSTATE

Error

Description

Error 1338: Cursor declaration after handler declaration

Error Code

SQLSTATE

Error

Description

Error 1339: Case not found for CASE statement

Error Code

SQLSTATE

Error

Description

1339

20000

ER_SP_CASE_NOT_FOUND

Case not found for CASE statement

Possible Causes and Solutions

Error 1340: Configuration file is too big

Error Code

SQLSTATE

Error

Description

1340

HY000

ER_FPARSER_TOO_BIG_FILE

Configuration file '%s' is too big

Possible Causes and Solutions

Error 1341: Malformed file type header in file

Error Code

SQLSTATE

Error

Description

Error 1342: Unexpected end of file while parsing comment

Error Code

SQLSTATE

Error

Description

1342

HY000

ER_FPARSER_EOF_IN_COMMENT

Unexpected end of file while parsing comment '%s'

Possible Causes and Solutions

Error 1343: Error while parsing parameter

Error Code

SQLSTATE

Error

Description

1343

HY000

ER_FPARSER_ERROR_IN_PARAMETER

Error while parsing parameter '%s' (line: '%s')

Possible Causes and Solutions

Error 1345: EXPLAIN/SHOW can not be issued; lacking privileges for underlying table

Error Code

SQLSTATE

Error

Description

1345

HY000

ER_VIEW_NO_EXPLAIN

EXPLAIN/SHOW can not be issued; lacking privileges for underlying table

Possible Causes and Solutions

Error 1346: File has unknown type in its header

Error Code

SQLSTATE

Error

Description

1346

HY000

ER_FRM_UNKNOWN_TYPE

File '%s' has unknown type '%s' in its header

Possible Causes and Solutions

Error 1347: '%s.%s' is not %s

Error Code

SQLSTATE

Error

Description

1347

HY000

ER_WRONG_OBJECT

'%s.%s' is not %s

Possible Causes and Solutions

Error 1349: View's SELECT contains a subquery in the FROM clause

Error Code

SQLSTATE

Error

Description

1349

HY000

ER_VIEW_SELECT_DERIVED

View's SELECT contains a subquery in the FROM clause

Possible Causes and Solutions

Error 1350: View's SELECT contains clause

Error Code

SQLSTATE

Error

Description

1350

HY000

ER_VIEW_SELECT_CLAUSE

View's SELECT contains a '%s' clause

Possible Causes and Solutions

Error 1351: View's SELECT contains a variable or parameter

Error Code

SQLSTATE

Error

Description

1351

HY000

ER_VIEW_SELECT_VARIABLE

View's SELECT contains a variable or parameter

Possible Causes and Solutions

Error 1352: View's SELECT refers to a temporary table'

Error Code

SQLSTATE

Error

Description

Error 1353: View's SELECT and view's field list have different column counts

Error Code

SQLSTATE

Error

Description

Error 1354: View merge algorithm can't be used here for now

Error Code

SQLSTATE

Error

Description

Error 1355: View being updated does not have complete key of underlying table in it

Error Code

SQLSTATE

Error

Description

1355

HY000

ER_WARN_VIEW_WITHOUT_KEY

View being updated does not have complete key of underlying table in it

Possible Causes and Solutions

Error 1356: View references invalid table(s) or column(s) or function(s) or definer/invoker of view

Error Code

SQLSTATE

Error

Description

Error 1357: Can't drop or alter from within another stored routine

Error Code

SQLSTATE

Error

Description

Error 1358: GOTO is not allowed in a stored procedure handler

Error Code

SQLSTATE

Error

Description

1358

HY000

ER_SP_GOTO_IN_HNDLR

GOTO is not allowed in a stored procedure handler

Possible Causes and Solutions

Error 1359: Trigger already exists

Error Code

SQLSTATE

Error

Description

Error 1360: Trigger does not exist

Error Code

SQLSTATE

Error

Description

1360

HY000

ER_TRG_DOES_NOT_EXIST

Trigger does not exist

Possible Causes and Solutions

Error 1362: Updating of row is not allowed in trigger

Error Code

SQLSTATE

Error

Description

Error 1363: There is no row in trigger

Error Code

SQLSTATE

Error

Description

Error 1364: Field doesn't have a default value

Error Code

SQLSTATE

Error

Description

Error 1365: Division by 0

Error Code

SQLSTATE

Error

Description

1365

22012

ER_DIVISION_BY_ZER

Division by 0

Possible Causes and Solutions

Error 1367: Illegal value found during parsing

Error Code

SQLSTATE

Error

Description

1367

22007

ER_ILLEGAL_VALUE_FOR_TYPE

Illegal %s '%s' value found during parsing

Possible Causes and Solutions

Error 1368: CHECK OPTION on non-updatable view

Error Code

SQLSTATE

Error

Description

Error 1370: command denied to user for routine

Error Code

SQLSTATE

Error

Description

Error 1371: Failed purging old relay logs

Error Code

SQLSTATE

Error

Description

Error 1372: Password hash should be a %d-digit hexadecimal number

Error Code

SQLSTATE

Error

Description

1372

HY000

ER_PASSWD_LENGTH

Password hash should be a %d-digit hexadecimal number

Possible Causes and Solutions

Error 1373: Target log not found in binlog index

Error Code

SQLSTATE

Error

Description

1373

HY000

ER_UNKNOWN_TARGET_BINLOG

Target log not found in binlog index

Possible Causes and Solutions

Error 1374: I/O error reading log index file

Error Code

SQLSTATE

Error

Description

1374

HY000

ER_IO_ERR_LOG_INDEX_READ

I/O error reading log index file

Possible Causes and Solutions

Error 1376: Failed on fseek()

Error Code

SQLSTATE

Error

Description

1376

HY000

ER_FSEEK_FAIL

Failed on fseek()

Possible Causes and Solutions

Error 1377: Fatal error during log purge

Error Code

SQLSTATE

Error

Description

Error 1378: A purgeable log is in use, will not purge

Error Code

SQLSTATE

Error

Description

1378

HY000

ER_LOG_IN_USE

A purgeable log is in use, will not purge

Possible Causes and Solutions

Error 1379: Unknown error during log purge

Error Code

SQLSTATE

Error

Description

Error 1380: Failed initializing relay log position

Error Code

SQLSTATE

Error

Description

Error 1381: You are not using binary logging

Error Code

SQLSTATE

Error

Description

Error 1383: WSAStartup Failed

Error Code

SQLSTATE

Error

Description

Error 1384: Can't handle procedures with different groups yet

Error Code

SQLSTATE

Error

Description

1384

HY000

ER_DIFF_GROUPS_PROC

Can't handle procedures with different groups yet

Possible Causes and Solutions

Error 1386: Can't use ORDER clause with this procedure

Error Code

SQLSTATE

Error

Description

Error 1387: Binary logging and replication forbid changing the global server

Error Code

SQLSTATE

Error

Description

Error 1390: Prepared statement contains too many placeholders

Error Code

SQLSTATE

Error

Description

1390

HY000

ER_PS_MANY_PARAM

Prepared statement contains too many placeholders

Possible Causes and Solutions

Error 1391: Key part length cannot be 0

Error Code

SQLSTATE

Error

Description

Error 1393: Can not modify more than one base table through a join view

Error Code

SQLSTATE

Error

Description

Error 1395: Can not delete from join view

Error Code

SQLSTATE

Error

Description

Error 1396: Operation failed for

Error Code

SQLSTATE

Error

Description

Error 1397: XAER_NOTA: Unknown XID

Error Code

SQLSTATE

Error

Description