ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: relation "settings" does not exist

Added by f lx about 1 year ago

-ruby 2.5.9p229 (2021-04-05 revision 67939) [x86_64-linux]
-Rails 5.2.6
-CentOS Linux release 8.4.2105
-postgres (PostgreSQL) 13.3(datestyle ISO, MDY & encoding UTF8)

Hi Redmine Community,

i'm setting up a Redmine installation and ran into the following problem:

i'm at step 9 of the installation process:

when i point my browser to the.Mac.hin.e:3000 i get the following:

screenshot webbrowser

the log gives me the following:

@[root@xxx-redmine log]# cat production.log
Creating scope :system. Overwriting existing method Enumeration.system.
Creating scope :sorted. Overwriting existing method Group.sorted.
Creating scope :sorted. Overwriting existing method User.sorted.
Started GET "/" for 192.168.xx.xx at 2021-08-17 05:54:22 -0400
Processing by WelcomeController#index as HTML
Completed 500 Internal Server Error in 259ms (ActiveRecord: 24.9ms)

ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: relation "settings" does not exist
LINE 8: WHERE a.attrelid = '"settings"'::regclass
: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,
c.collname, col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a
LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation
WHERE a.attrelid = '"settings"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum

i couldn't find a solution in the past 3 hours. the only hint i got was here:

as there's no explanation why there's no technical support to this problem, i'm tryin' to ask you for help, hoping my case differs from issue 11230.
if you need any other information, feel free to ask.
if there's no technical support from your side, could you pleae leave a hint where to look for a solution?
thx in advance!


forgot to ad the output from /script/about:

[root@xxx-redmine redmine-4.2.2]# ls
app appveyor.yml bin config db doc extra files Gemfile Gemfile.lock lib log package.json plugins public Rakefile README.rdoc test tmp vendor yarn.lock
[root@xxx-redmine redmine-4.2.2]# RAILS_ENV=production /script/about
-bash: /script/about: No such file or directory

redmine.png - screenshot webbrowser (8.42 KB)

Replies (1)

RE: ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: relation "settings" does not exist - Added by Fletcher Johnston about 1 year ago

Hi there,

Not familiar with WEBrick and your exact setup, but just reading the error message: "PG::UndefinedTable: ERROR: relation "settings" does not exist".

Are you able to connect to your PostgreSQL server and confirm that the settings table was created by the migrations? Perhaps something went wrong during the migration and that table is missing?