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 協議》，轉載必須註明作者和本文連結