catalog price rules disappear after mid night












5














enter image description herewe have a problem with catalog price rules in 1.9.0



we have some 1000 products in a site.



we applied catalog price rules to give discount for 500 products.



i did't gave any date limit for catalog price rules



those special prices are displaying only until mid night.



next day, after mid- night special prices are not displaying in site.



cron is working fine.



please help me to find some solution.










share|improve this question
























  • Can you please verify your Cron is setup properly? Following my answer here magento.stackexchange.com/questions/64876/…
    – Alvin Nguyen
    May 15 '15 at 6:59










  • @Alvin, please check here : prntscr.com/75e1fb i used this extension : magentocommerce.com/magento-connect/aoe-scheduler.html i am getting message as in the image.
    – Baby in Magento
    May 15 '15 at 7:06










  • please check the updated question with image.
    – Baby in Magento
    May 15 '15 at 10:13










  • How long does the cron take (if u receive cron-mails - prints in the scheduler scripts are ugly but quick)? Perhaps your AOE-scheduler could help. Are there some other process running (db-backup?) Is the sequence right?
    – Andreas Dyballa
    May 15 '15 at 14:37
















5














enter image description herewe have a problem with catalog price rules in 1.9.0



we have some 1000 products in a site.



we applied catalog price rules to give discount for 500 products.



i did't gave any date limit for catalog price rules



those special prices are displaying only until mid night.



next day, after mid- night special prices are not displaying in site.



cron is working fine.



please help me to find some solution.










share|improve this question
























  • Can you please verify your Cron is setup properly? Following my answer here magento.stackexchange.com/questions/64876/…
    – Alvin Nguyen
    May 15 '15 at 6:59










  • @Alvin, please check here : prntscr.com/75e1fb i used this extension : magentocommerce.com/magento-connect/aoe-scheduler.html i am getting message as in the image.
    – Baby in Magento
    May 15 '15 at 7:06










  • please check the updated question with image.
    – Baby in Magento
    May 15 '15 at 10:13










  • How long does the cron take (if u receive cron-mails - prints in the scheduler scripts are ugly but quick)? Perhaps your AOE-scheduler could help. Are there some other process running (db-backup?) Is the sequence right?
    – Andreas Dyballa
    May 15 '15 at 14:37














5












5








5


1





enter image description herewe have a problem with catalog price rules in 1.9.0



we have some 1000 products in a site.



we applied catalog price rules to give discount for 500 products.



i did't gave any date limit for catalog price rules



those special prices are displaying only until mid night.



next day, after mid- night special prices are not displaying in site.



cron is working fine.



please help me to find some solution.










share|improve this question















enter image description herewe have a problem with catalog price rules in 1.9.0



we have some 1000 products in a site.



we applied catalog price rules to give discount for 500 products.



i did't gave any date limit for catalog price rules



those special prices are displaying only until mid night.



next day, after mid- night special prices are not displaying in site.



cron is working fine.



please help me to find some solution.







magento-1.9 cron catalog-price-rules






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited May 15 '15 at 9:45

























asked May 15 '15 at 4:53









Baby in Magento

8311352164




8311352164












  • Can you please verify your Cron is setup properly? Following my answer here magento.stackexchange.com/questions/64876/…
    – Alvin Nguyen
    May 15 '15 at 6:59










  • @Alvin, please check here : prntscr.com/75e1fb i used this extension : magentocommerce.com/magento-connect/aoe-scheduler.html i am getting message as in the image.
    – Baby in Magento
    May 15 '15 at 7:06










  • please check the updated question with image.
    – Baby in Magento
    May 15 '15 at 10:13










  • How long does the cron take (if u receive cron-mails - prints in the scheduler scripts are ugly but quick)? Perhaps your AOE-scheduler could help. Are there some other process running (db-backup?) Is the sequence right?
    – Andreas Dyballa
    May 15 '15 at 14:37


















  • Can you please verify your Cron is setup properly? Following my answer here magento.stackexchange.com/questions/64876/…
    – Alvin Nguyen
    May 15 '15 at 6:59










  • @Alvin, please check here : prntscr.com/75e1fb i used this extension : magentocommerce.com/magento-connect/aoe-scheduler.html i am getting message as in the image.
    – Baby in Magento
    May 15 '15 at 7:06










  • please check the updated question with image.
    – Baby in Magento
    May 15 '15 at 10:13










  • How long does the cron take (if u receive cron-mails - prints in the scheduler scripts are ugly but quick)? Perhaps your AOE-scheduler could help. Are there some other process running (db-backup?) Is the sequence right?
    – Andreas Dyballa
    May 15 '15 at 14:37
















