[Spce-user] mySQL problem with Subscriber Profiles

[Alexander Griesser]

Hi Daniel,

thanks, that seems to be the issue - we forgot about the update-db-schema, now the table looks better:

mysql> explain events;
+---------------+---------------------------------------------+------+-----+------------+----------------+
| Field         | Type                                        | Null | Key | Default    | Extra          |
+---------------+---------------------------------------------+------+-----+------------+----------------+
| id            | int(11) unsigned                            | NO   | PRI | NULL       | auto_increment |
| type          | varchar(255)                                | NO   |     | NULL       |                |
| subscriber_id | int(11) unsigned                            | NO   | MUL | NULL       |                |
| reseller_id   | int(11) unsigned                            | NO   |     | 1          |                |
| old_status    | varchar(255)                                | YES  |     | NULL       |                |
| new_status    | varchar(255)                                | NO   |     | NULL       |                |
| timestamp     | decimal(13,3)                               | NO   |     | NULL       |                |
| export_status | enum('unexported','ok','filtered','failed') | NO   | MUL | unexported |                |
| exported_at   | datetime                                    | YES  |     | NULL       |                |
+---------------+---------------------------------------------+------+-----+------------+----------------+
9 rows in set (0.00 sec)

best,

Alexander Griesser
Head of Systems Operations

ANEXIA Internetdienstleistungs GmbH

E-Mail: ag at anexia.at
Web: http://www.anexia.at

Anschrift Hauptsitz Klagenfurt: Feldkirchnerstraße 140, 9020 Klagenfurt
Geschäftsführer: Alexander Windbichler
Firmenbuch: FN 289918a | Gerichtsstand: Klagenfurt | UID-Nummer: AT U63216601

-----Ursprüngliche Nachricht-----
Von: Spce-user [mailto:spce-user-bounces at lists.sipwise.com] Im Auftrag von Daniel Grotti
Gesendet: Dienstag, 19. Mai 2015 12:21
An: spce-user at lists.sipwise.com
Betreff: Re: [Spce-user] mySQL problem with Subscriber Profiles

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