Web Interface dies when adding a note to a fanout port

[listerr]

Not sure if this applies to the latest release, so maybe the fix is to upgrade to that.
We are on V4.1.0 and planning to upgrade soon.

I just tried to add a note to a reseller fanout port, but the web interface falls over and generates this error:

2017-11-10T11:59:34+00:00 ERR (3):

---

****************************** EXCEPTIONS *******************************

---

--------------------------- EXCEPTION --------------------------

Message: An exception occurred while executing 'UPDATE physicalinterface SET status = ?, speed = ?, monitorindex = ?, notes = ?, switchportid = ?, fanout_physical_interface_id = ?,
virtualinterfaceid = ? WHERE id = ?' with params ["1", "1000", "4", "x", 1631, 667, 225, 667]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1631' for key 'UNIQ_5FFF4D60E5F6FACB'
Line: 66
File: /srv/ixp4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php

Trace:

#0 /srv/ixp4/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(116): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...',
Object(Doctrine\DBAL\Driver\PDOException))
#1 /srv/ixp4/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(996): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver),
Object(Doctrine\DBAL\Driver\PDOException), 'UPDATE physical...', Array)
#2 /srv/ixp4/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(480): Doctrine\DBAL\Connection->executeUpdate('UPDATE physical...', Array, Array)
#3 /srv/ixp4/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(366):
Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable(Object(Entities\PhysicalInterface), 'physicalinterfa...', Array, NULL)
#4 /srv/ixp4/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1069): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update(Object(Entities\PhysicalInterface))
#5 /srv/ixp4/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(384): Doctrine\ORM\UnitOfWork->executeUpdates(Object(Doctrine\ORM\Mapping\ClassMetadata))
#6 /srv/ixp4/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(356): Doctrine\ORM\UnitOfWork->commit(NULL)
#7 /srv/ixp4/vendor/opensolutions/oss-framework/src/OSS/Controller/Action/Trait/Doctrine2Frontend.php(623): Doctrine\ORM\EntityManager->flush()
#8 /srv/ixp4/vendor/opensolutions/oss-framework/src/OSS/Controller/Action/Trait/Doctrine2Frontend.php(707): IXP_Controller_Frontend->addProcessForm(Object(IXP_Form_Interface_Physical),
Object(Entities\PhysicalInterface), true)
#9 /srv/ixp4/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php(516): IXP_Controller_Frontend->addAction()

[barryo]

This code has been complete rewritten but @yannrobin can you check that you can edit a physical interface to add/edit a note as a standalone physint but also with an associated fanout in reseller mode?

[yannrobin]

Hello,

I confirm that this bug has been fixed with the Laravel migration.