[freeside-users] Upgrade from 3.9 to 4.0

Ivan Kohler ivan at freeside.biz
Tue Aug 16 15:38:15 PDT 2016


Thanks for the problem report with full error message.

This is fixed in 4.1 (and the upgrade will take care of the cleanup).

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


On Thu, Feb 18, 2016 at 07:59:00PM -0400, Abel Alejandro wrote:
> Got stuck during freeside-upgrade with this error:
> 
> ALTER TABLE password_history ADD FOREIGN KEY ( svc_acct__svcnum )
> REFERENCES svc_acct ( svcnum ) ,
>   ADD FOREIGN KEY ( svc_dsl__svcnum ) REFERENCES svc_dsl ( svcnum ) ,
>   ADD FOREIGN KEY ( svc_alarm__svcnum ) REFERENCES svc_alarm ( svcnum ) ,
>   ADD FOREIGN KEY ( agent__agentnum ) REFERENCES agent ( agentnum ) ,
>   ADD FOREIGN KEY ( contact__contactnum ) REFERENCES contact ( contactnum )
> ,
>   ADD FOREIGN KEY ( access_user__usernum ) REFERENCES access_user ( usernum
> )
> DBD::Pg::db do failed: ERROR:  insert or update on table "password_history"
> violates foreign key constraint "password_history_svc_acct__svcnum_fkey"
> DETAIL:  Key (svc_acct__svcnum)=(1015) is not present in table "svc_acct".
> at /usr/local/bin/freeside-upgrade line 299.
> Error: ERROR:  insert or update on table "password_history" violates
> foreign key constraint "password_history_svc_acct__svcnum_fkey"
> DETAIL:  Key (svc_acct__svcnum)=(1015) is not present in table "svc_acct".
>  executing: ALTER TABLE password_history ADD FOREIGN KEY ( svc_acct__svcnum
> ) REFERENCES svc_acct ( svcnum ) ,
>   ADD FOREIGN KEY ( svc_dsl__svcnum ) REFERENCES svc_dsl ( svcnum ) ,
>   ADD FOREIGN KEY ( svc_alarm__svcnum ) REFERENCES svc_alarm ( svcnum ) ,
>   ADD FOREIGN KEY ( agent__agentnum ) REFERENCES agent ( agentnum ) ,
>   ADD FOREIGN KEY ( contact__contactnum ) REFERENCES contact ( contactnum )
> ,
>   ADD FOREIGN KEY ( access_user__usernum ) REFERENCES access_user ( usernum
> )  at /usr/local/bin/freeside-upgrade line 299.
> 
> Anyone having the same thing or just me?
> 
> -- 
> *Abel Alejandro*
> 
> 787 586 8313 | 787 705 0555
> <joquendo at alliedtechnologygrouppr.com>
> 
> 400 Calle Calaf 477
> San Juan, PR 00918
> aalejandro at alliedtechnologygrouppr.com

> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz
> http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users



More information about the freeside-users mailing list