Search Results
| 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 database
Search options not deleted
user 519
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.
24
votes
Accepted
How to "add to cart" a product with custom input field and save it to Database?
To accomplish this you could use Magento built-in "additional_options" functionality so that you don't have to edit email template, admin order view, customer order view (etc) to display your custom o …
8
votes
Change Magento 2 theme without using admin panel?
Try updating your theme id in core config database table
UPDATE core_config_data SET `value` = NULL WHERE path = 'design/theme/theme_id';
Also try
{magento root}/bin/magento setup:upgrade
{magento …
7
votes
Magento how to fetch row by row like PDO::fetch()
Take a look at How to convert sql query to magento in order to fetch data
$read = Mage::getSingleton('core/resource')->getConnection('core_read');
$readresult = $read->query("SELECT id FROM customer …
5
votes
Accepted
My magento website is not opening
See 1030 Got error 28 from storage engine
Mysql error "28 from storage engine" - means "not enough disk space".
To show disc space use command below.
myServer# df -h
3
votes
Accepted
Get order by id and customers that made the order
Try
<?php
require_once('app/Mage.php'); //Path to Magento
umask(0);
Mage::app();
$productId = 297;
$orders = Mage::getModel('sales/order')->getCollection();
$orders
->getSelect()
->jo …
3
votes
Accepted
In the database, what is the relationship between the customer_entity table and sales?
See sales_flat_order.customer_id
Since customer can check out as guest, then customer_id is either null for quest or contain the customer id for register member
2
votes
What are reasons for a Magento database become huge?
Some of the possible tables since you don't have a lot of products would be
sales quote tables
page view logs tables
See Magento database maintenance
But the best way to tell would be to list all … index_length) / 1024 / 1024), 2) "Size in MB"
FROM information_schema.TABLES
WHERE table_schema = "$DB_NAME"
ORDER BY (data_length + index_length) DESC;
See How to get the sizes of the tables of a mysql database …
1
vote
Accepted
Problem saving to database in custom extension
After add table or change your db structure you need to clear cache.
Change
Mage::getModel('zerobars_marketplacepolicies/marketplacepolicies')
to
Mage::getModel('marketplacepolicies/marketplacepo …
1
vote
Accepted
Trying to add address information like phone etc but only name, email and password get poste...
Try
$address_data = array (
'firstname' => 'fname here',
'lastname' => 'lastname here',
'street' => '123 test st',
'city' => 'city here',
. …
1
vote
Accepted
Set collection sort order to a specific value
Try
$consultantCollection->getSelect()->order(new Zend_Db_Expr("`firstname`='Peter' DESC"));
Should result in
Select .... ORDER BY `firstname`='Peter' DESC
Test Code
$customerCollection = Mage …
1
vote
Accepted
Does sales_shipping_aggregated relate to the sale_flat_order table? How?
Those tables are use for reporting (see Admin -> report -> sales -> shipping)
See
/app/code/core/Mage/Adminhtml/Block/Report/Sales/Shipping/Grid.php
class Mage_Adminhtml_Block_Report_Sales_Shippi …
1
vote
Attempting to merge a different shopping cart with Magento
Take a look at Clearing Magento after testing (sales related section).
It would be virtually impossible to recreate these orders from the db
A better approach would be
Use the API - Module: Shop …
1
vote
Show table in CMS Block
The correct way to do this would be to either create a custom module or widget.
But you could also include a custom template file and load the table data
{{block type="core/template" template="path/ …
1
vote
Does Magento have an uninstall for the db data and schema changes that an extension makes? I...
By default magento does not provide a way to undo database changes when removing modules. Some module provide will include a uninstall database script to run directly against the db. … To manually uninstall any module take a look at its install script and reverse the logic
It is always a good idea to do all testing in a development environment and make a backup copy of the database. …
1
vote
Accepted
migration- except home page all pages redirecting to old domain
Normally all you need to do is to log in to your database and update the base urls
update core_config_data set value = 'http://newdomain.com/' where path = 'web/unsecure/base_url';
update core_config_data …