Passing empty array to `run_query()` throws an error #20

New issue

Closed

opened 2023-11-02 17:01:48 +01:00 by vlw · 0 comments

vlw commented

2023-11-02 17:01:48 +01:00

(Migrated from codeberg.org)

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') LIMIT 1' at line 1

This is caused by run_query() only checking if the value for $param is null, not if it's empty.

"SELECT NULL FROM <table> WHERE () LIMIT 1"

``` You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') LIMIT 1' at line 1 ``` This is caused by `run_query()` only checking if the value for $param is `null`, not if it's empty. ``` "SELECT NULL FROM <table> WHERE () LIMIT 1" ```