Print Page - Column 'date' cannot be null

Title: Column 'date' cannot be null
Post by: unicorn on March 30, 2011, 09:35:13 AM

Could you add this patch to the rcube_imap and method add_message_cache? It's solution when incoming spam hasn't valid timestamp.

$timestamp = $headers->timestamp;
   if (!date('Ymd', $timestamp)) {
      $timestamp = time();
   }

$this->db->query(
"INSERT INTO ".get_table_name('messages').
" (user_id, del, cache_key, created, idx, uid, subject, ".
$this->db->quoteIdentifier('from').", ".
$this->db->quoteIdentifier('to').", ".
"cc, date, size, headers, structure)".
" VALUES (?, 0, ?, ".$this->db->now().", ?, ?, ?, ?, ?, ?, ".
$this->db->fromunixtime($timestamp).", ?, ?, ?)",
$_SESSION['user_id'],
$key,
$index,
$headers->uid,
(string)mb_substr($this->db->encode($this->decode_header($headers->subject, true)), 0, 128),
(string)mb_substr($this->db->encode($this->decode_header($headers->from, true)), 0, 128),
(string)mb_substr($this->db->encode($this->decode_header($headers->to, true)), 0, 128),
(string)mb_substr($this->db->encode($this->decode_header($headers->cc, true)), 0, 128),
(int)$headers->size,
serialize($this->db->encode(clone $headers)),
is_object($struct) ? serialize($this->db->encode(clone $struct)) : NULL
         );

Title: Column 'date' cannot be null
Post by: dshepherd on March 30, 2011, 10:07:52 AM

You'll need to add this request to the bug tracker, which can be found here Roundcube Webmail (http://trac.roundcube.net/), the devs will assess and action as appropriate.

Title: Column 'date' cannot be null
Post by: unicorn on March 30, 2011, 10:16:12 AM

Quote from: dshepherd;33982You'll need to add this request to the bug tracker, which can be found here Roundcube Webmail (http://trac.roundcube.net/), the devs will assess and action as appropriate.

I forgot password and when I reset password, then I didn't get e-mail with new password.

Title: Column 'date' cannot be null
Post by: rosali on March 31, 2011, 03:37:21 PM

There are mailing lists where you can address your issue aswell:

Roundcube - Mailing Lists (http://lists.roundcube.net/)

Title: Column 'date' cannot be null
Post by: sasha1grate on April 09, 2011, 08:24:09 AM

No matter where you live, there is a taxi company in your area. Whether you live in a bustling city such as New York and Chicago, or in the quiet mid-west like Fargo, there will always be a demand for cab service.

airport taxi in denver (http://www.applelimosdenver.com/),dia airport limo denver (http://www.applelimosdenver.com/)

Roundcube Community Forum

Release Support => Resolved Issues => Topic started by: unicorn on March 30, 2011, 09:35:13 AM