Magento: Difference between revisions

From Psygen Wiki
Jump to navigation Jump to search
No edit summary
Line 52: Line 52:
   <li>Re-index, re-enable cache, re-enable compilation</li>
   <li>Re-index, re-enable cache, re-enable compilation</li>
</ol>
</ol>
== Manually Cleaning Log Files ==
<ol>
  <li>Open the database in phpMyAdmin via the SiteWorx control panel.</li>
  <li>In the right frame, select the check box for the following tables:<br />
      dataflow_batch_export<br />
      dataflow_batch_import<br />
      log_customer<br />
      log_quote<br />
      log_summary<br />
      log_summary_type<br />
      log_url<br />
      log_url_info<br />
      log_visitor<br />
      log_visitor_info<br />
      log_visitor_online<br />
      report_viewed_product_index<br />
      report_compared_product_index<br />
      report_event
  </li>
  <li>At the bottom of the page, from the "With Selected" list, and select "Empty".</li>
  <li>A confirmation screen will appear. Click "Yes". This will truncate all of the selected tables.</li>
  <li>Click the "Structure" tab at the top of the page.</li>
  <li>Select the same tables as you did in Step 2, then under the "With Selected" list, select "Optimize".</li>
</ol>


== References ==
== References ==
Line 57: Line 85:
<ol>
<ol>
   <li>[https://magento.com/products/community-edition Magento Home Page]</li>
   <li>[https://magento.com/products/community-edition Magento Home Page]</li>
  <li>[https://docs.nexcess.net/article/how-to-perform-magento-database-maintenance.html#sthash.BXdKg3Aj.dpuf Magento Database Maintenance]</li>
</ol>
</ol>

Revision as of 17:07, 23 January 2017

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


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