Ошибки в заданиях планировщика Cron

[Varius]

krumax, еще про папку trigers ему напомни

 

[DarkMod]

до 5 утра много времени, а там уже и стата появится)))

 

[krumax]

до 5 утра много времени, а там уже и стата появится)))

а вручную запустить?

 

[Warrior Of Darkness]

смотри отработку задач: tr_complete_count.php tr_cleanup_and_dlstat.php clean_dlstat.php Обрати внимание на время последнего запуска задач. Смотрим папку triggers удаляем всё лишнее, а лучше берём её с чистого дистрибутива.

Спасибо!
Triggers залил из дистибутива права на папку с файлами - 777, как и написано в инструкции.
tr_complete_count.php - отработал
tr_cleanup_and_dlstat.php - Fatal error: DB Error [includes/cron/jobs/tr_cleanup_and_dlstat.php(61)] in /var/www/545tv/data/www/545tv.com/newtorrent/includes/db/mysql.php on line 803
clean_dlstat.php - отработал

 

[Warrior Of Darkness]

до 5 утра много времени, а там уже и стата появится)))

Шутка достойная Петросяна))))

 

[krumax]

tr_cleanup_and_dlstat.php - Fatal error: DB Error [includes/cron/jobs/tr_cleanup_and_dlstat.php(61)] in /var/www/545tv/data/www/545tv.com/newtorrent/includes/db/mysql.php on line 803

логи sql ?

 

[Warrior Of Darkness]

логи sql ?

Это все логи которые есть в папке LOG, php_err.log

[03-Jan-2013 20:28:48 Europe/Moscow] PHP Fatal error:  DB Error [includes/cron/jobs/avatars_cleanup.php(22)] in /var/www/545tv/data/www/545tv.com/newtorrent/includes/db/mysql.php on line 803
[03-Jan-2013 20:34:14 Europe/Moscow] PHP Fatal error:  DB Error [includes/cron/jobs/avatars_cleanup.php(22)] in /var/www/545tv/data/www/545tv.com/newtorrent/includes/db/mysql.php on line 803
[03-Jan-2013 21:57:17 Europe/Moscow] PHP Notice:  Undefined index: SEED_COUNT in /var/www/545tv/data/www/545tv.com/newtorrent/cache/tpl_default_viewtopic_torrent.tpl.php on line 495
[03-Jan-2013 21:57:18 Europe/Moscow] PHP Notice:  Undefined index: SEED_COUNT in /var/www/545tv/data/www/545tv.com/newtorrent/cache/tpl_default_viewtopic_torrent.tpl.php on line 495
[03-Jan-2013 22:40:17 Europe/Moscow] PHP Fatal error:  DB Error [includes/cron/jobs/tr_cleanup_and_dlstat.php(61)] in /var/www/545tv/data/www/545tv.com/newtorrent/includes/db/mysql.php on line 803
[03-Jan-2013 22:50:13 Europe/Moscow] PHP Fatal error:  DB Error [includes/cron/jobs/tr_cleanup_and_dlstat.php(61)] in /var/www/545tv/data/www/545tv.com/newtorrent/includes/db/mysql.php on line 803

и
sql_error_bb.log

#001061 Duplicate key name 'user_avatar'
 
ALTER TABLE bb_users ADD INDEX user_avatar(user_avatar(10))
 
Source  : includes/cron/jobs/avatars_cleanup.php(22) :: db1.545tv3
IP      : 188.120.233.113
Date    : 2013-01-03 20:28:48
Agent  : Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.97 Safari/537.11
Req_URI : /admin/admin_cron.php
Referer : http://newtorrent.545tv.com/admin/admin_cron.php?mode=list
Method  : POST
PID    : 10760
Request : Array
(
    [mode] => list
    [cron_enabled] => 0
    [cron_check_interval] => 300
    [select] => Array
        (
            [0] => 3
            [1] => 4
            [2] => 5
            [3] => 6
            [4] => 7
            [5] => 8
            [6] => 9
            [7] => 10
            [8] => 11
            [9] => 12
            [10] => 13
            [11] => 14
            [12] => 15
            [13] => 16
            [14] => 17
            [15] => 20
            [16] => 21
            [17] => 22
            [18] => 23
        )
 
    [cron_action] => run
    [confirm] => 1
    [submit] => Отправить
    [phpbb3_ef21a_u] => 1
    [phpbb3_ef21a_k] =>
    [phpbb3_ef21a_sid] => ebb33f55b5f2ae48b6a304e11ff0369e
    [advmaker_pop] => 1
    [amcu_nn] => 5
    [bb_t] => a:1:{i:237;i:1357228441;}
    [bb_data] => a:3:{s:2:"uk";s:12:"ni7T4j7Kd7KK";s:3:"uid";i:2;s:3:"sid";s:20:"155O1KbFiKlFvSRhPfoD";}
    [bb_dbg] => 1
)______________________________________________________________________________
 
