Reward Points Module for ZC v13x

Quote:

---

Originally Posted by hem

Do you have phpmyadmin???

If so check you have the following tables:

reward_customer_points
reward_master
reward_status_track

If you use a prefix then look of the same tables preceded by YOURPREFIX_

---

I have the following

reviews_description
reward_customer_points
reward_master
reward_point_history
reward_status_track

I've just upgraded to the latest version that i read has fixed attribute handling.

however i'm still having a BIG issue.

I am using another contributions to enable users to set the price of the product.

now the shopping cart sees a total and everything works right, except 0 reward points are awarded.

http://www.diversitygifts.com.au/ind...&products_id=1

**EDIT i changed the value of an attribute and now it gives just the base price. It may be a problem with how the other contribution works.

Quote:

---

Originally Posted by burgundy

Hello!

I am getting the same error message when I try to go to Customers --> Reward Points 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.

I am using mysql 5.0 and Zen Cart 1.3.8a. I have a fresh install of Reward Points Module. Everything else appears to be working fine.

---

Anyone have any ideas for me on what the problem can be? My install was a brand new installation of the contribution, I'm not updating from a previous version. I've checked the tables and they are there. Thanks

Does this play well with the other modules yet or is there still come problems?

Thanks!

Quote:

---

Originally Posted by burgundy

Anyone have any ideas for me on what the problem can be? My install was a brand new installation of the contribution, I'm not updating from a previous version. I've checked the tables and they are there. Thanks

---

I had this same error show up and I got lucky because the only setting that I changed was the "sunrise period" in the configuration- I had made it 10. I changed it back to 0 and it works fine now. Of course, I don't know how to add a Sunrise period but at least I don't have the error!!

Hope this helps???
Nancy

Quote:

---

Originally Posted by ladyink

I had this same error show up and I got lucky because the only setting that I changed was the "sunrise period" in the configuration- I had made it 10. I changed it back to 0 and it works fine now. Of course, I don't know how to add a Sunrise period but at least I don't have the error!!

Hope this helps???
Nancy

---

Hi Nancy

You are correct, just put the sunrise period back to 0 in the config and the error went away

but like you, I need the sunrise period :(

I found a problem.
If use "Super Orders" to change order status, the pending points won't add to earn point.

Thank you Ladyink and Nullmind. I set the sunrise period to 0 and that did the trick. However like you, I also need a sunrise period. And I tried setting it back to see if it worked on the off chance. It didn't.

Any of the wonderful resident coders have a fix for this? I'm just a coding noob, I wouldn't have the faintest idea what to do.

Or is there some other setting that needs to be tweaked in order for it to work? Maybe there's another switch we need to flip?

Quote:

---

Originally Posted by burgundy

Thank you Ladyink and Nullmind. I set the sunrise period to 0 and that did the trick. However like you, I also need a sunrise period. And I tried setting it back to see if it worked on the off chance. It didn't.

Any of the wonderful resident coders have a fix for this? I'm just a coding noob, I wouldn't have the faintest idea what to do.

Or is there some other setting that needs to be tweaked in order for it to work? Maybe there's another switch we need to flip?

---

I'll have a look in the morning.

So I just installed this mod and I have a few problems, and yes...I am kind of a newbie.

I copied all the files to the folders, installed SQL, and at first when I went to turn the Order Total portion "on" there was an error....So I tried uninstalling the SQL....it didnt work

So now I receive this error :
Fatal error: Call to a member function format() on a non-object in /home/nazarhoo/public_html/includes/modules/order_total/ot_gv.php on line 49

That is under the Order Total in Admin.

What do I have to do to get this mod working smoothly???

Thank You
-Mahir