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
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
asked 14 mins ago
kaushik kumar roykaushik kumar roy
257
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
asked 14 mins ago
kaushik kumar roykaushik kumar roy
257
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
asked 14 mins ago
kaushik kumar roykaushik kumar roy
257
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 14 mins ago
kaushik kumar roykaushik kumar roy
257
asked 14 mins ago
kaushik kumar roykaushik kumar roy
257
asked 14 mins ago
kaushik kumar roykaushik kumar roy
257
asked 14 mins ago
kaushik kumar roykaushik kumar roy
257
asked 14 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))'))
answered 5 mins ago
HelgeBHelgeB
2,8031321
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))'))
answered 5 mins ago
HelgeBHelgeB
2,8031321
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))'))
answered 5 mins ago
HelgeBHelgeB
2,8031321
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))'))
answered 5 mins ago
HelgeBHelgeB
2,8031321
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 5 mins ago
HelgeBHelgeB
2,8031321
answered 5 mins ago
HelgeBHelgeB
2,8031321
answered 5 mins ago
HelgeBHelgeB
2,8031321
answered 5 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
