Сломался счётчик просмотров

[VetalDX 1]

может подскажите как мне проверить на ошибки Планировщика ? ....

[siv1987 2628]

Что проверить? Менеджер задач только запускает отдельные задачи, их нужно проверять. Если время запуска задач обновляется значит он работает.

[VetalDX 1]

Время то обновляется задачи, но просмотры почему-то нет. Просмотры обновляются только если вручную обновить или как я сделал через крон на машине.

[VetalDX 1]

не обновляется в ручную

ошибки... что-то с забросами таблицы..

 

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 28 Jun 2016 07:30:03 +0000
Error: 1017 - Can't find file: 'downloads_fileviews' (errno: 2)
IP Address:  - /var/www/tmwin/data/www/tmwin.ru/interface/task.php
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT COUNT(*) as views, view_fid FROM downloads_fileviews GROUP BY view_fid
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin_cp8/sources/classes/class_taskmanager.php                            | [task_item].runTask                                                           | 208               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| interface/task.php                                                         | [class_taskmanager].runTask                                                   | 57                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 28 Jun 2016 07:31:42 +0000
Error: 1017 - Can't find file: 'profile_portal_views' (errno: 2)
IP Address: 46.160.84.125 - /admin_cp8/index.php?adsess=de1079406f56a975a992f2753b289676&app=core&module=system&section=taskmanager&do=task_run_now&task_id=14&tab=members
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT views_member_id, COUNT(*) as profile_views FROM profile_portal_views GROUP BY views_member_id
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin_cp8/applications/core/modules_admin/system/taskmanager.php           | [task_item].runTask                                                           | 325               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin_cp8/applications/core/modules_admin/system/taskmanager.php           | [admin_core_system_taskmanager].taskManagerRunTask                            | 97                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin_cp8/sources/base/ipsController.php                                   | [admin_core_system_taskmanager].doExecute                                     | 306               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 28 Jun 2016 07:36:25 +0000
Error: 1017 - Can't find file: 'profile_portal_views' (errno: 2)
IP Address: 46.160.84.125 - /admin_cp8/index.php?adsess=de1079406f56a975a992f2753b289676&app=core&module=system&section=taskmanager&do=task_run_now&task_id=14&tab=members
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT views_member_id, COUNT(*) as profile_views FROM profile_portal_views GROUP BY views_member_id
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin_cp8/applications/core/modules_admin/system/taskmanager.php           | [task_item].runTask                                                           | 325               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin_cp8/applications/core/modules_admin/system/taskmanager.php           | [admin_core_system_taskmanager].taskManagerRunTask                            | 97                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin_cp8/sources/base/ipsController.php                                   | [admin_core_system_taskmanager].doExecute                                     | 306               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 28 Jun 2016 07:39:10 +0000
Error: 1017 - Can't find file: 'profile_portal_views' (errno: 2)
IP Address: 46.160.84.125 - /admin_cp8/index.php?adsess=de1079406f56a975a992f2753b289676&app=core&module=system&section=taskmanager&do=task_run_now&task_id=14&tab=members
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT views_member_id, COUNT(*) as profile_views FROM profile_portal_views GROUP BY views_member_id
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin_cp8/applications/core/modules_admin/system/taskmanager.php           | [task_item].runTask                                                           | 325               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin_cp8/applications/core/modules_admin/system/taskmanager.php           | [admin_core_system_taskmanager].taskManagerRunTask                            | 97                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin_cp8/sources/base/ipsController.php                                   | [admin_core_system_taskmanager].doExecute                                     | 306               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Tue, 28 Jun 2016 07:45:55 +0000
Error: 1017 - Can't find file: 'profile_portal_views' (errno: 2)
IP Address:  - /var/www/tmwin/data/www/tmwin.ru/interface/task.php
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT views_member_id, COUNT(*) as profile_views FROM profile_portal_views GROUP BY views_member_id
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin_cp8/sources/classes/class_taskmanager.php                            | [task_item].runTask                                                           | 208               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| interface/task.php                                                         | [class_taskmanager].runTask                                                   | 57                |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 

 

sql запрос вот что показывает.

Ошибка
SQL запрос: Документация


mySQL query error: SELECT views_member_id, COUNT(*) as profile_views FROM profile_portal_views GROUP BY views_member_id
LIMIT 0, 25 
Ответ MySQL: Документация

#1064 - 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 'mySQL query error: SELECT views_member_id, COUNT(*) as profile_views FROM profil' at line 1 

 

 

при нажатие обновить задачу в ручную, а также он блокируется если через крон на машине.

[siv1987 2628]

Таблица "profile_portal_views" битая. Попробуйте починить (если не чинится удалите и создайте заново) или напишите в тп хостинга.