error 1054
I can not change shipping address
here is the error
Unknown column 'CF' in 'field list' SQL = UPDATE `` #__ virtuemart_userinfos` September virtuemart_user_id` = '517', `address_type` = 'ST',` address_type_name` = 'Shipment', `company` = '',` last_name` = 'cutters', `first_name` =' joseph ',` middle_name` =' ', `phone_1` =' ',` phone_2` =' ', `fax` =' ',` address_1` =' via roma 13 ', address_2` = `' ',` city` =' turin ', `virtuemart_state_id` =' 307 ',` virtuemart_country_id` =' 105 ', `zip` =' 10100 ',` agreed` =' 0 ', tos` `= '0',` customer_note` = '', `modified_on` = '04/04/2017 14: 24: 07',` modified_by` = '517', `locked_on` = '0',` locked_by `= '0',` PIVA` = '', `C`.`F` = '' WHERE` virtuemart_userinfo_id` = '47 '
JGLOBAL_TPL_CPANEL_LINK_TEXT
joomla 3.6.5 virtiemart 3.2.1
the column name you have in C.F. is breaking the query
try loosing the full stop
_by `= '0',` PIVA` = '', `C`.`F` = '' WHERE
Hi, I deleted the voice CF and P.IVA and it works, but I have needs these data for billing What can I do to fix it? thank you
Remove the full stop, call it PIVA and not P.IVA
ossia togli il punto perché è quello che causa il problema
ok !! I solved, thank you very much