1062 - Duplicate entry '' for key 2 error

[saadsinpk]

hi i have website http://www.rougejaunevert.com/www/ , i want to join my forum phpbb http://www.rougejaunevert.com/www/forum and my website http://www.rougejaunevert.com/www/ , i have join db of both, and make one table, now i try to register it give this error

1062 - Duplicate entry '' for key 2

insert into phpbb_users (user_name, user_email, user_forname, user_nickname, user_gender, user_birthday, username, user_password, user_image, user_ip, user_status) values ('saad', '[e-mail]', 'iqba', '5481515', 'Mlle', '11-12-1943', 'saad_sinpk', '4c76827a270ec72b6506b4bada3bf731', 'e80f2021abfd74faf4f533bc8c875b36.jpg', '119.63.136.101', 'active')

[TEP STOP]


help me please it is urgent

[dgreenhouse]

There's obviously a record already in the phpbb_users table for at least 1 of the values you're trying to insert - and that column has a 'uniquess' constraint set.

You said you've combined two tables into 1... Probably not a good idea unless you really know what you're doing...

What is the second index key for your modified table?

I noticed that some of your column names are not part of the default phpbb_user table definition...

Hope you have a backup of the original tables...

[saadsinpk]

can u please add me <email_removed> and come in my pc by teamviewer and sort me out i am totally confuse please help me :((

[dgreenhouse]

I don't mean to be rude, but you've only made 2 posts so far. As you hopefully understand, I'm reluctant to expose my network to just anyone - I've got too much time and money invested in my infrastructure.

Helping is one thing... Doing the work for you is another...

[saadsinpk]

can u just add me on yahoo or by any other way by which we can talk directly , please help me i am not hacker or any other bad guy, i just need your help

[saadsinpk]

here is my table of phpbb_user

there are 3 index file
i have original backup please tell me what i do ?
i want to make similar site <Link to commercial site removed>

[dgreenhouse]

Your not inserting a unique value for username_clean. username_clean has a UNIQUE index constraint set. I assume you might have some other issues, but that's the first thing to correct.

See: http://www.phpbb.com/search/?q=+utf8_clean_string

You also should run the username through utf8_clean_string() creating username_clean before the insert.

You can do it without the function (roll your own), but the included functionality is handy.

[saadsinpk]

i did not understand what you are saying but i see that when i delete one register user then i try to register it allow me to register, now what i do this username_clean was already in php forum , what i do that if any one register there name show in username_clean also please help me i will be thank full you

[dgreenhouse]

How much programming experience do you have?
Are you using the actual bulletin-board application?
Or are you just using the database from phpBB?
_____________________________________________

What I was saying in my last post was that you are not including a unique value to the column: username_clean.

I can assume since you did not include username_clean in the query that it is trying to insert whatever the DEFAULT value for that column is - on every insert. That being the case; and since there is a "unique index" set for that column, you'd get an error on the second insert.

You have to include a UNIQUE value for username_clean and it would normally be the value of username passed through the filter utf8_clean_string(). utf8_clean_string() is function that is included with phpBB in the file: /includes/utf/utf_tools.php that comes with phpBB.

As a matter of fact, username should be unique also, but username_clean; I'm guessing, is used to normalize different unicode characters

That is $username_clean = utf8_clean_string($username).

I am no phpBB expert, so my observations are at the very limited level, but I have mucked around with it a little.

I'm afraid to say that you're really going to have to buckle down and learn what you're doing before tearing things apart and putting them back together in un-tested ways. [ I've done it many times though ;-) I guess that's how I learned - by TERROR! ]

Sorry if I'm making an assumption about your abilities. Are you in Ghana?

_______________________________________

From the page: http://area51.phpbb.com/docs/code/ut...8_clean_string

utf8_clean_string (line 1817)
This function is used to generate a "clean" version of a string.

Clean means that it is a case insensitive form (case folding) and that it is normalized (NFC). Additionally a homographs of one character are transformed into one specific character (preferably ASCII if it is an ASCII character).

Please be aware that if you change something within this function or within functions used here you need to rebuild/update the username_clean column in the users table. And all other columns that store a clean string otherwise you will break this functionality.

return: Cleaned up version of the input string
string utf8_clean_string (string $text)
string $text: An unclean string, mabye user input (has to be valid UTF-8!)

[saadsinpk]

sir i don't have enough programming experience i am new to this , if you will help me i will be a great fan of you, i will do any thing for you , just solve my problem a big problem

[dgreenhouse]

I can't really solve your problem without you knowing what your problem is...

[dgreenhouse]

If you can do it, I'd recommend setting things back to the point where it was working.

Then, you can figure out the best way to move forward - be it further study, getting help from others more experienced to TRULY implement the functionality desired, etc.

But you're really in a pickle at the moment; unless you only made minor changes.

Is this for your job in your country?

Be honest...

The site looks very political and I know how it can be when politcal types are involved.

[saadsinpk]

can u just check problem, by coming in my pc, please don't resolve all problem just help me, can u come in my pc by teamviewer and then you check and tell me please

[dgreenhouse]

As I mentioned earlier, I'm not willing to do that at this point. Plus, I'm about to "go dark" and work on a very dense project - after getting some sleep; after being up for over 36 hours...

[dgreenhouse]

Sorry - Guinea or more appropriately: République de Guinée...

I really feel for you, but I'm unwilling to expose myself. I believe you're probably okay, I'm just worried about the ones who might be watching who are not. Plus as stated, I don't have the time right now...

[saadsinpk]

i can change back to original file
can u tell me that , i want to make 1 sign up db for phpbb forum and my website how can i do that ?

[saadsinpk]

anyone other person here who can help me ?

[dgreenhouse]

1- I'd set the files back to the orginal versions.
2- Use phpBB's database for the signup and "opt-in"
3- Figure out how to integrate your site's authentication stuff with phpBB
4- You REALLY have to learn this stuff yourself; nobody will have the time to do the work for you...
5- Or... You'll have to hire someone ($$$) to look at all of your work so far and do the integration/implementation
6- You are asking for a lot of someone's time...
7- I don't want to be rude, but you'll need to study and learn before anyone can help you make this work
8- I'm pretty much done with this thread until you've shown you're REALLY willing to do your homework...
9- I know it's stressfull and I can tell you're backed into a corner, but that's the just way life goes sometimes - we're all "stressed!"

[saadsinpk]

friend, i am using phpbb db, thanks for your support, i wish to learn php, and i am studying php, i see that i can only register one account in my website, when i delete that account from db then i can register other account, this mean in my db i can not created more then 1 account, i post this code can you see this

<?php require_once('admin/inc/config.php');?>
<?
switch($action)
{
    case 'register':
 
        $user_gender    =$_POST['gender'];
        $user_name    =$_POST['name'];
        $user_email    =$_POST['user_email'];
        $user_forname=$_POST['forname'];
        $user_nickname=$_POST['nickname'];
        $user_birthday     =$_POST['dd'].'-'.$_POST['mm'].'-'.$_POST['yy'];
        $username =$_POST['username'];
        $user_password=$_POST['user_password'];
 
        $sql    ="select * from ".TABLE_USERS." where username='$username' or user_email='$user_email'";
        $res    =tep_db_query($sql);
        $row    =tep_db_fetch_assoc($res);
        if(tep_db_num_rows($res) > (int)1)
        {
            $err=base64_encode("e-mail ou l'ID utilisateur existe déjà s'il vous plaît choisir un autre!");
        }
        else if($row['user_email']==$user_email)
        {
            $err=base64_encode("Cet e-mail id existe déjà s'il vous plaît choisir un autre!");
        }
        else if($row['username']==$username)
        {
            $err=base64_encode("Cet ID utilisateur existe déjà choisir un autre!");
        }
        else{
            $image=uploadImage('image', 'images/users/',96,'',32,"register.php?err=Please upload specified file size!",600);
 
            $sql_data_array=array('user_name'            =>$user_name,
                                  'user_email'            =>$user_email,
                                    'user_forname'            =>$user_forname,
                                  'user_nickname'        =>$user_nickname,
                                  'user_gender'            =>$user_gender,
                                  'user_birthday'    =>$user_birthday,
                                  'username'            =>$username,
                                  'user_password'        =>md5($user_password),
                                  'user_image'            =>$image,
                                  'user_ip'            =>USER_IP,
                                  'user_status'            =>'active'    
                                  );
            $res=tep_db_perform(TABLE_USERS, $sql_data_array);
            if($res)
            {
                tep_redirect("register.php?msg=".base64_encode("You are successfuly registered now you can access your account"));
            }                          
        }
    break;
    case 'edit':
        $sql="select * from ".TABLE_USERS." where user_id='".$_SESSION['site_username']."'";
    break;    
 
    case 'login':
 
            $username    =$_POST['username'];
            $user_password    =md5($_POST['user_password']);
            $sql ="select * from ".TABLE_USERS." where username='".tep_db_input($username)."' and user_password='".tep_db_input($user_password)."'";
            $res =tep_db_query($sql);
            $row =tep_db_fetch_assoc($res);
            if($username=='' && $_POST['user_password']=='')
            {
                tep_redirect("login.php?err=".base64_encode("Sorry user id and password canot left blank!"));
            }
            else if($row['user_status']=='inactive')
            {
                tep_redirect("login.php?err=".base64_encode("Your account has not activated contact administrator!"));
            }
            else if(tep_db_num_rows($res)>(int)0)
            {
                tep_session_register("site_user_name");
                tep_session_register("site_username");
                $_SESSION['site_user_name']=$row['username'];
                $_SESSION['site_username']  =$row['user_id'];                
                //previous page
                if(isset($_SESSION['last_return_url']))    {
                    list($page)= explode('.php',basename($_SESSION['last_return_url']) );
                }else{
                    $page='';
                }
                //end
                //check weather session is active or not
                if(isset($_SESSION['cId']) && $_SESSION['cId']==1){
                    tep_redirect('checkout.php?step=1');
                }else if(isset($_SESSION['last_return_url']) && $page=='video' ){
                    tep_redirect($_SESSION['last_return_url']);
                }else{
                    tep_redirect('dashboard.php');
                }
                //end
            }
            else{
                tep_redirect("login.php?err=".base64_encode("Wrong user id or password!"));
            }                    
        break;
    case 'logout':
            if(tep_session_is_registered('site_user_name')){
                tep_session_unregister('site_user_name');
                tep_session_unregister('site_username');
                tep_session_unregister('last_return_url');
                tep_redirect("login.php?msg=".base64_encode("You have successfully signed out!"));
            }else{
                tep_redirect("login.php");
            }
        break;    
}
// date month year
$date    =array('01','02','03','04','05','06','07','08','09','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26',
            '27','28','29','30','31');
$month    =array('01','02','03','04','05','06','07','08','09','10','11','12');
// end
$msg=tep_string_convert($msg,'base64');    //calling string convertion function
$err=tep_string_convert($err,'base64');    //calling string convertion function
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>rougejaunevert.com</title>
<META name="description" content="rougejaunevert.com"> 
<META name="keywords" content="news, guinee, guinea, articles, election, 2010, conakry, labe, kankan, video, radio, candidats, candidat, candidates, candidate, vote, lansana, conte, dadis, moussa, camara, colone,l general, t-shirt, love, shop, achat">
 
<link rel="shortcut icon" href="favicon.ico" />
<link href="style.css" rel="stylesheet" type="text/css" />
<link href="tutorsty.css" rel="stylesheet" type="text/css" />
<link href="flexcrollstyles.css" rel="stylesheet" type="text/css" />
<script type='text/javascript' src="flexcroll.js"></script>
<script language="javascript" src="js/valid.js"></script>
 
<!--valid user name-->
<script src="js/jquery.js" type="text/javascript" language="javascript"></script>
<script language="javascript">
//<!---------------------------------+
//  Developed by Roshan Bhattarai 
//  Visit http://roshanbh.com.np for this script and more.
//  This notice MUST stay intact for legal use
// --------------------------------->
$(document).ready(function()
{
    $("#username").blur(function()
    {
        //remove all the class add the messagebox classes and start fading
        $("#msgbox").removeClass().addClass('messagebox').text('Checking...').fadeIn("slow");
        //check the username exists or not from ajax
        $.post("user_availability.php",{ user_name:$(this).val() } ,function(data)
        {
          if(data=='no') //if username not avaiable
          {
              $("#msgbox").fadeTo(200,0.1,function() //start fading the messagebox
            { 
              //add message and change the class of the box and start fading
              $(this).html('Cet ID utilisateur existe déjà choisir un autre').addClass('messageboxerror').fadeTo(900,1); return false;
 
            });        
          }
          else if(data=='blank') //if username not avaiable
          {
              $("#msgbox").fadeTo(200,0.1,function() //start fading the messagebox
            { 
              //add message and change the class of the box and start fading
              $(this).html('Sil vous plaît entrer votre nom dutilisateur').addClass('messageboxerror').fadeTo(900,1); return false;
 
            });        
          }
          else
          {
              $("#msgbox").fadeTo(200,0.1,function()  //start fading the messagebox
            { 
              //add message and change the class of the box and start fading
              $(this).html('Userid disponible pour enregistrer').addClass('messageboxok').fadeTo(900,1);    
            });
          }
 
        });
 
    });
});
</script>
<style type="text/css">
.top {
    margin-bottom: 15px;
}
.messagebox{
    position:absolute;
    width:100px;
    margin-left:30px;
    border:1px solid #c93;
    background:#ffc;
    padding:3px;
}
.messageboxok{
    position:absolute;
    width:auto;
    margin-left:30px;
    border:1px solid #349534;
    background:#C9FFCA;
    padding:3px;
    font-weight:bold;
    color:#008000;
 
}
.messageboxerror{
    position:absolute;
    width:auto;
    margin-left:30px;
    border:1px solid #CC0000;
    background:#F7CBCA;
    padding:3px;
    font-weight:bold;
    color:#CC0000;
}
 
</style>
<!--end-->
</head>
<body>
<table width="984" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td class="hraderbg">
    <? require_once('inc/header.php');?>
    </td>
  </tr>
  <tr>
    <td><table width="984" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="657" align="left" valign="top"><table width="657" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td class="padB"><? tep_inner_banner(0);?></td>
          </tr>
          <tr>
            <td class="padB"><table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td style="background:#FFFFFF url(images/content-m-top.gif) no-repeat top;"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td style="background:url(images/contnet-m-btm.gif) no-repeat bottom;"><table width="100%" border="0" cellspacing="10" cellpadding="0">
                      <tr>
                        <td align="left" valign="top">
                        <table width="100%" border="0" cellspacing="0" cellpadding="0">
 
                          <tr>
                            <td class="brdrB"><h1>Vous Tes Un Nouveau Client ?</h1></td>
                          </tr>
                          <tr>
                              <td class="brdB">(Champs obligatoires <font class="redCommentText">*</font>)</td>
                          </tr>
                          <tr>
                            <td class="padTB">
                            <?php echo (!empty($msg)) ? '<div class="success">'.$msg.'</div>' : '';?>
                            <?php echo (!empty($err)) ? '<div class="error">'.$err.'</div>' : '';?>
                            <form method="post" name="userform" action="register.php?action=register" enctype="multipart/form-data" onsubmit="javascript:return validRegister()">
                                <table width="100%" cellpadding="4" cellspacing="0" style="padding-left:10px;" bgcolor="#FFFFFF">
                                  <tr>
                                        <td>Civilite <font class="redCommentText">*</font></td>
                                        <td align="left">
                                            <table width="200" border="0" cellpadding="2" cellspacing="0">
                                              <tr>
                                                <td width="20"><input type="radio" name="gender" value="Mlle" <? if(isset($gender) && $gender=='Mile') echo 'checked';?> /></td>
                                                <td width="33">Mlle</td>
                                                <td width="20"><input type="radio" name="gender" value="Mme" <? if(isset($gender) && $gender=='Mme') echo 'checked';?> /></td>
                                                <td width="43">Mme</td>
                                                <td width="20"><input type="radio" name="gender" value="M" <? if(isset($gender) && $gender=='M') echo 'checked';?> /></td>
                                                <td width="40">M</td>
                                              </tr>
                                            </table>
 
                                        </td>
                                  </tr>
                                  <tr>
                                        <td>Votre adresse e-mail<font class="redCommentText">*</font></td>
                                        <td align="left">
                                        <input type="text" name="user_email" class="box" size="40" value="<? echo isset($user_email) ? $email : '';?>" />
                                        </td>
                                  </tr>
                                   <tr>
                                        <td>User Id<font class="redCommentText">*</font></td>
                                        <td align="left">
                                        <input type="text" name="username" id="username" class="box" size="30" maxlength="20" />
                                        <span id="msgbox" style="display:none"></span>
                                        </td>
                                  </tr>
                                  <tr>
                                        <td>Votremotdepasse<font class="redCommentText">*</font></td>
                                        <td align="left">
                                        <input type="password" name="user_password" class="box" size="30" maxlength="30" />                                        </td>
                                  </tr>
                                  <tr>
                                        <td>Confirmez Votremotdepasse<font class="redCommentText">*</font></td>
                                        <td align="left">
                                        <input type="password" name="confirm_pass" class="box" size="30" maxlength="30" />                                        </td>
                                  </tr>
                                  <tr>
                                        <td width="25%">Nom<font class="redCommentText">*</font></td>
                                        <td width="75%" align="left">
                                        <input type="text" name="name" class="box" size="40" value="<? echo isset($name) ? $name : '';?>" />
                                        </td>
                                  </tr>
                                  <tr>
                                        <td>Prnom<font class="redCommentText">*</font></td>
                                        <td align="left">
                                        <input type="text" name="forname" size="40" value="<? echo isset($forname) ? $forname : '';?>">
                                        </td>
                                  </tr>
                                  <tr>
                                        <td>Pseudo</td>
                                        <td align="left">
                                        <input type="text" name="nickname" size="40" value="<? echo isset($name) ? $name : '';?>" />
                                        </td>
                                  </tr>
                                  <tr>
                                        <td>Date de naissance</td>
                                        <td align="left">
                                        <select name="dd">
                                            <option value="">DD</option>
                                            <?
                                                foreach($date as $val)
                                                {
                                            ?>
                                            <option value="<? echo $val;?>" <? if(isset($_POST['dd']) && $_POST['dd']==$val) echo 'selected';?>><? echo $val;?></option>
                                            <?    
                                                }
                                            ?>
                                        </select>
                                        <select name="mm">
                                            <option value="">MM</option>
                                            <?
                                                foreach($month as $val)
                                                {
                                            ?>
                                            <option value="<? echo $val;?>" <? if(isset($_POST['mm']) && $_POST['mm']==$val) echo 'selected';?>><? echo $val;?></option>
                                            <?    
                                                }
                                            ?>
                                        </select>
                                        <select name="yy">
                                            <option value="">YY</option>
                                            <?
                                                for($i=1920;$i<=2040; $i++)
                                                {
                                            ?>
                                            <option value="<? echo $i;?>" <? if(isset($_POST['yy']) && $_POST['yy']==$i) echo 'selected';?>><? echo $i;?></option>
                                            <?    
                                                }
                                            ?>
                                        </select>
                                        </td>
                                  </tr>
                                  <tr>
                                    <td>Image Profile</td>
                                    <td align="left">
                                    <input type="file" name="image"  size="40" />
                                  </td>
                                  </tr>
                                   <tr>
                                     <td>&nbsp;</td>
                                     <td align="left">
                                     <input type="image" name="submit" src="images/btn-submit.gif" style="border:none;padding:0px;" value="submit" />
                                     <img src="images/btn-cancel.gif" onclick="javascript:document.userform.reset();" />                                     </td>
                                   </tr>
                                 </table>
                                </form>
                             </td>
                          </tr>
                          <tr>
                            <td class=" brdrT"></td>
                          </tr>
                        </table></td>
                      </tr>
                    </table></td>
                  </tr>
                </table></td>
              </tr>
            </table></td>
          </tr>
        </table></td>
        <td align="right" valign="top" class="padL"><table width="318" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td class="padB"><table width="318" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td style="background:#FFFFFF url(images/content-s-top.gif) no-repeat top;"><table width="318" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td style="background:url(images/content-s-btm.gif) no-repeat bottom;">
                     <? require_once('top_candidats.php');?>
                    </td>
                  </tr>
                </table></td>
              </tr>
            </table></td>
          </tr>
          <tr>
            <td class="padB">
                <a href="http://www.store.rougejaunevert.com" target="_blank"><img src="images/shop.jpg" border="0" alt="shop" /></a>
            </td>
          </tr>
          <tr>
            <td class="padB">
            <? include('vote.php');?>
            </td>
          </tr>
 
        </table></td>
      </tr>
    </table></td>
  </tr>
  <? require_once('inc/footer.php');?>
</table>
</body>
</html>

i give you every thing , and i know i am almost done, but i don't know where i stuck, i know little bit php, by the thanks for ur support

[fodeATrougejaunevert]

Hello All,

SaadSpank took on this project of mine from getafreelancer. He claimed to know what he was doing but i am surprised to see that he has posted in many PHP help website and wasting people's time as well as mine. After 4 days of no result(quoted 24 hours to complete) and 6 extentions I have nothing to show for. I had to cancelled the project because of incompetance. I should have known i had more PHP experience than he did! My apologies to the good helpers in this forum for wasting your time. https://www.getafreelancer.com/users...k_1309160.html

[dgreenhouse]

That was a really sad situation.

Knowing that the job was a result of a post on Freelancer; or another like it, stands to reason.

What does one expect for $50?

I wouldn't turn on my computer for $50 [it's always on! :-)]

It's obvious that 'saadsinpk' didn't know what he was doing, but 'fodeATrougejaunevert' also shouldn't have been so cheap and try to bleed the desperate.

My belief is that these schlock-cheap job sites do the profession a disservice - even to those in other countries who can afford to work for $5 an hour after graduating from college.

I'm totally shocked by what people expect for absolutely nothing...

And that's what they'll normally get... Nothing!

[saadsinpk]

sir, i also buy freelancer for your project, and i was almost done, when i buy freelancer he did just help me, i also pay, but i think i waste your time for that i am really sorry,