Найти на сайте
  2. Форумы
  3. ОБСУЖДЕНИЯ
  4. Релизы
  5. Проблема обновления instantcms до 2.5.0 и 2.5.1.

Проблема обновления instantcms до 2.5.0 и 2.5.1.

#16 3 июля 2016 в 18:50
Ну правда мапс очень очень тормозит))
0
#17 3 июля 2016 в 18:51
0
#18 3 июля 2016 в 19:41

Установил memcache, включил cache, не помогает
0
#19 3 июля 2016 в 20:02
И в админке такая ошибка
Отладка включена
— Ошибки PHP ( critical_user_page, trace = 5 )
— Контрольные точки ( trace = 3 )
0
#20 4 июля 2016 в 09:14
Vladimir, включите в "Отладке" на вкладке "База данных" галку "Показывать коннекты и запросы к БД". После перезагрузки проблемной страницы появится лог запросов к БД. Найдите запросы с большим временем выполнения.

Кстати, у Вас отсутствует файл стилей отладки \templates\ваш_шаблон\css\debug.css или он не подключается в Вашем шаблоне. При наличии и подключении этого файла вывод отладки будет оформлен более наглядно, в том числе будут подсвечены жёлтым фоном "тяжёлые" запросы к БД.
0
#21 4 июля 2016 в 19:51
system/controllers/content/frontend.php (141) modelContent->getContentProps
system/controllers/content/frontend.php (141) content->renderItemsList
system/core/action.php (29) content->call_user_func_array
Query 12 — 954,1 ms — [ 1010,4 ms ] system/controllers/content/model.php (1780) cmsModel->getCount Affected/returned rows: 1
SELECT COUNT(i.id) as COUNT
FROM cms_con_places i
INNER JOIN cms_con_places_cats_bind as b FORCE INDEX (item_id) ON b.item_id = i.id
WHERE (b.category_id = '54') AND (i.is_parent_hidden IS NULL) AND (i.is_approved = '1') AND (i.is_pub = '1')

system/controllers/content/frontend.php (204) modelContent->getContentItemsCount
system/controllers/content/frontend.php (204) content->renderItemsList
system/core/action.php (29) content->call_user_func_array
Query 13 — 3784,8 ms — [ 4796,7 ms ] system/controllers/content/model.php (1816) cmsModel->get Affected/returned rows: 15
SELECT i.*, u.nickname as user_nickname, f.title as folder_title
FROM cms_con_places i
FORCE INDEX (date_pub)
INNER JOIN cms_con_places_cats_bind as b FORCE INDEX (item_id) ON b.item_id = i.id
INNER JOIN cms_users as u FORCE INDEX (PRIMARY) ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (b.category_id = '54') AND (i.is_parent_hidden IS NULL) AND (i.is_approved = '1') AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 0, 15

system/controllers/content/frontend.php (205) modelContent->getContentItems
system/controllers/content/frontend.php (205) content->renderItemsList
system/core/action.php (29) content->call_user_func_array
Query 14 — 0,3 ms — [ 4800,5 ms ] system/controllers/rating/model.php (17) cmsModel->getCount Affected/returned rows: 1
SELECT COUNT(i.id) as COUNT
FROM cms_rating_log i
WHERE (i.user_id = '1') AND (i.target_controller = 'content') AND (i.target_subject = 'places') AND (i.target_id = '250048')

system/controllers/rating/frontend.php (27) modelRating->isUserVoted
system/controllers/content/frontend.php (224) rating->getWidget
system/controllers/content/frontend.php (224) content->renderItemsList
Query 15 — 0,5 ms — [ 4802,4 ms ] system/controllers/rating/model.php (17) cmsModel->getCount Affected/returned rows: 1
SELECT COUNT(i.id) as COUNT
FROM cms_rating_log i
WHERE (i.user_id = '1') AND (i.target_controller = 'content') AND (i.target_subject = 'places') AND (i.target_id = '250047')

system/controllers/rating/frontend.php (27) modelRating->isUserVoted
system/controllers/content/frontend.php (224) rating->getWidget
system/controllers/content/frontend.php (224) content->renderItemsList
Query 16 — 0,2 ms — [ 4804 ms ] system/controllers/rating/model.php (17) cmsModel->getCount Affected/returned rows: 1
SELECT COUNT(i.id) as COUNT
FROM cms_rating_log i
WHERE (i.user_id = '1') AND (i.target_controller = 'content') AND (i.target_subject = 'places') AND (i.target_id = '250046')

system/controllers/rating/frontend.php (27) modelRating->isUserVoted
system/controllers/content/frontend.php (224) rating->getWidget
system/controllers/content/frontend.php (224) content->renderItemsList
Query 17 — 0,3 ms — [ 4805,6 ms ] system/controllers/rating/model.php (17) cmsModel->getCount Affected/returned rows: 1
SELECT COUNT(i.id) as COUNT
FROM cms_rating_log i
WHERE (i.user_id = '1') AND (i.target_controller = 'content') AND (i.target_subject = 'places') AND (i.target_id = '250045')

