PDA

View Full Version : Admin Homepage Messed Up



itsIAN
Sun 20th Apr '08, 12:11pm
Hi,

I've just upgraded to vBulletin 7.0 RC 3, and followed all of the steps, etc. I then was taken to the admin homepage, to turn my forums back on, but the admin homepage won't display. I keep getting:

Database error
Database error in vBulletin 3.7.0 Release Candidate 3:

Invalid SQL:

SELECT COUNT(*) AS count
FROM moderation AS moderation
INNER JOIN post AS post USING (postid)
WHERE moderation.type='reply';

MySQL Error : Unknown column 'midnigi5_forums.moderation.postid' in 'on clause'
Error Number : 1054
Date : Sunday, April 20th 2008 @ 11:10:29 AM
Script : http://midnightneoforums.com/admincp/index.php?do=home
Referrer : http://midnightneoforums.com/admincp/index.php?do=nav
IP Address : ---------
Username : itsIAN
Classname : vb_database
MySQL Version : 4.1.22-standard


Anyone know why it's doing this?

Jose Amaral Rego
Sun 20th Apr '08, 12:20pm
Follow instruction to the letter...
http://www.vbulletin.com/forum/showpost.php?p=1542237&postcount=2

itsIAN
Sun 20th Apr '08, 2:43pm
I'm not having trouble connecting to the database, it's just that when I login into my admincp, the front page has a database error.

Should I still do what you said, or not?

Jose Amaral Rego
Sun 20th Apr '08, 3:01pm
You can wait for 'Offical Responce' from the staff here...

You can just try this to see if you have any files that do not belong or have not been overwritten from an upgrade.
Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

[Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

That error is maybe from a corrupt file on servers host side in folder admincp/

itsIAN
Sun 20th Apr '08, 3:05pm
I ran the test, and it came up with quite a few files. And yes, it does have the admin one listed. (for it's index)

index.php File version mismatch: found 3.6.9, expected 3.7.0 Release Candidate 3

So, what do I do to fix this?

Steve Machol
Sun 20th Apr '08, 3:06pm
That means you did not upload all the 3.7.0 RC3 files. Upload those and overwrite the ones on the server.

Jose Amaral Rego
Sun 20th Apr '08, 3:07pm
Upload admincp folder files again in ASCII mode to overwrite older version and it should fix this issue of yours.


I see that 'Official Response' member is now taken this thread.

Time to slip away. :)

itsIAN
Sun 20th Apr '08, 3:08pm
What is ASCII mode, sorry?

itsIAN
Sun 20th Apr '08, 3:09pm
That means you did not upload all the 3.7.0 RC3 files. Upload those and overwrite the ones on the server.

I'm pretty sure I did, but I'll try again.

Jose Amaral Rego
Sun 20th Apr '08, 3:10pm
What is ASCII mode, sorry?
That is a mode you can select from your FTP client, but auto mode does just fine.

http://en.wikipedia.org/wiki/File_Transfer_Protocol

itsIAN
Sun 20th Apr '08, 3:12pm
kk. I'm reuploading all of the files, besides the images.

copiertalk
Sun 20th Apr '08, 3:17pm
I was trying to install a modification one day and forgot that I had renamed the admincp to something else. If the admincp has been renamed or it is not reflected in the config.php file would that cause problems?

just an idea.

itsIAN
Sun 20th Apr '08, 3:31pm
Yeah, I know what you mean, I'd have to change it in the config.php file. But the thing is, is that I can get into the admin CP, just the welcome page has a DB error.

Steve Machol
Sun 20th Apr '08, 3:34pm
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.

itsIAN
Sun 20th Apr '08, 4:01pm
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.

Sorry for the late response. I just finished reuploading all of the files, except for images and the install.php.

Logged in, and yes, still an error page. Here's the source:


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html dir="ltr" lang="en">
<head>
<title>Welcome to the vBulletin Admin Control Panel - Midnightneo Forums - vBulletin Admin Control Panel</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<link rel="stylesheet" type="text/css" href="../cpstyles/vBulletin_3_Manual/controlpanel.css" />
<style type="text/css">
.page { background-color:white; color:black; }
.time { color:silver; }
</style>
<script type="text/javascript">
<!--
var SESSIONHASH = "";
var IMGDIR_MISC = "../cpstyles/vBulletin_3_Manual";
var CLEARGIFURL = "./clear.gif";
function set_cp_title()
{
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown' && typeof(parent.document.title) == 'string')
{
parent.document.title = (document.title != '' ? document.title : 'vBulletin');
}
}
//-->
</script>
<script type="text/javascript" src="../clientscript/yui/yahoo-dom-event.js"></script>
<script type="text/javascript" src="../clientscript/yui/connection.js"></script>
<script type="text/javascript" src="../clientscript/vbulletin_global.js"></script>
</head>
<body style="margin:0px" onload="set_cp_title();">
<div class="pagetitle">Welcome to the vBulletin Admin Control Panel</div>
<div style="margin:10px">
<!-- END CONTROL PANEL HEADER -->

<div id="admin_news" style="display: none;">
<!-- form started:11 queries executed -->
<form action="index.php?do=handlemessage" method="post" name="news" id="news">
<input type="hidden" name="do" value="handlemessage" />
<input type="hidden" name="adminhash" value="e7961759922f60f1b9521d1e9c68faf6" />
<br />
<table cellpadding="4" cellspacing="0" border="0" align="center" width="90%" class="tborder" id="news_table">
</table>
</form>
<!-- form ended: 11 queries executed -->

</div><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>Midnightneo Forums 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://www.midnightneoforums.com/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 Midnightneo Forums 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="/">midnightneoforums.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 midnightneoforums.com forum technical staff have been notified of the error, though you may <a href="mailto:support@midnightneo.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 Release Candidate 3:

Invalid SQL:

SELECT COUNT(*) AS count
FROM moderation AS moderation
INNER JOIN post AS post USING (postid)
WHERE moderation.type='reply';

MySQL Error : Unknown column 'midnigi5_forums.moderation.postid' in 'on clause'
Error Number : 1054
Date : Sunday, April 20th 2008 @ 03:01:25 PM
Script : http://midnightneoforums.com/admincp/index.php?do=home
Referrer :
IP Address :
Username : itsIAN
Classname : vb_database</textarea></form>
</body>
</html>

itsIAN
Sun 20th Apr '08, 4:10pm
Also, I just checked in my admin panel, and at the top, it still says 3.6.9. Shouldn't it say 3.7?

itsIAN
Sun 20th Apr '08, 4:16pm
Okay, I've decided that I'm just going to reupload everything. I think it's safer.

itsIAN
Sun 20th Apr '08, 4:51pm
Problem fixed. I ended up having to delete all of the files, and then reuploading them all.

Thanks for the help everyone. :)

