[freeside-users] svc_broadband.blocknum

[Gregory Vera]

Thanks Kristian will give it a go

Gregory Vera



   1. Re: svc_broadband.blocknum Error (Kristian Hoffmann)


----------------------------------------------------------------------

Message: 1
Date: Fri, 12 Oct 2007 20:04:48 -0700 (PDT)
From: Kristian Hoffmann <khoff at fire2wire.com>
Subject: Re: [freeside-users] svc_broadband.blocknum Error
To: Freeside users mailing list <freeside-users at sisd.com>
Message-ID:
	<Pine.LNX.4.44.0710121955220.31501-100000 at luaren.pc-intouch.com>
Content-Type: TEXT/PLAIN; charset=X-UNKNOWN

The error message should read something like...

Can't find svc_broadband.blocknum in addr_block.blocknum

I'm assuming it just didn't get copied correctly.  Anyway, you'd get that
error if you had a svc_broadband record that references an
addr_block.blocknum that doesn't exist.  You could try running this
query...

SELECT svc_broadband.svcnum FROM svc_broadband
  LEFT JOIN addr_block ON (svc_broadband.blocknum = addr_block.blocknum)
  WHERE addr_block.blocknum IS NULL;

If it returns any records, then you have corrupt svc_broadband records
(possibly from directly manipulating the database?).  Hopefully that will
at least point you in the right direction.

Regards,

-- 
Kristian Hoffmann
Fire2Wire System Administrator
khoff at fire2wire.com



On Fri, 12 Oct 2007, Gregory Vera wrote:

> When editing or adding information to the Virtual Fields I have added for
> the svc_broadband I get the following error.
>
>
>
> Can?t find svc_broadband.blocknum inadd_block.blocknum
>
>
>
> What I?m I missing
>
>
>
>
>
> Gregory Vera
>
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.488 / Virus Database: 269.14.8/1064 - Release Date:
2007/10/11
> 03:09 PM
>
>



------------------------------

_______________________________________________
freeside-users mailing list
freeside-users at sisd.com
http://420.am/cgi-bin/mailman/listinfo/freeside-users


End of freeside-users Digest, Vol 28, Issue 10
**********************************************

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.14.10/1070 - Release Date: 2007/10/14
09:22 AM
 

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.14.10/1070 - Release Date: 2007/10/14
09:22 AM