Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>In Magento, whenever you make changes to products, static blocks, etc, it recognizes that the data in the database is no longer the same as what it has in the cache. Unfortunately, Magento doesn't realize <strong>what</strong> cache data is different, just that <strong>something</strong> is different.</p> <p>You will need to go into <em>System > Cache Management</em> and refresh the invalidated cache types.</p> <p>EDIT:</p> <p>Create a module (or use an existing module) that you can use to set up a cron job for refreshing the cache. Create a file: {namespace}/{modulename}/Model/Observer.php</p> <p>Inside that file:</p> <pre><code>&lt;?php class &lt;namespace&gt;_&lt;modulename&gt;_Model_Observer { public function refreshCache() { try { $allTypes = Mage::app()-&gt;useCache(); foreach($allTypes as $type =&gt; $blah) { Mage::app()-&gt;getCacheInstance()-&gt;cleanType($type); } } catch (Exception $e) { // do something error_log($e-&gt;getMessage()); } } } </code></pre> <p>In your module's etc/config.xml:</p> <pre><code>&lt;config&gt; ... &lt;crontab&gt; &lt;jobs&gt; &lt;{modulename}_refresh_cache&gt; &lt;schedule&gt;&lt;cron_expr&gt;* * * * *&lt;/cron_expr&gt;&lt;/schedule&gt; &lt;run&gt;&lt;model&gt;{modulename}/observer::refreshCache&lt;/model&gt;&lt;/run&gt; &lt;/{modulename}_refresh_cache&gt; &lt;/jobs&gt; &lt;/crontab&gt; ... &lt;/config&gt; </code></pre> <p>Now as long as cron is configured correctly on your server, the cache will update automatically, as often as cron runs.</p>
    singulars
    1. This table or related slice is empty.
    1. POWhat does "invalidated" cache mean in Magento?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMagento Guy
    1. USMagento Guy
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWhat does "invalidated" cache mean in Magento?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COI understand how to refresh the cache, which I do when I see that it has been invalidated. I just don't really understand how it knows that the cache has been invalidated. And related- why doesn't it automatically refresh the cache if it knows it is invalid? Is there any risk to refreshing the cache?
      singulars
      1. PO
      1. USlocalfilmmaker
    2. COWhenever you make changes, magento fires events. There are listeners to these events that invalidate the relevant cache. As for why it does this (and why it doesn't automatically refresh) this is ultimately a design decision, but probably has something to do with being able to stage content. For example, you could make changes to several products that all relate to one another, and can then refresh the cache. I've overcome this with a cron job that runs every time cron runs on the server, and calls a function to refresh the cache automatically. I'll edit my original answer to include the code.
      singulars
      1. PO
      1. USMagento Guy
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload