[rt-users] ERROR: relation "fm_classcustomfields_id_seq" does not exist

[Jesse Vincent]

On Tue, Jan 24, 2006 at 07:34:22PM -0600, Tracy Phillips wrote:
> Hi,
> 
> I am trying to install RTFM 2.2.0RC1 with RT 3.4.4 on FreeBSD 6.0 with
> Postgresql 8.1.
> 
> This is the error that I get:

Looks like the Pg ACL file is a bit out of date. from acl.pg, remove all
table names except:
	
FM_Classes_id_seq
FM_Classes
FM_Articles_id_seq
FM_Articles
FM_Topics_id_seq
FM_Topics
FM_ObjectTopics_id_seq
FM_ObjectTopics


> 
> [root at ded002 RTFM-2.2.0RC1]# make initdb
> /usr/bin/perl -Ilib -I/usr/local/rt3/lib
> /usr/local/rt3/sbin/rt-setup-database --action schema --datadir etc
> --datafile etc/initialdata --dba rt_user --prompt-for-dba-password
> In order to create or update your RT database,this script needs to
> connect to your Pg instance on localhost as rt_user.
> Please specify that user's database password below. If the user has no
> database
> password, just press return.
> 
> Password:
> Creating database schema.
> Done setting up database schema.
> /usr/bin/perl -Ilib -I/usr/local/rt3/lib
> /usr/local/rt3/sbin/rt-setup-database --action acl --datadir etc
> --datafile etc/initialdata --dba rt_user --prompt-for-dba-password
> In order to create or update your RT database,this script needs to
> connect to your Pg instance on localhost as rt_user.
> Please specify that user's database password below. If the user has no
> database
> password, just press return.
> 
> Password:
> DBD::Pg::st execute failed: ERROR:  relation
> "fm_classcustomfields_id_seq" does not exist
> Problem with statement:
>  GRANT SELECT, INSERT, UPDATE, DELETE ON FM_ClassCustomFields_id_seq to
> rt_user;
> ERROR:  relation "fm_classcustomfields_id_seq" does not exist
> ...returned with error: 65280
> *** Error code 255
> 
> Stop in /root/RTFM-2.2.0RC1.
> 
> Any ideas on how to get past this point?
> 
> Thanks,
> 
> Tracy
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT Wiki at http://wiki.bestpractical.com
> 
> Download a free sample chapter of RT Essentials from O'Reilly Media at http://rtbook.bestpractical.com
> 
> WE'RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
> San Francisco - Find out more at http://bestpractical.com/services/training.html
> 

--