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

keyconn:

I am having an issue with installing the sql patch for this mod. I am getting errors that state:
Cannot insert configuration_key "" because it already exists

This is happening on all of the "INSERT INTO configuration" statements. As of now, nothing appears on the "Configuration > Reward Point Configuration" page except the heading. I am running ZC 1.5.4. Any help will be greatly appreciated.

You never said if this was a fresh install or a upgrade of Reward Points.
If this is not and upgrade run the Uninstall_Reward_Points.sql and try again.

I know this installs perfectly fine on a zen cart v1.5.4 if installed correctly.

countrycharm:

You never said if this was a fresh install or a upgrade of Reward Points.
If this is not and upgrade run the Uninstall_Reward_Points.sql and try again.

I know this installs perfectly fine on a zen cart v1.5.4 if installed correctly.

This is a new, fresh install of the Reward Points Full Suite v2.5. I ran the Uninstall_Reward_Points.sql and then ran the Reward_Points_Full_Install.sql again, just now. I am getting the same results. I get 22 errors that state " ERROR: Cannot insert configuration_key "" because it already exists".

keyconn:

This is a new, fresh install of the Reward Points Full Suite v2.5. I ran the Uninstall_Reward_Points.sql and then ran the Reward_Points_Full_Install.sql again, just now. I am getting the same results. I get 22 errors that state " ERROR: Cannot insert configuration_key "" because it already exists".

What version of zen cart are you running? You should have grab a copy of reward points 2.5d. Still nobody has reported having install problems when installing any of the others versions.

Hi Guys,

I installed V2.5 on Zencart 1.5.1 on 4th June.

All worked fine at first but in the last few weeks, the points haven't been adding to customers accounts (they showed up on the order however)

I added the points manually as 'Pending' then updated status of the order to 'Posted' or 'Delivered' but that didn't trigger the points to move to 'Earned'.

Have just discovered that the problem does not occur when customer selects 'Direct Bank Deposit' as the payment option so that then means Paypal is the common denominator.

Have scoured this thread and can't find anybody else having this problem.
Any help would be appreciated.

If you need any further info please let me know.

Cheers.

Manners 4 Dogs:

Hi Guys,

I installed V2.5 on Zencart 1.5.1 on 4th June.

All worked fine at first but in the last few weeks, the points haven't been adding to customers accounts (they showed up on the order however)

I added the points manually as 'Pending' then updated status of the order to 'Posted' or 'Delivered' but that didn't trigger the points to move to 'Earned'.

Have just discovered that the problem does not occur when customer selects 'Direct Bank Deposit' as the payment option so that then means Paypal is the common denominator.

Have scoured this thread and can't find anybody else having this problem.
Any help would be appreciated.

If you need any further info please let me know.

Cheers.

Have you added any new plugins since the problem started? If not I'm not sure what it could be. I haven't run into this problem with PayPal. All works fine. You can try this, change paypal from pending status to processing then see when you transfer orders status to delivered if they transfer. If not look a the Reward Point Status Track

Thanks for the suggestions. I haven't installed any other plugins since this one and already have paypal set to processing as the default.
Could you please advise where I find the Reward Point Status Track?
(I might have to ask my web developer to look into that for me)

Cheers!

Manners 4 Dogs:

Thanks for the suggestions. I haven't installed any other plugins since this one and already have paypal set to processing as the default.
Could you please advise where I find the Reward Point Status Track?
(I might have to ask my web developer to look into that for me)

Cheers!

You can set the setting in Admin-->configuration-->**Reward Point Status Track

**

OK, so already had the status track set to advanced with points going from pending to earned when order status is updated to posted or delivered.
Changed this to simple setting and placed an order using paypal.
Still same result.

Just to make things interesting, I added 5 points to my account manually as pending. Changed the order status. Instead of moving to earned, 5 points were added to pending so I did it again - 5 more points were added to pending.

Do you think reinstalling might be the next step but will I loose all the current points data doing this?

Thanks for your help.

Manners 4 Dogs:

OK, so already had the status track set to advanced with points going from pending to earned when order status is updated to posted or delivered.
Changed this to simple setting and placed an order using paypal.
Still same result.

Just to make things interesting, I added 5 points to my account manually as pending. Changed the order status. Instead of moving to earned, 5 points were added to pending so I did it again - 5 more points were added to pending.

Do you think reinstalling might be the next step but will I loose all the current points data doing this?

Thanks for your help.

Couple question....

What version of reward points did you upgrade from?
Are you using Paypal express or PayPal IPN when accepting payment?

If you just upload the files it will not hurt anything. All your customers will still be there be in the database.

Let me know if that fixes it, it not I have one more thing up my sleeve, well maybe two. The other 2 requires adding a code snippet.

