<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
I have this issue as well.<br>
<br>
Dickie<br>
<br>
<div class="moz-cite-prefix">On 2/18/2016 6:59 PM, Abel Alejandro
wrote:<br>
</div>
<blockquote
cite="mid:CAKiNg231YVZvTLjaCqjO772zrbfFcv6mvkrkc1NymjvQykYiWQ@mail.gmail.com"
type="cite">
<div dir="ltr">Got stuck during freeside-upgrade with this error:<br>
<br>
<div>ALTER TABLE password_history ADD FOREIGN KEY (
svc_acct__svcnum ) REFERENCES svc_acct ( svcnum ) ,</div>
<div> ADD FOREIGN KEY ( svc_dsl__svcnum ) REFERENCES svc_dsl (
svcnum ) ,</div>
<div> ADD FOREIGN KEY ( svc_alarm__svcnum ) REFERENCES
svc_alarm ( svcnum ) ,</div>
<div> ADD FOREIGN KEY ( agent__agentnum ) REFERENCES agent (
agentnum ) ,</div>
<div> ADD FOREIGN KEY ( contact__contactnum ) REFERENCES
contact ( contactnum ) ,</div>
<div> ADD FOREIGN KEY ( access_user__usernum ) REFERENCES
access_user ( usernum ) </div>
<div>DBD::Pg::db do failed: ERROR: insert or update on table
"password_history" violates foreign key constraint
"password_history_svc_acct__svcnum_fkey"</div>
<div>DETAIL: Key (svc_acct__svcnum)=(1015) is not present in
table "svc_acct". at /usr/local/bin/freeside-upgrade line 299.</div>
<div>Error: ERROR: insert or update on table "password_history"
violates foreign key constraint
"password_history_svc_acct__svcnum_fkey"</div>
<div>DETAIL: Key (svc_acct__svcnum)=(1015) is not present in
table "svc_acct".</div>
<div> executing: ALTER TABLE password_history ADD FOREIGN KEY (
svc_acct__svcnum ) REFERENCES svc_acct ( svcnum ) ,</div>
<div> ADD FOREIGN KEY ( svc_dsl__svcnum ) REFERENCES svc_dsl (
svcnum ) ,</div>
<div> ADD FOREIGN KEY ( svc_alarm__svcnum ) REFERENCES
svc_alarm ( svcnum ) ,</div>
<div> ADD FOREIGN KEY ( agent__agentnum ) REFERENCES agent (
agentnum ) ,</div>
<div> ADD FOREIGN KEY ( contact__contactnum ) REFERENCES
contact ( contactnum ) ,</div>
<div> ADD FOREIGN KEY ( access_user__usernum ) REFERENCES
access_user ( usernum ) at /usr/local/bin/freeside-upgrade
line 299.</div>
<div><br>
</div>
<div>Anyone having the same thing or just me?</div>
<div><br>
</div>
-- <br>
<div class="gmail_signature">
<div dir="ltr"><span
style="font-family:arial,sans-serif;font-size:13px;color:rgb(102,102,102);background-color:rgb(255,255,255)"><i><font
size="4" face="'trebuchet ms', sans-serif">Abel
Alejandro</font></i></span>
<div
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><span
style="color:rgb(51,51,51);font-family:'trebuchet
ms',sans-serif">787 586 8313 </span><span
style="font-family:'trebuchet ms',sans-serif"><font
color="#ff6600">|</font></span><span
style="color:rgb(51,51,51);font-family:'trebuchet
ms',sans-serif"> 787 705 0555</span>
<div>
<div><br>
</div>
<div><span
style="color:rgb(102,102,102);font-family:'trebuchet
ms',sans-serif">400 Calle Calaf 477</span></div>
<div>
<div style="text-align:left"><span
style="color:rgb(102,102,102);font-family:'trebuchet
ms',sans-serif">San Juan, PR 00918</span></div>
</div>
</div>
</div>
<div
style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;text-align:left;background-color:rgb(255,255,255)"><a
moz-do-not-send="true"
href="mailto:aalejandro@alliedtechnologygrouppr.com"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:aalejandro@alliedtechnologygrouppr.com">aalejandro@alliedtechnologygrouppr.com</a></a></div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
freeside-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:freeside-users@freeside.biz">freeside-users@freeside.biz</a>
<a class="moz-txt-link-freetext" href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users">http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Dickie Bradford
Never-Enuff Intenet & Computer Services
117 North Main Street
Box 242
Carrolltown, Pa 15722
Phone: 814.344.8189
Fax: 814-690-1674
<a class="moz-txt-link-freetext" href="http://Never-Enuff.net">http://Never-Enuff.net</a></pre>
</body>
</html>