system/controllers/rating/frontend.php (27) modelRating->isUserVoted
system/controllers/content/frontend.php (224) rating->getWidget
system/controllers/content/frontend.php (224) content->renderItemsList
Query 18 — 0,3 ms — [ 4807,2 ms ] system/controllers/rating/model.php (17) cmsModel->getCount Affected/returned rows: 1
SELECT COUNT(i.id) as COUNT
FROM cms_rating_log i
WHERE (i.user_id = '1') AND (i.target_controller = 'content') AND (i.target_subject = 'places') AND (i.target_id = '250044')

system/controllers/rating/frontend.php (27) modelRating->isUserVoted
system/controllers/content/frontend.php (224) rating->getWidget
system/controllers/content/frontend.php (224) content->renderItemsList
Query 19 — 0,2 ms — [ 4808,7 ms ] system/controllers/rating/model.php (17) cmsModel->getCount Affected/returned rows: 1
SELECT COUNT(i.id) as COUNT
FROM cms_rating_log i
WHERE (i.user_id = '1') AND (i.target_controller = 'content') AND (i.target_subject = 'places') AND (i.target_id = '250043')

system/controllers/rating/frontend.php (27) modelRating->isUserVoted
system/controllers/content/frontend.php (224) rating->getWidget
system/controllers/content/frontend.php (224) content->renderItemsList
Query 20 — 0,2 ms — [ 4810,2 ms ] system/controllers/rating/model.php (17) cmsModel->getCount Affected/returned rows: 1
SELECT COUNT(i.id) as COUNT
FROM cms_rating_log i
WHERE (i.user_id = '1') AND (i.target_controller = 'content') AND (i.target_subject = 'places') AND (i.target_id = '250042')

system/controllers/rating/frontend.php (27) modelRating->isUserVoted
system/controllers/content/frontend.php (224) rating->getWidget
system/controllers/content/frontend.php (224) content->renderItemsList
Query 21 — 0,2 ms — [ 4811,8 ms ] system/controllers/rating/model.php (17) cmsModel->getCount Affected/returned rows: 1
SELECT COUNT(i.id) as COUNT
FROM cms_rating_log i
WHERE (i.user_id = '1') AND (i.target_controller = 'content') AND (i.target_subject = 'places') AND (i.target_id = '250041')

system/controllers/rating/frontend.php (27) modelRating->isUserVoted
system/controllers/content/frontend.php (224) rating->getWidget
system/controllers/content/frontend.php (224) content->renderItemsList
Query 22 — 0,2 ms — [ 4813,3 ms ] system/controllers/rating/model.php (17) cmsModel->getCount Affected/returned rows: 1
SELECT COUNT(i.id) as COUNT
FROM cms_rating_log i
WHERE (i.user_id = '1') AND (i.target_controller = 'content') AND (i.target_subject = 'places') AND (i.target_id = '250040')

system/controllers/rating/frontend.php (27) modelRating->isUserVoted
system/controllers/content/frontend.php (224) rating->getWidget
system/controllers/content/frontend.php (224) content->renderItemsList
Query 23 — 0,2 ms — [ 4814,9 ms ] system/controllers/rating/model.php (17) cmsModel->getCount Affected/returned rows: 1
SELECT COUNT(i.id) as COUNT
FROM cms_rating_log i
WHERE (i.user_id = '1') AND (i.target_controller = 'content') AND (i.target_subject = 'places') AND (i.target_id = '250039')

system/controllers/rating/frontend.php (27) modelRating->isUserVoted
system/controllers/content/frontend.php (224) rating->getWidget
system/controllers/content/frontend.php (224) content->renderItemsList
Query 24 — 0,3 ms — [ 4816,5 ms ] system/controllers/rating/model.php (17) cmsModel->getCount Affected/returned rows: 1
SELECT COUNT(i.id) as COUNT
FROM cms_rating_log i
WHERE (i.user_id = '1') AND (i.target_controller = 'content') AND (i.target_subject = 'places') AND (i.target_id = '250038')

system/controllers/rating/frontend.php (27) modelRating->isUserVoted
system/controllers/content/frontend.php (224) rating->getWidget
system/controllers/content/frontend.php (224) content->renderItemsList
Query 25 — 0,2 ms — [ 4818 ms ] system/controllers/rating/model.php (17) cmsModel->getCount Affected/returned rows: 1
SELECT COUNT(i.id) as COUNT
FROM cms_rating_log i
WHERE (i.user_id = '1') AND (i.target_controller = 'content') AND (i.target_subject = 'places') AND (i.target_id = '250037')

