Error map

CASE CASE expression returns mixed types: conversion failed / types cannot be matched

SQL · layer 5, Data

Open the full error page →

Centre: this error. First ring: errors it is linked with (12). Outer ring: what those are linked with. Colours show the layer of a request each error belongs to. Click any dot to re-centre the map on it; hover to follow its connections. The centre dot opens the error page.

CASE — CASE expression returns mixed types: conversion failed / types cannot be matched (SQL)CASEImplicit float to int — Deprecated: Implicit conversion from float 2.5 to int loses precision (PHP)Implicit float to i…Unable to cast object of type — System.InvalidCastException: Unable to cast object of type 'X' to type 'Y' (.NET)Unable to cast obje…TypeError — Fatal error: Uncaught TypeError: foo(): Argument #1 ($x) must be of type int, string given (PHP)TypeErrorArray to string conversion — Warning: Array to string conversion (PHP)Array to string con…245 — SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245) (SQL)245Unsupported operand types — Fatal error: Uncaught TypeError: Unsupported operand types: string + int (PHP)Unsupported operand…ClassCastException — java.lang.ClassCastException: class A cannot be cast to class B (Java)ClassCastExceptionERR_INVALID_ARG_TYPE — TypeError [ERR_INVALID_ARG_TYPE]: The "path" argument must be of type string. Received undefined (Node.js)ERR_INVALID_ARG_TYPETS2345 — TS2345: Argument of type 'string | undefined' is not assignable to parameter of type 'string'. (Node.js)TS2345AttributeError — AttributeError: 'X' object has no attribute 'y' (Python)AttributeError42804 — ERROR: column "x" is of type integer but expression is of type text — HINT: You will need to rewrite or cast the expression. (PostgreSQL)42804Cannot use object as array — Fatal error: Uncaught Error: Cannot use object of type stdClass as array (PHP)Cannot use object a…DEP0005 — DeprecationWarning: Buffer() is deprecated due to security and usability issues (DEP0005) (Node.js)DEP0005Deprecated null to internal — Deprecated: strlen(): Passing null to parameter #1 ($string) of type string is deprecated (PHP)Deprecated null to …Dynamic property deprecated — Deprecated: Creation of dynamic property Foo::$bar is deprecated (PHP)Dynamic property de…IllegalArgumentException — java.lang.IllegalArgumentException (Java)IllegalArgumentExce…IllegalStateException — java.lang.IllegalStateException (Java)IllegalStateExcepti…ArithmeticException — java.lang.ArithmeticException: / by zero (Java)ArithmeticExceptionAllowed memory size exhausted — PHP Fatal error: Allowed memory size of X bytes exhausted (PHP)Allowed memory size…Call to undefined function — PHP Fatal error: Uncaught Error: Call to undefined function (PHP)Call to undefined f…Cannot redeclare — Fatal error: Cannot redeclare function foo() (previously declared in …) (PHP)Cannot redeclareUndefined variable — Warning: Undefined variable $x (PHP)Undefined variableComposer memory — Composer: PHP Fatal error: Allowed memory size of 1610612736 bytes exhausted (PHP)Composer memoryPrimary script unknown — FastCGI sent in stderr: "Primary script unknown" (PHP)Primary script unkn…22P02 — ERROR: invalid input syntax for type integer: "abc" (PostgreSQL)22P0218456 — SQL Server: Login failed for user 'x'. (Error 18456) (SQL)18456208 — SQL Server: Invalid object name 'x'. (Msg 208) (SQL)208Cannot convert value of type — Swift: Cannot convert value of type 'X' to expected argument type 'Y' (iOS)Cannot convert valu…Call to undefined function create_function() — WordPress on PHP 8: Fatal error: Uncaught Error: Call to undefined function create_function() / each() (WordPress)Call to undefined f…E0308 — Rust: error[E0308]: mismatched types — expected `X`, found `Y` (Rust)E0308StringIndexOutOfBoundsException — java.lang.StringIndexOutOfBoundsException: begin 0, end 10, length 5 (Java)StringIndexOutOfBou…UnsupportedOperationException — java.lang.UnsupportedOperationException (List.of / Arrays.asList is immutable) (Java)UnsupportedOperatio…Stream closed — java.io.IOException: Stream closed (Java)Stream closedredirect_uri_mismatch — OAuth Error: redirect_uri_mismatch (Authentication)redirect_uri_mismat…divergent branches — hint: You have divergent branches and need to specify how to reconcile them. (Git)divergent branchesgpg failed to sign — error: gpg failed to sign the data — fatal: failed to write commit object (Git)gpg failed to signERR_UNKNOWN_FILE_EXTENSION — TypeError [ERR_UNKNOWN_FILE_EXTENSION]: Unknown file extension ".ts" (Node.js)ERR_UNKNOWN_FILE_EX…TS2307 — TS2307: Cannot find module 'x' or its corresponding type declarations. (Node.js)TS2307TS7016 — TS7016: Could not find a declaration file for module 'x'. 'x.js' implicitly has an 'any' type. (Node.js)TS7016TypeError: not a function — TypeError: x is not a function (JavaScript)TypeError: not a fu…ImportError — ImportError: cannot import name 'x' from 'y' (Python)ImportErrorKeyError — KeyError: 'x' (Python)KeyError1093 — MySQL ERROR 1093 (HY000): You can't specify target table 'x' for update in FROM clause (MySQL)10931175 — MySQL ERROR 1175 (HY000): You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column (MySQL)11751241 — MySQL ERROR 1241 (21000): Operand should contain 1 column(s) (MySQL)1241Call to member function on null — Fatal error: Uncaught Error: Call to a member function x() on null (PHP)Call to member func…ArgumentCountError — Fatal error: Uncaught ArgumentCountError: Too few arguments to function foo(), 1 passed and exactly 2 expected (PHP)ArgumentCountErrorDivisionByZeroError — Fatal error: Uncaught DivisionByZeroError: Division by zero (PHP)DivisionByZeroError