Can you please verify your Cron is setup properly? Following my answer here magento.stackexchange.com/questions/64876/…
– Alvin Nguyen
May 15 '15 at 6:59




Can you please verify your Cron is setup properly? Following my answer here magento.stackexchange.com/questions/64876/…
– Alvin Nguyen
May 15 '15 at 6:59












@Alvin, please check here : prntscr.com/75e1fb i used this extension : magentocommerce.com/magento-connect/aoe-scheduler.html i am getting message as in the image.
– Baby in Magento
May 15 '15 at 7:06




@Alvin, please check here : prntscr.com/75e1fb i used this extension : magentocommerce.com/magento-connect/aoe-scheduler.html i am getting message as in the image.
– Baby in Magento
May 15 '15 at 7:06












please check the updated question with image.
– Baby in Magento
May 15 '15 at 10:13




please check the updated question with image.
– Baby in Magento
May 15 '15 at 10:13












How long does the cron take (if u receive cron-mails - prints in the scheduler scripts are ugly but quick)? Perhaps your AOE-scheduler could help. Are there some other process running (db-backup?) Is the sequence right?
– Andreas Dyballa
May 15 '15 at 14:37




How long does the cron take (if u receive cron-mails - prints in the scheduler scripts are ugly but quick)? Perhaps your AOE-scheduler could help. Are there some other process running (db-backup?) Is the sequence right?
– Andreas Dyballa
May 15 '15 at 14:37










4 Answers
4






active

oldest

votes


















1














You might need to do reindexing. Please reindex once then check it is working or not.






share|improve this answer





















  • I reindexed everyhting using "Index management" in admin panel. every status is "ready" ,but still it disappeared today also.
    – Baby in Magento
    May 15 '15 at 5:00






  • 1




    can you give me access of admin panel because it's tough to know the problem without that?
    – Saurabh
    May 15 '15 at 5:14










  • hi @saurabh this is my cron settings : prntscr.com/75dnv9 if you tell what you need to see, i will post the screen shots, i am not in a position to give credentials....
    – Baby in Magento
    May 15 '15 at 5:58



















4














source : https://stackoverflow.com/questions/25280095/magento-catalog-price-rule-disappears-at-night



credits for genius "Alexei Yerofeyev". mostly i will never forget this man.



Yes, this is a bug in Magento (or some logic beyond my understanding). When Magento displays products on frontend, it checks if there are catalog rules for this date. And the date used for this check is your local, so in your case GMT+5. However, when catalog rules are being applied, it uses GMT date. So that means that you aren't able to apply rules until 5 AM.



The problem is in Mage_CatalogRule_Model_Action_Index_Refresh::execute() function. You will have to rewrite this function/class either in your extension, or via the local version of the file.



You have to replace line 121 here :



app/code/core/Mage/CatalogRule/Model/Action/Index/Refresh.php

$timestamp = $coreDate->gmtTimestamp('Today');


with this line:



$timestamp = Mage::app()->getLocale()->date(null, null, null, true)->get(Zend_Date::TIMESTAMP);


After that you should be able to apply the rules.






share|improve this answer























  • This solution doesn't work for 1.9.2.2. I have still strange catalog rules disappering. Any fixes? I use GMT+2 timezone. Any other hints? I also tried this extension magentocommerce.com/magento-connect/fix-catalog-rules.html but it got even worse. Catalog Price resets were triggered each day. now its triggered when some things are changed in store - like extension is updated etc.
    – sellio
    Jan 18 '16 at 20:31










  • @sellio please post new question with what and all you tried and other details, hopefully you will get an answer.....
    – Baby in Magento
    Jan 18 '16 at 20:34



















1














As stated above by @Baby-in-Magento the problem is with the indexer.



I had this problem as well, the issue exists when there is an offset of the local timezone greater than +01:00.



