Is there anything relevant in app/tmp/logs/error.log? Mike.
On Sun, Jul 15, 2012 at 7:51 AM, mohit kumar <[email protected]> wrote: > Now the problems are still same, I upgraded to the new version of cake > php. I have deleted and created the database again. > still i am getting same error. > > When i try to execute the same query with mysql, it generates no error. > > Here is the output of the sql dump from cake php, if executed on mysql , > it generates no error > NrQueryErrorAffectedNum. rowsTook (ms) 1INSERT INTO `competence`.`users` > (`username`, `password`, `role`, `experience`, `modified`, `created`) > VALUES ('mohit', 'mohit', 'Engineer', 1, '2012-07-15 08:48:26', '2012-07-15 > 08:48:26') > 11151 2SELECT `UsersCertification`.`certification_id` FROM > `competence`.`users_certifications` AS `UsersCertification` WHERE > `UsersCertification`.`user_id` = 6 > 001 3BEGIN > 001 > > > *With Best Regards, > Mohit Kumar <http://kumarmohit.com>* > *+91-9582894570* > > > > > On Fri, Jul 13, 2012 at 8:17 PM, mohit kumar <[email protected]> wrote: > >> Cake PHP 2.2.0 >> >> +-----------+ >> | version() | >> +-----------+ >> | 5.5.16 | >> +-----------+ >> 1 row in set (0.12 sec) >> >> >> On Fri, Jul 13, 2012 at 8:09 PM, Mike Griffin <[email protected]> wrote: >> >>> 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.organd 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 >>> >> >> >> >> -- >> 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
