mysql> DESCRIBE users; +------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | username | varchar(50) | YES | | NULL | | | password | varchar(50) | YES | | NULL | | | role | varchar(20) | YES | | NULL | | | experience | int(11) | NO | | NULL | | | created | datetime | YES | | NULL | | | modified | datetime | YES | | NULL | | +------------+-------------+------+-----+---------+----------------+ 7 rows in set (0.01 sec)
On Thu, Jul 12, 2012 at 2:01 AM, lowpass <[email protected]> wrote: > Are you setting the id in the data array for some reason? > > It looks like you're using mysql. What is the output of "DESCRIBE > users;" in mysql terminal? > > On Wed, Jul 11, 2012 at 3:10 PM, mohit kumar <[email protected]> wrote: > > yes., auto increment is set for id > > > > On Wed, Jul 11, 2012 at 7:21 PM, Max Dörfler < > [email protected]> > > wrote: > >> > >> Is the Auto Increment attribute set for the ID column? > >> > >> > >> On 07/11/2012 03:39 PM, mohit kumar wrote: > >> > >> Hi Folks, > >> > >> I created an add action for users, > >> I am trying to register them using this action. Everything is going > fine, > >> the data is being submitted, the passwords are being hash and if I > check the > >> registration is happening. But I am getting the following error. > >> > >>> Integrity constraint violation: 1062 Duplicate entry '0' for key > >>> 'PRIMARY' > >> > >> > >> I googled it to found a link which states that > >> > >>> The only way we could fix it, is by rebuilding the entire database from > >>> scratch. > >>> > >>> Dropping all tables and reloading them from a backup. > >> > >> > >> I tried that also , still getting that error. > >> > >> Thanks for help in advance > >> > >> -- > >> Best Regards, > >> Mohit Kumar > >> > >> > >> -- > >> Our newest site for the community: CakePHP Video Tutorials > >> http://tv.cakephp.org > >> Check out the new CakePHP Questions site http://ask.cakephp.org and > help > >> others with their CakePHP related questions. > >> > >> > >> To unsubscribe from this group, send email to > >> [email protected] For more options, visit this > group > >> at http://groups.google.com/group/cake-php > >> > >> > >> > >> -- > >> Our newest site for the community: CakePHP Video Tutorials > >> http://tv.cakephp.org > >> Check out the new CakePHP Questions site http://ask.cakephp.org and > help > >> others with their CakePHP related questions. > >> > >> > >> To unsubscribe from this group, send email to > >> [email protected] For more options, visit this > group > >> at http://groups.google.com/group/cake-php > > > > > > > > > > -- > > Best Regards, > > Mohit Kumar > > > > > > -- > > Our newest site for the community: CakePHP Video Tutorials > > http://tv.cakephp.org > > Check out the new CakePHP Questions site http://ask.cakephp.org and help > > others with their CakePHP related questions. > > > > > > To unsubscribe from this group, send email to > > [email protected] For more options, visit this > group at > > http://groups.google.com/group/cake-php > > -- > Our newest site for the community: CakePHP Video Tutorials > http://tv.cakephp.org > Check out the new CakePHP Questions site http://ask.cakephp.org and help > others with their CakePHP related questions. > > > To unsubscribe from this group, send email to > [email protected] For more options, visit this group > at http://groups.google.com/group/cake-php > -- Best Regards, Mohit Kumar -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
