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:
- Flush the cache (System>>Cache Management)
- Disable the cache
- Disable Compilation (System>>Tools>>Compilation)
- Go to Connect Manager (System>>Magento Connect>>Magento Connect Manager
- 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) - Select updates, click "Update"
- Wait....
- Click "Refresh"
- Check the file permissions (They are likely messed up.)
- delete
.maintenanceFlag - Re-index, re-enable cache, re-enable compilation
Manually Cleaning Log Files
- Open the database in phpMyAdmin via the SiteWorx control panel.
- 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 - At the bottom of the page, from the "With Selected" list, and select "Empty".
- A confirmation screen will appear. Click "Yes". This will truncate all of the selected tables.
- Click the "Structure" tab at the top of the page.
- Select the same tables as you did in Step 2, then under the "With Selected" list, select "Optimize".