Error:

The mysql database returned an error while processing your request.

The SQL statement was: SELECT CONCAT('

') FROM promotions WHERE NOW() BETWEEN start AND end AND pagename LIKE '%',pagename,'%';

The database returned this: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'pagename,'%'' at line 1

Other info:

$user_data{promotion_products.qty}=!!
$user_data{_cgifunction}=search
$user_data{promotion_products.promo}=',pagename,'
$user_data{promotion_products.end_date}=>NOW()
$user_data{promotion_products.date}= $user_data{_layout}=PROMOTIONS