Re: [Chasers-general] software setup

[shua <shua@u.washington.edu>]

ok, so i may be on my last thing for today. i finally got to
loadingthings and the first two worked (schema and look) but here is
what happened with add_system:


> [root@d-128-95-80-203 ~]# psql -U mars -f /var/www/html/chasers/chasers-schema/add_system_users.sql marsptdb
> INSERT 0 2
> psql:/var/www/html/chasers/chasers-schema/add_system_users.sql:32: ERROR:  null value in column "permission_date" violates not-null constraint
> psql:/var/www/html/chasers/chasers-schema/add_system_users.sql:39: ERROR:  language "plpgsql" does not exist
> HINT:  Use CREATE LANGUAGE to load the language into the database.

any quick answers here? i would love to finish this today.

thanks,
j

On Wed, 2007-01-24 at 16:30 -0800, Jonathan Hedstrom wrote:
> shua wrote:
> > when making changes to php.ini i have two questions.
> >
> > 1. i went into /etc/php.ini and edited the text. the only lines that are
> > actually necessary to edit DO NOT have ";" at the start, correct? reason
> > i ask is because the line "allow_call_time_pass_reference = On" appears
> > in 2 places but only once without a ";" in front of it. 
> >
> >   
> That's correct (everything behind a ";" is a comment). I'm not quite
> sure why the php people include each option twice...it seems confusing.
> > 2. for the changes regarding memory, do i need the text in the second
> > set of parentheses as well:
> >
> >   
> >> memory_limit = 32M      ; Maximum amount of memory a script may
> >> consume (8MB) (8MB barfs on FC3/PG8)
> >>     
> No, the line should simply read:
> 
> memory_limit = 32M
> 
> again, everything else behind the ";" is a comment, so the rest isn't necessary
> 
> 
> 
> -Jonathan