Basically just because magento is using the gmtTimestamp for the rule date which in the above stated case results in the day before today.



Therefor I developed a small module https://github.com/Chuvisco88/Chuvisco_CatalogRuleFix to fix the issue.
If someone ever has this problem, please give it a try.






share|improve this answer

















  • 1




    Chuvisco, than you for this. I installed your solution yesterday and today - voila! The rules still show up after 0100 AM. Thanks a lot! [Magento 1.9.3.2]
    – Sparc
    Dec 22 '17 at 2:03





















1














In my setup the solution was to set the mysql timezone same as the magento timezone
I managed it by using this initStatement in my local.xml file






share|improve this answer








New contributor




user498529 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.


















    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "479"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f67970%2fcatalog-price-rules-disappear-after-mid-night%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    4 Answers
    4






    active

    oldest

    votes








    4 Answers
    4






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    1














    You might need to do reindexing. Please reindex once then check it is working or not.






    share|improve this answer





















    • I reindexed everyhting using "Index management" in admin panel. every status is "ready" ,but still it disappeared today also.
      – Baby in Magento
      May 15 '15 at 5:00






    • 1




      can you give me access of admin panel because it's tough to know the problem without that?
      – Saurabh
      May 15 '15 at 5:14










    • hi @saurabh this is my cron settings : prntscr.com/75dnv9 if you tell what you need to see, i will post the screen shots, i am not in a position to give credentials....
      – Baby in Magento
      May 15 '15 at 5:58
















    1














    You might need to do reindexing. Please reindex once then check it is working or not.






    share|improve this answer





















    • I reindexed everyhting using "Index management" in admin panel. every status is "ready" ,but still it disappeared today also.
      – Baby in Magento
      May 15 '15 at 5:00






    • 1




      can you give me access of admin panel because it's tough to know the problem without that?
      – Saurabh
      May 15 '15 at 5:14










    • hi @saurabh this is my cron settings : prntscr.com/75dnv9 if you tell what you need to see, i will post the screen shots, i am not in a position to give credentials....
      – Baby in Magento
      May 15 '15 at 5:58














    1












    1








    1






    You might need to do reindexing. Please reindex once then check it is working or not.






    share|improve this answer












    You might need to do reindexing. Please reindex once then check it is working or not.







    share|improve this answer












    share|improve this answer



    share|improve this answer










    answered May 15 '15 at 4:58









    Saurabh

    364210




    364210












    • I reindexed everyhting using "Index management" in admin panel. every status is "ready" ,but still it disappeared today also.
      – Baby in Magento
      May 15 '15 at 5:00






    • 1




      can you give me access of admin panel because it's tough to know the problem without that?
      – Saurabh
      May 15 '15 at 5:14










    • hi @saurabh this is my cron settings : prntscr.com/75dnv9 if you tell what you need to see, i will post the screen shots, i am not in a position to give credentials....
      – Baby in Magento
      May 15 '15 at 5:58


















    • I reindexed everyhting using "Index management" in admin panel. every status is "ready" ,but still it disappeared today also.
      – Baby in Magento
      May 15 '15 at 5:00






    • 1




      can you give me access of admin panel because it's tough to know the problem without that?
      – Saurabh
      May 15 '15 at 5:14










    • hi @saurabh this is my cron settings : prntscr.com/75dnv9 if you tell what you need to see, i will post the screen shots, i am not in a position to give credentials....
      – Baby in Magento
      May 15 '15 at 5:58
















    I reindexed everyhting using "Index management" in admin panel. every status is "ready" ,but still it disappeared today also.
    – Baby in Magento
    May 15 '15 at 5:00




    I reindexed everyhting using "Index management" in admin panel. every status is "ready" ,but still it disappeared today also.
    – Baby in Magento
    May 15 '15 at 5:00




    1




    1




    can you give me access of admin panel because it's tough to know the problem without that?
    – Saurabh
    May 15 '15 at 5:14




    can you give me access of admin panel because it's tough to know the problem without that?
    – Saurabh
    May 15 '15 at 5:14












    hi @saurabh this is my cron settings : prntscr.com/75dnv9 if you tell what you need to see, i will post the screen shots, i am not in a position to give credentials....
    – Baby in Magento
    May 15 '15 at 5:58




    hi @saurabh this is my cron settings : prntscr.com/75dnv9 if you tell what you need to see, i will post the screen shots, i am not in a position to give credentials....
    – Baby in Magento
    May 15 '15 at 5:58













    4














    source : https://stackoverflow.com/questions/25280095/magento-catalog-price-rule-disappears-at-night



    credits for genius "Alexei Yerofeyev". mostly i will never forget this man.



    Yes, this is a bug in Magento (or some logic beyond my understanding). When Magento displays products on frontend, it checks if there are catalog rules for this date. And the date used for this check is your local, so in your case GMT+5. However, when catalog rules are being applied, it uses GMT date. So that means that you aren't able to apply rules until 5 AM.



    The problem is in Mage_CatalogRule_Model_Action_Index_Refresh::execute() function. You will have to rewrite this function/class either in your extension, or via the local version of the file.



    You have to replace line 121 here :



    app/code/core/Mage/CatalogRule/Model/Action/Index/Refresh.php

    $timestamp = $coreDate->gmtTimestamp('Today');


    with this line:



    $timestamp = Mage::app()->getLocale()->date(null, null, null, true)->get(Zend_Date::TIMESTAMP);


    After that you should be able to apply the rules.






    share|improve this answer























    • This solution doesn't work for 1.9.2.2. I have still strange catalog rules disappering. Any fixes? I use GMT+2 timezone. Any other hints? I also tried this extension magentocommerce.com/magento-connect/fix-catalog-rules.html but it got even worse. Catalog Price resets were triggered each day. now its triggered when some things are changed in store - like extension is updated etc.
      – sellio
      Jan 18 '16 at 20:31










    • @sellio please post new question with what and all you tried and other details, hopefully you will get an answer.....
      – Baby in Magento
      Jan 18 '16 at 20:34
















    4














    source : https://stackoverflow.com/questions/25280095/magento-catalog-price-rule-disappears-at-night



    credits for genius "Alexei Yerofeyev". mostly i will never forget this man.



    Yes, this is a bug in Magento (or some logic beyond my understanding). When Magento displays products on frontend, it checks if there are catalog rules for this date. And the date used for this check is your local, so in your case GMT+5. However, when catalog rules are being applied, it uses GMT date. So that means that you aren't able to apply rules until 5 AM.



    The problem is in Mage_CatalogRule_Model_Action_Index_Refresh::execute() function. You will have to rewrite this function/class either in your extension, or via the local version of the file.



    You have to replace line 121 here :



    app/code/core/Mage/CatalogRule/Model/Action/Index/Refresh.php

    $timestamp = $coreDate->gmtTimestamp('Today');


    with this line:



    $timestamp = Mage::app()->getLocale()->date(null, null, null, true)->get(Zend_Date::TIMESTAMP);


    After that you should be able to apply the rules.






    share|improve this answer























    • This solution doesn't work for 1.9.2.2. I have still strange catalog rules disappering. Any fixes? I use GMT+2 timezone. Any other hints? I also tried this extension magentocommerce.com/magento-connect/fix-catalog-rules.html but it got even worse. Catalog Price resets were triggered each day. now its triggered when some things are changed in store - like extension is updated etc.
      – sellio
      Jan 18 '16 at 20:31










    • @sellio please post new question with what and all you tried and other details, hopefully you will get an answer.....
      – Baby in Magento
      Jan 18 '16 at 20:34














    4












    4








    4






    source : https://stackoverflow.com/questions/25280095/magento-catalog-price-rule-disappears-at-night



    credits for genius "Alexei Yerofeyev". mostly i will never forget this man.



    Yes, this is a bug in Magento (or some logic beyond my understanding). When Magento displays products on frontend, it checks if there are catalog rules for this date. And the date used for this check is your local, so in your case GMT+5. However, when catalog rules are being applied, it uses GMT date. So that means that you aren't able to apply rules until 5 AM.



    The problem is in Mage_CatalogRule_Model_Action_Index_Refresh::execute() function. You will have to rewrite this function/class either in your extension, or via the local version of the file.



    You have to replace line 121 here :



    app/code/core/Mage/CatalogRule/Model/Action/Index/Refresh.php

    $timestamp = $coreDate->gmtTimestamp('Today');


    with this line:



    $timestamp = Mage::app()->getLocale()->date(null, null, null, true)->get(Zend_Date::TIMESTAMP);


    After that you should be able to apply the rules.






    share|improve this answer














    source : https://stackoverflow.com/questions/25280095/magento-catalog-price-rule-disappears-at-night



    credits for genius "Alexei Yerofeyev". mostly i will never forget this man.



    Yes, this is a bug in Magento (or some logic beyond my understanding). When Magento displays products on frontend, it checks if there are catalog rules for this date. And the date used for this check is your local, so in your case GMT+5. However, when catalog rules are being applied, it uses GMT date. So that means that you aren't able to apply rules until 5 AM.



    The problem is in Mage_CatalogRule_Model_Action_Index_Refresh::execute() function. You will have to rewrite this function/class either in your extension, or via the local version of the file.



    You have to replace line 121 here :



    app/code/core/Mage/CatalogRule/Model/Action/Index/Refresh.php

    $timestamp = $coreDate->gmtTimestamp('Today');


    with this line:



    $timestamp = Mage::app()->getLocale()->date(null, null, null, true)->get(Zend_Date::TIMESTAMP);


    After that you should be able to apply the rules.







    share|improve this answer














    share|improve this answer



    share|improve this answer








    edited May 23 '17 at 12:37









    Community

    1




    1










    answered May 18 '15 at 6:31









    Baby in Magento

    8311352164




    8311352164












    • This solution doesn't work for 1.9.2.2. I have still strange catalog rules disappering. Any fixes? I use GMT+2 timezone. Any other hints? I also tried this extension magentocommerce.com/magento-connect/fix-catalog-rules.html but it got even worse. Catalog Price resets were triggered each day. now its triggered when some things are changed in store - like extension is updated etc.
      – sellio
      Jan 18 '16 at 20:31










    • @sellio please post new question with what and all you tried and other details, hopefully you will get an answer.....
      – Baby in Magento
      Jan 18 '16 at 20:34


















    • This solution doesn't work for 1.9.2.2. I have still strange catalog rules disappering. Any fixes? I use GMT+2 timezone. Any other hints? I also tried this extension magentocommerce.com/magento-connect/fix-catalog-rules.html but it got even worse. Catalog Price resets were triggered each day. now its triggered when some things are changed in store - like extension is updated etc.
      – sellio
      Jan 18 '16 at 20:31










    • @sellio please post new question with what and all you tried and other details, hopefully you will get an answer.....
      – Baby in Magento
      Jan 18 '16 at 20:34
















    This solution doesn't work for 1.9.2.2. I have still strange catalog rules disappering. Any fixes? I use GMT+2 timezone. Any other hints? I also tried this extension magentocommerce.com/magento-connect/fix-catalog-rules.html but it got even worse. Catalog Price resets were triggered each day. now its triggered when some things are changed in store - like extension is updated etc.
    – sellio
    Jan 18 '16 at 20:31




    This solution doesn't work for 1.9.2.2. I have still strange catalog rules disappering. Any fixes? I use GMT+2 timezone. Any other hints? I also tried this extension magentocommerce.com/magento-connect/fix-catalog-rules.html but it got even worse. Catalog Price resets were triggered each day. now its triggered when some things are changed in store - like extension is updated etc.
    – sellio
    Jan 18 '16 at 20:31












    @sellio please post new question with what and all you tried and other details, hopefully you will get an answer.....
    – Baby in Magento
    Jan 18 '16 at 20:34




    @sellio please post new question with what and all you tried and other details, hopefully you will get an answer.....
    – Baby in Magento
    Jan 18 '16 at 20:34











    1














    As stated above by @Baby-in-Magento the problem is with the indexer.



    I had this problem as well, the issue exists when there is an offset of the local timezone greater than +01:00.



    Basically just because magento is using the gmtTimestamp for the rule date which in the above stated case results in the day before today.



    Therefor I developed a small module https://github.com/Chuvisco88/Chuvisco_CatalogRuleFix to fix the issue.
    If someone ever has this problem, please give it a try.






    share|improve this answer

















    • 1




      Chuvisco, than you for this. I installed your solution yesterday and today - voila! The rules still show up after 0100 AM. Thanks a lot! [Magento 1.9.3.2]
      – Sparc
      Dec 22 '17 at 2:03


















    1














    As stated above by @Baby-in-Magento the problem is with the indexer.



    I had this problem as well, the issue exists when there is an offset of the local timezone greater than +01:00.



    Basically just because magento is using the gmtTimestamp for the rule date which in the above stated case results in the day before today.



    Therefor I developed a small module https://github.com/Chuvisco88/Chuvisco_CatalogRuleFix to fix the issue.
    If someone ever has this problem, please give it a try.






    share|improve this answer

















    • 1




      Chuvisco, than you for this. I installed your solution yesterday and today - voila! The rules still show up after 0100 AM. Thanks a lot! [Magento 1.9.3.2]
      – Sparc
      Dec 22 '17 at 2:03
















    1












    1








    1






    As stated above by @Baby-in-Magento the problem is with the indexer.



    I had this problem as well, the issue exists when there is an offset of the local timezone greater than +01:00.



    Basically just because magento is using the gmtTimestamp for the rule date which in the above stated case results in the day before today.



    Therefor I developed a small module https://github.com/Chuvisco88/Chuvisco_CatalogRuleFix to fix the issue.
    If someone ever has this problem, please give it a try.






    share|improve this answer












    As stated above by @Baby-in-Magento the problem is with the indexer.



    I had this problem as well, the issue exists when there is an offset of the local timezone greater than +01:00.



    Basically just because magento is using the gmtTimestamp for the rule date which in the above stated case results in the day before today.



    Therefor I developed a small module https://github.com/Chuvisco88/Chuvisco_CatalogRuleFix to fix the issue.
    If someone ever has this problem, please give it a try.







    share|improve this answer












    share|improve this answer



    share|improve this answer










    answered Jul 19 '17 at 8:20









    Chuvisco

    90110




    90110








    • 1




      Chuvisco, than you for this. I installed your solution yesterday and today - voila! The rules still show up after 0100 AM. Thanks a lot! [Magento 1.9.3.2]
      – Sparc
      Dec 22 '17 at 2:03
















    • 1




      Chuvisco, than you for this. I installed your solution yesterday and today - voila! The rules still show up after 0100 AM. Thanks a lot! [Magento 1.9.3.2]
      – Sparc
      Dec 22 '17 at 2:03










    1




    1




    Chuvisco, than you for this. I installed your solution yesterday and today - voila! The rules still show up after 0100 AM. Thanks a lot! [Magento 1.9.3.2]
    – Sparc
    Dec 22 '17 at 2:03






    Chuvisco, than you for this. I installed your solution yesterday and today - voila! The rules still show up after 0100 AM. Thanks a lot! [Magento 1.9.3.2]
    – Sparc
    Dec 22 '17 at 2:03













    1














    In my setup the solution was to set the mysql timezone same as the magento timezone
    I managed it by using this initStatement in my local.xml file






    share|improve this answer








    New contributor




    user498529 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      1














      In my setup the solution was to set the mysql timezone same as the magento timezone
      I managed it by using this initStatement in my local.xml file






      share|improve this answer








      New contributor




      user498529 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





















        1












        1








        1






        In my setup the solution was to set the mysql timezone same as the magento timezone
        I managed it by using this initStatement in my local.xml file






        share|improve this answer








        New contributor




        user498529 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
        Check out our Code of Conduct.









        In my setup the solution was to set the mysql timezone same as the magento timezone
        I managed it by using this initStatement in my local.xml file







        share|improve this answer








        New contributor




        user498529 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
        Check out our Code of Conduct.









        share|improve this answer



        share|improve this answer






        New contributor




        user498529 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
        Check out our Code of Conduct.









        answered yesterday









        user498529

        111




        111




        New contributor




        user498529 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
        Check out our Code of Conduct.





        New contributor





        user498529 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
        Check out our Code of Conduct.






        user498529 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
        Check out our Code of Conduct.






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Magento Stack Exchange!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.





            Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


            Please pay close attention to the following guidance:


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f67970%2fcatalog-price-rules-disappear-after-mid-night%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            An IMO inspired problem

            Management

            Has there ever been an instance of an active nuclear power plant within or near a war zone?