Updating PS 1.6 - SQL Error

[DDM]

Hi,

Just updated a test PS 1.6.1.23 shop to the latest TB and everything went smoothly apart from one error during the database upgrade:

=====================================================

[WARNING] SQL 2.1.0.8
1064 in INSERT INTO `ps_configuration`(`name`, `value`, `date_add`, `date_upd`)
SELECT 'TB_MAIL_SUBJECT_TEMPLATE', '[{shop_name}] {subject}', NOW(), NOW()
WHERE (
    SELECT COUNT(*)
    FROM `ps_configuration`
    WHERE `name` = 'TB_MAIL_SUBJECT_TEMPLATE'
) = 0: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (
    SELECT COUNT(*)
    FROM `ps_configuration`
    WHERE `name` = 'TB_M' at line 3

=====================================================

There aren't *any* entries in the configuration table beginning with TB_ ... they're all PS_

 - Do I need to do anything about this error?

 - Also, all of the tables in the database still begin with the prefix of ps_ ..... I thought they would all be changed to a prefix of tb_    ?

Any thoughts?

Thanks,

[toplakd]

This error is related to back office "Advanced Parameters / Email" and therefore the "Email subject template field" is left blank, so after migration you have to add  {subject} {shop_name} into that field and save it. 

[DDM]

Thank you for your quick reply.

Sorted now, thank you  :)

Edited February 18, 2019 by DDM