News:

Looking for documentation? Take a look on our wiki

Main Menu

Error 1054 Unknown column on VirtueMart 3 Installation

Started by alejandrofgd, December 03, 2014, 22:19:40 PM

Previous topic - Next topic

alejandrofgd

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

jenkinhill

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.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

alejandrofgd

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

buskerud

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

Milbo

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Elli

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

jenkinhill

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/

Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum