Re: [Phpgroupware-users] RC1 installation problems

[Dave Hall]

Alex Borges <address@hidden> wrote:

> We found it....youre right, it was b0rk3n will be fixed in cvs as soon
> as i can nag dave to commit the change (its still really early in AU).
> 

Done

> 
> El vie, 12-09-2003 a las 09:44, Kevin Scott escribió:
> > Brian Johnson (address@hidden) wrote:
> > >
> > >Kevin Scott (address@hidden) wrote:
> > >>
> > >>cvs update this morning 9/12 EST postgresql 7.3.3 php4.2.2 
> apache 1.3.26
> > >>
> > >>upgrading a .508 dataset gets this error
> > >>
> > >>Database error: Invalid SQL: 3
> > >>PostgreSQL Error: 1 (ERROR: parser: parse error at or near "3" 
> at character 1 )
> > >>
> > >>Session halted.
> > >>
> > >>Hitting the back button and trying upgrade again gets this
> > >>
> > >>Database error: Invalid SQL: ALTER TABLE phpgw_accounts ADD 
> COLUMN person_id int4
> > >>PostgreSQL Error: 1 (ERROR: ALTER TABLE: column name 
> "person_id" already exists in
> > >>table "phpgw_accounts" )
> > >>
> > >
> > >This is very odd.  Can you load the 
> phpgwapi/setup/tables_update.inc.php file and
> > >search for a '3' in the upgrade to .509 function (should be the 
> second to last section)
> > >
> > >The lack of more SQL in the error makes it look like it is 
> trying to submit a '3' as
> > >a complate SQL query.
> > >
> > >It might also be a variable and harder to spot.  The SQL is 
> usually made up of a
> > >number of lines in the code and something like $sql .= "";
> > >
> > >The period means add it to the existing $sql string being 
> constructed.  Maybe you're
> > >missing one of the periods?
> > >
> > 
> > I don't know, I've spent 40 minutes looking at that section and 
> don't see anything
> > out of place. there are no lone 3's and I don't see anywhere a 
> variable would be set
> > to 3
> > 
> > 
> > 
> > >
> > >
> > >>I tried this with two different perfectly functioning .508 
> databases, same thing on
> > >>each.
> > >>
> > >>A Fresh install (new database) goes fine until creating admin 
> user, after the form
> > >>is submitted I get this error.
> > >>
> > >>Database error: Invalid SQL: insert into phpgw_accounts 
> (account_lid, account_type,
> > >>account_pwd, account_firstname, account_lastname, 
> account_status, account_expires,
> > >>person_id) values 
> ('Default','g','f9275xxxxxxxxxxxxxxxdad1cf0ba141',> 
> >>'Default','Group','A',-1,)
> >                         ^^^^  I think this is where the problem 
> is. what is a proper
> > value for person_id?
> > 
> > >>PostgreSQL Error: 1 (ERROR: parser: parse error at or near ")" 
> at character 233 )
> > >>
> > >>File: /usr/local/www/data-
> dist/phpgroupware/phpgwapi/inc/class.accounts_sql.inc.php> >>Line: 348
> > >>
> > >>Session halted.
> > >>
> > >
> > >Is this a completely new install or a existing db with all the 
> tables dropped?
> > 
> > This completely new fresh database
> > 
> > >looks like a sequence for the person_id (actually for contact_id 
> in another table
> > >but person_id is set to equal contact_id) is screwed up somehow 
> (in pgsql dropping
> > >sequences is a separate command/process from dropping a table)
> > >
> > >Just thinking out loud.  Hope something is useful.
> > 
> > Thanks again
> > 
> > >>This makes sense as there are 8 fields but only 7 values.  
> Anyways I can submit a
> > >>bug report or help trouble-shoot this if need be. THanks - 
> Kevin Scott
> > >>
> > >>
> > >>
> > >>_______________________________________________
> > >>Phpgroupware-users mailing list
> > >>address@hidden
> > >>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
> > >>
> > >
> > >
> > >
> > >_______________________________________________
> > >Phpgroupware-users mailing list
> > >address@hidden
> > >http://mail.gnu.org/mailman/listinfo/phpgroupware-users
> > >
> > >
> > 
> > --
> > www.kbinx.com
> > 
> > 
> > 
> > 
> > _______________________________________________
> > Phpgroupware-users mailing list
> > address@hidden
> > http://mail.gnu.org/mailman/listinfo/phpgroupware-users
> 
> 
> 
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
> 
>

dave.hall.vcf
Description: Card for <dave.hall@mbox.com.au>