Author Topic: error 1054 I can not change shipping address  (Read 240 times)

giriga

  • Jr. Member
  • **
  • Posts: 80
  • A beginner
error 1054 I can not change shipping address
« on: April 04, 2017, 16:32:50 pm »
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

  • 3rd party VirtueMart Developer
  • Hero Member
  • *
  • Posts: 7485
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.2
Re: error 1054 I can not change shipping address
« Reply #1 on: April 04, 2017, 17:15:11 pm »
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 http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

giriga

  • Jr. Member
  • **
  • Posts: 80
  • A beginner
Re: error 1054 I can not change shipping address
« Reply #2 on: April 04, 2017, 18:54:54 pm »
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

  • Jr. Member
  • **
  • Posts: 91
Re: error 1054 I can not change shipping address
« Reply #3 on: April 04, 2017, 19:39:54 pm »
Remove the full stop, call it PIVA and not P.IVA

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

giriga

  • Jr. Member
  • **
  • Posts: 80
  • A beginner
Re: error 1054 I can not change shipping address
« Reply #4 on: April 04, 2017, 20:41:30 pm »
ok !! I solved, thank you very much