@jaredbusch thank you.
I posted the SQL at the command line and it returned the same error.
I figured it out though as I seemed to have a Clients group in both the External and Private Contact Manager Areas - hence the return of two records in the subquery.
I deleted the Clients Group from the Private area leaving just the one in the External area, and it started working.
Cheers
I am having some problems implementing the script.
I have followed the direction to install it in /var/www/html
Ran chown
Edited the script to set the $contact_manager_group to Clients - which I have made in FreePBX v15.0.17.24 - Asterisk V16.15.0
I have loaded one contact into this group
When I execute the script by navigating to http://10.0.0.120/cm_to_yl_ab.php I recieve the error:
PDOException (21000)
SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row
Any advice would be awesome
Cheers
