Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

postgres syntax error on update #114

Open
tallenaz opened this issue Dec 19, 2014 · 1 comment
Open

postgres syntax error on update #114

tallenaz opened this issue Dec 19, 2014 · 1 comment

Comments

@tallenaz
Copy link

Any ideas? Our squash app is at rails version is 4.0.8 and pg version is at 0.17.1

E, [2014-11-14T13:39:54.134882 #9512] ERROR -- : PG::SyntaxError: ERROR:  syntax error at or near ","
LINE 1: ...admin" = $1 WHERE "memberships"."user_id,project_id" = 1,12
                                                                   ^
: UPDATE "memberships" SET "admin" = $1 WHERE "memberships"."user_id,project_id" = 1, 12
F, [2014-11-14T13:39:54.145761 #9512] FATAL -- : 
ActiveRecord::StatementInvalid (PG::SyntaxError: ERROR:  syntax error at or near ","
LINE 1: ...admin" = $1 WHERE "memberships"."user_id,project_id" = 1, 12
                                                                   ^
: UPDATE "memberships" SET "admin" = $1 WHERE "memberships"."user_id,project_id" = 1, 12):
  app/controllers/project/memberships_controller.rb:108:in `update'
  app/middleware/ping.rb:29:in `call'
@RISCfuture
Copy link
Contributor

Looks like an incompatibility between your version of ActiveRecord and composite_primsry_keys. Might want to play around with gem versions.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants