Reward Points Module for ZC v13x

[DarrenQ]

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?

[nigelt74]

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?

[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

[hem]

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?

[Sharni]

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

[nigelt74]

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?

[retched]

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?

[lauriesscraps]

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?

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