Reward Points Module for ZC v13x

I do have another problem now though, where can i find the file to edit the display in the sidebox for the reward points.

Now i have changed the prouct display text it is now jut say 33 worth in the shopping basket [more] sidebox?

Ok installed the latest version Brand new install(is there a tutorial somewhere on exactly hoe to configure it)

anyway it didn't work, so I reuploaded all files, and then manually checked they all went up

I have run th rpd file and these were the lines that came up in red

MySQL Database Check

customers_id- field missing in zen_reward_customer_points!!!
reward_points- field missing in zen_reward_customer_points!!!
pending_points- field missing in zen_reward_customer_points!!!
rewards_id- field missing in zen_reward_status_track!!!
customers_id- field missing in zen_reward_status_track!!!
orders_id- field missing in zen_reward_status_track!!!
date- field missing in zen_reward_status_track!!!
reward_points- field missing in zen_reward_status_track!!!
status- field missing in zen_reward_status_track!!!
Allow Redeem of Reward Points on Order Total or Subtotal- record missing in zen_configuration!!!

Everything else was fine

I had run the sql-new thingie via the zencart install sql patches link

I f i do it again will it fix it?

Only these ones appear show in red
zen_reward_customer_points- table found.
customers_id- field missing in zen_reward_customer_points!!!
reward_points- field missing in zen_reward_customer_points!!!
pending_points- field missing in zen_reward_customer_points!!!
zen_reward_status_track- table found.
rewards_id- field missing in zen_reward_status_track!!!
customers_id- field missing in zen_reward_status_track!!!
orders_id- field missing in zen_reward_status_track!!!
date- field missing in zen_reward_status_track!!!
reward_points- field missing in zen_reward_status_track!!!
status- field missing in zen_reward_status_track!!!
zen_configuration- table found.
Allow Redeem of Reward Points on Order Total or Subtotal- record missing in zen_configuration!!!

When i check in phpmyadmin those fields do appear to be in those tables

nigelt74:

Only these ones appear show in red
zen_reward_customer_points- table found.
customers_id- field missing in zen_reward_customer_points!!!
reward_points- field missing in zen_reward_customer_points!!!
pending_points- field missing in zen_reward_customer_points!!!
zen_reward_status_track- table found.
rewards_id- field missing in zen_reward_status_track!!!
customers_id- field missing in zen_reward_status_track!!!
orders_id- field missing in zen_reward_status_track!!!
date- field missing in zen_reward_status_track!!!
reward_points- field missing in zen_reward_status_track!!!
status- field missing in zen_reward_status_track!!!
zen_configuration- table found.
Allow Redeem of Reward Points on Order Total or Subtotal- record missing in zen_configuration!!!

When i check in phpmyadmin those fields do appear to be in those tables

I think that might be a false positive- What version of PHP and MySQL are you running?

I have tried searching this rather large thread for answers, but none of my key words get a result. So here goes.

I just installed this module on my cart. My business has been in operation for 2 years now, and I have a lot of loyal customers. I would like to give my existing customers reward points to match the orders that they have made. Is there a simple way to do this?

Thanks

Sharni

hem:

I think that might be a false positive- What version of PHP and MySQL are you running?

PHP Version 5.2.12
MySQL 5.0.90-community

But it still doesn't work as in when i make an order and mark it as dispatched no reward points are awarded

I'll add a link to the rpd file

http://nigel.geek.nz/sbo_shop/rpd.php

lauriesscraps:

I used Core FTP to transfer the files from the server to my external hard drive so the files look the same as they do on the server. They didn't download to a temp folder like my other internet downloads do. I am sorry to be so difficult. I know this is simple, I guess I just need to get the same page as everyone else.

Can anyone help me with this please?

lauriesscraps:

I recently updated my reward points module to the new version and it wiped all my reward points that I had in my store already. Hem mentioned that I can restor the sql tables and they will all come back, but I do not know where these are to restore them. I did back up my site before I did that so are the sql tables you are referring to in the back up files somewhere? If so, can someone tell me exactly where they are found in the system files so I can restore them?

Also, the reward points are no longer being shown on the product description pages. Is this something that is new with the updated module? If so that is fine, I just was afraid that I had done something wrong.

Thanks in advance to anyone that can help me. And thanks to hem for putting up with me up till now.

Laurie

Points are stored on the MySQL database. If you upgraded to the newer version and made sure to use the UPGRADE.SQL file included, you should not have lost your points. However, if you went "NEW.SQL", then your databases were demolished and new data was made.

If you upgraded, did you check to see if there was new code for the new version and the old?

I did use the update.sql but it had errors so I then used the new.sql. I know that is why, but I backed up all my files from the server through Core FTP to my EHD. So I was wondering if there was a file from that back up that would have the old rewards points stored so I can just restore that file.

I did not check for new coding. Not sure what you mean by that, but I did not check for new coding. Any suggestions?

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.

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?

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.

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".

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

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?

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!

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