我目前在尝试使用Rails对一张表进行复杂的WHERE
查询,但是我遇到了以下错误:
PG::Error: ERROR: column "email" does not exist
LINE 1: SELECT "bans".* FROM "bans" WHERE (Email='' AND IP='' AND (...
^
: SELECT "bans".* FROM "bans" WHERE (Email='' AND IP='' AND (Username='NULL' ))
我知道该列实际上是存在的,通过执行rails dbconsole
命令可以得到以下结果:
Jungle=> select * from bans;
id | Username | IP | Email | Reason | Length | created_at | updated_at
----+----------+----+-------+--------+--------+------------+------------
(0 rows)
所以这肯定在数据库中,有人有这方面的经验吗?