gistfile1.txt

//ListingEvent.js

module.exports = {
  tableName: 'listingEvent',
  attributes: {
    name: { type: 'string' },
    start: { type: 'date' },
    end: { type: 'date' },
    eventInstanceSlug: { type: 'string' },
    location: {
      model:'location'
    },
    artists: {
      collection: 'artist',
      via: 'listingEvents'
    },
    users: {
        collection: 'user',
        via: 'listingEvents'
    }
  }
};


//User.js

module.exports = {

  attributes: require('waterlock').models.user.attributes({

    email: 'string',
    username: 'string',
    images: {
      collection: 'image',
      via: 'user'
    },
    avatarImage: {
      model: 'image'
    },

    listingEvents: {
      collection: 'listingEvent',
      via: 'users'
    }

  }),

  beforeCreate: require('waterlock').models.user.beforeCreate,
  beforeUpdate: require('waterlock').models.user.beforeUpdate
};


/**
 * FilteredLineupController
 *
 * @description :: Server-side logic for managing Filteredlineups
 * @help        :: See http://links.sailsjs.org/docs/controllers
 */

var winston = require('winston');

module.exports = {
  find: function(req, res) {

    var name = req.param("name");
    var currentUserAttending = req.param("currentUserAttending");
    var location = req.param("location");
    var sort = req.param("sort");
    var eventInstanceSlug = req.param("eventInstanceSlug");
    var limit = req.param("limit");
    var skip = req.param("skip");

    var userId = req.session.user != null ? req.session.user.id : null;

    User.findOne().where({
        id: userId
      })
      .populate('listingEvents')
      .then(function(user) {

        var attendingIds = new Array();

        if (user !== undefined && user != null) {
          for (var i = 0; i < user.listingEvents.length; i++) {
            var le = user.listingEvents[i];
            attendingIds.push(le.id);
          }
        }

        var q = ListingEvent.find().where({
          eventInstanceSlug: eventInstanceSlug
        });

        q.populate('users');
        q.populate('location');

        if (name != undefined && name != null && name !== '') {
          q.where({
            name: {
              startsWith: name
            }
          });
        }

        if (location != undefined && location != null && location !== '') {
          q.where({
            location: {
              name: {
                startsWith: location
              }
            }
          });
        }
	
	//fails
        if (currentUserAttending === 'true' && req.session.user != undefined && req.session.user != null) {
          q.where({
            users: {
              id: req.session.user.id
            }
          });
        }

        q.skip(skip);
        q.limit(limit);

        q.exec(function(err, results) {
          if (err) {
            winston.error(err);
          }

          /*if (user !== null) {
            for (var i = 0; i < results.length; i++) {
              if (attendingIds.indexOf(results[i].id) > -1) {
                results[i].currentUserAttending = true;
              }
            }
          }*/

          return res.ok(results);

        });

      });
  }
};

Here is the error:

error:  name=error, length=92, severity=ERROR, code=42601, detail=undefined, hint=undefined, position=784, internalPosition=undefined, internalQuery=undefined, where=undefined, schema=undefined, table=undefined, column=undefined, dataType=undefined, constraint=undefined, file=scan.l, line=1053, routine=scanner_yyerror, name=error, length=92, severity=ERROR, code=42601, detail=undefined, hint=undefined, position=784, internalPosition=undefined, internalQuery=undefined, where=undefined, schema=undefined, table=undefined, column=undefined, dataType=undefined, constraint=undefined, file=scan.l, line=1053, routine=scanner_yyerror, rawStack=error: syntax error at or near "undefined"
    at Connection.parseE (/Users/waynedouglas/sonatribe-api/node_modules/sails-postgresql/node_modules/pg/lib/connection.js:534:11)
    at Connection.parseMessage (/Users/waynedouglas/sonatribe-api/node_modules/sails-postgresql/node_modules/pg/lib/connection.js:361:17)
    at Socket.<anonymous> (/Users/waynedouglas/sonatribe-api/node_modules/sails-postgresql/node_modules/pg/lib/connection.js:105:22)
    at Socket.emit (events.js:107:17)
    at readableAddChunk (_stream_readable.js:163:16)
    at Socket.Readable.push (_stream_readable.js:126:10)
    at TCP.onread (net.js:529:20), details=Details:  error: syntax error at or near "undefined"