Issue with Caller ID management module

Commercial Products and Partners Sangoma
1

When I try to install callerid management that I purchased I get this error below. I had to reinstall it because of an error while trying to upgrade it, I got as far as uninstalling it and now I get this error every time I try to reinstall.

I have the error log copied from the screen but I cannot post attachments or post anything with links in it so Im not sure how to convey that info.

2

You can now

3

This is what I do:
Module Updates, update CallerID management from 13.0.8.9 to 13.0.8.12
Get error message in the gui. All I can see is DBALException but I managed to copy all and paste below
reload the update module
callerid management is disabled
I then go and rollback to 13.0.8.9 and it enabled and works

info below:

CallerID Managment will be upgraded to online version 13.0.8.12

FreePBX® FreePBX is a registered trademark of
Sangoma Technologies Inc.
FreePBX 14.0.3.11 is licensed under the GPL
Copyright© 2007-2018www.sangoma.com
Status
Please wait while module actions are performed
Downloading and Installing callerid
Downloading callerid
Installing callerid
Untarring…Done
Updating tables callerid_entries…
Doctrine \ DBAL \ DBALException
An exception occurred while executing ‘ALTER TABLE callerid_entries CHANGE id id INT AUTO_INCREMENT NOT NULL’: SQLSTATE[23000]: Integrity constraint violation: 1062 ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry ‘1’ for key ‘PRIMARY’
COPY
Click Here Report this to the PBX bug tracker
Stack frames (11)
10
Doctrine\DBAL\DBALException
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php131
9
Doctrine\DBAL\DBALException driverExceptionDuringQuery
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php1046
8
PDOException
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php1044
7
PDO exec
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php1044
6
Doctrine\DBAL\Connection exec
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Synchronizer/AbstractSchemaSynchronizer.php62
5
Doctrine\DBAL\Schema\Synchronizer\AbstractSchemaSynchronizer processSql
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Schema/Synchronizer/SingleDatabaseSynchronizer.php158
4
Doctrine\DBAL\Schema\Synchronizer\SingleDatabaseSynchronizer updateSchema
/var/www/html/admin/libraries/BMO/Database/Migration.class.php188
3
FreePBX\Database\Migration modifyMultiple
/var/www/html/admin/libraries/BMO/Database.class.php199
2
FreePBX\Database migrateMultipleXML
/var/www/html/admin/libraries/modulefunctions.class.php1986
1
module_functions install
/var/www/html/admin/page.modules.php283
0
include
/var/www/html/admin/config.php394
/var/www/html/admin/libraries/Composer/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php
* @param \Doctrine\DBAL\Driver $driver
* @param \Exception $driverEx
* @param string $sql
* @param array $params
*
* @return \Doctrine\DBAL\DBALException
*/
public static function driverExceptionDuringQuery(Driver $driver, \Exception $driverEx, $sql, array $params = array())
{
$msg = “An exception occurred while executing '”.$sql."’";
if ($params) {
$msg .= " with params " . self::formatParameters($params);
}
$msg .= “:\n\n”.$driverEx->getMessage();

    if ($driver instanceof ExceptionConverterDriver && $driverEx instanceof DriverException) {
        return $driver->convertException($msg, $driverEx);
    }

    return new self($msg, 0, $driverEx);
}

/**
 * @param \Doctrine\DBAL\Driver     $driver
 * @param \Exception $driverEx
 *
 * @return \Doctrine\DBAL\DBALException
 */
public static function driverException(Driver $driver, \Exception $driverEx)
{
    $msg = "An exception occured in driver: " . $driverEx->getMessage();

    if ($driver instanceof ExceptionConverterDriver && $driverEx instanceof DriverException) {
        return $driver->convertException($msg, $driverEx);
    }

    return new self($msg, 0, $driverEx);
}

/**

Environment & details:
GET Data
display modules
action process
quietmode 1
online 1
modules Array ( [callerid] => Array ( [action] => upgrade [track] => stable ) )
POST Data empty
Files empty
Cookies
lang en_US
searchHide 1
_ga GA1.1.891283397.1518474498
PHPSESSID dp92j2o01oe3f3ul4qr8fgul52
_gid GA1.1.423080745.1533324422
Session
langdirection ltr
module_name modules
module_page modules
AMP_user ampuser Object ( [username] => Seth [id] => [password:ampuser:private] => 5ec3b1433f282f888cfd5ee323c3a7d8c02b2c40 [extension_high:ampuser:private] => [extension_low:ampuser:private] => [sections:ampuser:private] => Array ( [0] => * ) [mode:ampuser:private] => database [opmode:ampuser:private] => [lang] => [tz] => => [timeformat] => => [_lastactivity] => 1533325153 )
Server/Request Data
UNIQUE_ID W2SvYeqmGbM3U-XiK4SCqQAAAAQ
SCRIPT_URL /admin/config.php
SCRIPT_URI xx.xx.xx.xx/admin/config.php
HTACCESS on
HTTP_HOST xx.xx.xx.xx
HTTP_CONNECTION keep-alive
CONTENT_LENGTH 0
HTTP_ORIGIN xx.xx.xx.xx
HTTP_USER_AGENT Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36
HTTP_ACCEPT /
HTTP_REFERER xx.xx.xx.xx/admin/config.php?display=modules
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_ACCEPT_LANGUAGE en-US,en;q=0.9
HTTP_COOKIE lang=en_US; searchHide=1; _ga=GA1.1.891283397.1518474498; PHPSESSID=dp92j2o01oe3f3ul4qr8fgul52; _gid=GA1.1.423080745.1533324422
PATH /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
SERVER_SIGNATURE
SERVER_SOFTWARE Apache/2.4.6 (Sangoma) OpenSSL/1.0.1e-fips PHP/5.6.31
SERVER_NAME xx.xx.xx.xx
SERVER_ADDR xx.xx.xx.xx
SERVER_PORT 80
REMOTE_ADDR DOCUMENT_ROOT /var/www/html
REQUEST_SCHEME http
CONTEXT_PREFIX
CONTEXT_DOCUMENT_ROOT /var/www/html
SERVER_ADMIN [email protected]
SCRIPT_FILENAME /var/www/html/admin/config.php
REMOTE_PORT 53460
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD POST
QUERY_STRING display=modules&action=process&quietmode=1&online=1&modules%5Bcallerid%5D%5Baction%5D=upgrade&modules%5Bcallerid%5D%5Btrack%5D=stable
REQUEST_URI /admin/config.php?display=modules&action=process&quietmode=1&online=1&modules%5Bcallerid%5D%5Baction%5D=upgrade&modules%5Bcallerid%5D%5Btrack%5D=stable
SCRIPT_NAME /admin/config.php
PHP_SELF /admin/config.php
REQUEST_TIME_FLOAT 1533325153.147
REQUEST_TIME 1533325153
Environment Variables empty
Registered Handlers
0. Whoops\Handler\PrettyPageHandler

4

The upgrade wants to turn on auto incrementing on the table. But it can’t because you have two rows that have the same ID

5

Not sure how that happened. Do you know a way for me to correct it?

6

Anyone have an idea on how to fix this? Its more of annoyance than anything else but I paid for the module and seems like it ought to work a little better than this…

7

As with all commercial modules, there is free bug support while the maintenance period is active. Open a support ticket:
https://support.sangoma.com

8

I had exactly the same issue,

the below steps worked for me.

I uninstalled callerid management from web UI.
then I reinstalled via command line.

  1. fwconsole ma download callerid.
  2. fwconsole ma install callerid

–
Nikhil

9

This totally fixed it for me!!! thanks