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
TRy using the Install or if necessary update tables tool. Config/Tools/Tools & migration
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
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
Good news
After adding the above mentioned dlevel field AND RESETTING COOKIES it works!
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.
What is the 'dlevel' column for? It was removed from the last version, so why add it?
Quote from: hazael on November 20, 2022, 23:46:12 PM
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