PDA

View Full Version : new users cant register help please


d_mind
Mon 6th Nov '06, 1:37pm
I to evry one.
I have Imported a board from phpbb 2.xxx to vb 3.6 evrything have run ok.
Now I have finished I have see that wen some new user try to register I gote this error:

Error The ******** database has encountered a problem.Please try the following:

Load the page again by clicking the Refresh (http://www.luxteam.org/fisr2/register.php?do=addmember#) button in your web browser.
Open the ************** home page, then try to open another page.
Click the Back (http://javascript<b></b>:history.back(1)) button to try another link.The ************ forum technical staff have been notified of the error, though you may contact them (d_mind@hotmail.com) if the problem persists.
We apologise for any inconvenience.

The acouts is created but I do not recive any email for activation.
Waht can I do to fix it?
Colin F
Mon 6th Nov '06, 1:39pm
Please rightclick on that error page and select 'View Source'. You'll find the exact error message there.

Please copy that into your reply so that we can troubleshoot the exact problem.
d_mind
Mon 6th Nov '06, 1:57pm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>FISR2 Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<style type="text/css">
<!--
body { background-color: white; color: black; }
#container { width: 400px; }
#message { width: 400px; color: black; background-color: #FFFFCC; }
#bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
.bodytext { font: 8pt/11pt verdana, arial, sans-serif; }
a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
-->
</style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
<td><img src="./image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
<td id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The FISR2 database has encountered a problem.</td>
</tr>
<tr>
<td colspan="2"><hr /></td>
</tr>
<tr>
<td class="bodytext" colspan="2">
Please try the following:
<ul>
<li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
<li>Open the <a href="/">www.lufteam.com</a> home page, then try to open another page.</li>
<li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
</ul>
</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The www.lufteam.com (http://www.lufteam.com) forum technical staff have been notified of the error, though you may <a href="<A href="mailto:d_mind@hotmail.com">contact">mailto:d_mind@hotmail.com">contact them</a> if the problem persists.</td>
</tr>
<tr>
<td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
</tr>
</table>

<!--
Database error in vBulletin 3.6.2:
Invalid SQL:
INSERT INTO vb_userfield
(userid)
VALUES
(1699);
MySQL Error : Duplicate entry '1699' for key 1
Error Number : 1062
Date : Monday, November 6th 2006 @ 12:53:47 PM
Script : http://www.lufteam.com/fisr2/register.php?do=addmember
Referrer : http://www.lufteam.com/fisr2/register.php?do=register
IP Address : 212.233.41.53
Username : teste1
Classname : vb_database
-->

</body>
</html>
Colin F
Mon 6th Nov '06, 2:25pm
That looks as if your database is messed up a bit.
Try going to your
AdminCP -> Maintenance -> Update Counters
and running the 'Fix broken User Profiles' option there.

If that doesn't work, please open a support ticket providing AdminCP and phpMyAdmin login details so that I can manually update your database.