Reward Points Module for ZC v13x

[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!

[hem]

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!

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

[travel124]

Please I would to know to what files to add permissions.

Thank You.

[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!

[hem]

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.

[kimsonvu]

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 !

[hem]

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.

[kimsonvu]

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

[beadfaery]

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?

[hem]

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?

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)