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
Simple image editor tool to draw a simple box/rectangle in an existing image
What to do when my ideas aren't chosen, when I strongly disagree with the chosen solution?
Are taller landing gear bad for aircraft, particulary large airliners?
Can a Gentile theist be saved?
Is there a good way to store credentials outside of a password manager?
Can I use my Chinese passport to enter China after I acquired another citizenship?
No idea how to draw this using tikz
Lightning Web Component - do I need to track changes for every single input field in a form
What if somebody invests in my application?
Can a Bard use an arcane focus?
Can the harmonic series explain the origin of the major scale?
What will be the temperature on Earth when Sun finishes its main sequence?
My boss asked me to take a one-day class, then signs it up as a day off
Indicating multiple different modes of speech (fantasy language or telepathy)
Golf game boilerplate
Should a half Jewish man be discouraged from marrying a Jewess?
How can a jailer prevent the Forge Cleric's Artisan's Blessing from being used?
Reply ‘no position’ while the job posting is still there (‘HiWi’ position in Germany)
Word describing multiple paths to the same abstract outcome
The One-Electron Universe postulate is true - what simple change can I make to change the whole universe?
Would it be legal for a US State to ban exports of a natural resource?
Superhero words!
Books on the History of math research at European universities
Is a naturally all "male" species possible?
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
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
add a comment |
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
add a comment |
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
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
magento-1.9 sql query grid-layout
asked 16 mins ago
kaushik kumar roykaushik kumar roy
257
257
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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))'))
add a comment |
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
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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))'))
add a comment |
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))'))
add a comment |
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))'))
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))'))
answered 6 mins ago
HelgeBHelgeB
2,8031321
2,8031321
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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