SOLVED - Can't view customers after update 1.7.8. went wrong and rolled back to 1.7.7.8

[Rico92]

Hello everyone,

I'm working with Prestashop for about 7 months now and never expierenced problems. After deciding to update tonight, which i regret deeply, i am encountering two errors. After updating my font changed to something completely different and blocks were missing on the homepage. So i decided to roll back. After rolling back i can't go to the page ''Customers'' anymore. It is giving me a fatal error:

 

 

And the second error:

When i try to reach ''Active Carts'' it gives me this problem:

Table 'u96237p117807_p1.pr_connections' doesn't exist

 

Is there anyone who knows a solution for these problems? I would be ever grateful. I'd like to hear from you.

Kind regards,

Ricardo

Edited October 14, 2021 by Rico92 (see edit history)

[bnadauld]

Compare the an old sql backup to a backup of the db that seems to have gone wrong. Are there tables missing? - it looks like it. Did you get a timeouts when doing backups or when doing the upgrade possibly causing the issue? Both things that have happened to me. Ive had to revert to older db backups and lucky only lost a few customers info. i have also Frankenstein'd 2 db's - it did work but not the best route if ur unsure on sql