[Spce-user] mySQL problem with Subscriber Profiles

Matthias Hohl matthias.hohl at telematica.at
Tue May 19 05:42:17 EDT 2015


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?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sipwise.com/mailman/private/spce-user_lists.sipwise.com/attachments/20150519/9293958a/attachment.html>


More information about the Spce-user mailing list