|
|
Whether you've got 15 minutes or a couple of hours, we have a recipe worth your valuable time!
Error: User Error
An Error Has Occurred
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 ')) AND r.visible IN ('live') AND submitted_name = '')
GROUP BY r.id ORDER' at line 3: SELECT DISTINCT r.*, IF(r.image_small is not null and r.image_small != '',1,0) has_image , IFNULL(AVG(rcom.rating_stars), 0) as rating
FROM recipe r LEFT JOIN recipe_comment rcom ON (rcom.recipe_id = r.id AND rcom.approved='t')
WHERE (prep_time > 0 AND prep_time is not null AND (()) AND r.visible IN ('live') AND submitted_name = '')
GROUP BY r.id ORDER BY rating DESC
in file: /var/www/sites/www.perdue.com/htdocs/cms/include/Common/DB.php line 304
| DB.php:304 | - | trigger_error("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 \')) AND r.visible IN (\'live\') AND submitted_name = \'\')
GROUP BY r.id ORDER\' at line 3: <span class=\"query\">SELECT DISTINCT r.*, IF(r.image_small is not null and r.image_small != \'\',1,0) has_image , IFNULL(AVG(rcom.rating_stars), 0) as rating
FROM recipe r LEFT JOIN recipe_comment rcom ON (rcom.recipe_id = r.id AND rcom.approved=\'t\')
WHERE (prep_time > 0 AND prep_time is not null AND (()) AND r.visible IN (\'live\') AND submitted_name = \'\')
GROUP BY r.id ORDER BY rating DESC</span>", 256) | | DB.php:330 | - | db->mysqlsafequery("SELECT DISTINCT r.*, IF(r.image_small is not null and r.image_small != \'\',1,0) has_image , IFNULL(AVG(rcom.rating_stars), 0) as rating
FROM recipe r LEFT JOIN recipe_comment rcom ON (rcom.recipe_id = r.id AND rcom.approved=\'t\')
WHERE (prep_time > 0 AND prep_time is not null AND (()) AND r.visible IN (\'live\') AND submitted_name = \'\')
GROUP BY r.id ORDER BY rating DESC") | | DB.php:703 | - | db->createrecordset("SELECT DISTINCT r.*, IF(r.image_small is not null and r.image_small != \'\',1,0) has_image , IFNULL(AVG(rcom.rating_stars), 0) as rating
FROM recipe r LEFT JOIN recipe_comment rcom ON (rcom.recipe_id = r.id AND rcom.approved=\'t\')
WHERE (prep_time > 0 AND prep_time is not null AND (()) AND r.visible IN (\'live\') AND submitted_name = \'\')
GROUP BY r.id ORDER BY rating DESC") | | recipe.php:306 | - | db->getallrows("SELECT DISTINCT r.*, IF(r.image_small is not null and r.image_small != \'\',1,0) has_image , IFNULL(AVG(rcom.rating_stars), 0) as rating
FROM recipe r LEFT JOIN recipe_comment rcom ON (rcom.recipe_id = r.id AND rcom.approved=\'t\')
WHERE (prep_time > 0 AND prep_time is not null AND (()) AND r.visible IN (\'live\') AND submitted_name = \'\')
GROUP BY r.id ORDER BY rating DESC") | | category.html:103 | - | recipe_getallrecipes("prep", "1 hour %2B", "rating DESC") |
|
