There has been a critical error processing your request

SQL Error: Unknown column 'ps.price_prefix' in 'field list'
Error No: 1054
SQL: SELECT CASE WHEN ps.price_prefix='%' THEN p.price - (ps.price * (p.price/100))
ELSE ps.price END AS special_price
FROM product_specials ps
LEFT JOIN products p
ON p.product_id = ps.product_id
WHERE ps.product_id = '432'
AND ps.customer_group_id = '1'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, special_price ASC
LIMIT 1
PHP call stack:
#0 /home/r5m4177mpmp9/public_html/realhydraulics/core/lib/db.php:102
#1 /home/r5m4177mpmp9/public_html/realhydraulics/core/engine/extensions.php:1156
#2 /home/r5m4177mpmp9/public_html/realhydraulics/core/engine/extensions.php:383
#3 /home/r5m4177mpmp9/public_html/realhydraulics/core/lib/db.php:68
#4 /home/r5m4177mpmp9/public_html/realhydraulics/core/engine/promotion.php:274
#5 /home/r5m4177mpmp9/public_html/realhydraulics/storefront/controller/pages/product/product.php:270
#6 /home/r5m4177mpmp9/public_html/realhydraulics/core/engine/dispatcher.php:306
#7 /home/r5m4177mpmp9/public_html/realhydraulics/core/engine/dispatcher.php:341
#8 /home/r5m4177mpmp9/public_html/realhydraulics/core/engine/page.php:108
#9 /home/r5m4177mpmp9/public_html/realhydraulics/core/engine/router.php:205
#10 /home/r5m4177mpmp9/public_html/realhydraulics/core/engine/router.php:86
#11 /home/r5m4177mpmp9/public_html/realhydraulics/index.php:100
in /home/r5m4177mpmp9/public_html/realhydraulics/core/database/amysqli.php on line 135