Log in

View Full Version : PLZ Need Help Getting Error

-=Leb=-
05-21-2008, 10:45 PM
Hello gentlemens, if anyone try to register in my forum, they get database error when they click on complete registration for some reason.If you guys could help that will be great :( because i have no clue what to do. Never touched any file inside the forum root.

anyway you can take a look on the screenshot i took.
These products are installed in the forum.

Admin Log In As User

Atakan Marquee Text

Block Anonymous AOL Proxies

Cyb - Advanced Forum Statistics 5.8

Cyb - ChatBox 2.0

Cyb - PayPal Donate 4.5

Cyb - PM System Enhancements 1.5

Cyb - Thread Listing Make-Up 1.2

DMeNTED's RBL Checker 4.1

Footer Links 1.0.1

GTPrivate Message Quickreply 3.7.0.1

Guest Tracking 3.7.003

Icons for UserCP 1.2

Imageshack Image Upload 3.1.0 T

Inactive User Reminder Emails 1.1.2

IpInfo 1.5

Members who have Posted 3.7.002

Members who have Visited 3.7.003

Mini Navbar 1.0.4

Most ever Members & Guests 3.7.001

Multiple Account Registration Prevention 1.0.2

Multiple Login Detector 1.03

Photobucket Image Upload 2.0

Quick Reply and Quick Edit to Full Reply and Edit 1.5

Search For Unanswered Threads By Forum 3.7.003 T

Seperate Forum Categories 1.0.1

UserCP Navbar Menu 1.0.0

Usergroup Color Bar 1.0.0

View Forum Leaders Based On Usergroup Permissions 3.7.002

Who Has Read a Thread. 3.7.006 D

ZH - No Avatar 1.0.0

ZH - Sticky Thread Mark-Up
ssslippy
05-21-2008, 10:46 PM
You should be getting an email with what the error is.
-=Leb=-
05-21-2008, 10:48 PM
No, never got any email
Paul M
05-21-2008, 11:24 PM
You need to right click on the database error page and view the source, in that you will find the real sql error.
-=Leb=-
05-21-2008, 11:53 PM
Here is the code
I hope you are talking about this?
If i'm right the error i get from the Send Welcome Email in user registration options
but i have no idea how to fix it .Do you think its better if i turn the welcome email off?
BTW i have the default text in it.

<!--
Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE user SET emailDate = '1211416302' AND emailSend = '1211416302' WHERE userid = '100';

MySQL Error : Unknown column 'emailSend' in 'field list'
Error Number : 1054
Request Date : Wednesday, May 21st 2008 @ 08:31:26 PM
Error Date : Wednesday, May 21st 2008 @ 08:31:44 PM
Script : http://www.firewallcs.net/forums/register.php?do=addmember
Referrer : http://www.firewallcs.net/forums/register.php?do=register
IP Address : 213.*********
Username : same
Classname : vb_database
MySQL Version :
-->


</body>
</html>

--------------- Added 1211420626 at 1211420626 ---------------

I turned off the Send Welcome Email and it still doing same thing :(
King Kovifor
05-22-2008, 01:33 AM
emailSend isn't found in your database. You could add it or find and modify the query that is adding it. Also, if you would like to see these db errors in an email, make sure your current email address is listed as the technical email in the config.php file.
-=Leb=-
05-22-2008, 06:49 AM
I'm sorry, i didn't get it .Where and how do you add the email address in my database?
I have been running my webside since december 2007, never had this problem before, and what about the config.php my email address is already in it
Dismounted
05-22-2008, 06:58 AM
If you turn the Send Welcome Email off does it still error?
-=Leb=-
05-22-2008, 07:00 AM
yes i did ,its turned off now

--------------- Added 1211443541 at 1211443541 ---------------

ok here is the whole sourcecode


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>FireWaLL 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.firewallcs.net/forums/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 FireWaLL 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="/">www.firewallcs.net</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.firewallcs.net forum technical staff have been notified of the error, though you may <a href="mailto:my email address">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>


<!--
Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE user SET emailDate = '1211441635' AND emailSend = '1211441635' WHERE userid = '107';

MySQL Error : Unknown column 'emailSend' in 'field list'
Error Number : 1054
Request Date : Thursday, May 22nd 2008 @ 03:33:54 AM
Error Date : Thursday, May 22nd 2008 @ 03:33:55 AM
Script : http://www.firewallcs.net/forums/register.php?do=addmember
Referrer : http://www.firewallcs.net/forums/register.php?do=addmember
IP Address : 213.************
Username : blob
Classname : vb_database
MySQL Version :
-->


</body>
</html>
Paul M
05-22-2008, 07:08 AM
emailSend is not a default column in the user table, so this is being caused by a mod you have installed.
-=Leb=-
05-22-2008, 07:16 AM
Yea, i'm suspecting this mod i installed before.
I got error after when i installed this
and i uninstalled right after.

Save Users' E-mail Addresses for vB3.7
https://vborg.vbsupport.ru/showthread.php?t=169235&highlight=email

Is there anyway to fix this error and how?
Dismounted
05-22-2008, 07:17 AM
Disable it?
-=Leb=-
05-22-2008, 07:25 AM
I uninstalled this mod right after i got the error on user emails.I'm wondering about re'adding back the default column .If i could get the default column from you guys and explain for me where to add it.
Dismounted
05-22-2008, 07:37 AM
If the error does not occur, you don't need to do anything...
-=Leb=-
05-22-2008, 07:41 AM
If the error does not occur, you don't need to do anything...

It does because all new members when they register they get confused and never confim their email address because of this error.
What a bad luck :(
Marco van Herwaarden
05-22-2008, 08:59 AM
To troubleshoot this, please remove any hacks and disable your plugins, then see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.
-=Leb=-
05-22-2008, 09:23 AM
rgr that will do. Thank you sir <3

--------------- Added 1211460445 at 1211460445 ---------------

The problem is fixed. It was from Email reminder for inactive users , and i already reported the bug and he updated the pluging.
https://vborg.vbsupport.ru/showthread.php?t=180025

Thank you guys, i really appreciate your help <3