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!

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.

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 !

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

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

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:

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;]

hem:

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)
If they can't do this for you, is there a way of changing the ID (Or even adding in the order number) to show decending ie the largest number first? This would then let you add manually for the most recent orders you have taken.
The code would be within the customer_reward_points.php file would it not?

First, great mod. Thank you Andrew. I just completed the install, but have few questions. A few things are missing: (using your "readme" instructions and attachments for reference), step 6, 8, and 9. How can I fix this, and where should I look. Also, is there a way to exclude reward points for "gift certificates?" Thanks in advance.

CandleMan:

If they can't do this for you, is there a way of changing the ID (Or even adding in the order number) to show decending ie the largest number first? This would then let you add manually for the most recent orders you have taken.
The code would be within the customer_reward_points.php file would it not?

You are correct with this- However there are a number of elements within this mod which also require v4.2 or greater. To make the whole mod pre v4.2 compliant would also mean a greater number of MySQL calls and the resource impact that would entail.

winwallc:

First, great mod. Thank you Andrew. I just completed the install, but have few questions. A few things are missing: (using your "readme" instructions and attachments for reference), step 6, 8, and 9. How can I fix this, and where should I look. Also, is there a way to exclude reward points for "gift certificates?" Thanks in advance.

Check you make sure you have copied all the files over correctly (the thumbnails would indicate that the admin files are missing).

hem:

Check you make sure you have copied all the files over correctly (the thumbnails would indicate that the admin files are missing).

You are right, admin pages were missing. Are you familiar with these 2 issues below? thanks in advance

BTW -- I admit I am one of those dumbass that didn't read your instructions. It was too late when i notice your DB requirements. I am currently using 4.1.x.x.x. Is there a fix or sol?

Admi-> catalog -> Reward Points
Fatal error: Call to undefined function: getrewardpointrecord() in /home/content/c/h/o/chopsticks/html/zen/admin/reward_points.php on line 125
Admi-> customers -> Reward Points
Fatal error: Call to undefined function: cleanuprewardpointhistory() in /home/content/c/h/o/chopsticks/html/zen/admin/customers_reward_points.php on line 25

Ok, after combing thru all previous threads, my problems was solved. Although should I still be concern about the mysql v4.1?

:clap: awsome mod, thanks again Andrew. You D-man. :yes:

Ok I've combed this thread and perhaps I have missed it.

When I turn on the sidebox, all my other side boxes disappear that go below it. Everything else is working flawlessly. Am I missing something?

hintimates:

Ok I've combed this thread and perhaps I have missed it.

When I turn on the sidebox, all my other side boxes disappear that go below it. Everything else is working flawlessly. Am I missing something?

Have you changed anything in the sidebox code??? The reason that the other sideboxes are not loading is because there is a php error which is stopping any further code being run.

winwallc:

Ok, after combing thru all previous threads, my problems was solved. Although should I still be concern about the mysql v4.1?

:clap: awsome mod, thanks again Andrew. You D-man. :yes:

Well, if it works, it works...

I'd still pester your ISP to update their MySQL version. v6 is now available. v4.1 is over five years old now. Even MySQL themselves no longer support it; from their website: "Active development and support for MySQL database server versions 3.23, 4.0, and 4.1 has ended."

hem:

Have you changed anything in the sidebox code??? The reason that the other sideboxes are not loading is because there is a php error which is stopping any further code being run.

No I haven't changed anything. Loaded straight in without any changes. I actually unzipped the files again and reloaded just in case. Sideboxes won't show up and eliminates all the ones underneath it.

Just an additional thought in my testing of it -

Is it possible to add a Reward Points section into the user account files so they can log in and look to see what they have on hand in there when they go into My Account?

And the site for this particular issue is https://www.justmixandbake.com