php - MySQL error on registration form -


i'm creating website using joomla (with template mega deals ii), , whenever test registration, either 1 of 2 errors.

one: warning

registration failed: have error in sql syntax; check manual corresponds mysql server version right syntax use near ' 2)' @ line 3

this happens when id column in users table not primary key, creates db entry 0 id. registration form go through , can see account had been added in table; however, id 0 no matter how many accounts add.

two: warning

error getting user database: duplicate entry '0' key 'primary'

this happens when set id primary key , let auto increment. did lot of testing, , playing around values in table, seems me reason, registration form sends info database id set 0 (since default id none) first, error comes in, auto increments inside table. because i'm able add 1 user before specific error keeps reoccuring, seems first user takes default id , current auto increment id @ same time? possible?

both set int(11), when use id primary key max value of id current increment of id, around 700s.

any appreciated in solving problem.

here picture of db structure.

https://i.stack.imgur.com/txt9e.png

these other possible solutions stackoverflow i've tried:

mysql phpmyadmin error #1062 - duplicate entry '0' key 'primary'

phpmyadmin #1062 - duplicate entry '' key 'primary'

mysql 1062 - duplicate entry '0' key 'primary'

error: duplicate entry '0' key 'primary'

#1062 - duplicate entry '0' key 'primary'

phpmyadmin error "#1062 - duplicate entry '1' key 1"

phpmyadmin: mysql error 1062 - duplicate entry

#1062 - duplicate entry 0' key 'primary'

here code registration directory in mega deals ii template

from default.php 

<?php /**  * @package     joomla.site  * @subpackage  com_users  *  * @copyright   copyright (c) 2005 - 2015 open source matters, inc. rights reserved.  * @license     gnu general public license version 2 or later; see license.txt  */  defined('_jexec') or die;  jhtml::_('behavior.keepalive'); jhtml::_('behavior.formvalidation'); ?> <div class="row">     <div class="col-sm-4 col-sm-offset-4">         <div class="registration<?php echo $this->pageclass_sfx?>">             <?php if ($this->params->get('show_page_heading')) : ?>                 <h1><?php echo $this->escape($this->params->get('page_heading')); ?></h1>             <?php endif; ?>              <form id="member-registration" action="<?php echo jroute::_('index.php?option=com_users&task=registration.register'); ?>" method="post" class="form-validate" enctype="multipart/form-data">                  <?php foreach ($this->form->getfieldsets() $fieldset): // iterate through form fieldsets , display each one.?>                     <?php $fields = $this->form->getfieldset($fieldset->name);?>                     <?php if (count($fields)):?>                         <?php foreach ($fields $field) :// iterate through fields in set , display them.?>                             <?php if ($field->hidden):// if field hidden, display input.?>                                 <?php echo $field->input;?>                             <?php else:?>                                 <div class="form-group">                                     <?php echo $field->label; ?>                                     <?php if (!$field->required && $field->type != 'spacer') : ?>                                         <span class="optional"><?php echo jtext::_('com_users_optional');?></span>                                     <?php endif; ?>                                      <div class="group-control">                                         <?php echo $field->input;?>                                     </div>                                 </div>                             <?php endif;?>                         <?php endforeach;?>                     <?php endif;?>                 <?php endforeach;?>                  <div class="form-group">                     <button type="submit" class="btn btn-primary validate"><?php echo jtext::_('jregister');?></button>                     <a class="btn btn-danger" href="<?php echo jroute::_('');?>" title="<?php echo jtext::_('jcancel');?>"><?php echo jtext::_('jcancel');?></a>                     <input type="hidden" name="option" value="com_users" />                     <input type="hidden" name="task" value="registration.register" />                 </div>                 <?php echo jhtml::_('form.token');?>             </form>         </div>     </div> </div>

from complete.php

<?php /**  * @package     joomla.site  * @subpackage  com_users  *  * @copyright   copyright (c) 2005 - 2015 open source matters, inc. rights reserved.  * @license     gnu general public license version 2 or later; see license.txt  */  defined('_jexec') or die; ?> <div class="registration-complete<?php echo $this->pageclass_sfx;?>">     <?php if ($this->params->get('show_page_heading')) : ?>     <h1>         <?php echo $this->escape($this->params->get('page_heading')); ?>     </h1>     <?php endif; ?> </div>


Comments

Post a Comment

Popular posts from this blog

Is there a better way to structure post methods in Class Based Views -

i'm using class based views in django , never specify url in ajax calls , omit action parameter in form because know these requests go through post method of class based view. notice view - profile page make many requests depending on user updating on page - post method become convoluted , if/else mess example: def post(self, request, *args, **kwargs): # handle user changing available date if request.post.get('availabledate') != none: self.updateavailabledate(request) return jsonresponse({'result':'success'}) if request.post.get('newprojectname') != none: creative_user = creativeuserprofile.objects.get(id = request.user.id) project = project.create_project(creative_user, request.post['newprojectname']) project.save() return jsonresponse({'projectid': project.id }) if request.post.get('projectimage') != none , request.files['file']: proj
Read more

performance - Why is XCHG reg, reg a 3 micro-op instruction on modern Intel architectures? -

i'm doing micro-optimization on performance critical part of code , came across sequence of instructions (in at&t syntax): add %rax, %rbx mov %rdx, %rax mov %rbx, %rdx i thought had use case xchg allow me shave instruction , write: add %rbx, %rax xchg %rax, %rdx however, dimay found agner fog's instruction tables , xchg 3 micro-op instruction 2 cycle latency on sandy bridge, ivy bridge, broadwell, haswell , skylake. 3 whole micro-ops , 2 cycles of latency! 3 micro-ops throws off 4-1-1-1 cadence , 2 cycle latency makes worse original in best case since last 2 instructions in original might execute in parallel. now... cpu might breaking instruction micro-ops equivalent to: mov %rax, %tmp mov %rdx, %rax mov %tmp, %rdx where tmp anonymous internal register , suppose last 2 micro-ops run in parallel latency 2 cycles. given register renaming occurs on these micro-architectures, though, doesn't make sense me done way. why wouldn't register renamer
Read more

jquery - Responsive Navbar with Sub Navbar -

good day, forgive me nav vocabulary not best. if question confusing apologize. i'm working on navigation bar needs centered on page @ 768px , above. items in nav open (or perhaps toggle) subnav lives directly below. these nav should appear centered on page. i have been able work through responsive portion of nav bar, having main items align vertically , sub nav menu of each item roll out below, , gave them indent separation. working well. however, issue not responsive side, behavior @ width greater 768px. happens toggling menu's sub navigation pushes other main items down page below sub nav. here's code: $(document).ready(function () { //stick in fixed 100% height behind navbar don't wrap $('#slide-nav.navbar-inverse').after($('<div class="inverse" id="navbar-height-col"></div>')); $('#slide-nav.navbar-default').after($('<div id="navbar-height-col"></d
Read more