Edgewall Software

Changes between Initial Version and Version 1 of Ticket #11307, comment 20


Ignore:
Timestamp:
Sep 22, 2013, 6:22:33 PM (11 years ago)
Author:
Jun Omae

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #11307, comment 20

    initial v1  
    22
    33I am updating the time value which cause the error in different tables with this command
    4 
     4{{{
    55> update wiki set time =1379840041;
    6 
    76Query OK, 312 rows affected (0.08 sec)
    8 
    97Rows matched: 312  Changed: 312  Warnings: 0
    10 
     8}}}
    119
    1210Then I am running the update command which shows me a different table with the same error. After 3 or 4 iterations I am back to the wiki table
    13 
    14 
     11{{{
    1512# trac-admin /opt/caserio/trac/caserio upgrade
    16 
    1713OperationalError: (1690, "BIGINT value is out of range in '(`trac`.`revision`.`time` * 1000000)'")
    18 
    1914# trac-admin /opt/caserio/trac/caserio upgrade
    20 
    2115OperationalError: (1690, "BIGINT value is out of range in '(`trac`.`wiki`.`time` * 1000000)'")
    22 
    2316# trac-admin /opt/caserio/trac/caserio upgrade
    24 
    2517OperationalError: (1690, "BIGINT value is out of range in '(`trac`.`ticket`.`time` * 1000000)'")
    26 
    2718# trac-admin /opt/caserio/trac/caserio upgrade
    28 
    2919OperationalError: (1690, "BIGINT value is out of range in '(`trac`.`wiki`.`time` * 1000000)'")
    30 
    3120# trac-admin /opt/caserio/trac/caserio upgrade
    32 
    3321OperationalError: (1690, "BIGINT value is out of range in '(`trac`.`revision`.`time` * 1000000)'")
    34 
    35 
    3622# trac-admin /opt/caserio/trac/caserio upgrade
    37 
    3823OperationalError: (1690, "BIGINT value is out of range in '(`trac`.`wiki`.`time` * 1000000)'")
     24}}}