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,