Forum OpenACS Q&A: Error creating users after restore

Collapse
1: Error creating users after restore
Posted by Janine Ohmer on 01/16/04 09:03 PM
I just moved a 4.6.3/1.0.1 site from one system to another.  I did the usual:  load postgresql.sql and then the site dump.  Nothing out of the ordinary happened, but you cannot create users on the new site.  This error:

ERROR:  -20001: membership_rel  violation: Invalid object types. Object -2 (application_group) must be of type group Object 3334 (user) must be of type person

happens during the call to acs__add_user.

Any ideas what this could be???

Collapse
2: Re: Error creating users after restore (response to 1)
Posted by Janine Ohmer on 01/16/04 09:32 PM
*cough* apparently this is what happens when you forget to run "createlang plpgsql".  There must have been some errors the first time but I didn't spot them.

Well, hopefully this will help some other poor soul. :)