Tweet
When I go to my URL for my forum all I get is a page that says database error. How can I resolve this issue?
-
-
We need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
-
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>The Fellas Forum 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 The Fellas Forum 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.thefellasforum.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.thefellasforum.com forum technical staff have been notified of the error, though you may <a href="Comment
-
You missed the important bit still, but as your forum url is listed, I took a look ;
You seem to have lost a table from the database, that's pretty bad news - it will need restoring from a backup.<!--
Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT title, template
FROM template
WHERE templateid IN (481,133,482,135,136,137,483,139,141,142,143,144,145,140,1689,489,382,240,484,207,377,380, 389,226,227,228,229,340,394,393,395,398,1691,1690,1616,1642,1643,1644,1695,1698,1699,1700, 1701,1702,1703,1704,1705,1706,1707,1708,1711,1709,1710,1712,1713);
MySQL Error : Table 'fellas.template' doesn't exist
Error Number : 1146
Date : Sunday, September 9th 2007 @ 04:33:28 PM
Script : http://www.thefellasforum.com/
Referrer : http://www.vbulletin.com/forum/showthread.php?t=242492
IP Address : 82.x.x.x
Username : Unregistered
Classname : vb_database
-->Baby, I was born this wayComment
-
Where can I get a back up? How do I just lose a table?
I used to have a tech guy that took care of all these issues but he quit on me about 6 months ago and this is the first problem I have had. Your help is very appreciated.Comment
-
Actually, it's pretty hard to lose a table in mysql (unless it's dropped deliberately).
You get the backup from the backups you make. If you haven't made any then you are a bit stuffed (and now you know why you should make backups).
Your host may have one if you are lucky - otherwise you are going to need a bit of help from someone techincal to recreate your template table and re-import the default style. Any style customisations will have been lost if you end up on this route.Baby, I was born this wayComment
-
Well let's hope my hosting service has one. Otherwise I am toast.Comment
-
Alright, is there anyone we can hire to get in our database and fix it for us? PM or post here.Comment
-
Run the following query in phpMyAdmin or ask your hosting provider to run it:
CREATE TABLE template (
templateid INT UNSIGNED NOT NULL AUTO_INCREMENT,
styleid SMALLINT NOT NULL DEFAULT '0',
title VARCHAR(100) NOT NULL DEFAULT '',
template MEDIUMTEXT,
template_un MEDIUMTEXT,
templatetype ENUM('template','stylevar','css','replacement') NOT NULL DEFAULT 'template',
dateline INT UNSIGNED NOT NULL DEFAULT '0',
username VARCHAR(100) NOT NULL DEFAULT '',
version VARCHAR(30) NOT NULL DEFAULT '',
product VARCHAR(25) NOT NULL DEFAULT '',
PRIMARY KEY (templateid),
UNIQUE KEY title (title, styleid, templatetype)
);
Then upload tools.php from the "do not upload" folder into your AdminCP directory and use it to reimport your vbulletin-style.xml file. When done delete tools.php from your server.Translations provided by Google.
Wayne Luke
The Rabid Badger - a vBulletin Cloud demonstration site.
vBulletin 5 APIComment
-
i have no clue how to do any of the stuff you mentioned. i used to have a tech guy but he is no longer available to help.
i ran the query and go this:
Your SQL query has been executed successfully (Query took 0.2387 sec) SQL query: CREATE TABLE template(templateid INT UNSIGNED NOT NULL AUTO_INCREMENT ,
styleid SMALLINT NOT NULL DEFAULT '0',
title VARCHAR( 100 ) NOT NULL DEFAULT '',
template MEDIUMTEXT,
template_un MEDIUMTEXT,
templatetype ENUM( 'template', 'stylevar', 'css', 'replacement' ) NOT NULL DEFAULT 'template',
dateline INT UNSIGNED NOT NULL DEFAULT '0',
username VARCHAR( 100 ) NOT NULL DEFAULT '',
version VARCHAR( 30 ) NOT NULL DEFAULT '',
product VARCHAR( 25 ) NOT NULL DEFAULT '',
PRIMARY KEY ( templateid ) ,
UNIQUE KEY title( title, styleid, templatetype )
);
[ Edit ] [ Create PHP Code ]
hopefully that is what i was supposed to get... i do not understand the rest of what you said tho. is there someone i can hire to do this for me?
Comment
-
You don't have to hire anyone, start a support ticket with the proper login information and we can cotninue to help you troubleshoot this.Comment
-
i tried to do a ticket but i do not have my customer number. not sure i can get it either. my tech guy had the info and he will not speak to me.
i am lucky i knew enough to log in here. i did however click the "do not know customer number" field and entered info...
i will do whatever i need to to get back up and running, please help.Comment
-
If you do not have access to the Members Area then you are not the owner of this license. Unfortunately only the license owner can open tickets.
What exactly is your current problem and question? It's not clear to me.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
steve the problem is the site www.thefellasforum.com which i am the owner of the domain and the hosting is down.
it is some database issued which has been referenced in this thread that needs to be repaired. i used to employ someone who did everything from setting up the forum to fixing stuff like this. he is no longer available to me along with all of the info for vbulletin.
i need to figure out how to get someone's help getting my site back up. whether it means buying a whole new license or hiring someone i will do whatever needs to be done.
so in summary the problem is my site is down due to some issue with the database which i have no clue how to fix cos i am the least technical guy you will ever meet.Comment
-
What is the current status of this after running the query Wayne provided? I can't imagine you could be getting the same error after that.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
Comment