Upgrade from 10.0 gives mysql error

[ktaylor]

Hi all,

I'm upgrading from 10.0 to 10.7.x

When i tried to import the new product, i get

Invalid SQL:
ALTER TABLE vb_vbpicgallery_users DROP INDEX desc1;


Looking at my mysql table, i already have a desc1 column which means it's probably trying to combine all 3 (desc1, desc2 and desc3) into desc 1 right?

so how do i fix so it'll import correctly? Thanks!

[Greg]

A quick fix would be to comment out line 119 of the product file. But there should be an index to delete.

Change from

$db->query_write("ALTER TABLE ". TABLE_PREFIX ."vbpicgallery_users DROP INDEX desc1");


To

//$db->query_write("ALTER TABLE ". TABLE_PREFIX ."vbpicgallery_users DROP INDEX desc1");

[ktaylor]

Thanks! :)

[Gizmo999]

just had the same problem, index was missing on desc1 so i added it and product upload worked