magento 1 query generated back tics are wrongly placedProduct Collection for Default CategoryCreate invoice and shipment in magento via cron based on store view and order ageError report in var/report ,what does it mean? and is it serious problem? It keep create those error report and take 1.7 GB space alreadySubselect as main_table on magento collectionsql to query to Magento queryhow can i add shipping carrier column in admin pageMagento 1.9: How to show instock items first in product listing even after using sortingProblem in creating custom reports for inventory forecastingMagento - Add customer attribute to order gridCan't run CRON PDOException Magento 1.9.3.8

Giant Toughroad SLR 2 for 200 miles in two days, will it make it?

Why are all the doors on Ferenginar (the Ferengi home world) far shorter than the average Ferengi?

Teaching indefinite integrals that require special-casing

Is there a problem with hiding "forgot password" until it's needed?

What if somebody invests in my application?

Organic chemistry Iodoform Reaction

Indicating multiple different modes of speech (fantasy language or telepathy)

Is there an wasy way to program in Tikz something like the one in the image?

What will be the temperature on Earth when Sun finishes its main sequence?

Reply ‘no position’ while the job posting is still there (‘HiWi’ position in Germany)

Installing PowerShell on 32-bit Kali OS fails

What to do when my ideas aren't chosen, when I strongly disagree with the chosen solution?

Female=gender counterpart?

Is there a good way to store credentials outside of a password manager?

Visiting the UK as unmarried couple

Simulating a probability of 1 of 2^N with less than N random bits

How can I raise concerns with a new DM about XP splitting?

Lifted its hind leg on or lifted its hind leg towards?

What does the "3am" section means in manpages?

Proving by induction of n. Is this correct until this point?

What will be the benefits of Brexit?

How to prevent YouTube from showing already watched videos?

Could solar power be utilized and substitute coal in the 19th century?

Is exact Kanji stroke length important?



magento 1 query generated back tics are wrongly placed


Product Collection for Default CategoryCreate invoice and shipment in magento via cron based on store view and order ageError report in var/report ,what does it mean? and is it serious problem? It keep create those error report and take 1.7 GB space alreadySubselect as main_table on magento collectionsql to query to Magento queryhow can i add shipping carrier column in admin pageMagento 1.9: How to show instock items first in product listing even after using sortingProblem in creating custom reports for inventory forecastingMagento - Add customer attribute to order gridCan't run CRON PDOException Magento 1.9.3.8













0















I have an issue in Magento 1, where the SQL query that is getting generated has the back tics wrongly placed.



This is a piece of the code that helps to provide the collection to the grid layout.



protected function _prepareCollection()

$accountId = $this->getRequest()->getParam('id');
$collection = Mage::getResourceModel('testmodule/coupon_collection');


if (Mage::helper('testmodulecoupon')->isMultiProgram()
&& Mage::helper('core')->isModuleEnabled('Test_module')
)
$collection->getSelect()->joinLeft(
array('p' => $collection->getTable('testmodule/account')),
'main_table.program_id = p.program_id AND main_table.account_id = p.account_id',
array()
)->joinLeft(
array('r' => $collection->getTable('testmodule/program')),
'main_table.program_id = r.program_id',
array('status' => 'IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))')
);
else
$collection->addFieldToFilter('program_id', array('eq'=>0));

$collection->addFieldToFilter('main_table.account_id',$accountId);

$this->setCollection($collection);
return parent::_prepareCollection();



In the above code, this part of the line is generating the back tics wrongly.



array('status' => 'IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))') 


This is part of SQL query that is generating.



(`IF (main_table`.`program_id = 0, 1, IF(p`.`id AND r`.`use_coupon, 1, 0))` = '1')


I was not able to find a proper solution to fix this. Can anyone help on this ?
thanks










