Reward Points Module for ZC v13x

Ok so I have the rewards points showing but I have 2 shopping cart side boxes and then when I go to check out I get this error

1146 Table 'imperial_zc1.TABLE_STORE_CREDIT' doesn't exist
in:
[select amount from TABLE_STORE_CREDIT where customers_id = 1]

www.imperialgiftsnwares.com.au

Quote:

---

Originally Posted by NullMind

Andrew

Not sure if I missed it, but is there a way to prevent "gift certeficates" from counting toward points ? otherwise it's a double wammy

second, I am using the latest beta, do I need to re-run upgrade.sql ?

---

Just set the product ratio to 0.00

Hi

Mike_Dean a few posts back posted that he had a problem at
Admin->Customer->RewardPoints. I seem to have the same one.

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 zen_reward_status_track rp WHERE cp.customers_' at line 1
in:
[UPDATE zen_reward_customer_points cp, zen_reward_status_track rp SET cp.reward_points=cp.reward_points+IFNULL(SELECT SUM(rp.reward_points) FROM zen_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.

Tried to a reload of the file suggested and no luck. Redownloaded again and still no luck.

Everything was fine up to the first test sale and then this appeared in Admin

Any further suggestions?

Zen - 1.3.7
MySQL - 4.1.22

Quote:

---

Originally Posted by Rasyr

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.

---

I have same problem. Paypal didn't earn points.
Now i am not the only one have paypal problem, so it's not paypal pin issue.

Quote:

---

Originally Posted by imperialis

Ok so I have the rewards points showing but I have 2 shopping cart side boxes and then when I go to check out I get this error

1146 Table 'imperial_zc1.TABLE_STORE_CREDIT' doesn't exist
in:
[select amount from TABLE_STORE_CREDIT where customers_id = 1]

www.imperialgiftsnwares.com.au

---

Sorry mate, that's not one of my tables- Is it possible you have Numinix's Store Credit mod installed also???

Quote:

---

Originally Posted by Mike_Dean

Thanks Andrew.

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

---

Was I right about the reload???

Quote:

---

Originally Posted by hem

Was I right about the reload???

---

Pretty Much..

I ended up reloading the whole thing, took a couple of goes but it got there, just seem to be having some other issues now.

The sidebox for RP is not showing, and nothng shows up during checkout even after I have added points to an account ?

Quote:

---

Originally Posted by Mike_Dean

Pretty Much..

I ended up reloading the whole thing, took a couple of goes but it got there, just seem to be having some other issues now.

The sidebox for RP is not showing, and nothng shows up during checkout even after I have added points to an account ?

---

Did you enable the Reward Point sidebox (and/or Cart with Reward Point sidebox) under Admin->Tools->Layout Box Controller???

Also you will need to enable the Redeem Reward Point Order Total box under Admin->Modules->Order Total

Quote:

---

Originally Posted by hem

Did you enable the Reward Point sidebox (and/or Cart with Reward Point sidebox) under Admin->Tools->Layout Box Controller???

Also you will need to enable the Redeem Reward Point Order Total box under Admin->Modules->Order Total

---

Ok, thanks Andrew, will check that out shorty.. Busy packing orders at present :smile::smile::smile:

Quote:

---

Originally Posted by hem

Did you enable the Reward Point sidebox (and/or Cart with Reward Point sidebox) under Admin->Tools->Layout Box Controller???

---

Theres is no option to enable the RP sidebox here ???

Quote:

---

Also you will need to enable the Redeem Reward Point Order Total box under Admin->Modules->Order Total

---

Done...


Another issue, this is what is showing next to an item

42 PRODUCT_REWARD_POINT_TAG

Obviously its the number of points this product will offer as a reward, but the text obviously should not be reading that way whould it ?