system/controllers/rating/frontend.php (27) modelRating->isUserVoted
system/controllers/content/frontend.php (224) rating->getWidget
system/controllers/content/frontend.php (224) content->renderItemsList
Query 26 — 0,3 ms — [ 4819,6 ms ] system/controllers/rating/model.php (17) cmsModel->getCount Affected/returned rows: 1
SELECT COUNT(i.id) as COUNT
FROM cms_rating_log i
WHERE (i.user_id = '1') AND (i.target_controller = 'content') AND (i.target_subject = 'places') AND (i.target_id = '250036')

system/controllers/rating/frontend.php (27) modelRating->isUserVoted
system/controllers/content/frontend.php (224) rating->getWidget
system/controllers/content/frontend.php (224) content->renderItemsList
Query 27 — 0,3 ms — [ 4821,2 ms ] system/controllers/rating/model.php (17) cmsModel->getCount Affected/returned rows: 1
SELECT COUNT(i.id) as COUNT
FROM cms_rating_log i
WHERE (i.user_id = '1') AND (i.target_controller = 'content') AND (i.target_subject = 'places') AND (i.target_id = '250035')

system/controllers/rating/frontend.php (27) modelRating->isUserVoted
system/controllers/content/frontend.php (224) rating->getWidget
system/controllers/content/frontend.php (224) content->renderItemsList
Query 28 — 0,2 ms — [ 4822,8 ms ] system/controllers/rating/model.php (17) cmsModel->getCount Affected/returned rows: 1
SELECT COUNT(i.id) as COUNT
FROM cms_rating_log i
WHERE (i.user_id = '1') AND (i.target_controller = 'content') AND (i.target_subject = 'places') AND (i.target_id = '250034')

system/controllers/rating/frontend.php (27) modelRating->isUserVoted
system/controllers/content/frontend.php (224) rating->getWidget
system/controllers/content/frontend.php (224) content->renderItemsList
Query 29 — 0,1 ms — [ 4836,6 ms ] system/controllers/messages/model.php (321) cmsModel->getCount Affected/returned rows: 1
SELECT COUNT(i.id) as COUNT
FROM cms_users_messages i
WHERE (i.to_id = '1') AND (i.is_new = '1')

system/controllers/messages/hooks/menu_messages.php (15) modelMessages->getNewMessagesCount
system/controllers/messages/hooks/menu_messages.php (15) onMessagesMenuMessages->run
system/core/controller.php (454) onMessagesMenuMessages->call_user_func_array
Query 30 — 0 ms — [ 4837,5 ms ] system/controllers/messages/model.php (395) cmsModel->getCount Affected/returned rows: 1
SELECT COUNT(i.id) as COUNT
FROM cms_users_notices i
WHERE (i.user_id = '1')

system/controllers/messages/hooks/menu_messages.php (26) modelMessages->getNoticesCount
system/controllers/messages/hooks/menu_messages.php (26) onMessagesMenuMessages->run
system/core/controller.php (454) onMessagesMenuMessages->call_user_func_array
Query 31 — 0,1 ms — [ 4838,6 ms ] system/controllers/moderation/model.php (29) cmsModel->get Affected/returned rows: 0
SELECT i.*
FROM cms_moderators_tasks i
WHERE (i.moderator_id = '1')
LIMIT 1000

system/controllers/moderation/model.php (7) modelModeration->getTasks
system/controllers/moderation/hooks/menu_moderation.php (15) modelModeration->getTasksCounts
system/controllers/moderation/hooks/menu_moderation.php (15) onModerationMenuModeration->run
Query 32 — 0,1 ms — [ 4840,8 ms ] system/controllers/groups/model.php (205) cmsModel->get Affected/returned rows: 9
SELECT i.*, g.id as id, g.*
FROM cms_groups_members i
INNER JOIN cms_groups as g ON g.id = i.group_id
WHERE (i.user_id = '1')
ORDER BY g.title
LIMIT 1000

system/controllers/groups/hooks/menu_groups.php (16) modelGroups->getUserGroups
system/controllers/groups/hooks/menu_groups.php (16) onGroupsMenuGroups->run
system/core/controller.php (454) onGroupsMenuGroups->call_user_func_array

После Query 12, у всех время больше 4000ms
0
#22 4 июля 2016 в 20:12
Query 12 — 954,1 ms — [ 1010,4 ms ] system/controllers/content/model.php (1780) cmsModel->getCount Affected/returned rows: 1 
  1. SELECT COUNT(i.id) AS COUNT
  2. FROM cms_con_places i
  3. INNER JOIN cms_con_places_cats_bind AS b FORCE INDEX (item_id) ON b.item_id = i.id
  4. WHERE (b.category_id = '54') AND (i.is_parent_hidden IS NULL) AND (i.is_approved = '1') AND (i.is_pub = '1')
