[Phpgroupware-tracker] [Bug #3420] addressbook error postgresql 7.3.x

[nobody]

=================== BUG #3420: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3420&group_id=509

Changes by: Dave Hall <address@hidden>
Date: Fri 05/02/2003 at 11:54 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
          Resolution | Fixed                     | Invalid
              Status | Open                      | Closed


------------------ Additional Follow-up Comments ----------------------------
:)

That damn keyboard chair interface needs some work i think ;)



=================== BUG #3420: FULL BUG SNAPSHOT ===================


Submitted by: reiner_j                Project: phpGroupWare                 
Submitted on: Fri 05/02/2003 at 10:14
Category:  addressbook                Bug Group:  None                      
Severity:  5 - Major                  Priority:  None                       
Resolution:  Invalid                  Assigned to:  skwashd                 
Status:  Closed                       Component Version:  None              
Platform Version:  None               Reproducibility:  None                

Summary:  addressbook error postgresql 7.3.x

Original Submission:  Database error: Invalid SQL: INSERT INTO 
phpgw_addressbook 
(owner,access,cat_id,tid,fn,n_given,n_family,n_middle,n_prefix,n_suffix,sound,bday,note,tz,geo,url,pubkey,org_name,org_unit,title,adr_one_street,adr_one_locality,adr_one_region,adr_one_postalcode,adr_one_countryname,adr_one_type,label,adr_two_street,adr_two_locality,adr_two_region,adr_two_postalcode,adr_two_countryname,adr_two_type,tel_work,tel_home,tel_voice,tel_fax,tel_msg,tel_cell,tel_pager,tel_bbs,tel_modem,tel_car,tel_isdn,tel_video,tel_prefer,email,email_type,email_home,email_home_type,last_mod)
 VALUES ('3','public','','n','test 
user','test','user','','','','','','','0','','','','','','jddcd','','','','','','','','','','','','','','','','','','','','','','','','','','','','INTERNET','','INTERNET','1051827088')
PostgreSQL Error: 1 (ERROR: Relation »phpgw_addressbook« hat keine Spalte 
»last_mod« )

File: /var/www/html/phpg016/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.php
Line: 584

Session halted.

Follow-up Comments
*******************

-------------------------------------------------------
Date: Fri 05/02/2003 at 11:54       By: skwashd
:)

That damn keyboard chair interface needs some work i think ;)

-------------------------------------------------------
Date: Fri 05/02/2003 at 11:52       By: reiner_j
this was the prob :-(

-------------------------------------------------------
Date: Fri 05/02/2003 at 11:33       By: skwashd
but did you update the api in setup?

-------------------------------------------------------
Date: Fri 05/02/2003 at 11:13       By: reiner_j
update run 1 hour ago. Cant be the problem

-------------------------------------------------------
Date: Fri 05/02/2003 at 11:03       By: skwashd
It looks like you have not run the update in setup.  The extra field was added 
to support sync.


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=3420&group_id=509