Also what is admin-->configuration-->Reward Points Configurations--> **Reward Point Sunrise Period **set to?
I know you mention you already had the status track set to advanced with points going from pending to earned but you didn't mention if you had all of them set to posted or delivered?

countrycharm:

Couple question....

What version of reward points did you upgrade from?
Are you using Paypal express or PayPal IPN when accepting payment?

If you just upload the files it will not hurt anything. All your customers will still be there be in the database.

Let me know if that fixes it, it not I have one more thing up my sleeve, well maybe two. The other 2 requires adding a code snippet.

Hi Countrycharm,

This was a new install of v2.5b

I am using Paypal IPN
Sunrise Period is set to zero

All settings pictured below if that helps.
Attachment #15427

Will talk to my web manager and get her to upload all the files again and see if that fixes it. Will keep you posted.

Cheers. :smile:

Manners 4 Dogs:

Hi Countrycharm,

This was a new install of v2.5b

I am using Paypal IPN
Sunrise Period is set to zero

All settings pictured below if that helps.
Attachment #15427

Will talk to my web manager and get her to upload all the files again and see if that fixes it. Will keep you posted.

Cheers. :smile:

You probably need to switch over to paypal express. There were problems with Paypal IPN and reward points back long ago.

keyconn:

This is a new, fresh install of the Reward Points Full Suite v2.5. I ran the Uninstall_Reward_Points.sql and then ran the Reward_Points_Full_Install.sql again, just now. I am getting the same results. I get 22 errors that state " ERROR: Cannot insert configuration_key "" because it already exists".

Had to add database prefix to Reward_Points_Full_Install.sql statement and run it from phpMyAdmin. For some reason it would not except the Reward_Points_Full_Install.sql statement in admin/tools/install sql patches as you would normally do because of the errors. That states:
Cannot insert configuration_key "" because it already exists. The funny thing is there were nothing in the database either.

Fixed now anyway.

Reward Points v2.5e now has been released.

• Fixed Bug in the pagination code in admin-->customers_reward_points.php file - Fixed Limit Maximum Customers on Listings Page.
  Thanks to Delia for pointing that out.
• Fixed Bug in admin-->customers_reward_points.php file - When click on the edit button, the screen refreshes and you go back to page one.
  Thanks to Delia for catching this. Thanks to Ajeh for providing the code to fix it.
• Removed Delete Button on admin-->customers Reward Points Page. It didn't do anything, and doesn't really need to be there.
• **Added ** a link to the orders for the Customer rather than just their customers_id on admin-->customers Reward Points page. Click on customers_id and it will carry you to customer orders page.
  Thanks to Ajeh
• Updated the _doc folder to reflect these changes.
• Updated the version number from 2.5d to 2.5e.
  
  

I think mine is having the same problem. I have to transfer from pending to earned every day. They do not automatically transfer.

loaner:

I think mine is having the same problem. I have to transfer from pending to earned every day. They do not automatically transfer.

They do transfer if you have the setting setup right. I don't know what else to tell you. Recheck the files to see if all uploaded right.

Is the admin "delete reward points" supposed to delete the pending points to which it is referring? It just removes the listing from the status tracker, but doesn't subtract from pending points.

If that was not the intention, I've got some coding to do, because that's what we'd like to use it for. :)

countrycharm:

You probably need to switch over to paypal express. There were problems with Paypal IPN and reward points back long ago.

Have switched to Paypal Express and all works like a charm.

Cheers.

Manners 4 Dogs:

Have switched to Paypal Express and all works like a charm.

Cheers.

Thank you for confirming switching to PayPal Express fixed your problem.

Could anyone help me with 1.5.1 zencart?

My problem is:
My admin >reward point configuration> blank page!

I first installed 2.1b reward point full suite. Everything is good but only one problem I cannot solve. I found the reward pt ratio of sub-categories can only follow the global reward pt. ratio when order confirmation. Even the reward pt. of sub-categories was displaying correctly but it cannot calculate the actual point correctly.

I uninstalled it and install it again. I don't know whether my process was not correct. The reward point configuration list cannot show up again.
Then I upgrade to 2.5e but same problem occured. I uninstalled it and newly installed 2.5e and the problem is the same -- The reward point configuration list cannot show up again.

When I newly installed 2.5e There were some warnings as belows:

I've checked the logs file, it says:

America/Denver] PHP Fatal error: 1146:Table 'XXX_shop.reward_master' doesn't exist :: SELECT prp.point_ratio FROM reward_master prp WHERE prp.scope='0' LIMIT 1; in /.../.../public_html/includes/classes/db/mysql/query_factory.php on line 120

Please help and thanks a lot!!!