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

Unprocessable entity from API when assigning products #94

Open
Migweld opened this issue Jul 21, 2014 · 0 comments
Open

Unprocessable entity from API when assigning products #94

Migweld opened this issue Jul 21, 2014 · 0 comments

Comments

@Migweld
Copy link

Migweld commented Jul 21, 2014

The API call when searching for a variant in the related products form returns a 422 Unprocessable entity error. Expecting a list of matching variants.

AJAX exception is:

"exception":"Mysql2::Error: Column 'id' in field list is ambiguous: SELECT COUNT(DISTINCT count_column) FROM (SELECT  id AS count_column FROM `spree_variants` LEFT OUTER JOIN `spree_products` ON `spree_products`.`id` = `spree_variants`.`product_id` AND `spree_products`.`deleted_at` IS NULL WHERE `spree_variants`.`deleted_at` IS NULL AND ((`spree_products`.`name` LIKE '%Goo%' OR `spree_variants`.`sku` LIKE '%Goo%')) LIMIT 25 OFFSET 0) subquery_for_count"}

Gist of Gemfile.lock:
https://gist.github.com/Migweld/039aecad059d68278bd7

Any help appreciated.

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

No branches or pull requests

2 participants