Error 1054 Unknown column on VirtueMart 3 Installation

[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.

[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]

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]

Thank you.

[Elli]

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/