PDA

View Full Version : Error at the line 16099: SHOW CREATE TABLE adminmessage;



dertna
07-25-2008, 01:47 PM
help me for in the error

i used BigDump: Staggered MySQL Dump Importer v0.29b
to upload the database in my vb


Error at the line 16099: SHOW CREATE TABLE adminmessage;

Query: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>dertna Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
<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="http://dertna.com/vb/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 dertna 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="/">dertna.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 dertna.com forum technical staff have been notified of the error, though you may <a href="mailto:mohammad20106@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>
<form><textarea rows="15" cols="70" wrap="off" id="message">Database error in vBulletin 3.7.0:
Invalid SQL:
SHOW CREATE TABLE adminmessage;


MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '

Stopped on error

shadmego
07-25-2008, 02:57 PM
This is just a copy of the error page. There is nothing we can look at here.

To get more information about this error, I would recommend you look at your Error Page in CPanel. Look for any errors related to your issue.

~regards, and welcome to the Community.

dertna
07-26-2008, 05:13 AM
not errors related to my issue

shadmego
07-26-2008, 08:47 AM
The code you pasted in your first post doesn't contain any useful information for us to try and troubleshoot your problem. This code is only that of the error page itself, not the page that is causing the error.

I'm not sure how we can help without more knowledge of what you are trying to do.

~regards

r2b2
07-27-2008, 03:24 PM
SHOW CREATE TABLE adminmessage;

I haven't really done much in MySQL, but I don't think this is a valid SQL command (at least isn't in the SQL databases I use).