Author Topic: Error: 1054 Unknown column 'u.city' in 'field list'  (Read 621 times)

kostianev

  • Jr. Member
  • **
  • Posts: 68
  • Web Developer
    • MOON.bg
  • Skype Name: moonbgltd
  • VirtueMart Version: 3.x
Error: 1054 Unknown column 'u.city' in 'field list'
« on: January 11, 2018, 22:51:50 pm »
Dear, I have this error when I try to access the Orders List Page in VirtueMart:

1054 Unknown column 'u.city' in 'field list'

Please, help me! How can I fix this issue?!
PS. I tried DataBase Fix from Extension manager and DataBase / Tables repair in VM Tools page.

Jörgen

  • Global Moderator
  • Full Member
  • *
  • Posts: 1720
    • Kreativ Fotografi
  • VirtueMart Version: 3.2.12
Re: Error: 1054 Unknown column 'u.city' in 'field list'
« Reply #1 on: January 12, 2018, 08:33:59 am »
Is there som userfield called u.city or city in your setup or is there some custom plugin installed that handles invoices, orders or users ?

Have You perhaps updated to php 7.1 or 7.2 ? Please use PHP 7.0

regards

Jörgen @ Kreativ Fotografi
Joomla 3.8.3
Virtuemart 3.2.12
Olympiantheme Hera (customized)

kostianev

  • Jr. Member
  • **
  • Posts: 68
  • Web Developer
    • MOON.bg
  • Skype Name: moonbgltd
  • VirtueMart Version: 3.x
Re: Error: 1054 Unknown column 'u.city' in 'field list'
« Reply #2 on: January 12, 2018, 08:59:32 am »
Hi, I switch to php7.0.22 version and the problem still appear. I tried to disable the plugin for Advanced Users and the same, so the problem is not from there.
I remember that I deleted some fields in the Shopper Fields before few days, because there was duplicated. How can I get back the fields?

I tried to update VirtueMart to the latest version and Joomla core, but with no results.

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 8169
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.14
Re: Error: 1054 Unknown column 'u.city' in 'field list'
« Reply #3 on: January 14, 2018, 23:43:43 pm »
assume u have lost the column city in #__virtuemart_userinfos

check .. if gone make a new one

`city` char(64) NOT NULL DEFAULT

or maybe the VM table updater will recreate it - run from tools
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

kostianev

  • Jr. Member
  • **
  • Posts: 68
  • Web Developer
    • MOON.bg
  • Skype Name: moonbgltd
  • VirtueMart Version: 3.x
Re: Error: 1054 Unknown column 'u.city' in 'field list'
« Reply #4 on: January 15, 2018, 06:46:47 am »
Thank you!