Re: [Phpgroupware-users] RC1 installation problems

[Brian Johnson]

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 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,)
>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
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.

>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
>