Project

General

Profile

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

Added by f lx over 2 years 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)
-WEBrick

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:
https://www.redmine.org/projects/redmine/wiki/RedmineInstall#Step-9-Test-the-installation

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:

https://www.redmine.org/issues/11230

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!

flxx

Edit:
forgot to ad the output from /script/about:

[root@xxx-redmine redmine-4.2.2]# ls
app appveyor.yml bin config config.ru CONTRIBUTING.md 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 (8.42 KB) redmine.png screenshot webbrowser

Replies (1)

RE: ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR: relation "settings" does not exist - Added by Fletcher Johnston over 2 years 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?

    (1-1/1)