Print Page - Error: 1054 Unknown column 'u.city' in 'field list'

Title: Error: 1054 Unknown column 'u.city' in 'field list'
Post by: kostianev 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.

Title: Re: Error: 1054 Unknown column 'u.city' in 'field list'
Post by: Jörgen 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

Title: Re: Error: 1054 Unknown column 'u.city' in 'field list'
Post by: kostianev 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.

Title: Re: Error: 1054 Unknown column 'u.city' in 'field list'
Post by: GJC Web Design 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

Title: Re: Error: 1054 Unknown column 'u.city' in 'field list'
Post by: kostianev on January 15, 2018, 06:46:47 AM

Thank you!

VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: kostianev on January 11, 2018, 22:51:50 PM