View Full Version : database error but...
Jesakos
08-01-2007, 07:25 PM
hello.. i dont make any change in my forum.. when i press to see it is ok.. when i login.. i saw database error and i dont make anywhere any change.. what is the problem.. i must fix it.. :(
i it upgrade to 3.6.8...
My site:
www.secfreaks.gr
Pc 1203
08-01-2007, 07:29 PM
Right click and view the source. Then post it here and we'll help you.
- Pc1203
Jesakos
08-01-2007, 07:37 PM
this is my source code.. :o
on txt file
Pc 1203
08-01-2007, 07:39 PM
From the source code i do not find any error. When I say source code, I mean of the database error page.
- Pc1203
Jesakos
08-01-2007, 07:42 PM
this is the source of my database error
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>Secfreaks.gr 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://secfreaks.gr/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 Secfreaks.gr 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.secfreaks.gr</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.secfreaks.gr forum technical staff have been notified of the error, though you may <a href="mailto:dbmaster@example.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_calendar AS phrasegroup_calendar,
language.phrasegroup_adv_portal AS phrasegroup_adv_portal,
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 user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 8, user.languageid))
WHERE user.userid = 1;
MySQL Error : Table 'gwgrirc_firewall.userfield' doesn't exist
Error Number : 1146
Date : Wednesday, August 1st 2007 @ 08:41:40 PM
Script : http://www.secfreaks.gr/
Referrer : http://secfreaks.gr/login.php?do=login
IP Address : 85.72.65.80
Username :
Classname : vb_database
-->
</body>
</html>
Pc 1203
08-01-2007, 07:47 PM
MySQL Error : Table 'gwgrirc_firewall.userfield' doesn't existDid you upgrade correctly? Also I don't know whats the problem. Sorry
- Pc1203
Jesakos
08-01-2007, 08:23 PM
ok i am gonna reupload again and i see if i have the problem.. thanks..
Opserty
08-01-2007, 08:32 PM
http://www.secfreaks.gr/sm-keygen.php
I hope you have a valid license for 3.6.8
Jesakos
08-01-2007, 08:38 PM
i have original licence this is from older season when i have nulled .. now i have owned licence .. i buy it..
cheat-master30
08-01-2007, 08:43 PM
I hope you have a valid license for 3.6.8
He couldn't post in this forum if he didn't have a valid license, as the General vBulletin Discussion and the others in this section are only open for valid license holders.
Opserty
08-01-2007, 08:44 PM
Did you run the "/install/upgrade.php" file the first time you updated the files from the previous version to 3.6.8.
Because that error means either the table prefix is wrong or the table hasn't been created to begin with.
Edit:
He couldn't post in this forum if he didn't have a valid license, as the General vBulletin Discussion and the others in this section are only open for valid license holders.
Yes I know I realsed that after, just to lazy to edit :P
Jesakos
08-01-2007, 08:47 PM
yes i run the... path// /install/upgrade.php and i make the upgrade successfully but.. next day the problem.. or i didnt saw it before.. :o
i fix it thnks for help
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.