[SOLVED] Upgraded to 1.7.7.2 and Error: SQL 1.7.7.0 1146 in ALTER TABLE

[bksmartit]

Hello,

I upgraded my Prestashop ver. 1.7.6.1 to the latest ver. 1.7.7.2. Of course, I used 1-Click Upgrade tool

I received only 1 error after upgrade and it was this below:

Error: SQL 1.7.7.0 1146 in ALTER TABLE `pshop_aXXXXaGn_statssearch` CHANGE `keywords` `keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL: Table 'lxxxjxxx_pres379.pshop_aXXXXGn_statssearch' doesn't exist

I guess I will have to rollback to the previous version to fix this error first and upgrade it again to make sure no errors.

Can you let me know what and how should I do to fix this?

Thank you and your help is appreciated

Chris

 

Edited March 12, 2021 by bksmartit (see edit history)

[bksmartit]

 Noticed the pshop_aXXXXaGn_statssearch.sql table missing from my live Prestashop database.

I believe this table is missing after when I rolled back to previous version.

So exported ps_statssearch.sql table from a fresh Prestashop Database renamed it and edited and imported to my live Prestashop database.

It works this time and run upgrade again and it completed successfully and Database upgraded OK