[freeside-users] Upgrade from 3.9 to 4.0

[Abel Alejandro]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://freeside.biz/pipermail/freeside-users/attachments/20160218/0e003d32/attachment.html>