[freeside-users] Upgrade from 3.9 to 4.0

[Dickie]

I have this issue as well.

Dickie

On 2/18/2016 6:59 PM, 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
>
> 400 Calle Calaf 477
> San Juan, PR 00918
> aalejandro at alliedtechnologygrouppr.com 
> <mailto:aalejandro at alliedtechnologygrouppr.com>
>
>
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz
> http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users

-- 
Dickie Bradford
Never-Enuff Intenet & Computer Services
117 North Main Street
Box 242
Carrolltown, Pa 15722
Phone: 814.344.8189
Fax: 814-690-1674
http://Never-Enuff.net

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://freeside.biz/pipermail/freeside-users/attachments/20160218/6374d0f4/attachment.html>