[Spce-user] Contract does not exist for subscriber

[Anibal Cañada]

----- Mensaje original -----
De: "Andreas Granig" <agranig at sipwise.com>
Para: spce-user at lists.sipwise.com
Enviados: Miércoles, 19 de Noviembre 2014 13:47:53
Asunto: Re: [Spce-user] Contract does not exist for subscriber

Hi,

Hi, 
thank you very much for your fast response.
The error was that client haven´t the reseller_id correctly set in contacts.
After do ' update contacts set  reseller_id='1'  where id='6';' everything gonna ok again.
I am running a mr3.5.1 version, from a 3.1. A little tricky update history.

I didn´t know exactly how i ended in this scenario. it was the only one who give me that problem and was after the upgrade.
Thank you again,
Best regards.


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
> 
_______________________________________________
Spce-user mailing list
Spce-user at lists.sipwise.com
https://lists.sipwise.com/listinfo/spce-user