On 11 August 2011 18:45, fredrated <[email protected]> wrote: >>>"Can you confirm your connecting to the same database from the rails >>>app and from psql?" > > I started the webrick server in /home/work/timecard so it must be > pointing to the rails timecard app. and the database is specified in > database.yml, beyond that how do I determine the database I am using? > >>>"Are you sure the index page doesn't have the data harcoded somewhere?" > > I have opened all of the standard .html.erb files in the app/views/ > timeperiods directory and verified there is nothing there beyond the > rails defaults. > >>>"Have you tried copying the database with a different name and change >>>your app to use the new database? > > Not a bad idea so I used psql to clone the database and edited > database.yml in rails to refer to the new database. psql still shows > only 2 records. After restarting the rails server then navigating to > the url I now get "Fatal: database 'mymystery' does not exist". > Edited database.yml back to timecard_development, restarted the rails > server, and the url works again but shows all 6 records. Don't > understand why rails couldn't find my new database 'mymystery'. > > It seems clear we are not looking at the same data. I listed all > databases on my (VMWhere virtual) machine, opened and queried them all > with psql, and none of them have the records I added through the rails > interface.
Please post your complete database.yml Colin -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
