I have noticed other issues with unknown column 's.status', but none for this specific issue. I checked status reports, and there are no database updates pending (and I updated the DB anyway, to see if that fixed the issue).

I migrated from a D6 site to D7, on the D7 site I get this error whenever I try to view subscribers.

Thanks.

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'su.status' in 'where clause': SELECT COUNT(*) AS expression FROM (SELECT 1 AS expression FROM {simplenews_subscriber} sn LEFT OUTER JOIN {users} u ON sn.uid = u.uid INNER JOIN {simplenews_subscription} su ON sn.snid = su.snid WHERE (su.status = :db_condition_placeholder_0) ) subquery; Array ( [:db_condition_placeholder_0] => 1 ) in PagerDefault->execute() (line 74 of C:\Program Files\acquia-drupal\local\dru7.mysite\includes\pager.inc).

CommentFileSizeAuthor
#4 added_status_field.patch1.49 KBberdir

Comments

NathanFrankel’s picture

I ended up uninstalling the module an re-installing fresh. Then I imported the emails from the old D6 site. Easy solution, wish I would have thought of it before posting.

NathanFrankel’s picture

Status: Active » Fixed
berdir’s picture

Status: Fixed » Active

Good that you found a workaround, but we should still fix this, so lets keep it open.

Other users might have a lot of categories and so on which can't be re-imported so easily.

berdir’s picture

Status: Active » Needs review
StatusFileSize
new1.49 KB

Ok, here is a patch that confirms this bug with a test and fixes it. Tests fail without the fix.

berdir’s picture

Version: 7.x-1.0-alpha2 » 7.x-1.x-dev
berdir’s picture

Status: Needs review » Fixed

Commited and pushed.

Status: Fixed » Closed (fixed)

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