Can't delete "old" WiFi interfaces and zone interface was assigned to

Question

Hello, 
 I have another problem with my interfaces... I'm using the XG135 Appliance with the 15.01.0 MR-2 Firmware. 
 I'm using the Wireless-Protection with a Hotspot For using the hotspot i created a wireless network with the "Bridge to seperate Zone" option and created the zone whereon i got an interface which is now listed under "Administration | Interfaces" Some time after that i changed the wireless network from "Bridge to seperate zone" to "Bridge to VLAN" The Wireless network still works fine, but now the interface the XG created is still there (listed under "Administration | Interfaces") According to this i can't delete the created zone, because the Interface that isn't used any more is assigned to the zone 
 Creating a wireless network with the same name to get this deleted after isn't possible Here i get an error, because the name already exists 
 All is working fine, but it's uncomely to have things listed i don't need anymore What do i have to do to get this interface deleted? If procurable without resetting the device ;) 
 Thanks Thomas

ThomasMahin · Accepted Answer

Hi Julien, 
 i forgot that i opened this thread, because i didn't get an answer after my last post. 
 The solution for me was to contact the sophos support. I gave them support access to my XG an they solved it for me by manually deleting the interface from the database. 
 They did this by using the advanced shell. I checked the shell history and found the commands they used: I only copy&pasted the commands they used for my problem, so use this at your own risk. 
 First they checked my dhcp config: psql -U nobody -d corporate -c "select * from tbldhcpconf ;" 
 After this checking all interfaces: psql -U nobody -d corporate -c "select * from tblinterface;" 
 And finally delete the interface: psql -U nobody -d corporate -c "delete from tblinterface where interface=['InterfaceName']; " 
 
 Regards, Thomas