Reward Points Module for ZC v13x

Quote:

---

Originally Posted by nolsowski

:oops: I have no idea what I did but now on my product description page I get this error.

146 Table 'fromprop_zc1.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='2574' AND p2c.products_id='2574' 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;]


and now my Rewards Point Page says it doesn't exist. Here is my site in case you need it http://www.frompropertorocker.com

Thanks!

---

Okay I got the page to show up. I just re added rewards points page mod again. Now working on the error lol

Quote:

---

Originally Posted by nolsowski

:oops: I have no idea what I did but now on my product description page I get this error.

146 Table 'fromprop_zc1.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='2574' AND p2c.products_id='2574' 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;]


and now my Rewards Point Page says it doesn't exist. Here is my site in case you need it http://www.frompropertorocker.com

Thanks!

---

Okay I got that error off too. I just re added the module again and now it works. :clap:

Alright I lied. I thought I had everything fixed but now in my admin area under Catalog-Reward Points I get this error

1146 Table 'fromprop_zc1.zen_reward_master' doesn't exist
in:
[SELECT * FROM zen_reward_master WHERE scope='0' AND scope_id='0';]
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.

I re added everything to make sure I didn't miss a file but I still get this message.

I also get this message when I go to Customers-Reward Points

1146 Table 'fromprop_zc1.zen_reward_customer_points' doesn't exist
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.

These ones I am completely stumped on.

Quote:

---

These ones I am completely stumped on

---

Unfortunately, I'm not the author of the mod so I'm as stumped on as you. However, it doesn't seem to be something difficult to fix with the help of someone who knows sql and can probably guide you to clear corrupt entries and run the sql file again. Good luck :yes:

Quote:

---

Originally Posted by Athens Collectibles

Unfortunately, I'm not the author of the mod so I'm as stumped on as you. However, it doesn't seem to be something difficult to fix with the help of someone who knows sql and can probably guide you to clear corrupt entries and run the sql file again. Good luck :yes:

---

Thanks! Is there a way to completely unistall it? I tried to run the unistall.sql but I just got this error lol

1146 Table 'fromprop_zc1.configuration' doesn't exist
in:
[DELETE IGNORE FROM configuration WHERE configuration_group_id=@group_id;]
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.

Maybe if I just delete all the files out of my server it will go back to normal?

Nevermind lol. I got it. I added the new install.sql and it works now. I think I am going to stop messing with this for a while lol. Thanks for your help. :)

Glad that you sorted it out. Well done! :D

The product pages display "0 reward points". I suppose it's because you haven't configured the mod yet.

The link to your Reward Page works fine, you just have to define the page contents now. It's a long task but think of me who had to do it in two languages!

Quote:

---

Originally Posted by Athens Collectibles

Glad that you sorted it out. Well done! :D

The product pages display "0 reward points". I suppose it's because you haven't configured the mod yet.

The link to your Reward Page works fine, you just have to define the page contents now. It's a long task but think of me who had to do it in two languages!

---

Thank you!:D

Yeah I haven't figured out how I want them set yet lol. I got a headache from just trying to fix what I screwed up and I think I will wait until tomorrow to figure out how I want everything else.

Hi

Is there somewhere an explanation on how to export OScommerce customers rewards points to Zencart rewards points?

thanks

pat
:lookaroun

Quote:

---

Originally Posted by wirefram

Hi

Is there somewhere an explanation on how to export OScommerce customers rewards points to Zencart rewards points?

thanks

pat
:lookaroun

---

Yes but it will be difficult as I have tried it LOL. I have over 5K customers and have to do each one manually, UGH!

You MAY ask skipwaters here on the board.