[Spce-user] Contract does not exist for subscriber

[Andreas Granig]

Hi,

Looks like your DB is messed up. The column
billing.voip_subscribers.contract_id refers to billing.contracts.id, and
if you do "select contract_id from billing.voip_subscribers where id=4",
you should get a contract id which must exist in billing.contracts. If
this exists, you can dig one step further and check the contact_id in
the billing.contracts table, which in turn must reference to
billing.contacts, which again in turn must have a valid
billing.contact.reseller_id set.

Yeah, not exactly simple, so I'm wondering how you even ended up in this
scenario? Which version are you running, and did you upgrade from an
older version, and which version was the initially installed one, and
did you try to tinker with the DB directly or via the API?

Andreas

On 11/19/2014 01:20 PM, Anibal Cañada wrote:
> 
> hi, when i try to look client in the admin web, it send me this error, and dont let me in:
> 
> Contract does not exist for subscriber [13A80FB8EFF45FB0]
> 
> This the output from cat /var/log/ngcp/panel.log
> 
> Nov 19 13:16:09 sip1 ngcp-panel: ERROR: IP=XXX.98.XX.122 CALLED=Controller::Subscriber::base TX=13A80FB8EFF45FB0 USER=administrator DATA={} MSG="Contract does not exist for subscriber (subscriber id '4' points to non-existing contract id)" LOG=""
> 
> I suppose is just a command in the mysql database , but i cant find the table.
> 
> Best regards.
> 
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
>