Author Topic: Column 'date' cannot be null  (Read 6976 times)

Offline unicorn

  • Jr. Member
  • **
  • Posts: 15
Column 'date' cannot be null
« 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
         );

Offline dshepherd

  • Jr. Member
  • **
  • Posts: 87
Column 'date' cannot be null
« Reply #1 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, the devs will assess and action as appropriate.

Offline unicorn

  • Jr. Member
  • **
  • Posts: 15
Column 'date' cannot be null
« Reply #2 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, 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.

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
Column 'date' cannot be null
« Reply #3 on: March 31, 2011, 03:37:21 PM »
There are mailing lists where you can address your issue aswell:

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

sasha1grate

  • Guest
Column 'date' cannot be null
« Reply #4 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,dia airport limo denver