FOP2Admin Module installation error

Edward

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,

nicolas

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.

Edward

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

Edward

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.