Query 13 — 3784,8 ms — [ 4796,7 ms ] system/controllers/content/model.php (1816) cmsModel->get Affected/returned rows: 15 
  1. SELECT i.*, u.nickname AS user_nickname, f.title AS folder_title
  2. FROM cms_con_places i
  3. FORCE INDEX (date_pub)
  4. INNER JOIN cms_con_places_cats_bind AS b FORCE INDEX (item_id) ON b.item_id = i.id
  5. INNER JOIN cms_users AS u FORCE INDEX (PRIMARY) ON u.id = i.user_id
  6. LEFT JOIN cms_content_folders AS f ON f.id = i.folder_id
  7. WHERE (b.category_id = '54') AND (i.is_parent_hidden IS NULL) AND (i.is_approved = '1') AND (i.is_pub = '1')
  8. ORDER BY i.date_pub DESC
  9. LIMIT 0, 15
Это два самых долгих запроса из лога со временем 954,1 ms и 3784,8 ms соответственно. Смотреть нужно на время после номера запроса. А в квадратных скобках указано время с начала скрипта.

1. Посмотрите, есть ли ещё такие долгие запросы на этой странице?
2. Покажите эти запросы непосредственно Fuze или r2.
0
#23 20 июля 2016 в 21:00
Проблема в открытии личных сообщений в мобильном варианте выдаёт ошибку 404.
0
#24 27 апреля 2017 в 14:08
Тоже не могу обновиться на 2.7.0

Вот такая ошибка в режиме отладки

Notice: Undefined index: cats_view in /var/www/user/data/www/domen.ru/system/controllers/content/model.php on line 1414

Notice: Undefined index: cats_hide in /var/www/user/data/www/domen.ru/system/controllers/content/model.php on line 1415

Warning: Cannot modify header information — headers already sent by (output started at /var/www/user/data/www/domen.ru/system/controllers/content/model.php:1414) in /var/www/user/data/www/domen.ru/system/core/core.php on line 881

Warning: Cannot modify header information — headers already sent by (output started at /var/www/user/data/www/domen.ru/system/controllers/content/model.php:1414) in /var/www/user/data/www/domen.ru/system/core/core.php on line 882
Ошибка в запросе БД:
Неизвестный столбец 'i.is_deleted' в 'where clause'

SELECT i.*, u.nickname as user_nickname, f.title as folder_title
FROM cms_con_news i
FORCE INDEX (date_pub)
INNER JOIN cms_con_news_cats_bind as b FORCE INDEX (item_id) ON b.item_id = i.id
INNER JOIN cms_con_news_cats as c ON c.id = b.category_id
INNER JOIN cms_users as u FORCE INDEX (PRIMARY) ON u.id = i.user_id
LEFT JOIN cms_content_folders as f ON f.id = i.folder_id
WHERE (c.ns_left >= '2') AND (c.ns_right <= '3') AND (i.is_parent_hidden IS NULL) AND (i.is_approved = '1') AND (i.is_deleted IS NULL) AND (i.is_pub = '1')
ORDER BY i.date_pub desc
LIMIT 32
Последние вызовы:

get() @ /var/www/user/data/www/domen.ru/system/controllers/content/model.php: 2184
getContentItems() @ /var/www/user/data/www/domen.ru/system/controllers/content/widgets/list/widget.php: 118
run()
call_user_func_array() @ /var/www/user/data/www/domen.ru/system/core/core.php: 796
runWidget() @ /var/www/user/data/www/domen.ru/system/core/core.php: 757
runWidgets() @ /var/www/user/data/www/domen.ru/index.php: 45
0
Письма администратору при доба
Ошибка вывода списка городов s
Вы не можете отвечать в этой теме.
Войдите или зарегистрируйтесь, чтобы писать на форуме.

Похожие темы

Что будет премиум-компонентом InstantVideo после 2020 года?

Флейм / Флуд / Оффтопик Создана 4 года назад 7 сообщений

Работает ли биллинг на InstantCMS 2.16.3 ?

Биллинг Создана 7 месяцев назад 17 сообщений

Проблемы с шаблонами instantcms

Дизайн / Графика / Искусство Создана 3 года назад 208 сообщений

Не работает карта сайта на 2ке

Релизы 2.X Создана 4 года назад 1 сообщение

Status: 200 при сохранении настроек виджета

Разработка и тестирование Создана 3 года назад 9 сообщений

HTML блок сам исправляет код

Релизы 2.X Создана 1 год назад 24 сообщения

InstantCMS Team

Связь с нами
Email dev@instantcms.ru

Делаем полезные Интернет проекты с 2008 года 💫

О проекте

Поддержка

Дополнения

Используя этот сайт, вы соглашаетесь с тем, что мы используем файлы cookie.