View Single Post
  #1  
Old 06-18-2008, 09:39 AM
lucybb lucybb is offline
 
Join Date: Oct 2005
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default SQL error when sending out user password

I just installed a copy of vBulletin 3.7.1 Patch Level 1 on a brand new server running PHP Version 5.1.6 and mysql Client API version 5.0.45. Nothing funny has been installed on this server and all configuration settings are unchanged so should be at the defaults.

Vbulletin appears to be working fine apart from one thing.

When I go to send a user their password from the admin, vbuletin chugs along as if it is trying to do something for a minute or two and then displays the following database error:

Quote:
Database error in vBulletin 3.7.1:

Invalid SQL:

SELECT text, languageid, special
FROM phrase AS phrase
LEFT JOIN phrasetype USING (fieldname)
WHERE phrase.fieldname = 'frontredirect'
AND varname = 'lostpw' AND languageid IN (-1, 0, 1);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, June 18th 2008 @ 12:07:49 AM
Error Date : Wednesday, June 18th 2008 @ 12:08:19 AM
Script : http://www.test.com/boards/login.php?do=emailpassword
Referrer : http://www.test.com/boards/admincp/u...t5%40yahoo.com
IP Address : 55.55.55.555
Username : Admin
Classname : vB_Database
MySQL Version :
Has anybody got any ideas what could be wrong?

Thanks

Lucy

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

Sorry, I am also getting same error when I try to Email Activation Codes to user.

Thanks
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01279 seconds
  • Memory Usage 1,766KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete