Here is some added information on the errors with google checkout as described in prior post.
If I don't enable Google Checkout all works fine out of the box. If I enable google checkout I get the following error on the login page and the google checkout button doesn't show up or new sign up fields. Only the login for existing customers shows up:
1064 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 ((prp.scope_id= AND prp.scope=4) OR (gp.group_id=c.customers_group_pricin' at line 5
in:
[SELECT redeem_ratio FROM zen_reward_master prp, zen_customers as c LEFT JOIN(zen_group_pricing as gp) ON (gp.group_id=c.customers_group_pricing) WHERE c.customers_id= AND ((prp.scope_id= AND prp.scope=4) OR (gp.group_id=c.customers_group_pricing AND prp.scope_id=gp.group_id AND scope=3) OR (prp.scope=0)) ORDER BY prp.scope DESC LIMIT 1;]
If I edit the file reward_points_functions.php as follows the google checkout button shows up and all is well except when you click on google checkout you get the page in the picture shown in the prior post with it charging $10 for the 10 points earned. Normal checkout via authorize.net works fine either way.
original reward_points_functions.php:
function GetRedeemRatio($customers_id)
{
global $db;
$sql = "SELECT redeem_ratio
FROM ".TABLE_REWARD_MASTER." prp, ".TABLE_CUSTOMERS." as c
LEFT JOIN(".TABLE_GROUP_PRICING." as gp) ON (gp.group_id=c.customers_group_pricing)
WHERE c.customers_id=".$customers_id."
AND ((prp.scope_id=".$customers_id." AND prp.scope=".SCOPE_CUSTOMER.")
OR (gp.group_id=c.customers_group_pricing AND prp.scope_id=gp.group_id AND scope=".SCOPE_GROUP.")
OR (prp.scope=".SCOPE_GLOBAL."))
ORDER BY prp.scope DESC LIMIT 1;";
$result=$db->Execute($sql);
changed reward_points_functions.php:
function GetRedeemRatio($customers_id)
{
global $db;
$sql = "SELECT redeem_ratio
FROM ".TABLE_REWARD_MASTER." prp, ".TABLE_CUSTOMERS." as c
LEFT JOIN(".TABLE_GROUP_PRICING." as gp) ON (gp.group_id=c.customers_group_pricing)
WHERE c.customers_id='" . $customers_id . "'
AND ((prp.scope_id='" . $customers_id . "' AND prp.scope=".SCOPE_CUSTOMER.")
OR (gp.group_id=c.customers_group_pricing AND prp.scope_id=gp.group_id AND scope=".SCOPE_GROUP.")
OR (prp.scope=".SCOPE_GLOBAL."))
ORDER BY prp.scope DESC LIMIT 1;";
$result=$db->Execute($sql);
