People who code: we want your input. Take the Survey

Questions tagged [database]

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.

Filter by
Sorted by
Tagged with
0
votes
1answer
1k views

Sku field null in category_product_flat tables

We have a store, Magento 1.6 with circa 4500 products. Half of the products approx are having this issue: Symptoms... Admin Product Grid -> sort by SKU causes a fatal error. Admin Product Grid -> ...
2
votes
1answer
1k views

How to create delete url to delete row from table

How to create an URL for a link (on frontend),that ,when clicked, will call a function that deletes a row from the table. Manually it works :) public function deleteMessage($id) { Mage::...
1
vote
1answer
1k views

Update Product Names To Title Case

After exporting my previous database, allot of my product names where upper case. I now want to run a sql query to update the product names to title case. What is correct way to do this
1
vote
1answer
791 views

How do you set Allow Countries directly in the database, programmatically or using n98-magerun?

I have a list of over 200 countries I need to allow for an EE 1.13 site. I'd prefer not to do this through the admin interface because it is tedious and I am error prone. Is it possible to set Allow ...
0
votes
2answers
1k views

Tables indexes - too little or too many

we have a Magento installation @ Mage 1.7. We've been around since 1.3 ... What we are seeing more and more is that certain indexes appear that are no longer in Mage 1.7. For example we have an ...
0
votes
1answer
210 views

How to update the child table

I am currently struggling through my first magento project and it seems to be leaving me with asking more questions than it has answered. My current hurdle is adding default data to a child table. I ...
1
vote
1answer
1k views

Magento - Can't connect to Mysql server error frequently

We have a dedicated server with a virtual instance running the application server with Apache, PHP and a virtual instance with DB on it. We are running Magento 1.7.0 version on the application server ...
0
votes
1answer
656 views

addFieldToFilter doesn't return the right product for selected attribute values

I am currently programming a product configurator module for Magento. Everything is working fine so far besides the core functionality: choosing the right product from the database for the selected ...
1
vote
1answer
3k views

Not saving data to database in magento

Hi i write valid queries for data insertion but not successeded.If i print that query and excute it on sql server it works.I didn't figure out why this not works. This is my table structure. CREATE ...
2
votes
1answer
2k views

Reorder problem with custom quote attribute

I've defined a custom attribute called productcomment on sales_flat_quote_item and in sales_flat_order_item and the problem is when i want to reorder an specific order, the values are not copied. The ...
0
votes
1answer
4k views

“Database connection error” when installing 1.7.0.2 on Ubuntu

I'm installing Magento version 1.7.0.2 on an Ubuntu VM, hosted in Azure - I'm getting "Database connection error" in the Magento Installation Wizard. I've installed PHP & MySQL as instructed here....
0
votes
1answer
5k views

Help connecting Magento to a third-party REST API

I need to update Magento products using a third party API. What is the best method of doing so. Should I trigger an API call when an event/observer hits on product detail page? There is no OAuth yet, ...
0
votes
1answer
573 views

Update Option Type Checkbox to Dropdown

I want to edit my Magento option type for 181 products, changing checkbox and radio to dropdown Can i just create a mySQL query to change field in catalog_product_option, replacing checkbox and radio ...
0
votes
1answer
84 views

Move products and attributes from 1.4 db dump

I have a db dump from an old magento installation. From this I would like to move all products and attributes. The db dump was taked from a 1.4 instllation and it will be going to a 1.7 This is not ...
0
votes
1answer
487 views

Add Product Id Array To Custom Table From Admin

I think I've kicked the hornets nest. I have a custom db table. I am displaying a list of products in admin similar to the related products tab or the upsell tab. I want the id's of selected products ...
1
vote
2answers
7k views

Select Product Where Price Is Greater Than Zero

Given the following code: $mageProductCollection = Mage::getModel('catalog/product') ->getCollection() ->addAttributeToSelect('*') ...
2
votes
3answers
2k views

Safe for model method to rely on loaded model state?

Is it safe for a model method to rely on the model being in a loaded state i.e. accessing a data value? An simplified example: public function testMethod() { return 100 x $this->getData('...
3
votes
2answers
8k views

Magento Table Creation Using ORM Method

I'm trying to create a new table in the Magento database using Magento's *Varien_Db_Ddl_Table*. Using fresh Magento 1.7.0.2 CE install for this. I'm at a loss for syntax though. I'm trying to create ...
2
votes
3answers
2k views

How to sync Database between live and test system, when scheme has changed (How to export orders)

I have upgraded Magento CE from 1.4.1.1 to 1.7.0.2. Between this versions the database scheme has changed. This means, i can't easily export the database from the live system to the test system. And ...
0
votes
1answer
993 views

I can't cancel orders. Integrity Constraint Violation [closed]

Whenever i try to delete an order, by entering the order and then clicking cancel, i get a "The order has not been cancelled" Message. I tried deleting the order from the list, and issuing an action ...
0
votes
1answer
187 views

Customer selects type of configurable product > Query for vendors with that product [closed]

I would like some advice on how to go about this project before I start! We are developing a Magento site where other vendors can sell their product. My first project: "Get product structure to ...
5
votes
1answer
9k views

Query to return customer order history?

I am trying to dump historical customer order data from a legacy ecommerce site that we restored from an AMI. Ideally this would grab customer ID, email, order date, product SKUs ordered, and order ...
0
votes
1answer
968 views

Modify price adjustment of configurable products through API.

I'm trying to modify my configurable attributes options that I have set in Magento, but upon save I recieve a PDO error saying that it's a duplicate. I haven't been able to find a way to set these ...
30
votes
1answer
18k views

Which MySQL Server provides a better performance for Magento

What do you use as a MySQL Server for Magento? MySQL (Oracle) Percona others (MariaDB) Percona provides a set of improvments for InnoDB storage used by Magento intensively, but these improvements do ...
1
vote
1answer
438 views

Load Configurable Pricing Adjustments

I'm trying to import configurable products with the price corrections. The products and the relations are already in, but I can't seem to get the price corrections working. This is what the ...
4
votes
1answer
4k views

Magento running under MSSQL

Has anyone managed to get Magento running under MSSQL? Since 1.6 there is the possiblity to change the PDO driver, using some steps: Rename Mysql.php files to Mssql.php app/code/core/mage/Core/Model/...
0
votes
1answer
191 views

Admin module custom select not saveing

Ok so I've created a custom module that has a single table model with a active select (no, yes) and a title and image. Now when I save the title saves and updates fine, the image is deleted or updated ...
1
vote
2answers
3k views

SQL install script doesn't run when caches are turned on

I created an SQL installation script for my extension and it ran just fine. I was developing the extension with the caches turned off. When I turn the caches on, the installation script doesn't get ...
4
votes
1answer
3k views

Magento Reviews - When do they get aggregated?

Can somebody provide some insight for when reviews get put into the rating_option_vote_aggregated table? I'm trying to filter through my reviews based on four stars or higher and I was looking to use ...
0
votes
2answers
651 views

Importing large inventory kills the mysql server

I am using Magento data flow profiles for importing a very large inventory (has about 13000 products) and updating it three times a week.. i saw that after importing the products, the site is going ...
0
votes
1answer
345 views

Multiple Where Statements

I have the following line of code $select = $read->select() ->from($batchTable,array('id','batch','strength','flavor','brand')) ->where('status', 1) ->...
8
votes
1answer
266 views

For a cms/block entity, why are the subordinate data deleted from cms_page_store explicitly?

cms/block entities have a join table cms_block_store, the records in which link a given block to one or more stores. Prior to CE 1.6, the resource model Mage_Cms_Model_Mysql4_Block (link) does not ...
0
votes
1answer
577 views

How to add a custom field to Magento catalog_product_option_type_value table

I'm just wondering if there is an easier way? What I was going to do is create my own custom table with a reference to the option_type_id from the catalog_product_option_type_value because I don't ...
6
votes
1answer
366 views

Magento: what is the `customer_payment` entity type used for?

Short version: In our Magento database we have 40 records in our customer_entity table that have an entity_type_id that maps to an entity_type_code of 'customer_payment' in the eav_entity_type table. ...
5
votes
2answers
510 views

Combine Magento TAF with EcomDev_PHPUnit fixtures

I want to use the Magento Test Automation Framework to create a Smoke Test Suite, i.e. a test suite that quickly tests a cross section of the store to check for serious errors, not to test the correct ...

1
67 68 69 70
71