Problem with zend_db

Question

ZF/PHP This is my class Votes:

class Votes extends Zend_Db_table {

protected $_name = 'votes';

public function vote($object_id, $user_id, $vote){

    $data = array('object_id' => $object_id, 'user_id' => $user_id, 'value' => $vote);
    $this->insert($data);

    return true;

 }
}

The 'votes' has 'id' primary key. I get: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' when i call vote. Which means the engine every time try to make an insert with '0' as id's value. How to force insert to automatically increment 'id' column?

Pedantic note: You should be extending Zend_Db_Table_Abstract — user336242
– user336242, Commented Jun 12, 2011 at 16:38

Muhammad Zeeshan · Accepted Answer · 2011-06-12 15:21:13Z

4

Make the Vote table id, an auto increment field. This should solve the problem.

answered Jun 12, 2011 at 15:21

Muhammad Zeeshan

8,86610 gold badges47 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

impiix Over a year ago

ok, i was convinced that i have id as an auto_increment, now it's ok, thanks

Shaun Hare · Accepted Answer · 2011-06-12 15:19:24Z

0

Do not add the id - ensure the field type in the database is set to auto-increment and also set it as primary key using

 protected $_primary

answered Jun 12, 2011 at 15:19

Shaun Hare

3,8712 gold badges26 silver badges36 bronze badges

Comments

Brad Lucas · Accepted Answer · 2011-06-14 03:12:48Z

0

The id field in the database should be defined to auto increment.

In MySql the syntax is like the following:

id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT

answered Jun 14, 2011 at 3:12

Brad Lucas

1852 silver badges6 bronze badges

Collectives™ on Stack Overflow

Problem with zend_db

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related