Reward Points Module for ZC v13x

I'm trying to figure this out. Either its me or Reward Points is ignoring the category based rewards. Example:

I have my categories set up to give 0 rewards for the category "Gift Certificates". However, I still see the Gift Certificates awarding points as if I didn't even tell Rewards Points to award 0.

To further this, the item's product page reflects 0 points in the item display.

Can anyone help?

Quote:

---

Originally Posted by lauriesscraps

Would doing a complete restore of all the files in my back up do it? If so I can do that but I do not want to wipe any orders I have recieved since the back up was done, and I don't want to erase any products that were added. Does anybody know which files I should avoid restoring as to not erase the orders and products that were added since the back up?

Thanks again.

---

Not really. Database data and files are two different notes.

If you didn't do a back up of your database schemas prior to doing the update, then there is no reversal on this. You would need the SQL coding for your entire database available. Just backing up your files isn't enough. This is why whenever you do anything involving the database, it's a good idea to go to your hosting control panel and log into likely phpMyAdmin and do a complete backup of all your databases (even those not necessarily of ZenCart) before doing such work.

I would check with your host to see if they provide any automated back up and see if they a copy of your MySQL somewhere.

If you do a restore, there is a way to avoid losing your data. Restores normally involve doing a "IF THIS TABLE EXISTS, DELETE IT" sort of thing... So you may want to remove the CREATE TABLE coding. Secondly, any inserts should be changed from INSERT INTO to INSERT IGNORE INTO. This way you prevent duplicates. Doing this will tell MySQL to insert all of the data from the backup before you did MySQL ignoring any conflicts. This way you keep your current data and add your backup data.

This may sound a bit complicated but just remember before you begin... BACKUP EVERYTHING...

Trying it now. I hope it works. Long process and I have never done it before. Thanks for the information. I hope it saves me! THANK YOU, THANK YOU, THANK YOU!!!

If you need help with this I can help you through it. Otherwise, make sure you get the backup just in case something goes wrong.

Quote:

---

Originally Posted by retched

If you need help with this I can help you through it. Otherwise, make sure you get the backup just in case something goes wrong.

---

Thank you. I might, but I have a tutorial that HostMonster has created for this so I will give it a try, but I have downloaded a back up. Now I just have to do another backup before I do it. This seems so confusing! UGH! Thanks, I will let you know what happens.

Actually, I do have one question, how do I now which database to use. I have one called "_zc01 (106)". Is that the one? The others that are even close all say "_znc...something".

Quote:

---

Originally Posted by lauriesscraps

Thank you. I might, but I have a tutorial that HostMonster has created for this so I will give it a try, but I have downloaded a back up. Now I just have to do another backup before I do it. This seems so confusing! UGH! Thanks, I will let you know what happens.

Actually, I do have one question, how do I now which database to use. I have one called "_zc01 (106)". Is that the one? The others that are even close all say "_znc...something".

---

An easy way to answer this would be to check configure.php file for your ZenCart installation.

Open includes/configure.php in a text editor and look for define('DB_PREFIX', 'zen_');

Anything with the value listed in the second set of quotes, in my example 'zen_' is the database for ZenCart.

As for which database, look for define('DB_DATABASE', 'betadata');. That will list your zencart database. In my example, that is 'betadata'.

Still can't get it to work

I turned on my error log and I have this error

[09-Aug-2010 14:38:22] StoreRewardPoints called but SESSION['REWARD_POINTS_EARNED'] not found

This seems to happen when i place the order

Quote:

---

Originally Posted by nigelt74

Still can't get it to work

I turned on my error log and I have this error

[09-Aug-2010 14:38:22] StoreRewardPoints called but SESSION['REWARD_POINTS_EARNED'] not found

This seems to happen when i place the order

---

While installing, did you make sure to make all of the changes in each folder?

Quote:

---

Originally Posted by retched

An easy way to answer this would be to check configure.php file for your ZenCart installation.

Open includes/configure.php in a text editor and look for define('DB_PREFIX', 'zen_');

Anything with the value listed in the second set of quotes, in my example 'zen_' is the database for ZenCart.

As for which database, look for define('DB_DATABASE', 'betadata');. That will list your zencart database. In my example, that is 'betadata'.

---

Could I find this configure.php file under admin? If so, it does not show any text like this. Do I need to be looking for it somewhere else? Thanks!

Quote:

---

Originally Posted by lauriesscraps

Could I find this configure.php file under admin? If so, it does not show any text like this. Do I need to be looking for it somewhere else? Thanks!

---

The configure.php file I'm referring to is /catalog/includes/configure.php.

Essentially that is the <root of the zencart>/includes/configure.php