Reward Points Full Suite v2.5 (for ZC v1.5x) Support Thread

Quote:

---

Originally Posted by twitchtoo

strelitzia - You're welcome to email me directly and I'll send a copy immediately.

---

Email sent. Thanks

Quote:

---

Originally Posted by strelitzia

Email sent. Thanks

---

Check your snail mail :smile:

Reward Points Full Suite 2.5h for 1.55f has been submitted for approval

v2.5h - 01/07/2019 Updated By Twitch:

• Strelitza - Bug Reported - Twitch Wholesale code found in YOUR_ADMIN/orders.php:
• https://www.zen-cart.com/showthread....00#post1353100
• Reward Points 2.5h - Twitch Updated:
• Bugfix - Reset YOUR_ADMIN/orders.php in new install + upgrade fileset to 1.55f stock
• Version change updated in the installation instructions
• File naming standards enforced on directory names.

I've come across an issue with this module.
As the number of entries in reward_status_track table increases, loading the admin page takes longer and longer.
A site I just fixed had around 9700 entries, and admin was crashing every time I tried to load customers_reward_points.php
TTFB was in excess of 2 minutes!
I resolved this issue by applying an index to the database table like

ALTER TABLE `reward_status_track` ADD INDEX(`customers_id`);

Admin now loads instantly.
Please update your installer to include this index on the database table

Quote:

---

Originally Posted by strelitzia

I've come across an issue with this module.
As the number of entries in reward_status_track table increases, loading the admin page takes longer and longer.
A site I just fixed had around 9700 entries, and admin was crashing every time I tried to load customers_reward_points.php
TTFB was in excess of 2 minutes!
I resolved this issue by applying an index to the database table like

ALTER TABLE `reward_status_track` ADD INDEX(`customers_id`);

Admin now loads instantly.
Please update your installer to include this index on the database table

---

:bigups: got to check this

Is anyone working on updating for 1.5.6? Or has anyone tried this in 1.5.6?

Quote:

---

Originally Posted by jeking

Is anyone working on updating for 1.5.6? Or has anyone tried this in 1.5.6?

---

I've installed it to a 1.5.6a site. It's currently with the client for testing prior to go live. I haven't had any reports of issues with it so far

Quote:

---

Originally Posted by strelitzia

I've installed it to a 1.5.6a site. It's currently with the client for testing prior to go live. I haven't had any reports of issues with it so far

---

Good to know, thank you.

I have used this since a 1.5.6a upgrade and I had an issue similar to those in the past where the reward points were not being applied to the order total.

The fix contained in post 202 of this thread contains a fix and it has worked just fine for me.

Quote:

---

Originally Posted by strelitzia

I've come across an issue with this module.
As the number of entries in reward_status_track table increases, loading the admin page takes longer and longer.
A site I just fixed had around 9700 entries, and admin was crashing every time I tried to load customers_reward_points.php
TTFB was in excess of 2 minutes!
I resolved this issue by applying an index to the database table like

ALTER TABLE `reward_status_track` ADD INDEX(`customers_id`);

Admin now loads instantly.
Please update your installer to include this index on the database table

---

Where exactly do we do this? Should I use the Admin->Install SQL Patches or can I copy and past this into the Installation SQL in this area:

Code:

---

CREATE TABLE reward_status_track (
rewards_id INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
customers_id INT( 11 ) NOT NULL ,
orders_id INT( 11 ) NOT NULL ,
date DATETIME NOT NULL ,
reward_points DOUBLE( 15, 4 ) NOT NULL ,
status TINYINT( 1 ) NOT NULL,
UNIQUE (orders_id));
ALTER TABLE `reward_status_track` ADD INDEX(`customers_id`);

---

before I complete the installation or can I just stick it anywhere at the bottom of the page? Also, if I am to add it to the Installation SQL would I write it like this

Code:

---

ALTER TABLE reward_status_track ( ADD INDEX(customers_id));

---

or exactly as it is written above?

You just have to do it one time.
For example in phpmyadmin.
But I guess it can be done with Install SQL Patches also.

Perhaps someone will update the module to add this index upon installation.