Menu ▾ ▴

#279 Single quote generates SQL Error

1.1
closed
1
2016-02-02
2015-01-28
Laurent
No

Hello,

When an apostrophe (single quote) is used in the description when adding an ip address, it fails with an SQL Error.

I double checked that the chartset is "compatible" with the single quote and it is (UTF8).

Please note that the error only occurs when adding an IP Adresse through the button "Add new IP Address". When importing through an XLS file (button "Import IP addresses"), there is no worry and the description is correctly "printed" with the single quote.

Is there a single way to fix this issue ?

Thanks,

Regards,
Laurent

Discussion

  • Andrey Voroshnin

    Hi Laurent,

    It is caused by double check for single quotes. One of the loops was replacing already fixed quotes.
    Please replace files in directory /<phpipam folder="">/site/ipaddr with files attached. This should fix your problem.</phpipam>

     
    • Laurent

      Laurent - 2015-01-29

      Hi Andrey,

      Thanks a lot for your help. It worked !

      Problem fixed ! Ticket may be closed.

       
  • Miha Petkovsek

    Miha Petkovsek - 2016-02-02
    • status: open --> closed
     
  • Miha Petkovsek

    Miha Petkovsek - 2016-02-02

    Fixed in 1.2

     

Anonymous
Anonymous

Add attachments
Cancel