[Spce-user] error while upgrading

[Gene]

Is there a way to do a clean install?

Thanks.


-----Original Message-----
From: Jon Bonilla (Manwe) [mailto:jbonilla at sipwise.com] 
Sent: Tuesday, September 04, 2012 12:02 PM
To: Gene 
Cc: spce-user at lists.sipwise.com
Subject: Re: [Spce-user] error while upgrading

El Tue, 4 Sep 2012 11:04:42 -0400
"Gene " <gwillingham at telasip.com> escribió:

> Not sure exactly what I did.  
> 
> Next error: 
> 
> Applying revision script /usr/share/ngcp-db-schema/db_scripts/diff/10890.up:
> ERROR 1054 (42S22) at line 13: Unknown column 'group_id' in 'field list'
> 
> 

This one does not change the db. It's just to resync between provisioning and kamailio databases. If you have an error here, your db schema is broken. 

We could try last time to fix that column:

mysql kamailio

ALTER TABLE lcr_gw ADD column `group_id` int(11) unsigned NOT NULL AFTER defunct;