local sqlite development vs Heroku PG deployment

rubyonrails-talk
1

This is driving me crazy. I have my web app working great in development, then I commit and push it to Github and heroku automatically deploys my app.

Unfortunately, it doesn’t quite work out the same as the development.

Pages aren’t being found on production, but they are there in development and they are on my github repo.

Heroku logs are not very useful either. :frowning:

Any suggestions?

Thanks,

Joe

2

ok, I solved of my problems. My git commit / push didn’t work. Thats working now.

the other thing is…

ActionView::Template::Error (PG::UndefinedColumn: ERROR: column "startdate" does not exist

2017-02-01T03:51:33.326023+00:00 app[web.1]: LINE 1: SELECT "products".* FROM "products" ORDER BY Startdate ASC...

2017-02-01T03:51:33.326023+00:00 app[web.1]: ^

2017-02-01T03:51:33.326024+00:00 app[web.1]: HINT: Perhaps you meant to reference the column "products.Startdate".



Startdate is a column in my database table, I don't know where it coming up with 'startdate' does not exist? I don't have that in any of my references.



Thanks,

Joe
3

ok, I solved of my problems. My git commit / push didn't work. Thats working now.

the other thing is...

ActionView::Template::Error (PG::UndefinedColumn: ERROR: column "startdate" does not exist 2017-02-01T03:51:33.326023+00:00 app[web.1]: LINE 1: SELECT "products".* FROM "products" ORDER BY Startdate ASC... 2017-02-01T03:51:33.326023+00:00 app[web.1]: ^ 2017-02-01T03:51:33.326024+00:00 app[web.1]: HINT: Perhaps you meant to reference the column "products.Startdate".

Startdate is a column in my database table, I don't know where it coming up with 'startdate' does not exist? I don't have that in any of my references.

Thanks, Joe

This is driving me crazy. I have my web app working great in development, then I commit and push it to Github and heroku automatically deploys my app.

Unfortunately, it doesn't quite work out the same as the development.

Pages aren't being found on production, but they are there in development and they are on my github repo.

Heroku logs are not very useful either. :frowning:

Any suggestions?

Are you using capital letters in your table names? You're going to have to do some extra work to get that to work, because the standard is lower-case table names. Some RDBMs don't care what case you use for table names, but some do.

Walter

4

ok, I solved of my problems. My git commit / push didn't work. Thats working now.

the other thing is...

ActionView::Template::Error (PG::UndefinedColumn: ERROR: column "startdate" does not exist 2017-02-01T03:51:33.326023+00:00 app[web.1]: LINE 1: SELECT "products".* FROM "products" ORDER BY Startdate ASC... 2017-02-01T03:51:33.326023+00:00 app[web.1]: ^ 2017-02-01T03:51:33.326024+00:00 app[web.1]: HINT: Perhaps you meant to reference the column "products.Startdate".

Startdate is a column in my database table, I don't know where it coming up with 'startdate' does not exist? I don't have that in any of my references.

Thanks, Joe

This is driving me crazy. I have my web app working great in development, then I commit and push it to Github and heroku automatically deploys my app.

Unfortunately, it doesn't quite work out the same as the development.

Pages aren't being found on production, but they are there in development and they are on my github repo.

Heroku logs are not very useful either. :frowning:

Any suggestions?

Are you using capital letters in your table names? You're going to have to do some extra work to get that to work, because the standard is lower-case table names. Some RDBMs don't care what case you use for table names, but some do.

Walter

In particular, see About PostgreSQL Case Sensitivity – Xojo Programming Blog

-Rob

5

Hi, yes I had one column name I accidently capitalized. It caused me so much grief.

I altered the table, and had to clean up my table column references in my code and all is well now.

Just a quick question. I ran a migration that changed the column name on my local sqlite table, and when I tried the same migration on heroku it didn’t change the table column name. I used pgadmin 4 to alter the postgres table column name.

Thanks,

Joe