PDOException During Trunk Creation in FreePBX17

Hello,
I’m in the process of setting up a replacement 17 PBX and I got to the point to where I need to setup my trunks. I have two of them. A primary and a Backup. I was able to setup the first trunk without issue, however when I setup the second and clicked “submit”, I was given a "PDOException (23000) error. The details say " SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘2-maxchans’ for key PRIMARY.

Any idea what might be causing this? PBX17 bug or User Error?
The two trunks that are being setup are named differently and the IP for the SIP server is different.

Just a quick update.
I had originally performed a restore from my old PBXv16 to the new v17. At the end of the restore, it seems that the trunks were not converted. The system told me that I needed to run the “fwconsole trunks --convert2pjsip” option, however, the PBX came back with a big red error that said, "The “–convert2pjsip” option does not exist.

So I deleted the SIP trunks that were showing and added them back as PJSIP. Thats when the original error message started showing. I believe I caused my original problem. User Error.

I’m still confused why the convert2pjsip threw that error message. Anyone else see that?

If you manually execute this from your Freepbx cli then do you see any error?
“fwconsole trunks --convert2pjsip

Hi Kapil,
When I tried running that command from the cli, I would get the Red Box that says “The --convert2pjsip” option does not exist".

All of this was just after I did a restore from version 16. When I would click on the Apply Config button in the top right corner of the screen, that’s when it would say that the trunks(which were setup as chan_sip), needed to be converted and to use the command that you recommended.

I ended up just deleting those old chan_sip trunks and replacing them with the pjsip trunk configuration manually…then I would hit the Apply Config button and it seemed to be happy.

I might be making a mountain out of a mole hill here due to something I didn’t do correctly, but it did seem to have a problem with converting those trunks during the restore process.

Thanks!!

New information on using the convert2pjsip command.

It looks like there is a duplicate entry in the trunks table, try deleting the duplicate entry and then give it a try again. Thanks.

 select * from trunks

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.