error 1054 I can not change shipping address

[giriga]

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

[GJC Web Design]

the column name  you have in C.F. is  breaking the query

try loosing the full stop

_by `= '0',` PIVA` = '', `C`.`F` = '' WHERE

[giriga]

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

[bortolani]

Remove the full stop, call it PIVA and not P.IVA

ossia togli il punto perché è quello che causa il problema

[giriga]

ok !! I solved, thank you very much