title: BIGINT UNSIGNED value is out of range
body: <p>I am getting the error</p>
  
  <blockquote>
    <p>BIGINT UNSIGNED value is out of range in '(1301980250 - <code>mydb</code>.<code>news_articles</code>.<code>date</code>)'</p>
  </blockquote>
  
  <p>When I run the query </p>
  
  <pre><code>SELECT *, ((1 / log(1301980250 - date)) * 175) as weight FROM news_articles ORDER BY weight;
  </code></pre>
  
  <p>Removing the ORDER BY condition, removes the error too. How can I fix it?</p>
  
  <p><b>Update:</b> The date field contains unix timestamp (ex: 1298944082). The error started appearing after I upgraded MySQL from 5.0.x to 5.5.x</p>
  
  <p>Any help please?</p>