Heroku sql

local works, Heroku Server 500 Error.
The problem is sql request.
heroku run bash

To find how the sql on Heroku works, do the following test.
https://devcenter.heroku.com/articles/hero...
To see if your database is running on legacy infrastructure, use pg:info
To establish a psql session with your remote database, use heroku pg:psql.
then test SQL
select count(t.id), u.name from tickets t, users u where t.user_id = u.id group by u.name;

Ctrl+D, quit SQL Client

git add -A
git commit -m "500 error"
git push heroku master

本作品采用《CC 协议》，转载必须注明作者和本文链接