Directly related (12)

Implicit float to intPHP

Deprecated: Implicit conversion from float 2.5 to int loses precision

PHP 8.1+ warns when a float with a fractional part is silently converted to int (array keys, % operator, int parameters).

Unable to cast object of type.NET

System.InvalidCastException: Unable to cast object of type 'X' to type 'Y'

An explicit cast failed because the object’s runtime type isn’t the target type.

TypeErrorPHP

Fatal error: Uncaught TypeError: foo(): Argument #1 ($x) must be of type int, string given

A function received a value of the wrong type for a typed parameter.

Array to string conversionPHP

Warning: Array to string conversion

An array was used where a string is expected — echoing it, concatenating it, or passing it to a string function.

245SQL

SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245)

SQL Server tried to convert text to a number (often implicitly) and hit a non-numeric value.

Unsupported operand typesPHP

Fatal error: Uncaught TypeError: Unsupported operand types: string + int

An arithmetic or array operator was used with incompatible types (PHP 8 is stricter than PHP 7).

ClassCastExceptionJava

java.lang.ClassCastException: class A cannot be cast to class B

An object was cast to a type it isn’t.

ERR_INVALID_ARG_TYPENode.js

TypeError [ERR_INVALID_ARG_TYPE]: The "path" argument must be of type string. Received undefined

A Node API got an argument of the wrong type — usually undefined because an env var or config value is missing.

TS2345Node.js

TS2345: Argument of type 'string | undefined' is not assignable to parameter of type 'string'.

A value’s type doesn’t match the function parameter — commonly a possibly-undefined value passed where a definite one is required.

AttributeErrorPython

AttributeError: 'X' object has no attribute 'y'

You accessed an attribute or method that doesn’t exist on that object type.

42804PostgreSQL

ERROR: column "x" is of type integer but expression is of type text — HINT: You will need to rewrite or cast the expression.

An INSERT/UPDATE supplies a value of a different type than the column, and PostgreSQL won’t cast implicitly.

Cannot use object as arrayPHP

Fatal error: Uncaught Error: Cannot use object of type stdClass as array

Code used array syntax (`$x['key']`) on an object.

Two steps away (36)

DEP0005Node.js

DeprecationWarning: Buffer() is deprecated due to security and usability issues (DEP0005)

Code (yours or a dependency) uses the deprecated new Buffer() constructor.

Deprecated null to internalPHP

Deprecated: strlen(): Passing null to parameter #1 ($string) of type string is deprecated

PHP 8.1+ warns when null is passed to a built-in function that expects a string/int.

Dynamic property deprecatedPHP

Deprecated: Creation of dynamic property Foo::$bar is deprecated

PHP 8.2+ deprecates creating properties that aren’t declared in the class.

IllegalArgumentExceptionJava

java.lang.IllegalArgumentException

A method rejected an argument value as invalid.

IllegalStateExceptionJava

java.lang.IllegalStateException

A method was called when the object wasn’t in the right state for it.

ArithmeticExceptionJava

java.lang.ArithmeticException: / by zero

Integer division or modulo by zero.

Allowed memory size exhaustedPHP

PHP Fatal error: Allowed memory size of X bytes exhausted

The script tried to use more memory than PHP’s `memory_limit` allows.

Call to undefined functionPHP

PHP Fatal error: Uncaught Error: Call to undefined function

PHP can’t find the function you called — usually a missing extension, missing include, or namespace issue.

Cannot redeclarePHP

Fatal error: Cannot redeclare function foo() (previously declared in …)

