-- Обновление поля prefix_topic.topic_date_show
UPDATE prefix_topic SET topic_date_show=topic_date_add
WHERE topic_publish=1 AND topic_date_show IS NULL
Ошибка в запросe (1054): Unknown column 'topic_date_show' in 'where clause'

-- STEP 15
ALTER TABLE  `prefix_topic` ADD INDEX (  `topic_date_show` )
Ошибка в запросe (1072): Key column 'topic_date_show' doesn't exist in table

SQL Error: Unknown column 't.topic_date_show' in 'where clause' at /var/www/site.ru/common/classes/modules/topic/mapper/Topic.mapper.class.php line 395 --- Array ( [code] => 1054 [message] => Unknown column 't.topic_date_show' in 'where clause' [query] => SELECT b.blog_type AS ARRAY_KEY, COUNT(t.topic_id) AS cnt FROM prefix_topic AS t LEFT JOIN prefix_blog AS b ON t.blog_id=b.blog_id WHERE 1=1 AND (t.topic_publish = 1) AND (t.topic_date_show IS NULL OR t.topic_date_show <= '2016-11-03 17:11:45') AND ((t.topic_date_show IS NOT NULL AND t.topic_date_show >= '2016-11-02 17:00:00' AND t.topic_date_show <='2016-11-03 17:11:45') OR (t.topic_date_show IS NULL AND t.topic_date_add >= '2016-11-02 17:00:00')) GROUP BY b.blog_type [context] => /var/www/site.ru/common/classes/modules/topic/mapper/Topic.mapper.class.php line 395 )

ALTER TABLE `prefix_topic` ADD `topic_date_show` datetime DEFAULT NULL AFTER `topic_date_edit`;

UPDATE prefix_topic SET topic_date_show=topic_date_add
WHERE topic_publish=1 AND topic_date_show IS NULL;

ALTER TABLE  `prefix_topic` ADD INDEX (  `topic_date_show` );

ALTER TABLE `prefix_topic` ADD `topic_date_show` datetime DEFAULT NULL AFTER `topic_date_edit`
Ошибка в запросe (1060): Duplicate column name 'topic_date_show'

SQL Error: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'site.m.date_add' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /var/www/site.ru/common/classes/modules/mresource/mapper/Mresource.mapper.class.php line 1025 --- Array ( [code] => 1055 [message] => Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'site.m.date_add' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [query] => SELECT IF( ISNULL(t.target_tmp), IF((t.target_type LIKE 'topic%'), 'topic', IF(t.target_type = 'profile_avatar' OR t.target_type = 'profile_photo', 'user', t.target_type)), 'tmp') AS ttype , count(t.target_id) AS count FROM prefix_mresource_target as t, prefix_mresource as m WHERE t.mresource_id = m.mresource_id AND (m.type & (1 | 16 | 64)) AND m.user_id = 1 GROUP BY ttype ORDER BY m.date_add desc [context] => /var/www/site.ru/common/classes/modules/mresource/mapper/Mresource.mapper.class.php line 1025 )

2) — для аватарок в базе, наверное, стоят абсолютные пути, указывающие на другой хост, поэтому обрезать их автоматически движок не может, а в верстке явно не задается размер. Поправим

http://site.ru/uploads/images/00/00/01/2013/05/14/avatar_100x100.png

[LOG:1478578616.534-582151B88312A][2016-11-08 07:16:56][PID:13286][ERROR][[
SQL Error: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'site.m.date_add' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /var/www/site.ru/common/classes/modules/mresource/mapper/Mresource.mapper.class.php line 987
---
Array
(
    [code] => 1055
    [message] => Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'site.m.date_add' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
    [query] => SELECT
                  IF(
                    ISNULL(t.target_tmp),
                    IF((t.target_type LIKE 'topic%' AND t.target_id = 0), 'current',
                      IF(t.target_type = 'profile_avatar' OR t.target_type = 'profile_photo', 'user', t.target_type)),
                    'tmp') AS ttype
                  , count(t.target_id) AS count
                FROM
                  prefix_mresource_target as t, prefix_mresource as m
                WHERE
                  t.mresource_id = m.mresource_id
                  AND m.user_id = 1
                  AND t.target_type IN ( 'current', 'tmp', 'blog_avatar', 'profile_avatar', 'profile_photo' )

                GROUP  BY
                  ttype                ORDER BY
                 m.date_add desc
    [context] => /var/www/site.ru/common/classes/modules/mresource/mapper/Mresource.mapper.class.php line 987
)

]][END:1478578616.534-582151B88312A]