Integrity constraint violation: 1048 Column 'url_id' cannot be null

Question

I am getting this error in Zend Framework: Integrity constraint violation: 1048 Column 'url_id' cannot be null

My code is:

$stmt = $this->select()->where('url_address = ?', $url_address)->query();       
        $r = $stmt->fetchAll();              
        print_r($r);
        if(count($r)==0){

            $data = array(
                'url_address'      => $url_address,
            );

            $this->insert($data);       

            $stmt = $this->select()->where('url_address = ?', $url_address)->query();                               
                         $r = $stmt->fetchAll();    

        }   

        echo $r->url_id;
        return $r->url_id;

Did you try putting something in `url_id`? – Ignacio Vazquez-Abrams May 05 '11 at 17:48 — Ignacio Vazquez-Abrams, May 05 '11 at 17:48
url_id is auto-increment, primary key – Future King May 05 '11 at 17:49 — Future King, May 05 '11 at 17:49
That's not what that error is saying... – Ignacio Vazquez-Abrams May 05 '11 at 17:49 — Ignacio Vazquez-Abrams, May 05 '11 at 17:49
I am getting error on Line 12 $r = $stmt->fetchAll(); – Future King May 05 '11 at 17:54 — Future King, May 05 '11 at 17:54
It's not an auto-increment if it's showing that error – Mike B Mar 11 '14 at 16:56 — Mike B, Mar 11 '14 at 16:56

score -1 · Answer 1 · answered May 05 '11 at 17:49

-1

That's a MySQL error, not really a PHP one. You need the url_id field to be a default value of NULL if nothing is going to be inserted there.

answered May 05 '11 at 17:49

Abel Mohler

785
5
12

1

My problem solved The error was due to this line: $r->url_id; return $r[0]["url_id"]; – Future King May 05 '11 at 18:06
@FutureKing could you please elaborate on how you solved this problem? Possibly even post as an answer? – Lizz Jan 27 '15 at 12:59

Integrity constraint violation: 1048 Column 'url_id' cannot be null

1 Answers1