The database tag has no wiki summary.
0
votes
2answers
10 views
Delete custom EAV attributes from the database
I want to remove unused EAV attributes directly from the database before I move my store live. Attributes can be found in eav_attribute table, can I delete attributes from this table? Is it safe? Or ...
1
vote
1answer
50 views
CE 1.7: Merge two different databases in 1
Well Hello,
I've the need to merge 2 different databases together. But! I need to keep some data from 1 and other data from the other one...
DB 1: is a multisite setup
DB 2: is only 1 website...
...
0
votes
1answer
16 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 ...
1
vote
1answer
47 views
Magento keeps invoking install script after deployment
I'm trying to move my Magento store from local to web server. But I run into a problem:
The install wizzard pops out, I can't figure out why.
What I tryed till now:
Double checked the database ...
0
votes
1answer
24 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
2answers
25 views
Select Product Where Price Is Greater Than Zero
Given the following code:
$mageProductCollection = Mage::getModel('catalog/product')
->getCollection()
->addAttributeToSelect('*')
...
0
votes
1answer
37 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
3answers
21 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 ...
1
vote
2answers
53 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 ...
1
vote
1answer
25 views
How do I add additional options to customer gender?
I have a client who would like to add the option 'Transgender' in addition to Male and Female in the gender field.
Can I do this directly in the database? Would I need to update anything beyond the ...
2
votes
1answer
50 views
Importing attributes to a new magento installation
What are the tables I need to dump to be able to import them in a new installation?
I need this to avoid reinserting all the custom attributes for every new Magento installation.
thanks
1
vote
1answer
52 views
Database — What are log_url + log_visitor ? Can I truncate them?
I've to move a 9.8GB database from a live server to local so I can fix stuff without going offline. But, I just noticed that there are
log_url_info = ~23,039,809 = 2.1 GiB
log_url = ...
0
votes
1answer
40 views
I can't cancel orders. Integrity Constraint Violation
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 ...
1
vote
2answers
148 views
Moving Products from 1.4 to 1.7 - dilemma
I've to move a lot of products from an old Magento site (v. 1.4) to a new one (1.7) with fresh new theme with new modules it's also a multisite, infact there' already a lot of stuff I configured in ...
1
vote
1answer
114 views
How to add one custom field into register page and get it working?
I have been looking into some tutorials but none of them works, for example, first they told me to open xxx files and edit something but what I found on my files is just a class with no single method ...
1
vote
0answers
41 views
How to override the graph in dashboard
I have a table included some data about warehouse operation (order_id, phase, duration, datetime, order_canceled), so I need to draw a graph to present these data for performance management.
I tried ...
3
votes
1answer
50 views
Mechanics of the new Changelog Tables (ex: catalog_category_product_cat_cl)
I just spotted the mentioned tables in the database. I think they are new in Magento EE 1.13 and might be related to the new indexing.
+----------------------------------------+
| ...
0
votes
2answers
84 views
Add a custom field per store view
I need to add a custom field(drop down list) for a store view, what is the conditional statement I need to display this, it would be nice to have it dynamic and have it added in the admin side. Would ...
2
votes
1answer
64 views
Is it upgrade safe to add custom address attributes
currently i am developing a Magento extension, that needs to add several custom attributes to customer address.
I've found several tutorials on the topic that describe precisely what i need to build
...
2
votes
3answers
112 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 ...
5
votes
5answers
280 views
Clearing Magento after testing
I am currently doing a lot of tests in Magento so I can get familiar with it. Unfortunately the database is extremely cluttered with my tests. I wish to clear up the database so I can start over ...
0
votes
1answer
111 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
87 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
108 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 ...
0
votes
1answer
48 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 ...
0
votes
1answer
88 views
Magento displays same page inside the visible page when trying to send/receive data from another php [closed]
I'm trying to make a new functionality on a custom backend module that I've created a few weeks ago.
The new functionality consists in making a query in order to list in a 'select-option' some data ...
0
votes
1answer
138 views
Where are stored the group prices on magento database?
I'm developing a module in backend that displays the 'group prices' of the products, but I don't know where are them stored in the database in order to show them. If anyone has some idea I will ...
0
votes
1answer
93 views
How to execute large sql query in magento?
I want to store huge content in db and my sample text is 16129 characters in length when i tried to execute this query it is showing "error:The requested URL could not be retrieved" in firefox and ...
0
votes
1answer
290 views
Adding a new eav attribute type “file upload”
I need to have the ability to add a file upload at the admin site and process the files after these have been uploaded. As a first step I like to extend Magento eav attributes with a new custom type ...
1
vote
2answers
88 views
Can I use another database for media_storage?
While you can only use MySQL for the main Magento database, you can use Redis and Memcached for fast cache and session storage. This is particularly useful for cluster systems.
So what about for ...
1
vote
1answer
115 views
using time in special price from/to
i'm trying to set a time in the product special price to/from dates (i.e., special price from 3/20/2013 11am EST to 4/20/2013 10:59am EST), but i cannot get a time to show up or save.
when i enter a ...
0
votes
1answer
49 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
85 views
addAttributeToSort by ASC ignor null values
i try to sort my product collection.
At first it should be sorted by alphabet (A,B,C..) and then by other character like NULL ...
This is my code which I have tried...
return ...
0
votes
1answer
52 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
1answer
97 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
1answer
19 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)
...
0
votes
2answers
81 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
2answers
74 views
How can I filter Reviews based on their average rating to only display above a certain amount?
I'm trying to change up the review list block on our website such that it only displays the top three latest four star or higher reviews.
Currently I am trying to go about this in the following ...
0
votes
1answer
160 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
3answers
171 views
Convert a production database into test data
The closer a test is to production, the better it can emulate production behavior. I would like to copy the database backups from production into our test environments, but what do I need to change so ...
5
votes
2answers
184 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 ...
3
votes
1answer
144 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
...
1
vote
1answer
41 views
Setup Script Not Working Properly
I need to add attribute through a setup script.Attribute properties are working,but the frontend properties are not applied as specified in the setup script.For example, visible_on_front ...
2
votes
2answers
61 views
How to enable database logging without modifying the core?
I am afraid that this might be a rhetorical question, but:
Is there any other and cleaner way to enable DB logging then modifying the file Varien/Db/Adapter/Pdo/Mysql.php and set $_debug and ...
5
votes
1answer
120 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
2answers
144 views
Setting a product to in-stock raises foreign key exception
When executing the following:
$product = Mage::getModel('catalog/product')->load($id);
$stock_item = $product->getStockItem();
$stock_item->setIsInStock(true);
$stock_item->save();
...
1
vote
1answer
597 views
How to save form data to multiple tables in database
I have created a form in admin panel with various fields. Now the fields here doesn't belong to one single table. On the save, I want some values go into one particular table while others to go into ...
1
vote
2answers
333 views
Custom module with custom database table and per store settings
I am creating a custom module with a custom database table using the following tutorial.
This module is a custom contact form, and I would like the settings for that custom contact form to be on a ...
7
votes
2answers
350 views
Install scripts: Creating tables vs. updating existing ones
have one question, recently I was developing one module with a lot of tables in DB, and concept was changing often, so was need to change existing tables in DB, and I noticed difference in table ...
11
votes
6answers
1k views
Price re-index causes DB deadlocks during checkout
I'm experiencing an issue where I believe the Product Price re-indexing process is causing a deadlock exception in the checkout process.
I caught this exception in the checkout process:
Order ...
