PDOException: errors when adding users to a list [#1210960]

This error came from an attempt to create a freeform subscripton as an annonomous user in drupal. The user was successfully added to the list and shipped over to mailchimp
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ziegler.cache_mailchimp_user' doesn't exist: DELETE FROM {cache_mailchimp_user} WHERE (cid = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 071a86f559-xxxxxx@gmail.com ) in cache_clear_all() (line 169 of /var/www/ziegler/includes/cache.inc).

this error came about subscribing to an existing list in drupal as an authenticated user. user was successfully added.
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ziegler.cache_mailchimp_user' doesn't exist: DELETE FROM {cache_mailchimp_user} WHERE (cid = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 071a86f559-xxxx.xxx@hotmail.com ) in cache_clear_all() (line 169 of /var/www/ziegler/includes/cache.inc).

Comments

Comment #1

dboulet CreditAttribution: dboulet commented 7 July 2011 at 21:16

Version:	7.x-2.0-rc1	» 7.x-2.x-dev
Status:	Needs review	» Active

I get the same message.

Comment #2

levelos CreditAttribution: levelos commented 11 July 2011 at 22:00

Status:

Active

» Fixed

Looks like (obviously) the cache_mailchimp_user table doesn't exist in your instances. It should be created when installing the mailchimp module. Did you guys update from a previous version? We don't currently have a supported update path from either 6.x or 7.x-1.0, although it's in the works. Easiest approach is to disable and uninstall any older versions of the module and then do a clean install.

Comment #3

dboulet CreditAttribution: dboulet commented 11 July 2011 at 22:15

Yup, I upgraded from 7.x-1.0, didn't realize that there was no upgrade path in place. I'll try re-installing, thanks levelos.

Comment #4

donwinchell CreditAttribution: donwinchell commented 12 July 2011 at 11:15

when trying to un-install I get this error.
Notice: Use of undefined constant MAILCHIMP_QUEUE_CRON - assumed 'MAILCHIMP_QUEUE_CRON' in mailchimp_lists_uninstall() (line 77 of /var/www/ziegler/sites/all/modules/mailchimp/modules/mailchimp_lists/mailchimp_lists.install).
then
The selected modules have been uninstalled.
I will continue the process and let you know the outcome
on July 12, 2011 I re-Installed 7.x-2.x-dev seems to be working now. will keep you posted if other issues arise
just a note, if using drush to install, drush will install 7.x-1.x-dev not 7.x-2.x-dev