The code executed properly, but SQL syntax error returned

Question

Here is the error from error_log in WordPress:

[17-Feb-2018 15:08:13 UTC] WordPress database error 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 'AND timestamp <' at line 1 for query SELECT COUNT(DISTINCT(pid)) FROM wp_ahm_download_stats WHERE uid = 11 AND timestamp > AND timestamp < made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/whycrypto/404.php'), get_header, locate_template, load_template, require_once('/themes/whycrypto/header.php')

And here is the code causing the error:

$downloads = $wpdb->get_var("SELECT COUNT(DISTINCT(pid)) 
                            FROM wp_ahm_download_stats 
                            WHERE uid = $userid 
                            AND timestamp > $start_date 
                                AND timestamp < $end_date");

The code does the work without any problem, but error_log keeps returning this syntax error.

I thought it's about "timestamp" (which could be MySQL function or something), but it's not.

Any help is much appreciated!

Sounds to me that `$start_date` has no value or isn't quoted. What are the values for both `$start_date` and `$end_date`? — Funk Forty Niner, Feb 17 '18 at 15:36
That worked, thank you. I've wrapped the code to be executed only if $start_date & $end_date exist for particular user. — Jure Mraović, Feb 27 '18 at 16:57

The code executed properly, but SQL syntax error returned

0 Answers0