FOP2Admin Module installation error

  1. 13 years ago

    I had FOP2 running fine, but wanted to start using the FreePBX FOP2 Admin module to adjust my extensions (should have left well enough alone, IMHO) when it broke the install.

    Trying to install the FOP2 Admin module I am greeted with this error

    FATAL ERROR
    REPLACE INTO fop2buttons (type, device, privacy, label, exten, context, mailbox, queuechannel, customastdb) VALUES ('extension', 'SIP/2240', '', 'Bob\'s Laptop','2240','from-internal','2240@default','Local/2240@from-queue/n|Penalty=0|MemberName=Bob's Laptop|StateInterface=SIP/2240','CF/2240') [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Laptop|StateInterface=SIP/2240','CF/2240')' at line 1]SQL - 
    REPLACE INTO fop2buttons (type, device, privacy, label, exten, context, mailbox, queuechannel, customastdb) VALUES ('extension', 'SIP/2240', '', 'Bob\'s Laptop','2240','from-internal','2240@default','Local/2240@from-queue/n|Penalty=0|MemberName=Bob's Laptop|StateInterface=SIP/2240','CF/2240')

    Any way to fix this guy or is there a way to wipe FOP2 completely off and restart from scratch (not adverse to not using the FreePBX module).

    Thanks,

  2. admin

    16 Nov 2011 Administrator

    Hi,

    The bug was fixed on what it would be the next release.. in the meantime, you can remove the single quote from the extension name (Bob's Laptop), and try to install again. Once installed you can change names back.

  3. Ok, now that is working. However, I am now getting the FOP2 page with no buttons, extensions, basically nothing.

    http://i.imgur.com/3bsvp.jpg

  4. Disregard my last post, I was able to make a couple of changes to my extension (using the FOP2 admin module) and everything fell into place. So far so good.

or Sign Up to reply!