Can't create a %s from within another stored routine
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1312
0A000
ER_SP_BADSELECT
PROCEDURE %s can't return a result set in the given context
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1315
42000
ER_UPDATE_LOG_DEPRECATED_IGNORED
The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored. This option will be removed in MariaDB 5.6.
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1316
42000
ER_UPDATE_LOG_DEPRECATED_TRANSLATED
The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been translated to SET SQL_LOG_BIN. This option will be removed in MariaDB 5.6.
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1337
42000
ER_SP_VARCOND_AFTER_CURSHNDLR
Variable or condition declaration after cursor or handler declaration
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1346
HY000
ER_FRM_UNKNOWN_TYPE
File '%s' has unknown type '%s' in its header
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1365
22012
ER_DIVISION_BY_ZER
Division by 0
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1343
HY000
ER_FPARSER_ERROR_IN_PARAMETER
Error while parsing parameter '%s' (line: '%s')
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1344
HY000
ER_FPARSER_EOF_IN_UNKNOWN_PARAMETER
Unexpected end of file while skipping unknown parameter '%s'
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1359
HY000
ER_TRG_ALREADY_EXISTS
Trigger already exists
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1311
01000
ER_SP_UNINIT_VAR
Referring to uninitialized variable %s
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1339
20000
ER_SP_CASE_NOT_FOUND
Case not found for CASE statement
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1364
HY000
ER_NO_DEFAULT_FOR_FIELD
Field '%s' doesn't have a default value
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1334
HY000
ER_SP_CANT_ALTER
Failed to ALTER %s %s
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1336
0A000
ER_STMT_NOT_ALLOWED_IN_SF_OR_TRG
%s is not allowed in stored function or trigger
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1369
HY000
ER_VIEW_CHECK_FAILED
CHECK OPTION failed '%s.%s'
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1362
HY000
ER_TRG_CANT_CHANGE_ROW
Updating of %s row is not allowed in %strigger
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1360
HY000
ER_TRG_DOES_NOT_EXIST
Trigger does not exist
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1355
HY000
ER_WARN_VIEW_WITHOUT_KEY
View being updated does not have complete key of underlying table in it
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1345
HY000
ER_VIEW_NO_EXPLAIN
EXPLAIN/SHOW can not be issued; lacking privileges for underlying table
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1357
HY000
ER_SP_NO_DROP_SP
Can't drop or alter a %s from within another stored routine
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1381
HY000
ER_NO_BINARY_LOGGING
You are not using binary logging
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1375
HY000
ER_BINLOG_PURGE_PROHIBITED
Server configuration does not permit binlog purge
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1388
HY000
ER_NO_FILE_MAPPING
Can't map file: %s, errno: %d
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1373
HY000
ER_UNKNOWN_TARGET_BINLOG
Target log not found in binlog index
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1366
HY000
ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
Incorrect %s value: '%s' for column '%s' at row %ld
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1370
42000
ER_PROCACCESS_DENIED_ERROR
%s command denied to user '%s'@'%s' for routine '%s'
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1367
22007
ER_ILLEGAL_VALUE_FOR_TYPE
Illegal %s '%s' value found during parsing
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1380
HY000
ER_RELAY_LOG_INIT
Failed initializing relay log position: %s
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1368
HY000
ER_VIEW_NONUPD_CHECK
CHECK OPTION on non-updatable view '%s.%s'
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1309
42000
ER_SP_LABEL_REDEFINE
Redefining label %s
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1377
HY000
ER_BINLOG_PURGE_FATAL_ERR
Fatal error during log purge
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1385
HY000
ER_NO_GROUP_FOR_PROC
Select must have a group with this procedure
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1392
HY000
ER_VIEW_CHECKSUM
View text checksum failed
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1379
HY000
ER_LOG_PURGE_UNKNOWN_ERR
Unknown error during log purge
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1389
HY000
ER_WRONG_MAGIC
Wrong magic in %s
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1383
HY000
ER_WSAS_FAILED
WSAStartup Failed
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1384
HY000
ER_DIFF_GROUPS_PROC
Can't handle procedures with different groups yet
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1363
HY000
ER_TRG_NO_SUCH_ROW_IN_TRG
There is no %s row in %s trigger
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1387
HY000
ER_LOGGING_PROHIBIT_CHANGING_OF
Binary logging and replication forbid changing the global server %s
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1391
HY000
ER_KEY_PART_0
Key part '%s' length cannot be 0
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1371
HY000
ER_RELAY_LOG_FAIL
Failed purging old relay logs: %s
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1376
HY000
ER_FSEEK_FAIL
Failed on fseek()
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1393
HY000
ER_VIEW_MULTIUPDATE
Can not modify more than one base table through a join view '%s.%s'
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
1322
42000
ER_SP_BAD_CURSOR_QUERY
Cursor statement must be a SELECT
Possible Causes and Solutions
This article doesn't currently contain any content.
Error 1305: does not exist
Error Code
SQLSTATE
Error
Description
1305
42000
ER_SP_DOES_NOT_EXIST
%s %s does not exist
Possible Causes and Solutions
This error is returned when what is being called does not exist. For example:
There are a number of possible causes:
The or has not yet been created. See or . For example:
There was a typo in the name. Check also that the case is correct. See . For example:
The database specified is not the same as the database containing the stored procedure or function. For example:
Either change the default (current) database with the , or specify the database in the call, for example:
or
One is trying to access a stored procedure instead of a stored function, or vice-versa. For example:
This page is licensed: CC BY-SA / Gnu FDL
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
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
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
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1386: Can't use ORDER clause with this procedure
Error Code
SQLSTATE
Error
Description
1386
HY000
ER_ORDER_WITH_PROC
Can't use ORDER clause with this procedure
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
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
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1361: Trigger's is view or temporary table
Error Code
SQLSTATE
Error
Description
1361
HY000
ER_TRG_ON_VIEW_OR_TEMP_TABLE
Trigger's '%s' is view or temporary table
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1356: View references invalid table(s) or column(s) or function(s) or definer/invoker of view
Error Code
SQLSTATE
Error
Description
1356
HY000
ER_VIEW_INVALID
View '%s.%s' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Possible Causes and Solutions
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
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
This article doesn't currently contain any content.
This page is licensed: CC BY-SA / Gnu FDL
Error 1382: The syntax is reserved for purposes internal to the MariaDB server
Error Code
SQLSTATE
Error
Description
1382
HY000
ER_RESERVED_SYNTAX
The '%s' syntax is reserved for purposes internal to the MariaDB server
Possible Causes and Solutions
This article doesn't currently contain any content.
CALL Reset_animal_count();
ERROR 1305 (42000): PROCEDURE test.Reset_animal_count does not exist
SELECT Reset_animal_count();
ERROR 1305 (42000): FUNCTION test.Reset_animal_count does not exist