Magento

System Requirements

System Requirements for 1.9.3.1:

• PHP 5.6
• PHP Memory Limit: 256MB or higher
• MySQL 5.6
• Required PHP Extensions:
• PHP_MySQL
• simplexml
• mcrypt
• has
• GD
• DOM
• iconv
• curl
• SOAP

Database Info

Database info is stored at:

<DocumentRoot>/app/etc/local.xml

File Permissions (500 Errors)

If you get an Internal Server Error 500, the most likely cause is bad file permissions. Set the permissions as follows:

Directories: 755
Files: 644

Maintenance Mode

If the site says it is in maintenance mode:

Delete the file: .maintenanceFlag from the Magento root directory

Upgrading

To upgrade Magento from the Connect Manager:

1. Flush the cache (System>>Cache Management)
2. Disable the cache
3. Disable Compilation (System>>Tools>>Compilation)
4. Go to Connect Manager (System>>Magento Connect>>Magento Connect Manager
5. click the "Check for Updates" button
   (You can use the following extension key if new updates don't show up:
   http://connect20.magentocommerce.com/community/Mage_All_Latest)
6. Select updates, click "Update"
7. Wait....
8. Click "Refresh"
9. Check the file permissions (They are likely messed up.)
10. delete .maintenanceFlag
11. Re-index, re-enable cache, re-enable compilation

Manually Cleaning Log Files

1. Open the database in phpMyAdmin via the SiteWorx control panel.
2. In the right frame, select the check box for the following tables:
   dataflow_batch_export
   dataflow_batch_import
   log_customer
   log_quote
   log_summary
   log_summary_type
   log_url
   log_url_info
   log_visitor
   log_visitor_info
   log_visitor_online
   report_viewed_product_index
   report_compared_product_index
   report_event
3. At the bottom of the page, from the "With Selected" list, and select "Empty".
4. A confirmation screen will appear. Click "Yes". This will truncate all of the selected tables.
5. Click the "Structure" tab at the top of the page.
6. Select the same tables as you did in Step 2, then under the "With Selected" list, select "Optimize".

References

1. Magento Home Page
2. Magento Database Maintenance
3. Codexpedia - Turn on Magento debugging