[Phpgroupware-tracker] [bug #5175] Upgrade of existing DB fails

[nobody]

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

Changes by: Stefan Lauterbach <address@hidden>
Date: Fri 09/12/2003 at 20:44 (GMT)

------------------ Additional Follow-up Comments ----------------------------
Unfortunately I ran into another error. And I cannot find the location of the 
SQL statement.



Database error: Invalid SQL: 3

MySQL Error: 1064 (You have an error in your SQL syntax near '3' at line 1)



Session halted.



=================== BUG #5175: FULL BUG SNAPSHOT ===================


Submitted by: stl                     Project: phpGroupWare                 
Submitted on: Tue 09/09/2003 at 21:08
Category:  API - Setup                Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  High                       
Resolution:  Fixed                    Assigned to:  None                    
Status:  Closed                       Component Version:  TGZ               
Platform Version:  Linux - SuSE       Reproducibility:  Every Time          

Summary:  Upgrade of existing DB fails

Original Submission:  The automatic upgrade of the DB fails with the following 
message:



Database error: Invalid SQL: INSERT INTO phpgw_contact_addr (contact_id,add1, 
city, state, postal_code, country, tz, addr_type_id, created_on, created_by, 
modified_on, modified_by, addr_type_id) VALUES (201, 'Heinrich-Pesch-Straße 10 
', 'Köln', 'Nrw ', '50739 ', 'DE ', 0, 3, 1063140886, 5, 1063140886, 5, 0);

MySQL Error: 1110 (Column 'addr_type_id' specified twice)



Session halted.



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

-------------------------------------------------------
Date: Fri 09/12/2003 at 20:44       By: stl
Unfortunately I ran into another error. And I cannot find the location of the 
SQL statement.



Database error: Invalid SQL: 3

MySQL Error: 1064 (You have an error in your SQL syntax near '3' at line 1)



Session halted.

-------------------------------------------------------
Date: Tue 09/09/2003 at 23:53       By: skwashd
This has been corrected in CVS.



To grab a complete update of all fixes:



1)  Check to see if you have cvs installed: 'cvs --help'.

1a) If not, install a copy of cvs-cli from your favorite 

distro.



2)  Then just type:

    'cd <your phpgroupware dir>; cvs update -dP'.



You can do step 2 as many times in a day as you wish, and 

will always get the most current bug fixes.



Thanks,




CC list is empty


No files currently attached


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

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/