[Spce-user] mySQL problem with Subscriber Profiles

[Daniel Grotti]

Hi,
is that a fresh installation ? If not, after the upgrade did you run
ngcp-update-db-schema and ngcp-update-cfg-schema ?

Also are you assigning a profile set having the same reseller of the
target subscriber ?

It works for me on latest mr3.8.1.



--
Daniel Grotti
VoIP Engineer


Sipwise GmbH
Europaring F15 | 2345 Brunn am Gebirge, Austria | www.sipwise.com

On 05/19/2015 11:42 AM, Matthias Hohl wrote:
> Hello everybody,
> 
>  
> 
> I found a strange problem today in a test environment with 3.8.1
> 
>  
> 
> If I want to attach a “subscriber profile set” to a subscriber, I got a
> failure message “Failed to update subscriber” on the web interface.
> 
> If I look into the panel.log File I see this message:
> 
>  
> 
> May 19 11:29:33 xaas-sip ngcp-panel: ERROR: IP=80.0.0.1
> CALLED=Controller::Subscriber::edit_master TX=13DF95AC23625EF0
> USER=administrator DATA={ 'e164.cc' => '43', 'submitid' => '',
> 'profile.id' => '', 'webpassword' => 'e6oiM=', 'status' => 'active',
> 'lock' => '', 'webusername' => 'awtest', 'username' => 'awtest', 'save'
> => 'Save', 'e164.ac' => '720', 'email' => 'aw at org.org', 'password' =>
> 'jL0o<d', 'external_id' => '', 'profile_set.id' => '1', 'e164.sn' =>
> '8123456'} MSG="Failed to update subscriber
> (DBIx::Class::ResultSet::create(): *DBI Exception: DBD::mysql::st
> execute failed: Unknown column 'reseller_id' in 'field list'* [for
> Statement "INSERT INTO `accounting`.`events` ( `export_status`,
> `exported_at`, `new_status`, `old_status`, `reseller_id`,
> `subscriber_id`, `timestamp`, `type`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? )"
> with ParamValues: 0='unexported', 1=undef, 2='1', 3='', 4='3', 5='4',
> 6=1432027773, 7='start_profile'] at
> /usr/share/perl5/NGCP/Panel/Utils/Events.pm line 15#012)" LOG=""
> 
>  
> 
>  
> 
> Does anyone has a idea how to fix that?
> 
> 
> 
> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> https://lists.sipwise.com/listinfo/spce-user
>