Problem z aktualizacją 1.6.24 do 1.7.6.3

[dolec]

Wszystko przebiega ok z aktualizajcą , ale po skonczonej aktualizacji przy probie zalogowania do panelu  wyskakuje blad czy jest to wina jakiegos modulu wszystkie staralem sie odinstalowac wylaczylem nadpisywania itp.?

 

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>

[pycode.biz]

On 1/26/2020 at 9:40 AM, dolec said:

Wszystko przebiega ok z aktualizajcą , ale po skonczonej aktualizacji przy probie zalogowania do panelu  wyskakuje blad czy jest to wina jakiegos modulu wszystkie staralem sie odinstalowac wylaczylem nadpisywania itp.?

 

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>

Chyba wszystko poprawnie nie przeszło jednak - mi to wygląda na błąd migracji

[dolec]

Hmm ale w trakcie aktualizacji nie wyskoczyl zaden blad..tylko jeden warning  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)