table.createdAt column does not exist

515 views
Skip to first unread message

Manaus

unread,
May 3, 2017, 5:31:17 AM5/3/17
to CFWheels
Hello,
I've just added a column CreatedAt (Postgres' timestamp without time zone) in the database, filled in some example values, but upon querying I get this error in the subject, column does not exist.
Tried on other tables too, and I get table.updatedAt does not exist.
Thanks




Andrew Bellenie

unread,
May 3, 2017, 5:33:51 AM5/3/17
to ColdFusion on Wheels
Might need a reload?

--
You received this message because you are subscribed to the Google Groups "CFWheels" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cfwheels+unsubscribe@googlegroups.com.
To post to this group, send email to cfwh...@googlegroups.com.
Visit this group at https://groups.google.com/group/cfwheels.
For more options, visit https://groups.google.com/d/optout.

Manaus

unread,
May 3, 2017, 5:38:29 AM5/3/17
to CFWheels
Did it many times, also stopped and rebooted server... :)


Il giorno mercoledì 3 maggio 2017 11:33:51 UTC+2, Andrew Bellenie ha scritto:
Might need a reload?

On 3 May 2017 at 10:31, Manaus <max.n...@gmail.com> wrote:
Hello,
I've just added a column CreatedAt (Postgres' timestamp without time zone) in the database, filled in some example values, but upon querying I get this error in the subject, column does not exist.
Tried on other tables too, and I get table.updatedAt does not exist.
Thanks




--
You received this message because you are subscribed to the Google Groups "CFWheels" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cfwheels+u...@googlegroups.com.

Chris Peters

unread,
May 3, 2017, 9:18:53 AM5/3/17
to cfwh...@googlegroups.com
If your instance of Postgres is case sensitive (not even sure if you can do that), then the column names must be alllowercase: createdat, updatedat.

I'd link you to the chapter about conventions, but the docs site seems to be down? :(

--
You received this message because you are subscribed to the Google Groups "CFWheels" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cfwheels+unsubscribe@googlegroups.com.

To post to this group, send email to cfwh...@googlegroups.com.
Visit this group at https://groups.google.com/group/cfwheels.
For more options, visit https://groups.google.com/d/optout.



--

Chris Peters
Web Developer
Liquifusion Studios

chris....@liquifusion.com
Skype: liquifusion.support
www.liquifusion.com

Tom King

unread,
May 3, 2017, 9:21:01 AM5/3/17
to CFWheels


On Wednesday, 3 May 2017 14:18:53 UTC+1, Chris Peters wrote:
If your instance of Postgres is case sensitive (not even sure if you can do that), then the column names must be alllowercase: createdat, updatedat.

I'd link you to the chapter about conventions, but the docs site seems to be down? :(
On Wed, May 3, 2017 at 5:31 AM, Manaus <max.n...@gmail.com> wrote:
Hello,
I've just added a column CreatedAt (Postgres' timestamp without time zone) in the database, filled in some example values, but upon querying I get this error in the subject, column does not exist.
Tried on other tables too, and I get table.updatedAt does not exist.
Thanks




--
You received this message because you are subscribed to the Google Groups "CFWheels" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cfwheels+u...@googlegroups.com.

To post to this group, send email to cfwh...@googlegroups.com.
Visit this group at https://groups.google.com/group/cfwheels.
For more options, visit https://groups.google.com/d/optout.

Manaus

unread,
May 17, 2017, 9:59:55 AM5/17/17
to CFWheels
Thanks Chris you were right, the column name had a capital letter


Il giorno mercoledì 3 maggio 2017 15:18:53 UTC+2, Chris Peters ha scritto:
If your instance of Postgres is case sensitive (not even sure if you can do that), then the column names must be alllowercase: createdat, updatedat.

I'd link you to the chapter about conventions, but the docs site seems to be down? :(
On Wed, May 3, 2017 at 5:31 AM, Manaus <max.n...@gmail.com> wrote:
Hello,
I've just added a column CreatedAt (Postgres' timestamp without time zone) in the database, filled in some example values, but upon querying I get this error in the subject, column does not exist.
Tried on other tables too, and I get table.updatedAt does not exist.
Thanks




--
You received this message because you are subscribed to the Google Groups "CFWheels" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cfwheels+u...@googlegroups.com.

To post to this group, send email to cfwh...@googlegroups.com.
Visit this group at https://groups.google.com/group/cfwheels.
For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages