Upon upgrading Filefield from 6.3.5 to 6.3.6, I tried to run update.php. I got a bunch of red flags from. This prompted me to deactivate the following modules:

Date and related modules
Chaos Tools

Filefield 6.3.6 shows up in the Modules/CCK window. But update.php still complains and doesn't complete.

Instead, it keeps displaying this message:

user warning: Table 'afrixml.cache' doesn't exist query: DELETE FROM cache WHERE cid = 'variables' in /var/www/webdocs/afrixml/includes/cache.inc on line 179.
user warning: Table 'afrixml.cache' doesn't exist query: DELETE FROM cache WHERE cid = 'variables' in /var/www/webdocs/afrixml/includes/cache.inc on line 179.

Comments

quicksketch’s picture

quicksketch
he/him
commented

That seems like an awfully strange problem, how could your "cache" table be missing? Check that it still exists in the database.

draganFSD’s picture

draganFSD commented

I also cant see pictures from views... i just reuploaded filefield-6.x-3.5 version

tsbah’s picture

tsbah commented

My MySQL has the following cache tables:

cache_page
cache_rules
cache_similarterms
cache_tax_image
cache_uc_price
cache_update
cache_views
cache_views_data

In phpMyAdmin alphabetical list, the afrixml_cache is missing.

So when I try to run update.php, the screen top has still the same flag about missing afrixml_cache.

I have turned off ubercart

quicksketch’s picture

quicksketch
he/him
commented

"afrixml" is the name of your database. "cache" is the name of the missing table. If the cache table is mysteriously missing, you're going to have all kinds of problems in addition to performance issues. I'd suggest restoring a database backup or (at the very least) manually recreating the cache table.

tsbah’s picture

tsbah commented

Enabling the modules I disabled before my Filefield update attempt may not solve the mysterious cache problem.

So, I looked at the structure of the cache table in other databases on my CentOS installation.

To complete the creation of the cache table for the afrixml db, I must:

  1. assign the number of fields
  2. fill out the fields

Any suggestions?

I have also two four-day old backups
- one from the back-and-migrate module
- one from phpMyAdmin export

TIA

tsbah’s picture

tsbah commented

I forgot to add the required records for the cache table
Here they are:

Type
Length/Values1
Default
Collation
Attributes
Null
Index
AUTO_INCREMENT

tsbah’s picture

tsbah commented

I went ahead and [re]-created the cache table and added only one record named cid with index status.

That solved the issue.

update.php went through its checking; result: OK

When I checked Report Status, there was a new Filefield update alert, version 6.3.7.

It installed without a hitch.

quicksketch’s picture

quicksketch
he/him
commented
Status: Active » Fixed

Great. I still have no idea what would cause the cache table to disappear like that. FileField doesn't have any DROP TABLE commands in it, so I don't think it was responsible. Perhaps it was an error in restoring a backup or managing your database. Really nothing should ever be dropping the main cache table.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.