Roundcube Community Forum

 

Column 'date' cannot be null

Started by unicorn, March 30, 2011, 09:35:13 AM

Previous topic - Next topic

unicorn

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

dshepherd

You'll need to add this request to the bug tracker, which can be found here Roundcube Webmail, the devs will assess and action as appropriate.

unicorn

Quote from: dshepherd;33982You'll need to add this request to the bug tracker, which can be found here Roundcube Webmail, 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.

rosali

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

Roundcube - Mailing Lists
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

sasha1grate

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,dia airport limo denver