[freeside-users] svc_broadband.blocknum Error

[Kristian Hoffmann]

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
>
>