Error after succesfull upgrade from 1.6.2.4 to 1.7.6

[dolec]

(1/1) PrestaShopDatabaseException

Unknown column 'h.live_edit' in 'field list'<br /><br /><pre>SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop IN (1) AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
</pre>

 

Autoupgrade didnt show any errors and all green what can be a problem ? Now i see above error in Prestashop 1.7.6 only one warning:

 

[WARNING] SQL 1.7.6.2
            1054 in INSERT INTO `ps_info_lang` SELECT
`entity`.`id_info`, 1, `entity`.`id_lang`, `entity`.`text`
FROM `ps_info_lang` entity
LEFT JOIN `ps_info_lang` entity2 ON `entity2`.`id_shop` = 1 AND `entity`.`id_info` = `entity2`.`id_info`
WHERE `entity2`.`id_shop` IS NULL: Unknown column 'entity2.id_shop' in 'where clause'</div>
[2020-01-26 09:26:25] <div class="upgradeDbOk">[OK] SQL 1.7.6.2 INSERT INTO `ps_meta_lang` SELECT
`entity`.`id_meta`, 1, `entity`.`id_lang`, `entity`.title, `entity`.`description`, `entity`.`keywords`, `entity`.`url_rewrite`
FROM `ps_meta_lang` entity
LEFT JOIN `ps_meta_lang` entity2 ON `entity2`.`id_shop` = 1 AND `entity`.`id_meta` = `entity2`.`id_meta`
WHERE `entity2`.`id_shop` IS NULL</div>
[2020-01-26 09:26:25] <div class="upgradeDbOk">[OK] SQL 1.7.6.2 INSERT INTO `ps_product_lang` SELECT
`entity`.`id_product`, 1, `entity`.`id_lang`, `entity`.`description`, `entity`.`description_short`, `entity`.`link_rewrite`, `entity`.`meta_description`, `entity`.`meta_keywords`, `entity`.`meta_title`, `entity`.`name`, `entity`.`available_now`, `entity`.`available_later`, `entity`.`delivery_in_stock`, `entity`.`delivery_out_stock`
FROM `ps_product_lang` entity
LEFT JOIN `ps_product_lang` entity2 ON `entity2`.`id_shop` = 1 AND `entity`.`id_product` = `entity2`.`id_product`
WHERE `entity2`.`id_shop` IS NULL</div>

Edited January 30, 2020 by dolec (see edit history)

[JBW]

Seems to be related to a module "live_edit" - try to find any remaining files of this module and deactivate/delete them. Also check the DB tables mentioned for it

[shacker]

live edit is not longuer available in 1.7, so must be a module that need to be reinstalled

[dolec]

what should i do remove all modules which are not on prestashop 1.7 standard installation i can not get to admin panel so i can not reinstall anything:)

[JBW]

Check on your server (e.g. by FTP) and Database (e.g. PHPMYADMIN) for remains of this module

[dolec]

i checked search for live_edit in databse nothing where should i search in files? I deleted all old modules from modules directory

[dolec]

ok i found overrride hook.php

/overrides/classes/Hook.php

deleted and problem solved