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

[strelitzia]

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

Email sent. Thanks

[twitchtoo]

Email sent. Thanks

Check your snail mail

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.

[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

[mesnitu]

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

got to check this

[jeking]

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

[strelitzia]

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

[jeking]

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.

[The Mad Robot]

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.

[sammirah]

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:

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

ALTER TABLE reward_status_track ( ADD INDEX(customers_id));

or exactly as it is written above?

[mesnitu]

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.