Page 14 of 37 FirstFirst ... 4121314151624 ... LastLast
Results 131 to 140 of 362
  1. #131
    Join Date
    Nov 2013
    Location
    Dorset, UK
    Posts
    121
    Plugin Contributions
    0

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

    Hi again,

    I know I can run SQL query as follows:

    SELECT *
    FROM `zen_orders_total`
    WHERE `class` = 'ot_reward_points'

    However this shows the total points claimed for all time with no dates. For now I am removing the orders (by order number) that fall outside of the date range manually. Surely there must be an easier way....

    Again any suggestions????

  2. #132
    Join Date
    May 2012
    Location
    Dallas, Texas
    Posts
    11
    Plugin Contributions
    0

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

    I just installed Rewards Points Suite v2.5 on out Zen Cart 1.51. It appears to work as advertised except all points are pending and I want them to be awarded immediately.

    Sunrise = 0
    Status Track I have set to Advanced Pend: [Void] Earn: [Registered, Processing, Delivered, Manual] all others ignore.

    The store is for registrations so we seldom CHANGE a status. Default is Registered. Maybe that is the problem?

    Is there a way to have points go directly to AWARDED status?

    Here is my config:
    Name:  reward_points2.jpg
Views: 354
Size:  40.7 KB

  3. #133
    Join Date
    May 2012
    Location
    Dallas, Texas
    Posts
    11
    Plugin Contributions
    0

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

    SpaceMonkey -

    Try something like this:
    SELECT *
    FROM zen_orders_total ot INNER JOIN zen_orders o on ot.orders_id = o.orders_id
    WHERE `class` = 'ot_reward_points'
    and date_purchased > '2015-01-31'

    If you just want to filter this might be better:

    Select * from zen_orders_total
    Where orders_id in (SELECT o.orders_id
    FROM zen_orders_total ot INNER JOIN zen_orders o on ot.orders_id = o.orders_id
    WHERE `class` = 'ot_reward_points'
    and date_purchased > '2015-01-31')

    Since there is a time in the date_purchased field the > includes all orders on that date.

  4. #134
    Join Date
    Dec 2013
    Posts
    17
    Plugin Contributions
    0

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

    Hello,

    I've been using this plug-in for a few years now and it has always worked fine, until this weekend when it seems to have stopped applying any points that people are trying to use. I've made no changes to the settings or the code, no recent changes to the site at all.

    Any ideas as to why this might have happened?

    Thanks

    Running 1.5.4
    www.madrobotminiatures.com

  5. #135
    Join Date
    Dec 2013
    Posts
    17
    Plugin Contributions
    0

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

    OK, so I made some time to check the ZC logs and there are a bunch of errors, all the same thing:

    Invalid argument supplied for foreach() in /home/content/88/7710088/html/zencart/includes/functions/extra_functions/reward_points_functions.php on line 314

    That's about as far as I can get, any thoughts as to what could have caused this?

  6. #136
    Join Date
    Jun 2007
    Posts
    474
    Plugin Contributions
    2

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

    Quote Originally Posted by Joe Robot View Post
    OK, so I made some time to check the ZC logs and there are a bunch of errors, all the same thing:

    Invalid argument supplied for foreach() in /home/content/88/7710088/html/zencart/includes/functions/extra_functions/reward_points_functions.php on line 314

    That's about as far as I can get, any thoughts as to what could have caused this?
    Step 1 is to look in that file at that line of code. I copied that section below. Line 314 is the 'foreach' line. Have you installed any other Order Total Modules recently or adjusted the advanced calculation setting? Also, what version of ZEn-Cart and this module are you using?

    function GetRewardPointAdvancedCalculateValue()
    {
    $value=0;

    $module_list=GetRewardPointAdvancedCalculateTable();

    foreach($module_list as $module)
    if($module['action']=="Subtract")
    $value-=GetOrderTotalValue($module['module']);
    else
    $value+=GetOrderTotalValue($module['module']);

    return $value;
    }

  7. #137
    Join Date
    Jun 2007
    Posts
    474
    Plugin Contributions
    2

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

    Quote Originally Posted by osulywan View Post
    I just installed Rewards Points Suite v2.5 on out Zen Cart 1.51. It appears to work as advertised except all points are pending and I want them to be awarded immediately.

    Sunrise = 0
    Status Track I have set to Advanced Pend: [Void] Earn: [Registered, Processing, Delivered, Manual] all others ignore.

    The store is for registrations so we seldom CHANGE a status. Default is Registered. Maybe that is the problem?

    Is there a way to have points go directly to AWARDED status?

    Here is my config:
    Name:  reward_points2.jpg
Views: 354
Size:  40.7 KB
    I came here to ask the same thing. I have hit the same issue.

  8. #138
    Join Date
    Dec 2013
    Posts
    17
    Plugin Contributions
    0

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

    Thanks for that, I installed the latest version and everything has been sorted out.

    Thank you for your response :)

  9. #139
    Join Date
    Aug 2009
    Posts
    368
    Plugin Contributions
    0

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

    I'm trying to upgrade from 2.5b to 2.5e and after running Upgrade-to-2.5e.sql I have the following error:

    INSERT INTO configuration
    (configuration_id ,configuration_title ,configuration_key ,configuration_value ,configuration_description ,configuration_group_id ,sort_order ,last_modified ,date_added ,use_function ,set_function)
    VALUES (NULL , 'Show Reward Points on Product Info Display Page', 'SHOW_REWARD_POINTS_PRODUCT', '0', 'Display Reward Points on product info display page?<br />0= No<br />1= Yes', @cgi, '1', NULL, now(), NULL , 'zen_cfg_select_option(array(''0'', ''1''), ');

    #1062 - Duplicate entry 'SHOW_REWARD_POINTS_PRODUCT' for key 'unq_config_key_zen'


    What should I do now ?

  10. #140
    Join Date
    Jun 2007
    Posts
    474
    Plugin Contributions
    2

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

    Quote Originally Posted by lindasdd View Post
    I came here to ask the same thing. I have hit the same issue (pending points not moving to Earned.)
    A quick fix is to run the following SQL in the admin SQL patch page whenever you want to transfer all of them:
    UPDATE reward_customer_points SET reward_points = (reward_points+pending_points),pending_points = 0;

 

 
Page 14 of 37 FirstFirst ... 4121314151624 ... LastLast

Similar Threads

  1. First 1.0 Release of Reward Points module [Support Thread]
    By hem in forum All Other Contributions/Addons
    Replies: 38
    Last Post: 4 Apr 2013, 02:34 PM

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