Redmine does not generate db/schema.rb
Added by Alexey Lustin over 17 years ago
i have install a new Redmine installation (r2744)
after install all the gem i have migrate db and load default data
all perfect throw this moment
then i have decided install the plugin - Budget and Rate
in my script to reload mongrel used db:migrate:all
and i have the error
rake db:migrate:all RAILS_ENV="production" --trace
(in /home/virtwww/w_lustin_e3572841/http)
** Invoke db:migrate:all (first_time)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
rake aborted!
PGError: ERROR: relation "schema_migrations" already exists
: CREATE TABLE "schema_migrations" ("version" character varying(255) NOT NULL)
...
WHY THE FIRST TIME ? i think
then i use the psql
the value in last row - version=20090503121510
ok, i think and the run
RAILS_ENV=production script/about
About your application's environment Ruby version 1.8.6 (x86_64-linux) RubyGems version 1.3.1 Rails version 2.2.2 Active Record version 2.2.2 Action Pack version 2.2.2 Active Resource version 2.2.2 Action Mailer version 2.2.2 Active Support version 2.2.2 Application root /home/virtwww/w_lustin_e3572841/http Environment production Database adapter postgresql Database schema version 0
i dont now, why database version is 0
when i decided to force schema generation and run
rake db:schema:dump RAILS_ENV="production" --trace
nothing changes
cat db/schema.rb # This file is auto-generated from the current state of the database. Instead of editing this file, # please use the migrations feature of Active Record to incrementally modify your database, and # then regenerate this schema definition. # # Note that this schema.rb definition is the authoritative source for your database schema. If you need # to create the application database on another system, you should be using db:schema:load, not running # all the migrations from scratch. The latter is a flawed and unsustainable approach (the more migrations # you'll amass, the slower it'll run and the greater likelihood for issues). # # It's strongly recommended to check this file into your version control system. ActiveRecord::Schema.define(:version => 0) do end
anybody know where is My error
Redmine is working, i have create 3 projects and 5 users.
But, i nave have no ability to migration.
Replies (2)
RE: Redmine does not generate db/schema.rb
-
Added by Alexey Lustin over 17 years ago
RE: Redmine does not generate db/schema.rb
-
Added by Alexey Lustin over 17 years ago
i have wins this problem
if the database in Postgres is not public, then you have to use another parameter in database.yml
and it is schema_search_path:
template looks like this
production: adapter: postgresql database: <your_database_name> host: <postgres_host> username: <postgres_user> passord: <postgres_user_password> encoding: utf8 schema_search_path: <database_schema> (default - public)
in the FAQ i think