Possemaster
Wed 7th May '08, 6:03am
I go to User CP as admin.

and a lot of function go to a blank page. like 5 functions.
example social group messages (http://www.console-forums.net/moderation.php?do=viewgms&type=moderated) gives a blank page.

and especially the moderated (posts, treads and stuff give an error)

like this one


Database error in vBulletin 3.7.0:
Invalid SQL:
SELECT COUNT(*) AS posts

FROM moderation AS moderation
INNER JOIN post AS post ON (moderation.postid = post.postid)

INNER JOIN thread AS thread ON (post.threadid = thread.threadid)
WHERE type = 'reply'
AND forumid IN (3, 8, 9, 10, 11, 80, 22, 24, 25, 26, 27, 28, 29, 19, 30, 31, 32, 33, 34, 35, 21, 36, 62, 63, 64, 65, 66, 20, 37, 67, 68, 76, 69, 70, 23, 38, 71, 72, 73, 74, 75, 12, 13, 14, 15, 16, 17, 18, 39, 40, 43, 46, 7, 77, 6, 79);
MySQL Error : Unknown column 'moderation.postid' in 'on clause'
Error Number : 1054
Request Date : Wednesday, May 7th 2008 @ 04:55:18 AM
Error Date : Wednesday, May 7th 2008 @ 04:55:18 AM
Script : http://www.console-forums.net/moderation.php?do=viewposts&type=moderated
Referrer : http://www.console-forums.net/usercp.php
IP Address : 217.136.238.232
Username : admin
Classname : vB_Database
MySQL Version : 5.0.45-community-log


what do i do , my users are getting on my nerves. I gotta fix this because networking contacts and stuff does not work.

please help

Steve Machol
Wed 7th May '08, 10:50am
Please start your own thread with all the relevant details. Thank you.