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.
3,729
questions
2
votes
2
answers
3k
views
Get Image url from database
How to get image from database and display it in magento?
my imgs.php is:
$a = $_SESSION['id'];
$ob = Mage::getModel('management/file')->getCollection();
$res = $ob->...
2
votes
1
answer
10k
views
how to Fetch data from database in magento [closed]
Which methods are available for fetching information from the Magento database?
- 7,495
0
votes
1
answer
137
views
Two Tables, Cannot retrieve entity config on second table when joining tables
Problem
I'm creating a simple module that contains two tables named:
city_faq
city_faq_section
I'm having a difficult time joining city_faq with city_faq_section. Each time I try to do so, I ...
CommunityBot
- 1
4
votes
1
answer
406
views
addColumn() or addAttribute() ? What is the best for performance, migration & usability?
What is the best method of adding new attributes to the sales and/or quote tables in magento via an install script:
use: addColumn() or use addAttribute() ?
So the main questions are :
What is ...
- 16.7k
2
votes
0
answers
27
views
Search results getting concatenated by a word I put somewhere. How did I manage that and how to revert it? [closed]
This may sound stupid (it really is) but I recently noticed the word "test" is being concatenated to all product names on the catalog search page. I'm almost certain this was my doing (I like to ...
- 173
1
vote
1
answer
583
views
How to manually convert a series of quotes to invoices (orders)
For about 24 hours yesterday we were experiencing an issue where Magento could not create new invoices. It has since been resolved but I now have a series of orders (22) that are trapped in the ...
- 76
1
vote
1
answer
366
views
Where does Magento get its value for sales_flat_invoice.increment_id?
I've been digging around in the database and the web trying to determine how this numbering system works.
I see that sales_flat_invoice.increment_id has the following information:
`increment_id` ...
- 8,223
0
votes
2
answers
727
views
How to handle this database error when copying for staging environment?
I wanted to copy my live shop (1.9.0.1) to a staging environment.
The first time i did it it went ok, but i have configured the VAT and tax in admin sales>taxes and that is working ok, but for some ...
CommunityBot
- 1
0
votes
1
answer
629
views
catalog_product_entity_media_gallery in mysql is missing
I'm using magento 1.8,
I want to import products with a csv file. the file is okay, but i get this error:
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a ...
- 6,104
1
vote
1
answer
120
views
Why is tax_class_id reset to 0 [closed]
I hope someone can help. We have a very strange problem. We found out that some products didn't have tax in the shop so we had a look in de backend. The right class is selected when editing a product ...
- 123
0
votes
1
answer
708
views
How to raise the next increment for customer_id.entity_id in database
To summarize, I'm attempting to merge two Magento installs. I have a series of customers that I'm trying to incorporate from one instance into another.
With that being said... I would like customer ...
CommunityBot
- 1
1
vote
2
answers
4k
views
MySQL deadlock on catalogsearch_query
I am getting deadlocks on this table catalogsearch_query. The table has approx 500k rows.
The site is averaging about 2000 concurrent users.
Edit: To clarify concurrent users I mean the following:
...
- 6,104
0
votes
1
answer
472
views
Select only reviews that have an image using addFieldToFilter
I'm currently doing the following query to get the reviews from the review table.
$summaryData = Mage::getModel('review/review')->getCollection()
->addStoreFilter(Mage::app()->getStore()-...
- 81
2
votes
1
answer
302
views
Learning Magento extension Development [closed]
I am New in Magento i want to Develop magento Extension I know Php and MySql and web Development . I am finding easiest way to Learn Magento developing
- 1,726
2
votes
2
answers
5k
views
Set Magento MySQL Connection to use SSL
We have a Magento site on a VM with 2GB of RAM. Right now, both Apache and MySQL are running on that same VM. Since that's just not enough RAM for this site, I have been tasked with separating the ...
- 141
2
votes
3
answers
284
views
Is there an extension to log messages in db and then browse them in backend?
I'm dealing with a development task that needs the client to be able to read log messages. The client has no access to filesystem, so common log files are not usable.
I was thinking about logging ...
- 198k
0
votes
1
answer
438
views
Error logging into magento admin, magento-1.9 [duplicate]
There has been an error processing your request
SQLSTATE[HY000] [1045] Access denied for user 'dev_bechnus'@'localhost' (using password: YES)
Trace:
0 /home/dev/public_html/lib/Zend/Db/Adapter/Pdo/...
- 6,104
1
vote
1
answer
923
views
Magento Enterprise (1.14) modify admin password via database
How do I go about changing an admin account password in the database in Magento 1.14 (enterprise)
Is it sha(256) with a 32 character salt
- 2,973
0
votes
2
answers
1k
views
Getting product information from a external database
I have been given an unfinished product from a client, and it is a mess.
This is my first time ever using Magento, but I have used other CMS's. So please bare with me as I am a "newbie". I do have ...
- 27.2k
1
vote
2
answers
949
views
Database error - reindex
I have an error in the database.
The problem occured in the index, Catalog search index, and I can't reindex data.
I deleted all files in /var/locks and tried to do it manually with the command php ...
CommunityBot
- 1
1
vote
0
answers
92
views
Using group() in Magento EE with SOLR breaks pagination in Magento [closed]
When using GROUP BY (MySQL statement) on collections in Magento CE, we need to apply something similar to https://stackoverflow.com/questions/3485455/using-group-breaks-getselectcountsql-in-magento so ...
CommunityBot
- 1
2
votes
0
answers
190
views
mysql fields max length of for each data type [closed]
I am checking for maximum length of each data type fields in magento.
For example "Text" field, magento has many text fields by default, so what is the maximum length of the default text fields.
and ...
- 3,136
2
votes
1
answer
264
views
Magento 1.8 not recognizing forward slash after base_url (was working)
I have posted this to stackexchange.com as well, before noticing that in the details of the forums not accepting new questions
I have noticed the issue when the CSS appeared to be broken. Heres what ...
CommunityBot
- 1
0
votes
2
answers
174
views
Magento relaunch: Migration of live and test databases
our agency has a local magento test environment. Database was a clone from a day XY in the past.
Since then, the old, live magento has got new customers, new orders.
Do you have some tips for ...
CommunityBot
- 1
2
votes
1
answer
4k
views
F5 key Flood and "Error log record number reporting" page
I have a VM testing Magento. Configuration is classic LAMP. Everything works fine but I discovered a big issue in running Magento. F5 flood.
1) Visit any page you want.
2) Keep F5 key pressed. Page ...
- 17.3k
2
votes
1
answer
223
views
Sql for this query
Can someone tell me the Sql that this query runs?
$category = Mage::getModel('catalog/category')->getCollection();
$category->addAttributeToFilter("Top_Menu" , array('eq' => '146'...
- 6,127
1
vote
2
answers
842
views
Moving URLs and files on the server: Do I need to change something in the database before the move?
I have purchased some disk space and two domains from my hosting
provider. I am currently not using a dedicated IP + SSL certificate
because I am just testing. In fact both of the following two sites
...
- 17.6k
1
vote
1
answer
6k
views
Change store id value
I'm working on a store with one store which has store id = 1. I want to write a db query that will update this id to something else (say 9 for example). Which table should I look for to edit this and ...
- 198k
0
votes
2
answers
3k
views
Only the Homepage is showing after moving Magento
I've just moved a Magento website to another server and domain.
I adjusted the secure and unsecure url path in the cofig data table and also adjusted the config.xml. After that i've also cleared the ...
- 37.5k
-1
votes
1
answer
216
views
Magento change hosting
Today I changed one magento to another server. But I have one problem:
In the new server, all my products have automatically set:
special price to 0.00
all data fields to: 30/11/2000
In categories ...
0
votes
2
answers
226
views
Attempting to merge a different shopping cart with Magento
I have an ambitious goal of merging about 1000 orders from a custom, shopping cart solution (not Magento) that we used before my company switched to Magento. This is for the sake of customer service ...
CommunityBot
- 1
12
votes
2
answers
12k
views
Ok to truncate report_viewed_product_index
I was reading through the list of tables that are ok to truncate (https://stackoverflow.com/questions/12205714/list-of-tables-to-safely-truncate-in-magento) and I didn't see
...
CommunityBot
- 1
0
votes
2
answers
829
views
Bundle items not showing in cart
I have a bundle product with a number of bundled items all with default amount 1.
For some reason, Magento is only showing 1 (the first one) of my bundled items in the cart!
I have a local Magento ...
- 271
2
votes
3
answers
3k
views
What are reasons for a Magento database become huge?
I am not sure if I am allowed to ask this here but I have a curiosity. Is it normal that a Magento with 800 orders to have 600mb? Also there are only 20 products (12 configurable, 3 bundles)
CommunityBot
- 1
3
votes
2
answers
6k
views
How to delete extension completely
I tried to install ADDTHISS social networks extension, on first attempt it installed successfully but it was not working properly so I tried re-installing. Now if I try installation, I am getting this ...
CommunityBot
- 1
1
vote
1
answer
366
views
Custom SQL for Reporting on catalogsearch_query Table
I'm having trouble writing a query for grouping and concatenating query IDs on Magento's catalogsearch_query table.
Summary: Can I "CONCAT" results of a GROUP_CONCAT?
Here's what I have:
SELECT
...
- 2,699
4
votes
2
answers
595
views
Extending newsletter functionality correctly
I have previously made a module which would allow a user to sign up for newsletters and decide on which type of newsletters they would receive e.g. promotion, new lines etc. This module was my first ...
CommunityBot
- 1
0
votes
1
answer
45
views
Inline transaltion no longer editable
Hi I have an inline translation which is no longer showing up with a red box around it, and so I am unable to edit the content from the front end.
Inspecting the element it should be held in "...
- 37.5k
1
vote
1
answer
160
views
Is setIdFieldName dangerous for db objects?
Varien_Objects and their descendents provide a way to refer to objects by ids by another name.
/**
* set name of object id field
* ...
- 37.5k
1
vote
1
answer
496
views
Is it safe to truncate the catalogindex_* tables?
My Magento installation (1.4.1) contains the following tables:
catalogindex_price
catalogindex_minimal_price
catalogindex_eav
catalogindex_aggregation
catalogindex_aggregation_tag
...
CommunityBot
- 1
0
votes
1
answer
1k
views
Does sales_shipping_aggregated relate to the sale_flat_order table? How?
I see that there are not any relationships from sales_shipping_aggregated to the sales_flat_order table. I'm trying to determine if there is a relationship to anything other than ...
- 13.9k
1
vote
1
answer
1k
views
In the database, what is the relationship between the customer_entity table and sales?
I'm trying to merge Magento orders between two different stores and I'm tracking down all of the relationships. The one I'm currently trying to figure out is the customer_entity table and the sales_* ...
- 13.9k
0
votes
1
answer
337
views
MySQL attribute values auto increment count values of 1
I require to bulk update a set of attribute values in magento. After some struggle i have come up with the following which updates my attribute values starting with 400100 adding +1 for the next and ...
- 198k
1
vote
1
answer
698
views
Invoice ID Column Null in Credit Memo Table
Has anybody else noticed that the invoice_id column in sales_flat_creditmemo is always Null?
The order_id column is populated, but nothing in the invoice_id column. Is this just me?
- 1,724
-1
votes
1
answer
1k
views
SQLSTATE[42S02]: Base table or view not found: 1146 Table db name xyz.core_url_rewrite' doesn't exist
in local this error are display in my magento website plzz give me right answer
thanks
CommunityBot
- 1
0
votes
2
answers
4k
views
My DB file size over 700 MB Any problem?
I just exported my DB and found my DB file size 761 MB
I think this is too heavy and effect badly to admin performance
Am I something wrong while running store? Is it okay with this big db file ...
- 18.1k