Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 12293

Questions related to Magento's MySQL database, for example, the table schema, plain SQL queries or database configuration. For questions about the Magento database access layer, use other tags, like: eav, model, resource-model, collections, install-script. For questions about SQL queries in particular, the SQL tag is appropriate too.

0 votes

Magento 2 can't change host in env.php

here you can see working configuration of env.php. return array ( ... 'db' => array ( 'table_prefix' => '', 'connection' => array ( 'default' => array ( …
Amasty's user avatar
  • 6,518
5 votes
Accepted

Error: You cannot define a correlation name 'type_shirt_idx' more than once

It's because Magento tries to join the same filter with the same alias twice. Most common reason is you have 2 or more catalog/layer_view blocks at the page. Check the layout files and disable 3-d par …
Amasty's user avatar
  • 6,518
3 votes

Advice on closing orders that can not be viewed in a safe manner

The sales_flat_order_grid table only contains records that are visible on the grid. So if you remove any record from that table, the overall order storage will not be impacted and you'll not see this …
Amasty's user avatar
  • 6,518
2 votes

Do I have to escape this search $q input? (for sql injection)

Yes, you can safely use this function without any escape on your side. At the end of this function Magento call public function prepareSqlCondition($fieldName, $condition) and all passed variab …
Amasty's user avatar
  • 6,518
1 vote

Magento Each New Invoice Increment Id Increment By 5?

You can set different increment models for each document type in the database. Now they use the same class, so the changes affects all types. …
Amasty's user avatar
  • 6,518
1 vote

Creating a redeemption form that verifies coupon code and adds it to cart

May be you'd better develop it inside magento, say as a new block at the cms page + custom controller? So you can use $quote object inside your controller?
Amasty's user avatar
  • 6,518
0 votes

quickly update an attribute value for number of products belonging to a particular attribute...

Its available right from the admin panel: open the products grid, filter by the attribute set then select mass product action "change attributes" and specify the new value.
Amasty's user avatar
  • 6,518