Hi,
If changing the product layouts individually works, then you got it. It is obvious the problem must be something to do with the "write access" because the selection can't be made for some categories. (probably to the old categories, that you create before you update the Virtuemart. -- I am just guessing..)
I can't be sure what might cause it, but i don't think you will be able to solve it by touching the MySQL. Indeed; I strongly suggest you to stay away from MySQL.
If you don't have thousands of products, then you should follow the way that actually works, which is:
changing the product layouts individually one-by one
Look at the bright side, at least you know a way out. There are some very weird cases that no method actually works beside re-installing the Virtuemart and starting everything from scratch.
Actually there is one more thing you can try.
(i assume you want to set
flexv2 for all products, instead of
default)
Open this PHP folder:
/templates/YOUR_TEMPLATE/html/com_virtuemart/productdetails/
and rename these files:
/templates/YOUR_TEMPLATE/html/com_virtuemart/productdetails/default.php
/templates/YOUR_TEMPLATE/html/com_virtuemart/productdetails/default.xml
to
/templates/YOUR_TEMPLATE/html/com_virtuemart/productdetails/default2.php
/templates/YOUR_TEMPLATE/html/com_virtuemart/productdetails/default2.xml
then, duplicate these 2 files:
/templates/YOUR_TEMPLATE/html/com_virtuemart/productdetails/flexv2.php
/templates/YOUR_TEMPLATE/html/com_virtuemart/productdetails/flexv2.xml
and rename the duplicated copies as follow:
/templates/YOUR_TEMPLATE/html/com_virtuemart/productdetails/default.php
/templates/YOUR_TEMPLATE/html/com_virtuemart/productdetails/default.xml
Got the idea? So the "default" and "flexv2" will be the exact same layouts. (which is originally flexv2) the old "default" layout will be named as "default2".
________________________________________________________________________________
If you like PureMart and satisfied with the support you have received, please "write a review" on:
flexiblewebdesign.com/Virtuemart-2-Templates/PureMart
Rate PureMart and write a couple of sentences to share your experience with the support team. It won't take more than 2 minutes from you but it is extremely important for us. Thanks in advance!
Regards,
Support