Duplicate entry 'xx'' for key 'PRIMARY'
Hey I have just changed my home page of my retro and now every time someone signs up they are getting a "UberCMS has encountered an error
Duplicate entry 'xx' for key 'PRIMARY'" error, it still makes the account so im assuming its trying to make it twice.
This is my page-fp.tpl file, could someone help me out? Also from the post I got this off it does not have json registration, could someone please help me out?
Code:
<!DOCTYPE html>
<!--[if lt IE 7]> <html class="no-js lt-ie9 lt-ie8 lt-ie7"> <![endif]-->
<!--[if IE 7]> <html class="no-js lt-ie9 lt-ie8"> <![endif]-->
<!--[if IE 8]> <html class="no-js lt-ie9"> <![endif]-->
<!--[if gt IE 8]><!--> <html class="no-js"> <!--<![endif]-->
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<title>Habbo Hotel - Make friends, join the fun, get noticed! </title>
<meta name="viewport" content="width=device-width">
<script>
var andSoItBegins = (new Date()).getTime();
var habboPageInitQueue = [];
var habboStaticFilePath = "%www%/web-gallery";
</script>
<link rel="shortcut icon" href="%www%/web-gallery/images/v3/favicon.ico" type="image/vnd.microsoft.icon" />
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Ubuntu:400,700,400italic,700italic">
<link rel="stylesheet" href="%www%/web-gallery/static/styles/v3_landing.css" type="text/css" />
<script src="%www%/web-gallery/static/js/v3_landing_top.js" type="text/javascript"></script>
<meta name="description" content="Check into the world's largest virtual hotel for FREE! Meet and make friends, play games, chat with others, create your avatar, design rooms and more..." />
<meta name="keywords" content="habbo hotel, virtual, world, social network, free, community, avatar, chat, online, teen, roleplaying, join, social, groups, forums, safe, play, games, online, friends, teens, rares, rare furni, collecting, create, collect, connect, furni, furniture, pets, room design, sharing, expression, badges, hangout, music, celebrity, celebrity visits, celebrities, mmo, mmorpg, massively multiplayer" />
<script src="%www%/web-gallery/static/js/13389159.js"></script>
<meta name="build" content="63-BUILD-FOR-PATCH-1591a - 04.03.2013 12:03 - com" />
</head>
<body>
</head>
<body>
<div id="overlay"></div>
<div id="change-password-form" class="overlay-dialog" style="display: none;">
<div id="change-password-form-container" class="clearfix form-container">
<h2 id="change-password-form-title" class="bottom-border">Forgot Password?</h2>
<div id="change-password-form-content" style="display: none;">
<form method="post" action="https://www.habbo.com/account/password/identityResetForm" id="forgotten-pw-form">
<input type="hidden" name="page" value="/?changePwd=true" />
<span>Type in your Habbo account email address:</span>
<div id="email" class="center bottom-border">
<input type="text" id="change-password-email-address" name="emailAddress" value="" class="email-address" maxlength="48"/>
<div id="change-password-error-container" class="error" style="display: none;">Please enter a correct email address</div>
</div>
</form>
<div class="change-password-buttons">
<a href="#" id="change-password-cancel-link">Cancel</a>
<a href="#" id="change-password-submit-button" class="new-button"><b>Send Email</b><i></i></a>
</div>
</div>
<div id="change-password-email-sent-notice" style="display: none;">
<div class="bottom-border">
<span>Hey, we just sent you an email with a link that lets you reset your password.<br>
<br>
NOTE! Remember to check your "junk" folder too!</span>
<div id="email-sent-container"></div>
</div>
<div class="change-password-buttons">
<a href="#" id="change-password-change-link">Back</a>
<a href="#" id="change-password-success-button" class="new-button"><b>OK</b><i></i></a>
</div>
</div>
</div>
<div id="change-password-form-container-bottom" class="form-container-bottom">
</div>
</div>
<header>
<div id="border-left"></div>
<div id="border-right">
</div>
<div id="login-form-container">
<a href="#home" id="habbo-logo"></a>
<form id="loginformitem" name="loginformitem" method="post">
<div id="login-columns">
<div id="login-column-1">
<label for="credentials-username">Username</label>
<input tabindex="2" type="text" name="credentials.username" id="credentials-username">
<input tabindex="5" type="checkbox" name="_login_remember_me" id="credentials-remember-me">
<label for="credentials-remember-me" class="sub-label">Keep me logged in</label>
</div>
<div id="login-column-2">
<label for="credentials-password">Password</label>
<input tabindex="3" type="password" name="credentials.password" id="credentials-password">
<a href="#" id="forgot-password" class="sub-label">Forgot your password?</a>
</div>
<div id="login-column-3">
<input type="submit" value="Login" style="margin: -10000px; position: absolute;">
<a href="#" tabindex="4" class="button" id="credentials-submit"><b></b><span>Login</span></a>
</div>
<div id="login-column-4">
<div id="fb-root"></div>
<script type="text/javascript">
window.fbAsyncInit = function() {
Cookie.erase("fbsr_183096284873");
FB.init({appId: '183096284873', status: true, cookie: true, xfbml: true});
if (window.habboPageInitQueue) {
// jquery might not be loaded yet
habboPageInitQueue.push(function() {
$(document).trigger("fbevents:scriptLoaded");
});
} else {
$(document).fire("fbevents:scriptLoaded");
}
};
window.assistedLogin = function(FBobject, optresponse) {
Cookie.erase("fbsr_183096284873");
FBobject.init({appId: '183096284873', status: true, cookie: true, xfbml: true});
permissions = 'user_birthday,email';
defaultAction = function(response) {
if (response.authResponse) {
fbConnectUrl = "/facebook?connect=true";
Cookie.erase("fbhb_val_183096284873");
Cookie.set("fbhb_val_183096284873", response.authResponse.accessToken);
Cookie.erase("fbhb_expr_183096284873");
Cookie.set("fbhb_expr_183096284873", response.authResponse.expiresIn);
window.location.replace(fbConnectUrl);
}
};
if (typeof optresponse == 'undefined')
FBobject.login(defaultAction, {scope:permissions});
else
FBobject.login(optresponse, {scope:permissions});
};
(function() {
var e = document.createElement('script');
e.async = true;
e.src = document.location.protocol + '//connect.facebook.net/en_US/all.js';
document.getElementById('fb-root').appendChild(e);
}());
</script>
<a class="fb_button fb_button_large" onclick="assistedLogin(FB); return false;">
<span class="fb_button_text">Login with Facebook</span>
</a>
<div id="rpx-signin">
<a class="rpxnow" onclick="return false;" href="">More ways to login</a>
</div> </div>
</div>
</form>
</div>
<div id="alerts">
<noscript>
<div id="alert-javascript-container">
<div id="alert-javascript-title">
Missing JavaScript support
</div>
<div id="alert-javascript-text">
Javascript is disabled on your browser. Please enable JavaScript or upgrade to a Javascript-capable browser to use Habbo :)
</div>
</div>
</noscript>
<div id="alert-cookies-container" style="display:none">
<div id="alert-cookies-title">
Missing cookie support
</div>
<div id="alert-cookies-text">
Cookies are disabled on your browser. Please enable cookies to use Habbo.
</div>
</div>
<script type="text/javascript">
document.cookie = "habbotestcookie=supported";
var cookiesEnabled = document.cookie.indexOf("habbotestcookie") != -1;
if (cookiesEnabled) {
var date = new Date();
date.setTime(date.getTime()-24*60*60*1000);
document.cookie="habbotestcookie=supported; expires="+date.toGMTString();
} else {
if (window.habboPageInitQueue) {
// jquery might not be loaded yet
habboPageInitQueue.push(function() {
$('#alert-cookies-container').show();
});
} else {
$('alert-cookies-container').show();
}
}
</script>
</div>
<div id="top-bar-triangle"></div>
<div id="top-bar-triangle-border"></div>
</header>
<div id="content">
<ul>
<li id="home-anchor">
<div id="welcome">
<a href="#registration" class="button large" id="join-now-button"><b></b><span>Join today</span><span class="sub">(It's free)</span></a>
<div id="slogan">
<h1>Welcome to %shortname%,</h1>
<p>a strange place with awesome people. </p>
<p><a id="tell-me-more-link" href="#">Tell me more...</a></p>
</div>
</div>
<div id="carousel">
<div id="image1"></div>
<div id="image2"></div>
<div id="image3"></div>
<div id="tell-me-more">%shortname% Hotel is a virtual world for players to get together and have some fun! We are currently in beta so that when we officially release we will be stable and hopefully bug free: D
</div>
<div id="floaters"></div>
<li id="registration-anchor">
<div id="registration-form">
<div id="registration-form-header">
<h2>User ID</h2>
<p>Fill in these details to begin:</p>
</div>
<div id="registration-form-main">
<form action="register_submit" method="post">
<div id="registration-form-main-left">
<div class="field field-habbo-name">
<label for="habbo-name"><b>Name</b></label>
<input type="text" id="habbo-name" size="32" value="" name="bean.avatarName" class="text-field" maxlength="32"/>
</div>
<div class="field field-password">
<label for="password"><b>Password</b></label>
<input type="password" id="password" size="35" name="bean.password" value="" class="password-field" maxlength="32"/>
</div>
<label for="password2"><b>Retype Password</b></label>
<input type="password" id="password2" size="35" name="bean.retypedPassword" value="" class="password-field" maxlength="32"/>
<label for="email"><b>Email</b></label>
<input type="text" id="email" size="35" name="bean.email" value="" class="text-field" maxlength="48"/>
</div>
<div id="registration-form-main-right">
<div id="captcha-container">
<label for="recaptcha_response_field">Captcha</label>
<label for="recaptcha_response_field" class="details">Type in the two words (separated with a space):</label>
<script type="text/javascript"
src="http://www.google.com/recaptcha/api/challenge?k=6LfI2t0SAAAAAE6AjuPdmPrjsZmkNqcfljusRpmc">
</script>
<script>
habboPageInitQueue.push(function() {
RecaptchaUtil.showRecaptcha("captcha-container", "6LfI2t0SAAAAAE6AjuPdmPrjsZmkNqcfljusRpmc")
});
</script>
<div id="captcha-image-container">
<div id="recaptcha_image"></div>
<div id="captcha-overlay"></div>
</div>
<p id="captcha-new" class="details"><a class="recaptcha-reload" href="#">Try new code</a></p>
<input type="text" name="recaptcha_response_field" id="recaptcha_response_field">
</div>
<p class="checkbox-container" id="registration-tos">
<input id="tos" value="accept" type="checkbox" id="password" name="bean.tos" %post-tos-check%/></a>
<label for="tos" class="details checkbox">
I accept the <a href="http://help.habbo.com/entries/23096348-Terms-of-Service-and-Privacy-Policy" target="_blank" onclick="window.open('http://help.habbo.com/entries/23096348-Terms-of-Service-and-Privacy-Policy'); return false;">Terms Of Service</a> and Privacy Policy
</label>
</p></br>
<input type="submit" class="new-button" id="next" value="Create account" />
</div>
</div>
</form>
</div>
</div>
</li><div id="magnifying-glass"></div>
<div id="sail"></div>
</li>
</ul>
</div>
<footer>
<div id="age-recommendation"></div>
<script src="%www%/web-gallery/static/js/v3_landing_bottom.js" type="text/javascript"></script>
<!--[if IE]><script src="%www%/web-gallery/static/js/v3_ie_fixes.js" type="text/javascript"></script>
<![endif]-->
</body>
</html>
Re: Duplicate entry 'xx'' for key 'PRIMARY'
this has been fixed, still unsure on the json
