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).
| Comment | File | Size | Author |
|---|---|---|---|
| #4 | added_status_field.patch | 1.49 KB | berdir |
Comments
Comment #1
NathanFrankel commentedI 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.
Comment #2
NathanFrankel commentedComment #3
berdirGood 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.
Comment #4
berdirOk, here is a patch that confirms this bug with a test and fixes it. Tests fail without the fix.
Comment #5
berdirComment #6
berdirCommited and pushed.