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 2079
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.
7
votes
Magento Table Creation Using ORM Method
For future reference, the following syntax will add a TINYINT(1) field - for which BOOLEAN is a MySQL alias:
->addColumn('is_active', Varien_Db_Ddl_Table::TYPE_BOOLEAN, 1, array(
'nullable' => fa …
- 1,531
0
votes
1
answer
528
views
Add Product Id Array To Custom Table From Admin
I want the id's of selected products (those the user has ticked) to go into my database field in the form of a single-dimensional array (1,2,3,4).
Is this insane, possible, sort-of-crazy? … I have the module and the product table but I can't get the data into the database. Any pointers would be helpful, thank you! …
- 1,531
8
votes
3
answers
4k
views
Is It Worthwhile To Use A Separate MySQL Server?
My question: is it worthwhile to split the MySQL database onto a separate server, which only serves the database. … I then want to have multiple servers which contain the codebase and serve apache, interfacing with the database box. All will be virtual containers. …
- 1,531
3
votes
2
answers
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. …
- 1,531
2
votes
2
answers
8k
views
Select Product Where Price Is Greater Than Zero
Given the following code:
$mageProductCollection = Mage::getModel('catalog/product')
->getCollection()
->addAttributeToSelect('*')
…
- 1,531
6
votes
Accepted
Magento MySQL Has Gone Away Error
Issue resolved! Thanks to all for the help. This was a hardware firewall issue with the web host, even after they were disabled by us.
As confirmed by 1&1's server team, the hardware firewalls were c …
- 1,531
15
votes
7
answers
28k
views
Magento MySQL Has Gone Away Error
www/html/domain.com/live/lib/Varien/Autoload.php on line 93
Warning: include(): Failed opening 'File.php' for inclusion
I have looked most of the articles I can find about this and tinkered with the database …
- 1,531