SQL Error: 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 ')' at line 18 at /home/xxxxx/web/xxxxx.ru/public_html/common/classes/modules/favourite/mapper/Favourite.mapper.class.php line 458 — Array ( [code] => 1064 [message] => 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 ')' at line 18 [query] => SELECT COUNT(f.target_id) as cnt FROM prefix_favourite AS f, prefix_topic AS t, prefix_blog AS b WHERE f.user_id = 4 AND f.target_publish = 1 AND f.target_type = 'topic' AND f.target_id = t.topic_id AND t.blog_id = b.blog_id AND b.blog_type IN () ; [context] => /home/xxxxx/web/xxxxx.ru/public_html/common/classes/modules/favourite/mapper/Favourite.mapper.class.php line 458 )
В целом перенос прошел проблемно. Апгрейд бд вообще не выполнился, пришлось руками построчно выполнять.
Прошу откликнуться, если вдруг у кого подобное встречалось.
Есть ли различия в структуре бд у 1.0 и 1.0.7 ?