Page 6 of 248 FirstFirst ... 456781656106 ... LastLast
Results 51 to 60 of 2475
  1. #51
    Join Date
    Aug 2006
    Posts
    231
    Plugin Contributions
    0

    Default Re: Reward Points Module- Live Release now available.

    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.

  2. #52
    Join Date
    Aug 2006
    Posts
    231
    Plugin Contributions
    0

    Default Re: Reward Points Module- Live Release now available.

    Quote Originally Posted by Mike_Dean View Post
    Thanks Rasyr, appreciate your help on this,

    Ok..

    I checked the file as you suggested and it's as follows.

    define('DB_PREFIX', '');

    So we can assume that there is no prefix..

    The problem is, that I can't even run the sql file to begin with.

    I uploaded the files, and then when I try and enter the Admin CP, thats when I get the error, so I can't even run the sql to begin with, so modifying the sql is not going to help ?

    Sorry....
    Ahh.. do what Hem says right after your last post (I had missed somebody being told that earlier apparently).

    Which sql file did you run the first time? And did you have the module installed before this (from your comments, it sounds like no).

  3. #53
    Join Date
    Feb 2006
    Location
    Central Coast, NSW, Australia
    Posts
    560
    Plugin Contributions
    0

    Default Re: Reward Points Module- Live Release now available.

    Quote Originally Posted by Rasyr View Post
    Ahh.. do what Hem says right after your last post (I had missed somebody being told that earlier apparently).

    Which sql file did you run the first time?
    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.

  4. #54
    Join Date
    Feb 2006
    Location
    Central Coast, NSW, Australia
    Posts
    560
    Plugin Contributions
    0

    Default Re: Reward Points Module- Live Release now available.

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

  5. #55
    Join Date
    Feb 2006
    Location
    Central Coast, NSW, Australia
    Posts
    560
    Plugin Contributions
    0

    Default Re: Reward Points Module- Live Release now available.

    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.

  6. #56
    Join Date
    Apr 2008
    Posts
    129
    Plugin Contributions
    0

    Default Re: Reward Points Module- Live Release now available.

    Quote Originally Posted by pinetreecandles View Post
    If you use a prefix in your table names (iE mine is zen_) then you would need to change that SQL statement to read:
    Code:
    RENAME TABLE `zen_reward_point_history` TO `zen_reward_status_track`;
    If your prefix is different you just replace zen_ with yours. Then run it. It should make the change then.
    Where do I find my prefix?

  7. #57
    Join Date
    Sep 2007
    Location
    Dublin, Ireland
    Posts
    1,288
    Plugin Contributions
    8

    Default Re: Reward Points Module- Live Release now available.

    Quote Originally Posted by Mike_Dean View Post
    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..
    The trick is to change the extension- anything but php should do
    Andrew

    Andrew Moore
    Omnicia Agile Development
    www.omnicia.com

  8. #58
    Join Date
    Sep 2007
    Location
    Dublin, Ireland
    Posts
    1,288
    Plugin Contributions
    8

    Default Re: Reward Points Module- Live Release now available.

    Quote Originally Posted by imperialis View Post
    Where do I find my prefix?
    If this is the first time you've installed the mod, just run the new.sql under Admin->Tools->Install SQL Patch
    Andrew

    Andrew Moore
    Omnicia Agile Development
    www.omnicia.com

  9. #59
    Join Date
    Sep 2007
    Location
    Dublin, Ireland
    Posts
    1,288
    Plugin Contributions
    8

    Default Re: Reward Points Module- Live Release now available.

    Quote Originally Posted by Mike_Dean View Post
    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.
    Mike- reload admin/includes/functions/extra_functions/reward_points_functions.php- It looks like something (possibly Notepad) has stuck in an unwanted line break.
    Andrew

    Andrew Moore
    Omnicia Agile Development
    www.omnicia.com

  10. #60
    Join Date
    Feb 2006
    Location
    Central Coast, NSW, Australia
    Posts
    560
    Plugin Contributions
    0

    Default Re: Reward Points Module- Live Release now available.

    Quote Originally Posted by hem View Post
    Mike- reload admin/includes/functions/extra_functions/reward_points_functions.php- It looks like something (possibly Notepad) has stuck in an unwanted line break.
    Thanks Andrew.

    Took a while but I got there..

 

 
Page 6 of 248 FirstFirst ... 456781656106 ... LastLast

Similar Threads

  1. v139h Reward Points module display order totals including reward points
    By irsarahbean in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 23 Jun 2013, 01:19 AM
  2. Reward points module : 0 points earned
    By jonnyboy22 in forum Addon Payment Modules
    Replies: 5
    Last Post: 5 Jun 2012, 09:52 AM
  3. Reward Points module- points not calculated correctly
    By cpoet in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 9 Sep 2010, 05:02 PM
  4. Reward Points Module - Hide message when 0 points offered
    By expresso in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 11 Dec 2008, 06:58 PM
  5. Experimental Reward Points Module
    By precursor999 in forum Addon Payment Modules
    Replies: 7
    Last Post: 2 Apr 2007, 09:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR