MySQL Error!
MySQL error in file: \engine\modules\search.php at line 775
Error Number: 1054
The Error returned was:
Unknown column 'p.date' in 'where clause'
SQL query:
SELECT * FROM dle_post WHERE dle_post.approve = 1 AND p.date < '2026-02-16 08:20:32' AND ( title LIKE '%%' OR xfields LIKE '%new|%' OR xfields LIKE '%year|%' ) ORDER BY date DESC LIMIT 5$sql_request = "$sql_find AND (
title LIKE '%{$query}%'
OR xfields LIKE '%genre|{$query}%'
OR xfields LIKE '%year|{$query}%'
) ORDER BY $order_by LIMIT $search_start,{$config['search_number']}";
$db->query("
SELECT * FROM " . PREFIX . "_post
WHERE " . PREFIX . "_post.approve = 1
{$this_date}
AND (
title LIKE '%{$query}%'
OR xfields LIKE '%new|{$query}%'
OR xfields LIKE '%year|{$query}%'
)
ORDER BY date DESC
LIMIT 5
");
