Where is the error message appearing? I've tried creating a database and creating the table and when I run the INSERT query, it works fine. Can you try running that query from the command line and see what happens then?
What version of cakePHP and MySQL are you using? On Fri, Jul 13, 2012 at 3:08 PM, mohit kumar <[email protected]> wrote: > That was I guess added by bake tool, i did not code the add function. > > the information that i get when i try to add is as follows > > > > NrQueryErrorAffectedNum. rowsTook (ms) 1INSERT INTO `competence`.`users` > (`username`, `password`, `role`, `experience`, `modified`, `created`) > VALUES ('sid', '8fee7c4fe462305bdbb0acad830137f0d40af5a2', 'admin', 1, > '2012-07-13 16:01:47', '2012-07-13 16:01:47') > 11169 2SELECT `UsersCertification`.`certification_id` FROM > `competence`.`users_certifications` AS `UsersCertification` WHERE > `UsersCertification`.`user_id` = 5 > 000 3BEGIN > The debug information on the page is > > > > > - CORE\Cake\Model\Model.php line > 1884<http://localhost/cake/competence/users/add#>→ > DboSource->insertMulti(AppModel, > array, array) <http://localhost/cake/competence/users/add#> > > object(AppModel) { > useDbConfig => 'default' > useTable => 'users_certifications' > id => false > data => array([maximum depth reached]) > schemaName => 'competence' > table => 'users_certifications' > primaryKey => 'id' > validate => array([maximum depth reached]) > validationErrors => array([maximum depth reached]) > validationDomain => null > name => 'UsersCertification' > alias => 'UsersCertification' > tableToModel => array( > [maximum depth reached] > ) > cacheQueries => false > belongsTo => array([maximum depth reached]) > hasOne => array([maximum depth reached]) > hasMany => array([maximum depth reached]) > hasAndBelongsToMany => array([maximum depth reached]) > actsAs => null > Behaviors => object(BehaviorCollection) {} > whitelist => array([maximum depth reached]) > cacheSources => true > findQueryType => null > recursive => (int) 1 > order => null > virtualFields => array([maximum depth reached]) > __backAssociation => array([maximum depth reached]) > __backInnerAssociation => array([maximum depth reached]) > __backOriginalAssociation => array([maximum depth reached]) > __backContainableAssociation => array([maximum depth reached]) > findMethods => array( > [maximum depth reached] > ) > tablePrefix => '' > } > array( > (int) 0 => '`user_id`', > (int) 1 => '`certification_id`' > ) > array( > (int) 1 => array( > (int) 0 => '5', > (int) 1 => '1' > ) > ) > > > > On Fri, Jul 13, 2012 at 7:12 PM, Mike Griffin <[email protected]> wrote: > >> What is in the $this->request->data array? >> >> Mike >> >> On Fri, Jul 13, 2012 at 2:32 PM, mohit kumar <[email protected]> wrote: >> > Thanks for your response, >> > >> > I have already deleted the user table once.. >> > The code is mostly used from the bake tool. >> > >> > Here is the snapshot of my UsersController. >> > >> https://github.com/mohitkr05/Competence/blob/master/Controller/UsersController.php >> > >> > There are no entry for id=0; >> > >> > mysql> SELECT id,username FROM users WHERE id=0; >> > Empty set (0.16 sec) >> > >> > >> > My snapshot of user table >> > >> > +----+-----------+ >> > | id | username | >> > +----+-----------+ >> > | 1 | vaibhav | >> > | 2 | vaibhav | >> > | 3 | mohitkr05 | >> > | 4 | vishal | >> > +----+-----------+ >> > 4 rows in set (0.03 sec) >> > >> > and its sql is >> > >> > CREATE TABLE IF NOT EXISTS `users` ( >> > `id` int(11) NOT NULL AUTO_INCREMENT, >> > `username` varchar(50) DEFAULT NULL, >> > `password` varchar(50) DEFAULT NULL, >> > `role` varchar(20) DEFAULT NULL, >> > `experience` int(11) NOT NULL, >> > `created` datetime DEFAULT NULL, >> > `modified` datetime DEFAULT NULL, >> > PRIMARY KEY (`id`) >> > ) >> > >> > Thanks for your help. >> > >> > On Fri, Jul 13, 2012 at 1:58 PM, Mike Griffin <[email protected]> >> wrote: >> >> >> >> On Wed, Jul 11, 2012 at 2:39 PM, mohit kumar <[email protected]> >> 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' >> >> >> >> There shouldn't be an id of 0 if its auto incrementing. Did you set an >> >> auto_increment_offset anywhere? >> >> What is your add action? Post the code here so we can see if the id is >> >> being set anywhere. >> >> >> >> What happens if you run: >> >> SELECT id,username FROM users WHERE id=0; >> >> >> >> Mike. >> >> >> >> -- >> >> 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 > -- 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
