When I tried to visit admin/content/simplenews i got this database error:
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'sc.name' in 'field list': SELECT COUNT(*) AS expression FROM (SELECT n.nid AS nid, n.vid AS vid, n.title AS title, n.created AS created, n.status AS status, sn.tid AS tid, sc.name AS name, sn.status AS sent_status, 1 AS expression FROM {node} n INNER JOIN {simplenews_newsletter} sn ON n.nid = sn.nid LEFT OUTER JOIN {simplenews_category} sc ON sn.tid = sc.tid) subquery; Array ( ) in PagerDefault->execute() (line 75 of /var/www/drupal7/includes/pager.inc).
I do not know if this has anything to do with this, but when I try to create a new Newsletter node, there is no dropdown to choose newsletter category (see attached image).
I use D7 beta 1.
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | simplenews_944360_1_join.patch | 1.26 KB | simon georges |
| snapshot1.png | 22.42 KB | slashrsm |
Comments
Comment #1
miro_dietikerThere seems to be a join missing to the term table - where the category name resides.
Comment #2
simon georges commentedJust changing the status to major as Simplenews does not work at all because of this bug. (But not critical because as there is no release yet, we cannot expect everything to go flawless ;)).
Anyway, I'm glad this module has began its D7 port.
Comment #3
simon georges commentedI've made a patch that fix it for me (I mean I can see the screen), I'll test further when I can successfully create a node of type 'Newsletter' (probably another Simplenews D7 issue).
Anyway, if anyone is willing to test this patch, feel free to report back any issue with it.
Comment #4
miro_dietikerlooks perfectly right.
committed