[Rails] Re: Error in migration - Error: You have an error in your SQL syntax; check the manual that corresponds

No problem... The best thing about this site is the set of fresh eyes > >>> -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscr

[Rails] Re: Error in migration - Error: You have an error in your SQL syntax; check the manual that corresponds

now work. thank you пятница, 10 июля 2015 г., 18:05:04 UTC+3 пользователь Dmitriy написал: > > i inserted > > pids = Vote.where(subject_type: 'Photo').pluck(:subject_id).uniq > unless pids.empty? > > but again same error > > > пятница, 10 июля 2015 г., 17:27:12 UTC+3 пользователь Elizabeth Mc

[Rails] Re: Error in migration - Error: You have an error in your SQL syntax; check the manual that corresponds

i inserted pids = Vote.where(subject_type: 'Photo').pluck(:subject_id).uniq unless pids.empty? but again same error пятница, 10 июля 2015 г., 17:27:12 UTC+3 пользователь Elizabeth McGurty написал: > > If I am reading your error message correctly: > UPDATE photos SET votes_count = 0, ratin

[Rails] Re: Error in migration - Error: You have an error in your SQL syntax; check the manual that corresponds

If I am reading your error message correctly: UPDATE photos SET votes_count = 0, rating = 0 WHERE id NOT IN () Looks like your IN Operator is empty. Pretty sure that will throw an error. If I am correct, I think that you should check the return on pids. Otherwise, thanks for this offering I