VM 4.0.7 10744 Unknown column 'mf_name' in 'where clause'

[Alexb65]

I installed this version to solve the custom fields edit bugs and the problem has gone:

Pagination errors has gone also so ... well done and thanks

Now I'm facing the inability to search any products both in frontend and backend with error

1054: Unknown column 'mf_name' in 'where clause'

Is there any known fix?

Thank you in advance for any help

[jenkinhill]

TRy using the Install or if necessary update tables tool.   Config/Tools/Tools & migration

[Alexb65]

Thank you very much for the hint

Very unfortunately this leads to a

Unknown column 'dlevel' in 'where clause'

error 

and doesn't fix the search problem

[Alexb65]

Manually adding a dlevel field in virtuemart_categories fixes the missing dlevl error but doesn't fix product search but now the error is

Unknown column '#__virtuemart_product_manufacturers.virtuemart_manufacturer_id' in 'where clause'

I checked the table structure and the field is present so it seems a sort of left join error in query

[Alexb65]

Good news

After adding the above mentioned dlevel field AND RESETTING COOKIES it works!

[Darko F.]

I install
com_virtuemart.4.0.7.10744_package_or_extract.zip

and I get error:
Unknown column 'dlevel' in 'where clause'

My solution was that I install first   com_virtuemart.4.0.7.10732_package_or_extract.zip   it worked

Then I install
com_virtuemart.4.0.7.10744_package_or_extract.zip

And it worked without problem.

[hazael]

What is the 'dlevel' column for? It was removed from the last version, so why add it?

[Jörgen]

What is the 'dlevel' column for? It was removed from the last version, so why add it?

My guess is that there is some code still referring to dlevel and therefore it seems to be working after adding dlevel. This probably works like a temporary patch.

Jörgen @ Kreativ Fotografi