bugphpGroupWare - Bugs: bug #5245, Upgrade of existing DB fails

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #5245: Upgrade of existing DB fails

Submitted by:  Invalid User ID <Invalid User ID>
Submitted on:  Fri 12 Sep 2003 08:47:40 PM UTC  
 
Item Group: 0.9.16RC1Category: API - phpGroupware API
Severity: 3 - NormalPriority: 5 - Normal
Status: FixedPrivacy: Public
Assigned to: Alejandro Borges (lex) <alexbsa>Open/Closed: Closed
Component Version: SVNOperating System: GNU/Linux - SuSE
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Thu 18 Sep 2003 10:40:04 PM UTC, comment #3:

Hey Stefan,

Thanks for helping with the testing. Will close this one.

Dave Hall <skwashd>
Project Administrator
Thu 18 Sep 2003 06:39:54 AM UTC, comment #2:

hey!! i think i found where is the error, in setup scripts, in tables_update.inc.php when try to upgrade the addresses this code run:

$db1->query("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) VALUES ("
. $GLOBALS['phpgw_setup']->oProc->f('org_id')
. ", '" .
$db1->db_addslashes($GLOBALS['phpgw_setup']->oProc->f('adr_one_street'))
." '" . ", '" .
$db1->db_addslashes($GLOBALS['phpgw_setup']->oProc->f('adr_one_locality'))
. "'" . ", '" . $db1->db_addslashes($GLOBALS['phpgw_setup']->oProc->f('adr_one_region'))
." '" . ", '".
$db1->db_addslashes($GLOBALS['phpgw_setup']->oProc->f('adr_one_postalcode'))
." '". ", '" . $db1->db_addslashes($GLOBALS['phpgw_setup']->oProc->f('adr_one_countryname'))
." '". ", " .
intval($GLOBALS['phpgw_setup']->oProc->f('tz'))
. ", " .
($GLOBALS['phpgw_setup']->oProc->f('addr_type_id'))? $GLOBALS['phpgw_setup']->oProc->f('addr_type_id') : $addr_type
. ", " . $GLOBALS['phpgw_setup']->oProc->f('created_on')
. ", " . $GLOBALS['phpgw_setup']->oProc->f('created_by')
. ", " . $GLOBALS['phpgw_setup']->oProc->f('modified_on')
. ", " . $GLOBALS['phpgw_setup']->oProc->f('modified_by')
. ");");

and for any reason the sql which this want to run is '3' i think this 3 is the addr_type_id, but i don't know why this concatenation only returns '3'.

i will review this later and try to fix, but probably bjohnson can help me in this :P

Jonathan Rivera <jarg>
Sat 13 Sep 2003 11:15:10 PM UTC, comment #1:

Can you please try a CVS update - I think this one was fixed the other day.

Dave Hall <skwashd>
Project Administrator

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 3 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Thu 18 Sep 2003 10:40:04 PM UTCskwashdStatusNone=>(Error - Not Found)
  Open/ClosedOpen=>(Error - Not Found)
Sat 13 Sep 2003 11:15:10 PM UTCskwashdAssigned toNone=>NA

Back to the top


Powered by Savane 3.1-cleanup1