Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 05-21-2008, 10:45 PM
-=Leb=-'s Avatar
-=Leb=- -=Leb=- is offline
 
Join Date: Jan 2008
Location: Sweden
Posts: 353
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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, 0 views)
Reply With Quote
  #2  
Old 05-21-2008, 10:46 PM
ssslippy ssslippy is offline
 
Join Date: Jan 2006
Posts: 877
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You should be getting an email with what the error is.
Reply With Quote
  #3  
Old 05-21-2008, 10:48 PM
-=Leb=-'s Avatar
-=Leb=- -=Leb=- is offline
 
Join Date: Jan 2008
Location: Sweden
Posts: 353
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No, never got any email
Reply With Quote
  #4  
Old 05-21-2008, 11:24 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You need to right click on the database error page and view the source, in that you will find the real sql error.
Reply With Quote
  #5  
Old 05-21-2008, 11:53 PM
-=Leb=-'s Avatar
-=Leb=- -=Leb=- is offline
 
Join Date: Jan 2008
Location: Sweden
Posts: 353
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 [DATE]1211420626[/DATE] at [TIME]1211420626[/TIME] ---------------

I turned off the Send Welcome Email and it still doing same thing
Reply With Quote
  #6  
Old 05-22-2008, 01:33 AM
King Kovifor's Avatar
King Kovifor King Kovifor is offline
 
Join Date: Nov 2004
Location: PA
Posts: 3,872
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #7  
Old 05-22-2008, 06:49 AM
-=Leb=-'s Avatar
-=Leb=- -=Leb=- is offline
 
Join Date: Jan 2008
Location: Sweden
Posts: 353
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #8  
Old 05-22-2008, 06:58 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If you turn the Send Welcome Email off does it still error?
Reply With Quote
  #9  
Old 05-22-2008, 07:00 AM
-=Leb=-'s Avatar
-=Leb=- -=Leb=- is offline
 
Join Date: Jan 2008
Location: Sweden
Posts: 353
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

yes i did ,its turned off now

--------------- Added [DATE]1211443541[/DATE] at [TIME]1211443541[/TIME] ---------------

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>
Reply With Quote
  #10  
Old 05-22-2008, 07:08 AM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

emailSend is not a default column in the user table, so this is being caused by a mod you have installed.
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 03:16 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07976 seconds
  • Memory Usage 2,286KB
  • Queries Executed 14 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (1)postbit_attachment
  • (10)postbit_onlinestatus
  • (10)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete