Pgsql... customroles does not exist

RT Users
#1

Hi,

Yes, I don’t see it in the database tables at all. I have to assume
that I missed a database upgrade script for PostgreSQL when I migrated.
However, I can’t seem to find it. Or, is there a pgsql command that I
run to create the new tables?

Thank you,

Paul

#2

Hi,

Hi Paul,

Yes, I don’t see it in the database tables at all. I have to assume that I missed a database upgrade script for PostgreSQL when I migrated. However, I can’t seem to find it. Or, is there a pgsql command that I run to create the new tables?

The CustomRoles table is created by the 4.3.12 upgrade step (specifically, the file schema.Pg). You can inspect which upgrade steps you’ve run by visiting Admin -> Tools -> System Configuration then scrolling down to “RT upgrade history”.

Thank you,

Paul

Best,
Shawn

signature.asc (801 Bytes)

#3

That was friggin’ GLORIOUS. :slight_smile:

Thank you, Shawn. That cleared up everything. :slight_smile:

P.

PS - I didn’t know that system configuration page existed either! THANKS!On 07/19/2016 11:25, Shawn M Moore wrote:

On Jul 19, 2016, at 10:52, pathiaki2 via rt-users rt-users@lists.bestpractical.com wrote:
Hi,
Hi Paul,

Yes, I don’t see it in the database tables at all. I have to assume that I missed a database upgrade script for PostgreSQL when I migrated. However, I can’t seem to find it. Or, is there a pgsql command that I run to create the new tables?
The CustomRoles table is created by the 4.3.12 upgrade step (specifically, the file schema.Pg). You can inspect which upgrade steps you’ve run by visiting Admin -> Tools -> System Configuration then scrolling down to “RT upgrade history”.

Thank you,

Paul
Best,
Shawn