Just ran the database update and getting this error

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'base.status' in 'field list': SELECT base.id AS id, base.name AS name, base.mc_list_id AS mc_list_id, base.label AS label, base.description AS description, base.list_type AS list_type, base.settings AS settings, base.status AS status, base.module AS module, base.created AS created, base.updated AS updated FROM {mailchimp_lists} base; Array ( ) in EntityAPIController->query() (line 152 of /home/xxxxxxx/xxxxxx/drupal/sites/all/modules/entity/includes/entity.controller.inc).

Comments

levelos’s picture

levelos commented
Status: Active » Fixed

There was an error in the update process for 2.x-2.2, sorry about that. Just rolled a new release to address the issue, http://drupal.org/node/1358576.

bradwade’s picture

bradwade commented
Version: 7.x-2.2 » 7.x-2.3
Status: Fixed » Active

Having already installed 7.x-2.2 and received this error, updating to 7.x-2.3 was not sufficient to fix error. Although 7.x-2.3 added update #7201, update #7200 remained in the list of available updates and continued to fail before #7201 could run. I had to disable and *uninstall* mailchimp_lists to remove the updates from the list. Re-installing 7.x-2-3 fresh resulted in no errors.
(Was there a better way to recover from this situation?)

s@ilor’s picture

s@ilor commented

Hi bradwade,

Just did, as you, update to 7.x-2.3. Same problem; running the Update script results in a blank screen and a PDO. I know I can remove the module from the site via FTP, but it's brutal and leaves me with a mess in the database.What other method can I use to remove and clean up, so I can attempt a fresh install?

- Christian

bradwade’s picture

bradwade commented

Drunkensailor -

Although not the best solution as you will lose data/configuration for your mailchimp lists:
1) disable the mailchimp_lists (at admin/modules)
2) unistall the mailchimp_lists (admin/modules/uninstall)
3) renable the mailchimp_lists (make sure latest version of code is installed)
4) readd and reconfigure your mailchimp lists (admin/config/services/mailchimp/lists)

No need to remove the code/files from the website with FTP.

-Brad

s@ilor’s picture

s@ilor commented

Brad,

Thanks for this. I appreciate it. However, it's not a viable method for me as the site basically locks up in mid-process of running the update script, leaving me with only a blank page with an error message, "PDO Excemption yadda, yadda ..." There is no way of gracefully uninstalling the module. So, what I'm left with, is only the dirty way. Let me rephrase that; I cannot think of another way, but if there is, I'd love to hear about it.

Cheers,

- Christian

levelos’s picture

levelos commented
Status: Active » Closed (duplicate)

Christian, you can also use Drush if you have access to it. This is a duplicate of #1358416: Entity load and save operations in hook_update_N cause update failures, where there's a patch you could try as well.