And.... Paypal - Customer did not get the points that he should have had added into the Pending list (let alone the Earned).
So, the problem with Paypal customers not being awarded their points is happening with me as well.
We use Paypal IPN.
And.... Paypal - Customer did not get the points that he should have had added into the Pending list (let alone the Earned).
So, the problem with Paypal customers not being awarded their points is happening with me as well.
We use Paypal IPN.
NONE !!!!....... I cant even run an sql file to begin with.... as I cant get into my Admin CP
(as posted three times...)
This is my first attempt at using this particular mod, as I was waiting for it to come out of Beta... So I haven't tried running it before, or uploaded any sql files associated with this mod before
(Excuse my apparent frustration...)
I tried that thanks Andrew, and it still throws up the same error.
1146 Table 'nortsandones.reward_status_track' doesn't exist
in:
[SELECT ph.*, o.orders_status FROM reward_status_track ph, orders o WHERE ph.orders_id=o.orders_id AND ph.dateIf you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Even tried renaming it completely to just bob.php and no luck..
What else could possibly be wrong.
Steps taken..
Renamed the custom file in your includes files to similate that of my custom template correct ?
Uploaded the admin and include folders. correct ?
I've uploaded plenty of mods and to be honest, this is the first that has not worked.. Thank god I'm doing it on my local site.
I really want to get this working as it (looks) like a great Mod.
Ok.. got it..!!
I just completely removed the rewards_points_functions.php file
Then I was able to get into Admin CP and I've put that file back. so Now I'll take the next step and see how I go..
Perserverence sure does pay off..
ok..
Next issues...
Now getting the following error when I try to enter the Rewards Points section under Customers in Admin
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT SUM(rp.reward_points) FROM reward_status_track rp WHERE cp.customers_id=r' at line 1
in:
[UPDATE reward_customer_points cp, reward_status_track rp SET cp.reward_points=cp.reward_points+IFNULL(SELECT SUM(rp.reward_points) FROM reward_status_track rp WHERE cp.customers_id=rp.customers_id AND rp.status=0 AND rp.dateIf you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Bookmarks