teenha
Fri 4th Mar '05, 1:23pm
I am trying to install vBulletin for the first time with Verio. I made it to step 3 where an error occured. I submitted a ticket but have not yet received a response. Anybody have any ideas on how to fix this to complete the install?:
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 (javascript:window.location=window.location;) button in your browser.
An E-Mail has been dispatched to our Technical Staff (brian@teenhabits.com), who you can also contact if the problem persists.
We apologise for any inconvenience.
The full html source is below:
<!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:outset 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="<A href="mailto:brian@teenhabits.com">Technical">mailto:brian@teenhabits.com">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: Friday 04th of March 2005 12:35:50 AM
Script: http://www.teenhabits.com/forum/install/install.php?step=3
Referer:
IP Address: 69.28.166.41
-->
</body></html>
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 (javascript:window.location=window.location;) button in your browser.
An E-Mail has been dispatched to our Technical Staff (brian@teenhabits.com), who you can also contact if the problem persists.
We apologise for any inconvenience.
The full html source is below:
<!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:outset 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="<A href="mailto:brian@teenhabits.com">Technical">mailto:brian@teenhabits.com">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: Friday 04th of March 2005 12:35:50 AM
Script: http://www.teenhabits.com/forum/install/install.php?step=3
Referer:
IP Address: 69.28.166.41
-->
</body></html>