View Full Version : Database error.
Stanyer
04-11-2008, 10:19 AM
I get this error:
Database Error Database error
The Forum database has encountered a problem.
Please try the following:
* Load the page again by clicking the Refresh button in your web browser.
* Open the www.servermysql.x10hosting.com home page, then try to open another page.
* Click the Back button to try another link.
The www.servermysql.x10hosting.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
We apologise for any inconvenience.
However all the other vbulletin pages work fine.
Brian
04-11-2008, 10:51 AM
Can you view the source of the page and post that here?
Also, please edit your CMPS license and add a valid URL.
Stanyer
04-11-2008, 03:45 PM
1)
<?php
// ++=========================================================================++
// || vBadvanced CMPS v3.0.0 (vB 3.6 - vB 3.7) - 81231
// || © 2003-2007 vBadvanced.com - All Rights Reserved
// || This file may not be redistributed in whole or significant part.
// || http://vbadvanced.com
// || Downloaded 08:05, Fri Apr 11th 2008
// || 879081231_401936019124
// ++ ========================================================================++
error_reporting(E_ALL & ~E_NOTICE);
define('THIS_SCRIPT', 'adv_index');
define('VBA_PORTAL', true);
define('VBA_SCRIPT', 'CMPS');
// ============================================
// Enter the full path to your forum here
// Example: /home/vbadvanced/public_html/forum
// ============================================
$forumpath = '/home/myserver/public_html/forum';
// ============================================
// No Further Editing Necessary!
// ============================================
if ($forumpath)
{
if (!is_dir($forumpath))
{
echo 'Invalid forum path specified! Please edit this file and be sure to include the correct path for your $forumpath variable.';
exit;
}
chdir($forumpath);
}
$phrasegroups = array();
$globaltemplates = array();
$actiontemplates = array();
$specialtemplates = array();
require_once('./includes/vba_cmps_include_template.php');
require_once('./global.php');
print_portal_output($home);
?>
2) Sure, how'd i do that?
Brian
04-11-2008, 05:18 PM
1). I meant for you to right click on the page where you receive the database error when viewing it in your browser, select "View Source", and then post the source code from that here. That will allow you to see the entire error message with more details.
2). Click the Members' Area link at the top of any page, then the "Edit License Details" link next to your license.
Stanyer
04-13-2008, 09:07 AM
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>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="http://www.servermysql.x10hosting.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 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.servermysql.x10hosting.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.servermysql.x10hosting.com forum technical staff have been notified of the error, though you may <a href="mailto:unknown@unknown.com">contact them</a> if the problem persists.</td>
</tr>
<tr>
<td class="bodytext" colspan="2"> <br />We apologise for any inconvenience.</td>
</tr>
</table>
<!--
Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_adv_portal AS phrasegroup_adv_portal,
language.phrasegroup_calendar AS phrasegroup_calendar,
language.phrasegroup_postbit AS phrasegroup_postbit,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM forum_user AS user
LEFT JOIN forum_userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN forum_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN forum_language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
WHERE user.userid = 1;
MySQL Error : Unknown column 'language.phrasegroup_adv_portal' in 'field list'
Error Number : 1054
Date : Sunday, April 13th 2008 @ 09:06:52 AM
Script : http://www.servermysql.x10hosting.com/index.php
Referrer :
IP Address : 82.25.128.238
Username :
Classname : vB_Database
-->
</body>
</html>
Also none of the admin pages work (return the same error).
Stanyer
04-14-2008, 08:53 AM
Still needs fixing -.-
Brian
04-14-2008, 09:54 AM
Your URL in the Members' Area here still needs to be updated.
Stanyer
04-14-2008, 09:56 AM
Alright done that, now any idea about my problem?
Stanyer
04-14-2008, 10:08 AM
Brian please help!
Stanyer
04-14-2008, 10:57 AM
Sorry i thought you were leaving this thread, i'll bring this back up to the top seeing as the other thread is locked, thanks.
Brian
04-14-2008, 11:00 AM
Also see our forum rules (http://www.vbadvanced.com/forum/announcement.php?f=138&a=2) regarding bumping threads.
As for the error you're receiving, you need to follow the instructions in the readme.html file that comes with the download package and run the vbacmps_install.php file.
vBulletin® v3.8.4, Copyright ©2000-2012, Jelsoft Enterprises Ltd.