Error upgrading Doctrine schema

[Obsidrian Drama]

Hello all!

I'm trying to upgrade an old v1.7.4.2 to at least v.1.78.10, and it's becoming a never ending quest...

First I did a direct upgrade: big fail. It was a very big leap.

Then I tried this suggested update path:

1.7.4.2 -> 1.7.6.5 -> 1.7.7.5 -> 1.7.8.10

The first upgrade step works fine, but upgrading from 1.7.6.5 to 1.7.7.5 bombs at the very end with:
 

Error during database upgrade.
You may need to restore your database.Error upgrading Doctrine schema

...and I'm asked if I want to restore the previous version.

Still, the version is shown as upgraded but my guess is that I've ended up with an unstable database.

I have repeated the process several times and I was also suggested to truncate the tables ps_connections and ps_guest - I've done so but I get the same results.

Is there a fix to the DB issue? And, what would be the best way to achieve the proposed upgrade?

TIA!

 

[musicmaster]

Truncating those tables helps only when you have a timeout problem.

One possible solution for your problem you can find here.

The conclusion of that guy:

Quote

Moral: Do not create in your modules a class that accesses a Prestashop table and has the same name as another, even if they are in different namespaces. The Doctrine gets mixed up.

 

[Obsidrian Drama]

Thanks for the hint.
Oddly enough, those conditions are not met... I'll take a closer look at the upgrade log to see where it fails though...

I'll keep you all posted. 
Thanks!