Error on `/content`

[mhkeller]

http://localhost:5000/api/v1/content?sort=-created&facets=subject_tags,impact_tags,categories,levels&apikey=mj&orgid=1

{"status_code": 500, "message": "(psycopg2.InternalError) current transaction is aborted, commands ignored until end of transaction block\n [SQL: 'SELECT anon_1.users_id AS anon_1_users_id, anon_1.users_name AS anon_1_users_name, anon_1.users_email AS anon_1_users_email, anon_1.users_password AS anon_1_users_password, anon_1.users_apikey AS anon_1_users_apikey, anon_1.users_admin AS anon_1_users_admin, anon_1.users_super_user AS anon_1_users_super_user, anon_1.users_created AS anon_1_users_created, anon_1.users_updated AS anon_1_users_updated, auths_1.id AS auths_1_id, auths_1.org_id AS auths_1_org_id, auths_1.name AS auths_1_name, auths_1.value AS auths_1_value, org_settings_1.id AS org_settings_1_id, org_settings_1.user_id AS org_settings_1_user_id, org_settings_1.org_id AS org_settings_1_org_id, org_settings_1.name AS org_settings_1_name, org_settings_1.value AS org_settings_1_value, org_settings_1.level AS org_settings_1_level, org_settings_1.json_value AS org_settings_1_json_value, org_metric_summary_1.org_id AS org_metric_summary_1_org_id, org_metric_summary_1.metrics AS org_metric_summary_1_metrics, orgs_1.id AS orgs_1_id, orgs_1.name AS orgs_1_name, orgs_1.slug AS orgs_1_slug, orgs_1.timezone AS orgs_1_timezone, orgs_1.created AS orgs_1_created, orgs_1.updated AS orgs_1_updated \\nFROM (SELECT users.id AS users_id, users.name AS users_name, users.email AS users_email, users.password AS users_password, users.apikey AS users_apikey, users.admin AS users_admin, users.super_user AS users_super_user, users.created AS users_created, users.updated AS users_updated \\nFROM users \\nWHERE users.apikey = %(apikey_1)s \\n LIMIT %(param_1)s) AS anon_1 LEFT OUTER JOIN (orgs_users AS orgs_users_1 JOIN orgs AS orgs_1 ON orgs_1.id = orgs_users_1.org_id) ON anon_1.users_id = orgs_users_1.user_id LEFT OUTER JOIN auths AS auths_1 ON orgs_1.id = auths_1.org_id LEFT OUTER JOIN org_settings AS org_settings_1 ON orgs_1.id = org_settings_1.org_id LEFT OUTER JOIN org_metric_summary AS org_metric_summary_1 ON orgs_1.id = org_metric_summary_1.org_id'] [parameters: {'apikey_1': u'mj', 'param_1': 1}]", "error": "InternalError"}

[abelsonlive]

looks like you have orgid instead of org in your request.

[mhkeller]

Here it is again

URL

http://localhost:5000/api/v1/content?facets=subject_tags,impact_tags,categories,levels&incl_body=false&ids=6,18,11,28,16,26,49,27,48,1,19,9,43,12,50,31,34,7,2,46,35,24,38,47,23&sort_ids=true&apikey=mj&org=1

RESPONSE

