Reward Points Module for ZC v13x

And.... Paypal - Customer did not get the points that he should have had added into the Pending list (let alone the Earned).

So, the problem with Paypal customers not being awarded their points is happening with me as well.

We use Paypal IPN.

Quote:

---

Originally Posted by Mike_Dean

Thanks Rasyr, appreciate your help on this,

Ok..

I checked the file as you suggested and it's as follows.

define('DB_PREFIX', '');

So we can assume that there is no prefix..

The problem is, that I can't even run the sql file to begin with.

I uploaded the files, and then when I try and enter the Admin CP, thats when I get the error, so I can't even run the sql to begin with, so modifying the sql is not going to help ?

Sorry....

---

Ahh.. do what Hem says right after your last post (I had missed somebody being told that earlier apparently).

Which sql file did you run the first time? And did you have the module installed before this (from your comments, it sounds like no).

Quote:

---

Originally Posted by Rasyr

Ahh.. do what Hem says right after your last post (I had missed somebody being told that earlier apparently).

Which sql file did you run the first time?

---

NONE !!!!....... I cant even run an sql file to begin with.... as I cant get into my Admin CP
(as posted three times...)

This is my first attempt at using this particular mod, as I was waiting for it to come out of Beta... So I haven't tried running it before, or uploaded any sql files associated with this mod before

(Excuse my apparent frustration...)



I tried that thanks Andrew, and it still throws up the same error.

1146 Table 'nortsandones.reward_status_track' doesn't exist
in:
[SELECT ph.*, o.orders_status FROM reward_status_track ph, orders o WHERE ph.orders_id=o.orders_id AND ph.dateIf 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.


Even tried renaming it completely to just bob.php and no luck..

What else could possibly be wrong.

Steps taken..

Renamed the custom file in your includes files to similate that of my custom template correct ?

Uploaded the admin and include folders. correct ?


I've uploaded plenty of mods and to be honest, this is the first that has not worked.. Thank god I'm doing it on my local site.

I really want to get this working as it (looks) like a great Mod.

Ok.. got it..!!

I just completely removed the rewards_points_functions.php file

Then I was able to get into Admin CP and I've put that file back. so Now I'll take the next step and see how I go..

Perserverence sure does pay off..

ok..
Next issues...


Now getting the following error when I try to enter the Rewards Points section under Customers in Admin

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 'SELECT SUM(rp.reward_points) FROM reward_status_track rp WHERE cp.customers_id=r' at line 1
in:
[UPDATE reward_customer_points cp, reward_status_track rp SET cp.reward_points=cp.reward_points+IFNULL(SELECT SUM(rp.reward_points) FROM reward_status_track rp WHERE cp.customers_id=rp.customers_id AND rp.status=0 AND rp.dateIf 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.

Quote:

---

Originally Posted by pinetreecandles

If you use a prefix in your table names (iE mine is zen_) then you would need to change that SQL statement to read:

Code:

---

RENAME TABLE `zen_reward_point_history` TO `zen_reward_status_track`;

---

If your prefix is different you just replace zen_ with yours. Then run it. It should make the change then.

---

Where do I find my prefix?

Quote:

---

Originally Posted by Mike_Dean

Ok.. got it..!!

I just completely removed the rewards_points_functions.php file

Then I was able to get into Admin CP and I've put that file back. so Now I'll take the next step and see how I go..

Perserverence sure does pay off..

---

The trick is to change the extension- anything but php should do

Quote:

---

Originally Posted by imperialis

Where do I find my prefix?

---

If this is the first time you've installed the mod, just run the new.sql under Admin->Tools->Install SQL Patch

Quote:

---

Originally Posted by Mike_Dean

ok..
Next issues...


Now getting the following error when I try to enter the Rewards Points section under Customers in Admin

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 'SELECT SUM(rp.reward_points) FROM reward_status_track rp WHERE cp.customers_id=r' at line 1
in:
[UPDATE reward_customer_points cp, reward_status_track rp SET cp.reward_points=cp.reward_points+IFNULL(SELECT SUM(rp.reward_points) FROM reward_status_track rp WHERE cp.customers_id=rp.customers_id AND rp.status=0 AND rp.dateIf 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.

---

Mike- reload admin/includes/functions/extra_functions/reward_points_functions.php- It looks like something (possibly Notepad) has stuck in an unwanted line break.

Quote:

---

Originally Posted by hem

Mike- reload admin/includes/functions/extra_functions/reward_points_functions.php- It looks like something (possibly Notepad) has stuck in an unwanted line break.

---

Thanks Andrew.

Took a while but I got there..
:smile: