Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

FOP2 Community Forum

  1. Home
  2. Support
  3. FOP2Admin Module installation error

FOP2Admin Module installation error

Scheduled Pinned Locked Moved Support
4 Posts 2 Posters 80 Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • E
    E
    Edward
    wrote on last edited by
    #1

    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,

    1 Reply Last reply
    0
    • N
      N
      nicolas
      wrote on last edited by
      #2

      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.

      1 Reply Last reply
      0
      • E
        E
        Edward
        wrote on last edited by
        #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

        1 Reply Last reply
        0
        • E
          E
          Edward
          wrote on last edited by
          #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.

          1 Reply Last reply
          0

          Hello! It looks like you're interested in this conversation, but you don't have an account yet.

          Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

          With your input, this post could be even better 💗

          Register Login
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          Powered by NodeBB Contributors
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups