Upgrade error 1.07 to 1.08

[haylau]

upgraded from 1.07 to 1.08.

 

Received this message

UPGRADE COMPLETE!

Errors

 

SQL 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

[toplakd]

Its funny. Copying the red formatted text from forum into field gives error,

but copying same text from thirtybees other instalation gives green ok.

Let me try once again without red formatting.
[{shop_name}] {subject}

p.s.

Exactly. Pasting Red formatted text into field with ctrl+v gives red error, but pasting red formated text with ctrl+shift+v gives no error.

Edited January 27, 2019 by toplakd

[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 [{shop_name}] {subject} into that field and save it. 

[haylau]

29 minutes ago, toplakd said:

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 [{shop_name}] {subject} into that field and save it. 

Thanks for the reply I have done that but when I save I get this error message

Email template must contains {subject} placeholder

 

 

[haylau]

1 hour ago, toplakd said:

Its funny. Copying the red formatted text from forum into field gives error,

but copying same text from thirtybees other instalation gives green ok.

Let me try once again without red formatting.
[{shop_name}] {subject}

p.s.

Exactly. Pasting Red formatted text into field with ctrl+v gives red error, but pasting red formated text with ctrl+shift+v gives no error.

Weird - but it has worked. Many thanks for your help

[Traumflug]

On 1/27/2019 at 10:42 AM, toplakd said:

Its funny. Copying the red formatted text from forum into field gives error,

but copying same text from thirtybees other instalation gives green ok.

Some databases like this syntax, others not. Before committing this query I tested it, of course. In my local DB it works.

There is this Gitub issue with a (hopefully) better syntax: https://github.com/thirtybees/tbupdater/issues/15

 

Being knee-deep into the new Gut Updater (which solves this without SQL), I didn't come around to test this, yet.