vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   PLZ Need Help Getting Error (https://vborg.vbsupport.ru/showthread.php?t=180081)

-=Leb=- 05-21-2008 10:45 PM

PLZ Need Help Getting Error
 
1 Attachment(s)
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/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 :(

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 [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>

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.


All times are GMT. The time now is 12:10 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01144 seconds
  • Memory Usage 1,749KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete