VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: alejandrofgd on December 03, 2014, 22:19:40 PM

Title: Error 1054 Unknown column on VirtueMart 3 Installation
Post by: alejandrofgd on December 03, 2014, 22:19:40 PM
Hi everyone,

I am trying to install VirtueMart 3.0 and I get this error in Extension Manager:

1054 Unknown column '' in 'field list' SQL=SELECT `` FROM `turis_virtuemart_configs` WHERE `virtuemart_config_id` = "1"

Do I have a problem with de DB?

Thanks in advance,

Álex
Title: Re: Error 1054 Unknown column on VirtueMart 3 Installation
Post by: jenkinhill on December 04, 2014, 00:16:05 AM
It is possible that resetting the db tables may help.

Go to Configuration/Shop and under Advanced Settings turn on "Enable database Update tools"

Then go to Tools/Tools & Migration and hit the Install or if necessary update tables button.
Title: Re: Error 1054 Unknown column on VirtueMart 3 Installation
Post by: alejandrofgd on December 04, 2014, 14:55:47 PM
Thanks for the answer.

I finally decide to choose another ecommerce plugin as I have no time in my current project to try solve this error. Anyway, I think there is indeed a problem in my DB.

Regards,

Álex
Title: Re: Error 1054 Unknown column on VirtueMart 3 Installation
Post by: buskerud on March 04, 2015, 21:17:29 PM
Quote from: jenkinhill on December 04, 2014, 00:16:05 AM
It is possible that resetting the db tables may help.

Go to Configuration/Shop and under Advanced Settings turn on "Enable database Update tools"

Then go to Tools/Tools & Migration and hit the Install or if necessary update tables button.


Just to let you know, the fix here worked out well when I had  the same error :)

Thank you

Bjorn
Title: Re: Error 1054 Unknown column on VirtueMart 3 Installation
Post by: Milbo on March 10, 2015, 14:07:31 PM
Thank you.
Title: Re: Error 1054 Unknown column on VirtueMart 3 Installation
Post by: Elli on March 17, 2015, 03:46:48 AM
Quote from: jenkinhill on December 04, 2014, 00:16:05 AM
It is possible that resetting the db tables may help.

Go to Configuration/Shop and under Advanced Settings turn on "Enable database Update tools"

Then go to Tools/Tools & Migration and hit the Install or if necessary update tables button.

Hi.

I'm also having this issue with VM2.9 and I'm trying to install it in Joomla 3x. Where can I find the Configuration/Shop option?

Sorry, beginner here not really familiar with this.

Elli
Title: Re: Error 1054 Unknown column on VirtueMart 3 Installation
Post by: jenkinhill on March 17, 2015, 12:08:43 PM
You should not be using VM2.9 now as that was a development series. Current version would be VM3.0.6.2

See http://docs.virtuemart.net/manual/configuration-menu.html

And have a look around the demo, the backend is accessible to see how things work. http://demo.virtuemart.net/