Problem with Shipments-Update

[keora]

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

[GJC Web Design]

https://forum.virtuemart.net/index.php?topic=79800.0

have u tried the table updater in Tools?

[keora]

@GJC: Yes I did, then I get the 2nd Error (see original post).

[GJC Web Design]

I guess u have to correct then these errors manually by phpmyadmin etc

[keora]

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.

[Milbo]

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.

[keora]

@Milbo: Sorry for being such a database noob, but how do I drop the keys and indexes?!

[GJC Web Design]

see screen  .. open the table in your phpmyadmin

[keora]

@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!?

[GJC Web Design]

there is only one #__virtuemart_shipmentmethods

just drop non primary and test