Re: [Phpgroupware-users] RC1 installation problems

[Kevin Scott]

Brian Johnson (address@hidden) wrote:
>
>look at the good side, the list isn't taking 12 hours to post a message 
>anymore :)
>
>

Time is relative.
I still prefer a mailist over IRC as it is easier to search.

>
>Kevin Scott (address@hidden) wrote:
>>
>>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
>>>
>>>
>>
>>
>>
>>
>>
>>_______________________________________________
>>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