{

    "status_code": 500,
    "message": "(psycopg2.ProgrammingError) missing FROM-clause entry for table \"content\"\nLINE 5: ...,48,1,19,9,43,12,50,31,34,7,2,46,35,24,38,47,23], content.id...\n                                                             ^\n [SQL: 'SELECT anon_1.content_id AS anon_1_content_id, anon_1.content_org_id AS anon_1_content_org_id, anon_1.content_recipe_id AS anon_1_content_recipe_id, anon_1.content_type AS anon_1_content_type, anon_1.content_provenance AS anon_1_content_provenance, anon_1.content_url AS anon_1_content_url, anon_1.content_domain AS anon_1_content_domain, anon_1.content_created AS anon_1_content_created, anon_1.content_updated AS anon_1_content_updated, anon_1.content_site_name AS anon_1_content_site_name, anon_1.content_favicon AS anon_1_content_favicon, anon_1.content_img_url AS anon_1_content_img_url, anon_1.content_thumbnail AS anon_1_content_thumbnail, anon_1.content_title AS anon_1_content_title, anon_1.content_description AS anon_1_content_description, anon_1.content_body AS anon_1_content_body, anon_1.content_active AS anon_1_content_active, anon_1.content_meta AS anon_1_content_meta, anon_1.content_title_search_vector AS anon_1_content_title_search_vector, anon_1.content_body_search_vector AS anon_1_content_body_search_vector, anon_1.content_description_search_vector AS anon_1_content_description_search_vector, anon_1.content_meta_search_vector AS anon_1_content_meta_search_vector, tags_1.id AS tags_1_id, tags_1.org_id AS tags_1_org_id, tags_1.name AS tags_1_name, tags_1.slug AS tags_1_slug, tags_1.created AS tags_1_created, tags_1.updated AS tags_1_updated, tags_1.color AS tags_1_color, tags_1.type AS tags_1_type, tags_1.category AS tags_1_category, tags_1.level AS tags_1_level, authors_1.id AS authors_1_id, authors_1.org_id AS authors_1_org_id, authors_1.name AS authors_1_name, authors_1.img_url AS authors_1_img_url, authors_1.created AS authors_1_created, authors_1.updated AS authors_1_updated, authors_1.search_vector AS authors_1_search_vector, content_metric_summary_1.org_id AS content_metric_summary_1_org_id, content_metric_summary_1.content_item_id AS content_metric_summary_1_content_item_id, content_metric_summary_1.metrics AS content_metric_summary_1_metrics \\nFROM (SELECT content.id AS content_id, content.org_id AS content_org_id, content.recipe_id AS content_recipe_id, content.type AS content_type, content.provenance AS content_provenance, content.url AS content_url, content.domain AS content_domain, content.created AS content_created, content.updated AS content_updated, content.site_name AS content_site_name, content.favicon AS content_favicon, content.img_url AS content_img_url, content.thumbnail AS content_thumbnail, content.title AS content_title, content.description AS content_description, content.body AS content_body, content.active AS content_active, content.meta AS content_meta, content.title_search_vector AS content_title_search_vector, content.body_search_vector AS content_body_search_vector, content.description_search_vector AS content_description_search_vector, content.meta_search_vector AS content_meta_search_vector \\nFROM content LEFT OUTER JOIN content_metric_summary ON content.id = content_metric_summary.content_item_id \\nWHERE content.org_id = %(org_id_1)s AND content.id IN (%(id_1)s, %(id_2)s, %(id_3)s, %(id_4)s, %(id_5)s, %(id_6)s, %(id_7)s, %(id_8)s, %(id_9)s, %(id_10)s, %(id_11)s, %(id_12)s, %(id_13)s, %(id_14)s, %(id_15)s, %(id_16)s, %(id_17)s, %(id_18)s, %(id_19)s, %(id_20)s, %(id_21)s, %(id_22)s, %(id_23)s, %(id_24)s, %(id_25)s) ORDER BY idx(ARRAY[6,18,11,28,16,26,49,27,48,1,19,9,43,12,50,31,34,7,2,46,35,24,38,47,23], content.id) \\n LIMIT %(param_1)s OFFSET %(param_2)s) AS anon_1 LEFT OUTER JOIN (content_items_tags AS content_items_tags_1 JOIN tags AS tags_1 ON tags_1.id = content_items_tags_1.tag_id) ON anon_1.content_id = content_items_tags_1.content_item_id LEFT OUTER JOIN (content_items_authors AS content_items_authors_1 JOIN authors AS authors_1 ON authors_1.id = content_items_authors_1.author_id) ON anon_1.content_id = content_items_authors_1.content_item_id LEFT OUTER JOIN content_metric_summary AS content_metric_summary_1 ON anon_1.content_id = content_metric_summary_1.content_item_id ORDER BY idx(ARRAY[6,18,11,28,16,26,49,27,48,1,19,9,43,12,50,31,34,7,2,46,35,24,38,47,23], content.id)'] [parameters: {'id_25': 23, 'id_10': 1, 'id_11': 19, 'id_12': 9, 'id_13': 43, 'id_14': 12, 'id_15': 50, 'id_16': 31, 'id_17': 34, 'id_18': 7, 'id_19': 2, 'org_id_1': 1, 'id_21': 35, 'id_20': 46, 'id_23': 38, 'id_22': 24, 'param_1': 25, 'id_24': 47, 'param_2': 0, 'id_2': 18, 'id_3': 11, 'id_1': 6, 'id_6': 26, 'id_7': 49, 'id_4': 28, 'id_5': 16, 'id_8': 27, 'id_9': 48}]",
    "error": "ProgrammingError"

}