#001061 Duplicate key name 'user_avatar'
 
ALTER TABLE bb_users ADD INDEX user_avatar(user_avatar(10))
 
Source  : includes/cron/jobs/avatars_cleanup.php(22) :: db1.545tv3
IP      : 188.120.233.113
Date    : 2013-01-03 20:34:14
Agent  : Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.97 Safari/537.11
Req_URI : /admin/admin_cron.php
Referer : http://newtorrent.545tv.com/admin/admin_cron.php?mode=list
Method  : POST
PID    : 10944
Request : Array
(
    [mode] => list
    [cron_enabled] => 0
    [cron_check_interval] => 300
    [select] => Array
        (
            [0] => 3
            [1] => 4
            [2] => 5
            [3] => 6
            [4] => 7
            [5] => 8
            [6] => 9
            [7] => 10
            [8] => 11
            [9] => 12
            [10] => 13
            [11] => 14
            [12] => 15
            [13] => 16
            [14] => 17
            [15] => 20
            [16] => 21
            [17] => 22
            [18] => 23
        )
 
    [cron_action] => run
    [confirm] => 1
    [submit] => Отправить
    [phpbb3_ef21a_u] => 1
    [phpbb3_ef21a_k] =>
    [phpbb3_ef21a_sid] => ebb33f55b5f2ae48b6a304e11ff0369e
    [advmaker_pop] => 1
    [amcu_nn] => 5
    [bb_t] => a:1:{i:237;i:1357228441;}
    [bb_data] => a:3:{s:2:"uk";s:12:"ni7T4j7Kd7KK";s:3:"uid";i:2;s:3:"sid";s:20:"cbGGvOnW18cgl3J9SOOM";}
    [bb_dbg] => 1
)______________________________________________________________________________
 
#001146 Table '545tv3.buf_last_seeder' doesn't exist
 
REPLACE INTO buf_last_seeder (topic_id, seeder_last_seen) SELECT topic_id, 1357238401 FROM bb_bt_tracker WHERE seeder = 1 GROUP BY topic_id
 
Source  : includes/cron/jobs/tr_cleanup_and_dlstat.php(61) :: db1.545tv3
IP      :
Date    : 2013-01-03 22:40:17
Agent  :
Req_URI :
Referer :
Method  :
PID    : 13516
Request : Array
(
)______________________________________________________________________________
 
#001146 Table '545tv3.buf_last_seeder' doesn't exist
 
REPLACE INTO buf_last_seeder (topic_id, seeder_last_seen) SELECT topic_id, 1357239001 FROM bb_bt_tracker WHERE seeder = 1 GROUP BY topic_id
 
Source  : includes/cron/jobs/tr_cleanup_and_dlstat.php(61) :: db1.545tv3
IP      :
Date    : 2013-01-03 22:50:13
Agent  :
Req_URI :
Referer :
Method  :
PID    : 13727
Request : Array
(
)______________________________________________________________________________

Другие он логи не дает, даже если удалить все логи из папки и заново отработать все задания в кроне.

 

[krumax]

#001146 Table '545tv3.buf_last_seeder' doesn't exist REPLACE INTO buf_last_seeder (topic_id, seeder_last_seen) SELECT topic_id, 1357238401 FROM bb_bt_tracker WHERE seeder = 1 GROUP BY topic_id

вот и ответ.

Please Login or Register to view hidden text.

 

[Warrior Of Darkness]

вот и ответ.

Please Login or Register to view hidden text.

Спасибо, теперь интересно, как это поправить, каков запрос в базу для создания таблицы которой нет?

 

[krumax]

Спасибо, теперь интересно, как это поправить, каков запрос в базу для создания таблицы которой нет?

Трекер работает с анонсером на xbt ?