Reward Points Module for ZC v13x

I am still unable to finish this install because of info below.


I have the mod set up and thanks it looks like a great one. I have one problem.

In my admin catalog I cannot access my Reward Points.

Under Customers I cannot access Group Reward Points and Reward Points.

I am getting this error for all 3.

Sorry, your security clearance does not allow you to access this resource.

Please contact your site administrator if you believe this to be incorrect.

Sorry for any inconvenience.

Thank You for the help!

Quote:

---

Originally Posted by travel124

I am still unable to finish this install because of info below.


I have the mod set up and thanks it looks like a great one. I have one problem.

In my admin catalog I cannot access my Reward Points.

Under Customers I cannot access Group Reward Points and Reward Points.

I am getting this error for all 3.

Sorry, your security clearance does not allow you to access this resource.

Please contact your site administrator if you believe this to be incorrect.

Sorry for any inconvenience.

Thank You for the help!

---

You will have to take the question to the Admin Permissions mod thread- I'm afraid I don't use that modification.

Quote:

---

Originally Posted by hem

I'm guessing that you MySQL version is lower than 4.2

---

Hi,

I use bluehost and their Php version is 5.

What can i do now to fix this trouble?

Thanks in advance !

Quote:

---

Originally Posted by kimsonvu

Hi,

I use bluehost and their Php version is 5.

What can i do now to fix this trouble?

Thanks in advance !

---

It works with v5. Just check with your ISP that your hosting is set for this version. I know with my host I had to add a line to my .htaccess file in order to use the newer version as they defaulted to v4 for backward compatibility.

Error
SQL query:

SELECT (

@group_id := `configuration_group_id`
)
FROM `configuration_group`
WHERE `configuration_group_title` LIKE 'Reward Points';



MySQL said:

#1146 - Table 'thescra1_zc2.configuration_group' doesn't exist

help how do i fix this

Quote:

---

Originally Posted by hem

It works with v5. Just check with your ISP that your hosting is set for this version. I know with my host I had to add a line to my .htaccess file in order to use the newer version as they defaulted to v4 for backward compatibility.

---

Hi,

I checked ! This is 5.26 php version !

PHP Version: 5.2.6 (Zend: 2.2.0) PHP Memory Limit: 128M

Quote:

---

Originally Posted by kimsonvu

Hi,

After search customer last name in Admin->Customer->Reward Points Module

I click into customer which i found to edit point but i saw this trouble :

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 status=0 ORDER BY date DESC LIMIT 12' at line 1
in:
[SELECT rewards_id, orders_id, date, reward_points, status FROM handicrareward_status_track WHERE customers_id= AND status=0 ORDER BY date DESC LIMIT 12;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Do you know how to fix this?

Thanks you!

---

Hi Andrew. I've just discovered I'm having this problem, too :( I've had a customer pay with Paypal, so need to manually award her points, but I can't due to this error.

I have checked and yes....I am running MySQL version 4.1.22-standard .
Any idea how I update this? Do I need to ask my host to do it?:wacko:

Quote:

---

Originally Posted by beadfaery

Hi Andrew. I've just discovered I'm having this problem, too :( I've had a customer pay with Paypal, so need to manually award her points, but I can't due to this error.

I have checked and yes....I am running MySQL version 4.1.22-standard .
Any idea how I update this? Do I need to ask my host to do it?:wacko:

---

Yes- just give your ISP a call and see if they can't update you to v5 (point out to them that v6 will be available shortly)

Hello,
today I install the version 1.2 and now it didn't work correctly. I am in Germany and we have to show all prices with tax in it. Version 1.13 always calculate the reward points from the price without tax (It is o.k.).
The new version calculate from the prices without tax on the product_info_display.php and show for example 40 reward points but if you add the item to the cart the sitebox show 48 reward points, because it calculates from the price with tax.
I think it is equal from which price it is calculated but it should be the same in every case.
I use it on a life-shop and have to go back to 1.13 because this issue isn't acceptable.

This mod has not worked all week for me. I added the permissions but no longer getting downloads to come through on orders. I tried ran the uninstall and now I have this error.

1146 Table 'digit124_zenstore.zen_reward_master' doesn't exist
in:
[SELECT prp.point_ratio*p.products_price AS reward_points, prp.point_ratio, p.products_price, p.products_priced_by_attribute FROM zen_reward_master prp, zen_products p, zen_products_to_categories p2c WHERE p.products_id='2749' AND p2c.products_id='2749' AND ((prp.scope_id=p.products_id AND prp.scope='2') OR (p.products_id=p2c.products_id AND prp.scope_id=p2c.categories_id AND prp.scope='1') OR (prp.scope='0')) ORDER BY prp.scope DESC LIMIT 1;]