{"action":"created","issue":{"url":"https://api.github.com/repos/madbob/GASdotto/issues/62","labels_url":"https://api.github.com/repos/madbob/GASdotto/issues/62/labels{/name}","comments_url":"https://api.github.com/repos/madbob/GASdotto/issues/62/comments","events_url":"https://api.github.com/repos/madbob/GASdotto/issues/62/events","html_url":"https://github.com/madbob/GASdotto/issues/62","id":115754580,"number":62,"title":"Can't query for orders: orderaggregate_array does not exist","user":{"login":"boyska","id":14236,"avatar_url":"https://avatars.githubusercontent.com/u/14236?v=3","gravatar_id":"","url":"https://api.github.com/users/boyska","html_url":"https://github.com/boyska","followers_url":"https://api.github.com/users/boyska/followers","following_url":"https://api.github.com/users/boyska/following{/other_user}","gists_url":"https://api.github.com/users/boyska/gists{/gist_id}","starred_url":"https://api.github.com/users/boyska/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/boyska/subscriptions","organizations_url":"https://api.github.com/users/boyska/orgs","repos_url":"https://api.github.com/users/boyska/repos","events_url":"https://api.github.com/users/boyska/events{/privacy}","received_events_url":"https://api.github.com/users/boyska/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-11-08T19:45:15Z","updated_at":"2015-11-09T08:08:15Z","closed_at":null,"body":"**Summary**: on a clean installation, creating suppliers and products works fine, but there is no apparent way to create an order. Actually the order _seems_ to be created, and it _is_ created in the db. Still, the query asking for orderaggregate fails.\r\n\r\nWhen the page is loaded an `action=get` is issued asking for OrderAggregates; this is the POSTed data.\r\n```\r\n{\"type\":\"OrderAggregate\", \"has_Order\":[], \"has_Supplier\":[1], \"has_User\":[1], \"has_ShippingPlace\":[]\r\n, \"has_CustomFile\":[], \"has_Product\":[], \"has_Category\":[4,3,2,1], \"has_Measure\":[4,3,2,1], \"has_ProductVariant\"\r\n:[], \"has_ProductVariantValue\":[], \"has\":[]}\r\n```\r\n\r\n```\r\n\"Errore: Impossibile recuperare lista oggetti OrderAggregate executing |SELECT id FROM OrderAggregate\r\n WHERE id > 0 AND id IN (SELECT OrderAggregate_ARRAY.parent FROM OrderAggregate_ARRAY, Orders WHERE OrderAggregate_ARRAY\r\n.target = Orders.id AND Orders.status != 3)  AND id IN  ( SELECT target_id FROM ACL WHERE gas = 1 AND\r\n target_type = 'OrderAggregate' )  ORDER BY id DESC|  (ERROR:  relation \\\"orderaggregate_array\\\" does\r\n not exist\\nLINE 1: ...ND id IN (SELECT OrderAggregate_ARRAY.parent FROM OrderAggre...\\n            \r\n                                                 ^)\"\r\n```\r\n\r\nThe error occurs both with MySQL and with PostgreSQL.\r\nI am of course available to provide further details, if you so need.\r\n"},"comment":{"url":"https://api.github.com/repos/madbob/GASdotto/issues/comments/154992752","html_url":"https://github.com/madbob/GASdotto/issues/62#issuecomment-154992752","issue_url":"https://api.github.com/repos/madbob/GASdotto/issues/62","id":154992752,"user":{"login":"boyska","id":14236,"avatar_url":"https://avatars.githubusercontent.com/u/14236?v=3","gravatar_id":"","url":"https://api.github.com/users/boyska","html_url":"https://github.com/boyska","followers_url":"https://api.github.com/users/boyska/followers","following_url":"https://api.github.com/users/boyska/following{/other_user}","gists_url":"https://api.github.com/users/boyska/gists{/gist_id}","starred_url":"https://api.github.com/users/boyska/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/boyska/subscriptions","organizations_url":"https://api.github.com/users/boyska/orgs","repos_url":"https://api.github.com/users/boyska/repos","events_url":"https://api.github.com/users/boyska/events{/privacy}","received_events_url":"https://api.github.com/users/boyska/received_events","type":"User","site_admin":false},"created_at":"2015-11-09T08:08:15Z","updated_at":"2015-11-09T08:08:15Z","body":">Which version of code did you used? The latest release from\n>gasdotto.net, or from git master?\n\nThe latest (3.0) release, from gasdotto.net\n\n-- \nboyska\n\n"}}