search

madebyraygun / trending-posts

Trending Posts for Craft CMS 3 tracks pageviews over time and orders posts by popularity on the front-end.
MIT License
6 stars 3 forks source link

PostgreSQL undefined column fix. #10

Closed JamesNuttall closed 3 years ago

JamesNuttall commented 5 years ago

PostgreSQL uses only single quotes for this (i.e. WHERE name = 'John'). Double quotes are used to quote system identifiers; field names, table names, etc. (i.e. WHERE "last name" = 'Smith'). — wiki.postgresql.org

To account for this I just swapped the use of single/double quotes. See the error below:

image

daltonrooney commented 5 years ago

Thanks for reporting! I will merge this as soon as I can test it. Away from my computer for the holiday but will take care of it soon.