PDA

View Full Version : SQL error when sending out user password


lucybb
18 Jun 2008, 11:39
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:

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/user.php?do=emailpassword&u=2600&email=Test_Test5%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 1213785826 at 1213785826 ---------------

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

Thanks

Marco van Herwaarden
18 Jun 2008, 11:44
Strange that you get this on this query, not a really heavy one. You could try to repair your database tables and maybe edit a (any) phrase and save it to rebuild the phrases.

lucybb
18 Jun 2008, 11:47
Thanks, I fixed prob by using SMTP Email instead and now it works. Sorry, always the way that you spend hours unable to fix something, then when you post for help an idea suddenly comes to you!