Hi guys!
I got the following problem (see attatchment) when I try to change something with the shipment methods.
There was no migration or anything with the page - just standard update through the extension managers.
I tried to update and install tables then I got another error (2nd one).
Anybody got a similar problem?
System: Joomla 3.6.5 and VM 3.2.1
Thanks, Stefan
https://forum.virtuemart.net/index.php?topic=79800.0
have u tried the table updater in Tools?
@GJC: Yes I did, then I get the 2nd Error (see original post).
I guess u have to correct then these errors manually by phpmyadmin etc
And unfortunately I have no idea how. The Problem also occurred now the 2nd time on one of my pages for no reason. The first one I thought I might have made an error with the migration, but that one just happened.
You just need to drop all keys of that table, and to execute the tableupdater again.
important KEYS, INDEXES, not a normal data column. Keys can be regenerated within seconds.
@Milbo: Sorry for being such a database noob, but how do I drop the keys and indexes?! :(
see screen .. open the table in your phpmyadmin
@GJC: Thanks a lot!
I was able to find everything, but now I am running into another problem:
a. I am not 100% sure which table to take (there are several shipment methods) and
b. if I want tot drop a Pimary it reads an error, telling me I can't do that!?
there is only one #__virtuemart_shipmentmethods
just drop non primary and test