Go Back   vb.org Archive > Community Discussions > Forum and Server Management
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 11-19-2008, 11:17 PM
The4um's Avatar
The4um The4um is offline
 
Join Date: Nov 2008
Posts: 45
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default DB error when a new user had been registred

The error is shown when the user clicks the submit button to finish the register's process
I use vbulletin 3.7.4 and I updated from 3.6.8
how can I fix this trouble???
anyone can help me?

this is the error message

Code:
<!--
Database error in vBulletin 3.7.4:

Invalid SQL:
UPDATE user SET emailDate = '1227121576' AND emailSend = '1227121576' WHERE userid = '1457';

MySQL Error   : Unknown column 'emailSend' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, November 19th 2008 @ 01:06:03 PM
Error Date    : Wednesday, November 19th 2008 @ 01:06:16 PM
Script        : http://www.****.com/register.php?do=addmember
Referrer      :
IP Address    : *x9.*x9.*x.*x9
Username      : error
Classname     : vB_Database
MySQ
Reply With Quote
  #2  
Old 11-19-2008, 11:24 PM
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Location: Indianapolis
Posts: 2,451
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Disable your plugins one by one to find which one is causing the problem.
Reply With Quote
  #3  
Old 11-20-2008, 04:40 AM
AdrianH AdrianH is offline
 
Join Date: Sep 2007
Posts: 222
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Did you see this ?

http://www.vbulletin.com/forum/showthread.php?t=290128

Quote:
Somehow, a serious, but not destructive bug worked its way into 3.7.4. After modifying a user in the UserCP, you will receive a database error when saving the user. I have updated the affected file, includes/class_dm_user.php, in the 3.7.4 download. If you downloaded 3.7.4 previous to this message, please download it again and replace the file.

I had database errors when trying to update usernames via vB maintenance and in registration ,changing the mentioned file cures the problem.
Reply With Quote
  #4  
Old 11-20-2008, 08:41 PM
The4um's Avatar
The4um The4um is offline
 
Join Date: Nov 2008
Posts: 45
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

yes I did, on vbulletin.com told me that an add-on is causing the error but I don't know wich one could be
finally, I updated my forum to 3.7.4 last week
Reply With Quote
  #5  
Old 11-20-2008, 08:56 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'd venture to guess it is an addon using one of the hooks found in the register.php page.

If you don't want to look those up, then try disabling one product at a time and see if this error goes away.

Another idea is to do a search for "emailSend" ("all forums" "all posts") and see if a Modification comes up or another thread about this comes up. Perhaps if a Modification comes up in the results, then it is one you have installed and it's the problem.
Reply With Quote
  #6  
Old 11-20-2008, 09:25 PM
The4um's Avatar
The4um The4um is offline
 
Join Date: Nov 2008
Posts: 45
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'd searched into the DB and I found some 'stuffs ' with "emailSend" but I'm afraid to delete it but I dont know if those stuffs could my db crash
Reply With Quote
  #7  
Old 11-20-2008, 09:39 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Then don't search the database. Do it using one of the methods I suggested.
Reply With Quote
  #8  
Old 11-20-2008, 10:02 PM
The4um's Avatar
The4um The4um is offline
 
Join Date: Nov 2008
Posts: 45
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'll try it, thank you
Reply With Quote
  #9  
Old 11-21-2008, 01:30 AM
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Location: Indianapolis
Posts: 2,451
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Do you have the automatically add a friend modification installed?

Turn email confirmation off, then try registering and see if the problem persists.
Reply With Quote
  #10  
Old 11-22-2008, 02:05 AM
The4um's Avatar
The4um The4um is offline
 
Join Date: Nov 2008
Posts: 45
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I don't have that modification installed, but I disabled the Plugin/Hook system and I didn't have any error with register
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 01:33 AM.


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.03948 seconds
  • Memory Usage 2,251KB
  • Queries Executed 11 (?)
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)bbcode_code
  • (1)bbcode_quote
  • (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
  • (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_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_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete