Noooob question (2 days ruby experience :wink: I have a plugin almost doing what I want but have a hang up here: posts = Post.where('user_id = ? and post_number = ?', params["uid"], params["tid"]) .order(created_at: :desc) .limit(params["total"]) I’ve tried a number of versions. …

What does the logs say? :slight_smile:

so good of you to ask, and admittedly that helped… :smiley: BUT perhaps you can assist further with my query! The issue was the input value while I can do ok Post.where('user_id: '1,2') #works Post.where('topic_id: '4,5') #works Fails Post.where('user_id = ? or topic_id = ?', '1,2', '4,…

Boom! (thanks BTW ) ActiveRecord::StatementInvalid (PG::InvalidTextRepresentation: ERROR: invalid input syntax for integer: "1,2" LINE 1: ...ERE ("posts"."deleted_at" IS NULL) AND (user_id = '1,2' or t... ^ : SELECT "posts".* FROM "post…

Try Post.where(user_id IN (?) OR topic_id IN (?), [1,2], [4,5])

So if I say post.where() it causes a error?

@tgxworld Thanks that helped a bunch. For the record I was doing a bunch of stuff that I SHOULD have known better… not splitting the string to an actual array (duh facepalm ) your request seems to have fix the syntax issues (woot) final code uid = params["uid"].split(",") tid = params["tid"].s…

Post.where() causing 500 error

Development

tgxworld (Alan Tan) March 11, 2016, 11:41am 4

So why did it fail? What is the error that was raised when you ran the code?

Topic		Replies	Views
SQL Error with `screened_ip_addresses` (API throws 500) Migration rest-api	14	1377	April 6, 2020
Attempting to create Monthly Leaderboard query - head exploding Data & reporting sql-query	18	2027	October 8, 2018
Problem migrating polls: `integer out of range` (1000000000000) Product Support	2	902	December 4, 2018
User can't post: 500 internal server error Product Support	10	1599	April 18, 2018
Getting 500 server error when trying to post via API Product Support	2	529	December 9, 2019

Post.where() causing 500 error

Related topics