.cache in database?

[Guest]

Hi,

 

I have moved my site (thank goodness for good hosting companies) and have had to rebuild my database (thanks too bad hosting companies). I rebuilt it correctly as far as I can tell, my admin section works fine, products load etc. But none of my regular pages will load. Instead, I get an error message saying:

1146 - Table 'xxxxx.cache' doesn't exist (xxxxx is my database name)

DELETE FROM cache WHERE cache_expires <= '2005-03-10 09:00:54'

[TEP STOP]

Does anybody know the table I need to build? I don't recall ever seeing it before. It's not listed in the database installation directions that come with osC, and I haven't been able to find anything about it in the forums.

 

Thanks for your help!

 

NS

[tina_boots]

Hi,

 

I have moved my site (thank goodness for good hosting companies) and have had to rebuild my database (thanks too bad hosting companies).  I rebuilt it correctly as far as I can tell, my admin section works fine, products load etc.  But none of my regular pages will load.  Instead, I get an error message saying:

1146 - Table 'xxxxx.cache' doesn't exist  (xxxxx is my database name)

DELETE FROM cache WHERE cache_expires <= '2005-03-10 09:00:54'

[TEP STOP]

Does anybody know the table I need to build?  I don't recall ever seeing it before.  It's not listed in the database installation directions that come with osC, and I haven't been able to find anything about it in the forums.

 

Thanks for your help!

 

NS

<{POST_SNAPBACK}>

 

Hmmm that appears to be a perplexing one. I did some checking and there is no table nor was I able to locate the code that creates that SQL string. Is your "Use Cache" setting set to true or false?

 

Be well,

 

Tina

[Guest]

Hi Tina,

 

Thanks for taking the time to ponder this one. It is set to false, which makes it even more complexing.

 

Thanks,

 

NS

[oblivion77]

Hi,

 

I have moved my site (thank goodness for good hosting companies) and have had to rebuild my database (thanks too bad hosting companies).  I rebuilt it correctly as far as I can tell, my admin section works fine, products load etc.  But none of my regular pages will load.  Instead, I get an error message saying:

1146 - Table 'xxxxx.cache' doesn't exist  (xxxxx is my database name)

DELETE FROM cache WHERE cache_expires <= '2005-03-10 09:00:54'

[TEP STOP]

Does anybody know the table I need to build?  I don't recall ever seeing it before.  It's not listed in the database installation directions that come with osC, and I haven't been able to find anything about it in the forums.

 

Thanks for your help!

 

NS

<{POST_SNAPBACK}>

 

Did you get this fixed yet? I just had the same problem with a new install which I used a copy of my other OsC website and copied everything over to the new server. Are you using Ultimate SEO URLs v2.0? If so I think that is where your problem resides and you might be able to fix this way.

 

Find this code in*catalog*/includes/application_top.php and comment out every line with the pound sign (#).

# include the cache class
include('includes/classes/cache.class.php');
$cache = new cache($languages_id);
# include the Ultimate SEO URLs cache file
include('includes/seo_cache.php');
# Get the cache - no parameters will get all GLOBAL cache entries for this language
$cache->get_cache('GLOBAL');
if ( isset($HTTP_GET_VARS['cName']) && defined(urldecode($HTTP_GET_VARS['cName'])) ) {
$cPath = str_replace( 'cPath=', '', constant(urldecode($HTTP_GET_VARS['cName'])) );
$HTTP_GET_VARS['cPath'] = $cPath;
}
if (isset($HTTP_GET_VARS['pName']) && defined(urldecode($HTTP_GET_VARS['pName'])) ) {
$pid = str_replace('products_id=', '', constant(urldecode($HTTP_GET_VARS['pName'])));
$HTTP_GET_VARS['products_id'] = (int)$pid;
}

 

Then run install-seo.php and install-cache.php. After you do that you need to go back to *catalog*/includes/application_top.php and uncomment everything you commented out. Hopefully this works for you, this is how I fixed it on my server.

[Simplyeasier]

Did you get this fixed yet? I just had the same problem with a new install which I used a copy of my other OsC website and copied everything over to the new server. Are you using Ultimate SEO URLs v2.0? If so I think that is where your problem resides and you might be able to fix this way.

 

Find this code in*catalog*/includes/application_top.php and comment out every line with the pound sign (#). 

# include the cache class
include('includes/classes/cache.class.php');
$cache = new cache($languages_id);
# include the Ultimate SEO URLs cache file
include('includes/seo_cache.php');
# Get the cache - no parameters will get all GLOBAL cache entries for this language
$cache->get_cache('GLOBAL');
if ( isset($HTTP_GET_VARS['cName']) && defined(urldecode($HTTP_GET_VARS['cName'])) ) {
$cPath = str_replace( 'cPath=', '', constant(urldecode($HTTP_GET_VARS['cName'])) );
$HTTP_GET_VARS['cPath'] = $cPath;
}
if (isset($HTTP_GET_VARS['pName']) && defined(urldecode($HTTP_GET_VARS['pName'])) ) {
$pid = str_replace('products_id=', '', constant(urldecode($HTTP_GET_VARS['pName'])));
$HTTP_GET_VARS['products_id'] = (int)$pid;
}

 

Then run install-seo.php and install-cache.php. After you do that you need to go back to *catalog*/includes/application_top.php and uncomment everything you commented out. Hopefully this works for you, this is how I fixed it on my server.

<{POST_SNAPBACK}>

 

if you have Ultimate SEO

 

- you could just drop and create the Cache Table - make sure you insert the data into the table from your old working site.

 

ensure you have the relevant .htaccess file in the root

 

Should see you OK

 

Charles