why i can't write anything to a custom cache table?

Question

First in mymodule.install I declared mymodule_schema(hook_schema) mymodule_install() and mymodule_unistall()

Where mymodule_schema() is like this:

function mymodule_schema() {
    $schema = array();
    $schema['cache_mymodule'] = drupal_get_schema_unprocessed('system', 'cache');
    return $schema;
}

this worked perfectly and table cache_mymodule with the same structue as table cache was created.
But in my code, using this:

$cid=some_calcuated_cid();
$cache=cache_get($cid,'cache_mymodule');
if (!$cache){
    $data = some_calcuated_data();
    cache_set($cid,$data,'cache_mymodule');
    dpm('CACHE SET');
else {
    dpm('used cache');
}

I always get 'CACHE SET', Now if i change 'cache_mymodule' to just cache, Or remove it, It works perfectly (saying used cache), Am I missing some hook in mymodule?

Answer 1

It looks like the problem is just a misnamed variable.

Surely

$data = some_calcuated_data();
cache_set($cid,$cache,'cache_mymodule');

should be

$data = some_calcuated_data();
cache_set($cid, $data, 'cache_mymodule');

At the moment you're setting the cache as NULL, any time it's already NULL...probably not what you were going for :)

Answer 2

You don't need to create your own table to use the internal cache. Just use cache_set() and cache_get() as documented. This will store the $my_data in the default 'cache' table:

// Store $my_data in cache.
cache_set($data_id, $my_data);

// Get $my_data from cache.
$data = cache_get($data_id);

Your code snippet should look something like this:

$cid = some_calcuated_cid();
$cache = cache_get($cid);

if (!$cache){
  $data = some_calcuated_data();
  cache_set($cid, $data);
}

Documentation:

cache_set()

cache_get()

Answer 3

In order to debug this, enable the mysql log which displays all queries executed (you will need a mysql restart)

mysqld.exe --log=path\to\log\file\your-log-file-name.log

This will give you a clue if the respective sql insert command is actually triggered and executed. And you should also check (via sql) if 'cache_mymodule' is empty or not after the code snippet execution.