The same function (or class) was defined twice — usually a file included more than once.

Undefined variablePHP

Warning: Undefined variable $x

PHP read a variable that was never assigned in the current scope.

Composer memoryPHP

Composer: PHP Fatal error: Allowed memory size of 1610612736 bytes exhausted

Composer ran out of memory while resolving or installing dependencies.

Primary script unknownPHP

FastCGI sent in stderr: "Primary script unknown"

Nginx passed a script path to PHP-FPM that PHP-FPM couldn’t find — usually a wrong SCRIPT_FILENAME or root.

22P02PostgreSQL

ERROR: invalid input syntax for type integer: "abc"

A string couldn’t be converted to the column’s type (integer, numeric, boolean, date…).

18456SQL

SQL Server: Login failed for user 'x'. (Error 18456)

SQL Server rejected the login — wrong password, wrong authentication mode, or a disabled/missing login.

208SQL

SQL Server: Invalid object name 'x'. (Msg 208)

The table/view doesn’t exist in the current database or schema.

Cannot convert value of typeiOS

Swift: Cannot convert value of type 'X' to expected argument type 'Y'

The value’s type doesn’t match what the function or property expects.

Call to undefined function create_function()WordPress

WordPress on PHP 8: Fatal error: Uncaught Error: Call to undefined function create_function() / each()

An old plugin/theme uses functions removed in PHP 8 (create_function, each), so the site breaks after a PHP upgrade.

E0308Rust

Rust: error[E0308]: mismatched types — expected `X`, found `Y`

A value’s type doesn’t match what the context expects — common with &str vs String, Option/Result vs plain values, and integer ty…

StringIndexOutOfBoundsExceptionJava

java.lang.StringIndexOutOfBoundsException: begin 0, end 10, length 5

substring()/charAt() used an index outside the string.

UnsupportedOperationExceptionJava

java.lang.UnsupportedOperationException (List.of / Arrays.asList is immutable)

Code tried to modify an immutable or fixed-size collection.

Stream closedJava

java.io.IOException: Stream closed

Code read or wrote a stream after it was closed — often by a try-with-resources block or a wrapper closing the underlying stream.

redirect_uri_mismatchAuthentication

OAuth Error: redirect_uri_mismatch

The redirect URI in your OAuth request doesn’t exactly match one registered for the client in the provider’s console.

divergent branchesGit

hint: You have divergent branches and need to specify how to reconcile them.

Git 2.27+ asks you to choose merge, rebase or fast-forward-only when local and remote both have new commits.

gpg failed to signGit

error: gpg failed to sign the data — fatal: failed to write commit object

Commit signing is enabled but GPG couldn’t sign — no TTY for the passphrase, wrong key, or agent not running.

ERR_UNKNOWN_FILE_EXTENSIONNode.js

TypeError [ERR_UNKNOWN_FILE_EXTENSION]: Unknown file extension ".ts"

Node tried to run a TypeScript file as ESM without a TypeScript loader.

TS2307Node.js

TS2307: Cannot find module 'x' or its corresponding type declarations.

TypeScript can’t resolve the import — the package isn’t installed, the path alias isn’t configured, or there are no types.

TS7016Node.js

TS7016: Could not find a declaration file for module 'x'. 'x.js' implicitly has an 'any' type.

The JavaScript package has no TypeScript types bundled and no @types package installed.

TypeError: not a functionJavaScript

TypeError: x is not a function

You called something as a function, but its value is not a function (it’s undefined, a string, an object…).

ImportErrorPython

ImportError: cannot import name 'x' from 'y'

The module was found, but the name you’re importing from it doesn’t exist — usually a version change or a circular import.

KeyErrorPython

KeyError: 'x'

You accessed a dictionary key that doesn’t exist.

1093MySQL

MySQL ERROR 1093 (HY000): You can't specify target table 'x' for update in FROM clause

An UPDATE/DELETE uses a subquery that reads from the same table, which MySQL doesn’t allow directly.

1175MySQL

MySQL ERROR 1175 (HY000): You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

MySQL Workbench’s safe updates mode blocked an UPDATE/DELETE without a key-based WHERE.

1241MySQL

MySQL ERROR 1241 (21000): Operand should contain 1 column(s)

A subquery or expression returned several columns where only one is expected.

Call to member function on nullPHP

Fatal error: Uncaught Error: Call to a member function x() on null

Code called a method on a variable that is null instead of an object.

ArgumentCountErrorPHP

Fatal error: Uncaught ArgumentCountError: Too few arguments to function foo(), 1 passed and exactly 2 expected

A function was called with fewer arguments than it requires.

DivisionByZeroErrorPHP

Fatal error: Uncaught DivisionByZeroError: Division by zero

Code divided by zero (or used modulo by zero) — PHP 8 throws instead of warning.