Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 22 May 2008, 00:45
-=Leb=-'s Avatar
-=Leb=- -=Leb=- is offline
 
Join Date: Jan 2008
PLZ Need Help Getting Error

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
Attached Images
File Type: jpg error.jpg (29.2 KB, 26 views)
__________________
For You Who Like To Play CounterStrike Source, Check Our Website At:
FireWaLL Website
Reply With Quote
  #2  
Old 22 May 2008, 00:46
ssslippy's Avatar
ssslippy ssslippy is offline
 
Join Date: Jan 2006
You should be getting an email with what the error is.
__________________
Immortal Guild - My Guilds Website
Reply With Quote
  #3  
Old 22 May 2008, 00:48
-=Leb=-'s Avatar
-=Leb=- -=Leb=- is offline
 
Join Date: Jan 2008
No, never got any email
__________________
For You Who Like To Play CounterStrike Source, Check Our Website At:
FireWaLL Website
Reply With Quote
  #4  
Old 22 May 2008, 01:24
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
You need to right click on the database error page and view the source, in that you will find the real sql error.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #5  
Old 22 May 2008, 01:53
-=Leb=-'s Avatar
-=Leb=- -=Leb=- is offline
 
Join Date: Jan 2008
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/reg...p?do=addmember
Referrer : http://www.firewallcs.net/forums/reg...hp?do=register
IP Address : 213.*********
Username : same
Classname : vb_database
MySQL Version :
-->


</body>
</html>

--------------- Added 22 May 2008 at 02:43 ---------------

I turned off the Send Welcome Email and it still doing same thing
__________________
For You Who Like To Play CounterStrike Source, Check Our Website At:
FireWaLL Website

Last edited by -=Leb=-; 22 May 2008 at 02:43. Reason: Auto-Merged DoublePost
Reply With Quote
  #6  
Old 22 May 2008, 03:33
King Kovifor's Avatar
King Kovifor King Kovifor is offline
 
Join Date: Nov 2004
Real name: Jeremy
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.
__________________
Former vBulletin.org Staff Member

Do not request support through any other means except the forums.

Useful Post With Links on Learning How To Develop vBulletin Plugins

Latest Modification: Stop Forum Spam Integration
Reply With Quote
  #7  
Old 22 May 2008, 08:49
-=Leb=-'s Avatar
-=Leb=- -=Leb=- is offline
 
Join Date: Jan 2008
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
__________________
For You Who Like To Play CounterStrike Source, Check Our Website At:
FireWaLL Website
Reply With Quote
  #8  
Old 22 May 2008, 08:58
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson
If you turn the Send Welcome Email off does it still error?
__________________
Former vBulletin.org Staff Member

View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote
  #9  
Old 22 May 2008, 09:00
-=Leb=-'s Avatar
-=Leb=- -=Leb=- is offline
 
Join Date: Jan 2008
yes i did ,its turned off now

--------------- Added 22 May 2008 at 09:05 ---------------

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/reg...p?do=addmember
Referrer : http://www.firewallcs.net/forums/reg...p?do=addmember
IP Address : 213.************
Username : blob
Classname : vb_database
MySQL Version :
-->


</body>
</html>
__________________
For You Who Like To Play CounterStrike Source, Check Our Website At:
FireWaLL Website

Last edited by -=Leb=-; 22 May 2008 at 09:05. Reason: Auto-Merged DoublePost
Reply With Quote
  #10  
Old 22 May 2008, 09:08
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
emailSend is not a default column in the user table, so this is being caused by a mod you have installed.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #11  
Old 22 May 2008, 09:16
-=Leb=-'s Avatar
-=Leb=- -=Leb=- is offline
 
Join Date: Jan 2008
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
http://www.vbulletin.org/forum/showt...ighlight=email

Is there anyway to fix this error and how?
__________________
For You Who Like To Play CounterStrike Source, Check Our Website At:
FireWaLL Website
Reply With Quote
  #12  
Old 22 May 2008, 09:17
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson
Disable it?
__________________
Former vBulletin.org Staff Member

View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote
  #13  
Old 22 May 2008, 09:25
-=Leb=-'s Avatar
-=Leb=- -=Leb=- is offline
 
Join Date: Jan 2008
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.
__________________
For You Who Like To Play CounterStrike Source, Check Our Website At:
FireWaLL Website
Reply With Quote
  #14  
Old 22 May 2008, 09:37
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson
If the error does not occur, you don't need to do anything...
__________________
Former vBulletin.org Staff Member

View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote
  #15  
Old 22 May 2008, 09:41
-=Leb=-'s Avatar
-=Leb=- -=Leb=- is offline
 
Join Date: Jan 2008
Originally Posted by Dismounted View Post
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
__________________
For You Who Like To Play CounterStrike Source, Check Our Website At:
FireWaLL Website
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 17:53.

Layout Options | Width: Wide Color: