Roundcube Community Forum

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

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;33982

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.

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/)