user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 4 ) count_alias' at line 3 query: SELECT COUNT(*) FROM (SELECT send.sid AS sid FROM send send WHERE .nid = 4 ) count_alias in /profiles/openatrium/modules/contrib/views/includes/view.inc on line 745.

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 4 LIMIT 0, 20' at line 8 query: SELECT send.sid AS sid, send.timestamp AS send_timestamp, name, uid, send.subject AS send_subject, send.message AS send_message FROM send send WHERE .nid = 4 LIMIT 0, 20 in /profiles/openatrium/modules/contrib/views/includes/view.inc on line 771.

Comments

AndrzejG’s picture

I have similar:

* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 83 ) count_alias' at line 3 query: SELECT COUNT(*) FROM (SELECT send.sid AS sid FROM send send WHERE .nid = 83 ) count_alias in /sites/all/modules/views/includes/view.inc on line 745.
* user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 83 LIMIT 0, 20' at line 8 query: SELECT send.sid AS sid, send.timestamp AS send_timestamp, name, uid, send.subject AS send_subject, send.message AS send_message FROM send send WHERE .nid = 83 LIMIT 0, 20 in /sites/all/modules/views/includes/view.inc on line 771.

AndrzejG’s picture

Priority: Normal » Major
hhiroshi’s picture

Subscribe

halloffame’s picture

+1

Experiencing the same thing. Any fix yet?

HTF’s picture

I also get this problem

dan3h’s picture

I'm also getting this problem. It appears to me that the send module's view is broken.

On a fresh install of the send module (and its two submodules), if you go to 'admin/build/views/edit/send', you'll see

  1. In the Default display, under 'Relationships':
    • Broken/missing handler: send > uid
    • Broken/missing handler: send_recipient > rid
    • Broken/missing handler: send_recipient > nid
  2. In the 'Send node history' display, under 'Fields':
    • Broken/missing handler Module
  3. In the 'Most emailed' display, under 'Fields':
    • Broken/missing handler Recipients

I have views 2.x installed. I'm assuming that much is right...?

Allie Micka’s picture

A code change broke some views handlers, and it's not a very easy fix. I have disabled this default view for now, and it won't be in the next release. This will prevent the error message bloodbath until we get an appropriate fix.

nymo’s picture

+1

Allie Micka’s picture

Status: Active » Closed (fixed)