Issabel 5 - Batch Extensions

This site is best viewed in a modern browser with JavaScript enabled.

Issabel 5 - Batch Extensions

MRLewis

I've got Issabel 5 up and running and want to import al my extensions using the "Batch of Extensions", however, every time I try to import a file I get the following error...

Ext: 210 - Error when inserting or updating Direct DID: Error de conexion a la base de datos - Array ( [0] => HY000 [1] => 1364 [2] => Field 'mohclass' doesn't have a default value )

I have created an extension and exported the file so the fields are all present and correct. I have tried adding a field called "MOH Class" and also "mohclass" but neither of these work.

Can anybody help resolve this as I really don't want to have to input all my extensions manually.

Many thanks

benjange

MRLewis Hola. Crea una extensión, importa con Batch of Extensions y con un excel o google sheets compara los campos, para descubrir las diferencias en el nombre de los campos.
Saludos.

vidadigital

MRLewis Same problem here.

DanielRC10

vim /var/www/html/modules/extensions_batch/libs/paloSantoExtensionsBatch.class.php
Search "INSERT INTO incoming", insert mohclass and default like that:

        $sql = 'INSERT INTO incoming (cidnum, extension, description, destination, '.
                    'privacyman, alertinfo, ringing, grppre, delay_answer, '.
                    'pricid, pmmaxretries, pmminlength, mohclass) '.
               'VALUES ("", ?, ?, ?, 0, "", "", "", 0, "", "", "","default")';