Tweet
Help - Creating access table error
Hi
I have been trying to install my forum and i get the good old:
here is the source code
I have done everything right but i don't know what else to do. Any help will be appreciated.
Cheers
Diego
I have been trying to install my forum and i get the good old:
Step 3) Creating Tables (Step 3 of 13)
Step 3) Creating Tables
Creating access table
*
There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.
An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
We apologise for any inconvenience.
Step 3) Creating Tables
Creating access table
*
There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.
An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
We apologise for any inconvenience.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>vBulletin 3.0 Install Script Step 3) Creating Tables</title>
<link rel="stylesheet" href="../cpstyles/vBulletin_3_Default/controlpanel.css" />
<style type="text/css">
#all {
margin: 10px;
}
#all p, #all td, #all li, #all div {
font-size: 11px;
font-family: verdana, arial, helvetica, sans-serif;
}
</style>
</head>
<body style="margin:0px">
<table cellpadding="4" cellspacing="0" border="0" width="100%" class="navbody" style="border
utset 2px">
<tr>
<td width="160"><img src="../cpstyles/vBulletin_3_Default/cp_logo.gif" alt="" title="vBulletin 3 ©2000 - 2004 Jelsoft Enterprises Ltd." /></td>
<td style="padding-left:100px">
<b>vBulletin 3.0 Install Script</b><br />
(Please be patient as some parts may take some time)<br />
<br />
<b style="font-size:10pt;">Step 3) Creating Tables</b> (Step 3 of 13)</td>
</tr>
</table>
<div id="all">
<p style="font-size:10pt;"><b><u>Step 3) Creating Tables</u></b></p>
<ul><li>Creating access table</li>
<!--
CREATE TABLE access (
userid INT UNSIGNED NOT NULL DEFAULT '0',
forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY userid (userid, forumid)
)
-->
<html><head><title> Database Error</title><style type="text/css"><!--.error { font: 11px tahoma, verdana, arial, sans-serif; }--></style></head>
<body></table></td></tr></table></form>
<blockquote><p class="error"> </p><p class="error"><b>There seems to have been a slight problem with the database.</b><br />
Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</a> button in your browser.</p><p class="error">An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p class="error">We apologise for any inconvenience.</p></blockquote>
<!--
Database error in vBulletin :
Invalid SQL:
CREATE TABLE access (
userid INT UNSIGNED NOT NULL DEFAULT '0',
forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY userid (userid, forumid)
)
mysql error: Table 'access' already exists
mysql error number: 1050
Date: Sunday 03rd of April 2005 09:07:59 PM
Script: http://mbcbabes.com/forum/install/install.php?step=3
Referer: http://mbcbabes.com/forum/install/install.php?step=2
IP Address: 210.23.136.233
-->
</body></html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>vBulletin 3.0 Install Script Step 3) Creating Tables</title>
<link rel="stylesheet" href="../cpstyles/vBulletin_3_Default/controlpanel.css" />
<style type="text/css">
#all {
margin: 10px;
}
#all p, #all td, #all li, #all div {
font-size: 11px;
font-family: verdana, arial, helvetica, sans-serif;
}
</style>
</head>
<body style="margin:0px">
<table cellpadding="4" cellspacing="0" border="0" width="100%" class="navbody" style="border
utset 2px"><tr>
<td width="160"><img src="../cpstyles/vBulletin_3_Default/cp_logo.gif" alt="" title="vBulletin 3 ©2000 - 2004 Jelsoft Enterprises Ltd." /></td>
<td style="padding-left:100px">
<b>vBulletin 3.0 Install Script</b><br />
(Please be patient as some parts may take some time)<br />
<br />
<b style="font-size:10pt;">Step 3) Creating Tables</b> (Step 3 of 13)</td>
</tr>
</table>
<div id="all">
<p style="font-size:10pt;"><b><u>Step 3) Creating Tables</u></b></p>
<ul><li>Creating access table</li>
<!--
CREATE TABLE access (
userid INT UNSIGNED NOT NULL DEFAULT '0',
forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY userid (userid, forumid)
)
-->
<html><head><title> Database Error</title><style type="text/css"><!--.error { font: 11px tahoma, verdana, arial, sans-serif; }--></style></head>
<body></table></td></tr></table></form>
<blockquote><p class="error"> </p><p class="error"><b>There seems to have been a slight problem with the database.</b><br />
Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</a> button in your browser.</p><p class="error">An E-Mail has been dispatched to our <a href="mailto:[email protected]">Technical Staff</a>, who you can also contact if the problem persists.</p><p class="error">We apologise for any inconvenience.</p></blockquote>
<!--
Database error in vBulletin :
Invalid SQL:
CREATE TABLE access (
userid INT UNSIGNED NOT NULL DEFAULT '0',
forumid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
accessmask SMALLINT UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY userid (userid, forumid)
)
mysql error: Table 'access' already exists
mysql error number: 1050
Date: Sunday 03rd of April 2005 09:07:59 PM
Script: http://mbcbabes.com/forum/install/install.php?step=3
Referer: http://mbcbabes.com/forum/install/install.php?step=2
IP Address: 210.23.136.233
-->
</body></html>
I have done everything right but i don't know what else to do. Any help will be appreciated.
Cheers
Diego
Comment