[freeside-users] import 3.6git database into 4.1 ?

[Ivan Kohler]

We have not seen any upgrade failures of this sort.

Attempting to insert a record into cust_location with an existing 
primary key seems very strange and makes me wonder if there is a more 
serious underlying problem with your database.

Do you still see this problem with a current snapshot of 
FREESIDE_4_BRANCH ?

-- 
Ivan Kohler
President and Head Geek
Freeside Internet Services, Inc.
http://www.freeside.biz/


On Sat, Dec 10, 2016 at 05:03:44PM -0500, Ian Fraser wrote:
> 
> Allows the upgrade to continue until it gets to upgrading cust_main  where
> it dies on a non-unique key.  However the Record referred to IS unique as
> below:
> 
> DBD::Pg::st execute failed: ERROR:  duplicate key value violates unique
> constraint "cust_location_pkey"
> DETAIL:  Key (locationnum)=(6) already exists. [for Statement "INSERT INTO
> cust_location ( locationnum, custnum, address1, city, state, zip, latitude,
> longitude, coord_auto, country) VALUES ('6', '5', '145 noway ', 'Dallas',
> 'CA', '78945', '43.0119437', '-84.7411244', 'Y', 'US')"] at
> /usr/share/perl5/FS/Record.pm line 1376.
> Error upgradging payment information for custnum 5: ERROR: duplicate key
> value violates unique constraint "cust_location_pkey"
> DETAIL:  Key (locationnum)=(6) already exists. at
> /usr/share/perl5/FS/cust_main.pm line 5720.