I have form where in the settings I want to save user IP address. I set field type to TEXT in MySQL it is set to CHAR(60).
[ATTACH=JSON]{“data-align”:“none”,“data-size”:“full”,“title”:“2018-10-22 17_09_59-ScriptCase - Development - admin.jpg”,“data-attachmentid”:85184}[/ATTACH]
Could somebody verify it this is a bug or I’m doing something wrong ???
[ATTACH=JSON]{“data-align”:“none”,“data-size”:“full”,“title”:“2018-10-22 17_09_39-main_menu.jpg”,“data-attachmentid”:85185}[/ATTACH]
SQL ERROR shows this (so it is obviously a field for IP number), IT looks like possibly SC is not adding quotes.
UPDATE ins_customers SET LastName = 'ABULARACH', FirstName = 'DR', MiddleName = 'GLORIA', Nationality = '', BusinessName = '', BusinessType = '10', BusinessOwner = '', Country = 'USA', State = 'IL', City = 'PALATINE', Zip = '60067', Zip2 = '', Address = '149 Chewink Court', HomePhone = '', CellPhone = '', WorkPhone = '', Email = '', Spouse = '', DOB = null, SpouseDOB = null, LeadSource = 'OLD CUSTOMER', ReferalName = 'none', CurrentCustomer = 'YES', Class = 'PERSONAL', ColX2 = 127.0.0.1 WHERE CustomerID = 553
I know I can probably do the same in code but it would take much more time when I need to do it in different Apps in multiple places.