News:

Looking for documentation? Take a look on our wiki

Main Menu

error 1054 I can not change shipping address

Started by giriga, April 04, 2017, 16:32:50 PM

Previous topic - Next topic

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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