Contrib.social

Table 'databasename.cache_mailchimp' doesn't exist: TRUNCATE {cache_mailchimp}

Open on Drupal.org →
Created on 12 June 2014, about 10 years ago
Updated 20 October 2023, 8 months ago

Hi there,
thanks for your work on the new release. It looks great but unfortunately I keep running into the following error message post installation:
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db-name.cache_mailchimp' doesn't exist: TRUNCATE {cache_mailchimp} ; Array ( ) in cache_clear_all() (line 165 of D:\domains\example.com\wwwroot\subdomain\includes\cache.inc).

The error message will appear again after running the Update Script. It also prevents me from flushing all caches and is accompanied by:
The website encountered an unexpected error. Please try again later.

I've checked PHPMyAdmin and it's true, there is no db-name.cache_mailchimp table. The only Mailchimp related tables are: 

cache_mailchmip-user
mailchimp_activity_entity
mailchimp_campaigns
mailchinp_lists
mailchimp_signup

I'm not very good with PHP -
does anyone else have this error post installation or ideas as to why it would happen?
are there any fixes, e.g. can I manually create this table? if so what structure should it have?

Thanks - would really love to get this module working on my site,
A~

🐛 Bug report
Status

Closed: works as designed

Version

5.0

Component

General

Created by

🇮🇪Ireland Aptalops

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • Comment 8 months ago →
    🇩🇰Denmark ressa Copenhagen

    I was seeing a missing table db.cache_mailchimp running Drush commands. Here's how to create the missing table with Drush:

    drush sql:query 'CREATE TABLE IF NOT EXISTS cache_mailchimp ( \
cid varchar(255) NOT NULL DEFAULT "", \
data longblob, \
expire int(11) NOT NULL DEFAULT "0", \
created int(11) NOT NULL DEFAULT "0", \
serialized smallint(6) NOT NULL DEFAULT "0", \
PRIMARY KEY (cid), \
KEY expire (expire) \
);'

    The resulting table:

    $ drush sql:query 'SHOW COLUMNS FROM cache_mailchimp;'
cid	varchar(255)	NO	PRI
data	longblob	YES		NULL
expire	int(11)	NO	MUL	0
created	int(11)	NO		0
serialized	smallint(6)	NO		0
contrib.social Blog FAQ Discussions
Production build 0.69.0 2024