Ошибки при переезде

Lion18

Пользователь
#1
#001690 BIGINT UNSIGNED value is out of range in '(`tr`.`tmp`.`total_posts` - 1)'

UPDATE tmp_sync_topics tmp, bb_topics t SET t.topic_replies = tmp.total_posts - 1, t.topic_first_post_id = tmp.topic_first_post_id, t.topic_last_post_id = tmp.topic_last_post_id, t.topic_last_post_time = tmp.topic_last_post_time, t.topic_attachment = tmp.topic_attachment WHERE t.topic_id = tmp.topic_id

Source : includes\functions_admin.php(113) :: db1.tr
IP : 127.0.0.1
Date : 2011-11-27 00:56:33
Agent : Opera/9.80 (Windows NT 5.1; U; ru) Presto/2.9.168 Version/11.52
Req_URI : /admin/index.php?sync_topics=1
Referer :

Please Login or Register to view hidden text.


Method : GET
PID : 00220
Request : Array
(
[sync_topics] => 1
)______________________________________________________________________________
Не подскажите что может быть?
 

Lion18

Пользователь
#2
Никто не знает что это может быть?Происходит при обновлении тем или запуске крон задачи Board maintenance
#001690 BIGINT UNSIGNED value is out of range in '(`tracker`.`tmp`.`total_posts` - 1)'

UPDATE tmp_sync_topics tmp, bb_topics t SET t.topic_replies = tmp.total_posts - 1, t.topic_first_post_id = tmp.topic_first_post_id, t.topic_last_post_id = tmp.topic_last_post_id, t.topic_last_post_time = tmp.topic_last_post_time, t.topic_attachment = tmp.topic_attachment WHERE t.topic_id = tmp.topic_id

Source : includes/functions_admin.php(113) :: db1.tracker
IP : 78.111.17.66
Date : 2011-12-01 14:07:34
Agent : Opera/9.80 (Windows NT 6.1; U; YB/3.5.1; ru) Presto/2.6.30 Version/10.63
Req_URI : /admin/index.php?sync_topics=1
Referer :

Please Login or Register to view hidden text.


Method : GET
PID : 01985
Request : Array
(
[sync_topics] => 1
[aftakampl0] => login_username #Lion18^cron_check_interval #300^add_max_filesize #10^quota_desc_list[] #Mega|Cool |Cool|start |Start|High|Medium|Low^max_filesize_list[] #1024|768|512|256|128|15|10|256^rss_image #images/rss2.png^rss_max_topics #15|10
[order_vote_4] => 1
[bb_data] => a:3:{s:2:"uk";s:12:"SHJleWQbDNbc";s:3:"uid";i:2;s:3:"sid";s:20:"8v1Fvrg146FzpUwK51yZ";}
[bb_dbg] => 1
[bb_t] => a:1:{i:3766;i:1322737459;}
 

Lion18

Пользователь
#6
PheRum не работает.
Количество сообщений пользователей. синхронизирует. Темы нет. Ошибка:
Fatal error: DB Error [includes/functions_admin.php(113)] in /var/www/****.org/includes/db/mysql.php on line 803
includes/functions_admin.php(113): ( "); )

PHP:
DB()->query("
UPDATE
$tmp_sync_topics tmp, ". BB_TOPICS ." t
SET
t.topic_replies = tmp.total_posts - 1,
t.topic_first_post_id = tmp.topic_first_post_id,
t.topic_last_post_id = tmp.topic_last_post_id,
t.topic_last_post_time = tmp.topic_last_post_time,
t.topic_attachment = tmp.topic_attachment
WHERE
t.topic_id = tmp.topic_id
");
includes/db/mysql.php on line 803 : ( trigger_error($msg, E_USER_ERROR); )

PHP:
    /**
    * Trigger error
    */
    function trigger_error ($msg = 'DB Error')
    {
        if (error_reporting())
        {
            if (DEBUG === true)
            {
                $err = $this->sql_error();
                $msg .= "\n". trim(sprintf('#%06d %s', $err['code'], $err['message']));
            }
            else
            {
                $msg .= " [". $this->debug_find_source() ."]";
            }

          trigger_error($msg, E_USER_ERROR);
        }
    }
Красным выделил строки ошибок. В просте выше ошибка в sql_error_bb.log
 

Lion18

Пользователь
#10
Так и не решил эти 2 ошибки.
По первой в sql_slow_bb.log
PHP:
1324130991 | 12-17 17:09:50 | 143 | 1.3 | 22066 | db1 | INSERT INTO tmp_sync_topics SELECT t.topic_id, COU [...cut...] _id) WHERE t.topic_status != 2 GROUP BY t.topic_id # Records: 7827 Duplicates: 0 Warnings: 9 # includes/functions_admin.php(100) index.php?sync_topics=1