share|improve this question


























    0















    I have an issue in Magento 1, where the SQL query that is getting generated has the back tics wrongly placed.



    This is a piece of the code that helps to provide the collection to the grid layout.



    protected function _prepareCollection()

    $accountId = $this->getRequest()->getParam('id');
    $collection = Mage::getResourceModel('testmodule/coupon_collection');


    if (Mage::helper('testmodulecoupon')->isMultiProgram()
    && Mage::helper('core')->isModuleEnabled('Test_module')
    )
    $collection->getSelect()->joinLeft(
    array('p' => $collection->getTable('testmodule/account')),
    'main_table.program_id = p.program_id AND main_table.account_id = p.account_id',
    array()
    )->joinLeft(
    array('r' => $collection->getTable('testmodule/program')),
    'main_table.program_id = r.program_id',
    array('status' => 'IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))')
    );
    else
    $collection->addFieldToFilter('program_id', array('eq'=>0));

    $collection->addFieldToFilter('main_table.account_id',$accountId);

    $this->setCollection($collection);
    return parent::_prepareCollection();



    In the above code, this part of the line is generating the back tics wrongly.



    array('status' => 'IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))') 


    This is part of SQL query that is generating.



    (`IF (main_table`.`program_id = 0, 1, IF(p`.`id AND r`.`use_coupon, 1, 0))` = '1')


    I was not able to find a proper solution to fix this. Can anyone help on this ?
    thanks










    share|improve this question
























      0












      0








      0








      I have an issue in Magento 1, where the SQL query that is getting generated has the back tics wrongly placed.



      This is a piece of the code that helps to provide the collection to the grid layout.



      protected function _prepareCollection()

      $accountId = $this->getRequest()->getParam('id');
      $collection = Mage::getResourceModel('testmodule/coupon_collection');


      if (Mage::helper('testmodulecoupon')->isMultiProgram()
      && Mage::helper('core')->isModuleEnabled('Test_module')
      )
      $collection->getSelect()->joinLeft(
      array('p' => $collection->getTable('testmodule/account')),
      'main_table.program_id = p.program_id AND main_table.account_id = p.account_id',
      array()
      )->joinLeft(
      array('r' => $collection->getTable('testmodule/program')),
      'main_table.program_id = r.program_id',
      array('status' => 'IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))')
      );
      else
      $collection->addFieldToFilter('program_id', array('eq'=>0));

      $collection->addFieldToFilter('main_table.account_id',$accountId);

      $this->setCollection($collection);
      return parent::_prepareCollection();



      In the above code, this part of the line is generating the back tics wrongly.



      array('status' => 'IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))') 


      This is part of SQL query that is generating.



      (`IF (main_table`.`program_id = 0, 1, IF(p`.`id AND r`.`use_coupon, 1, 0))` = '1')


      I was not able to find a proper solution to fix this. Can anyone help on this ?
      thanks










      share|improve this question














      I have an issue in Magento 1, where the SQL query that is getting generated has the back tics wrongly placed.



      This is a piece of the code that helps to provide the collection to the grid layout.



      protected function _prepareCollection()

      $accountId = $this->getRequest()->getParam('id');
      $collection = Mage::getResourceModel('testmodule/coupon_collection');


      if (Mage::helper('testmodulecoupon')->isMultiProgram()
      && Mage::helper('core')->isModuleEnabled('Test_module')
      )
      $collection->getSelect()->joinLeft(
      array('p' => $collection->getTable('testmodule/account')),
      'main_table.program_id = p.program_id AND main_table.account_id = p.account_id',
      array()
      )->joinLeft(
      array('r' => $collection->getTable('testmodule/program')),
      'main_table.program_id = r.program_id',
      array('status' => 'IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))')
      );
      else
      $collection->addFieldToFilter('program_id', array('eq'=>0));

      $collection->addFieldToFilter('main_table.account_id',$accountId);

      $this->setCollection($collection);
      return parent::_prepareCollection();



      In the above code, this part of the line is generating the back tics wrongly.



      array('status' => 'IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))') 


      This is part of SQL query that is generating.



      (`IF (main_table`.`program_id = 0, 1, IF(p`.`id AND r`.`use_coupon, 1, 0))` = '1')


      I was not able to find a proper solution to fix this. Can anyone help on this ?
      thanks







      magento-1.9 sql query grid-layout






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked 14 mins ago









      kaushik kumar roykaushik kumar roy

      257




      257




















          1 Answer
          1






          active

          oldest

          votes


















          0














          Try to build that part of the query using Zend_Db_Expr object. This way should work correctly:



          array('status' => new Zend_Db_Expr('IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))'))




          share






















            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%2f267355%2fmagento-1-query-generated-back-tics-are-wrongly-placed%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            Try to build that part of the query using Zend_Db_Expr object. This way should work correctly:



            array('status' => new Zend_Db_Expr('IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))'))




            share



























              0














              Try to build that part of the query using Zend_Db_Expr object. This way should work correctly:



              array('status' => new Zend_Db_Expr('IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))'))




              share

























                0












                0








                0







                Try to build that part of the query using Zend_Db_Expr object. This way should work correctly:



                array('status' => new Zend_Db_Expr('IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))'))




                share













                Try to build that part of the query using Zend_Db_Expr object. This way should work correctly:



                array('status' => new Zend_Db_Expr('IF (main_table.program_id = 0, 1, IF(p.id AND r.use_coupon, 1, 0))'))





                share











                share


                share










                answered 5 mins ago









                HelgeBHelgeB

                2,8031321




                2,8031321



























                    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.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f267355%2fmagento-1-query-generated-back-tics-are-wrongly-placed%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

                    HP P840 HDD RAID 5 many strange drive faiuresHP SmartArray P400: How to repair failed logical drive?Reusing Raid 5 Drive?reliably and automatically determine connection path of physical position of HDD from /dev/sdX device fileHow to replace failed drive in RAID 5 array in HP DL380 G4 serverQuestions on increasing RAID 5 arrayRaid 10, Logical device are missingHP Code 341 “Physical Drive State: Predictive failure. This physical drive is predicted to fail soon.”HPE 1.92TB SATA 6G Mixed Use SFF SSD very slow compared to SAS HDD HP disksHP drive array “ready for rebuild” (RAID5)Hard Disc Failure or RAID Glitch

                    Jalkaväkirykmentti 49 (jatkosota) Sisällysluettelo Perustaminen | Keskittäminen | Komentaja(t) | Lähteet | NavigointivalikkoInfobox OKlaajentamalla

                    Can Not View Content Blocks due to require.js error - Magento 2 theme change Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?get requirejs-config.js to load declared cdn's for jqueryOverride Magento/Checkout/view/frontend/web/js/view/shipping.js in custom theme not workingAdding Custom JS to Magento 2 Themerequire.js error on Magento 2Magento 2 require js throw errorMagento 2.1.2 regionUpdater js error on register.phtmlError loading popper.js on Magento 2 Theme (require js)requirejs error in my child themeIssue with bootstrap 4 in magento 2Magento 2 checkout page keeps on loading.In console,$.event.props is undefined in jquery.mobile.custom.js:44:2.How to clear that?Magento 2 Stuck on Checkout page