Apologies if this has already been requested, but I have been unsuccessful in finding any FreePBX documentation on the Fatal SQL Error received when attempting to use an apostrophe (ie single quote) in the Display Name field of Extensions (ie O'Brien). I was able to find external documentation (http://www.4guysfromrolla.com/webtech/051899-1.shtml) directing me to enter 2 apostrophe's and this is working for the moment in FreePBX. Hard to believe I could possibly be the first to whine about this. But, perhaps no one has made the effort to submit a ticket? :]
The link above does provide code for a fix if it helps.
Actual Error when using a single quote =
hi
FATAL SQL ERROR! ::::: UPDATE endpointman_line_list SET line = '1', ext = '3605', description = 'Maureen O'Brien'
WHERE luid = 60 [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 'Brien' WHERE luid = 60' at line 1]SQL -..............can reproduce remainder of code if needed.
