vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   MySQL Error (https://vborg.vbsupport.ru/showthread.php?t=237906)

jbizzle 03-10-2010 12:05 AM
MySQL Error
 
I am getting multiple SQL errors

Code:
MySQL Error  : MySQL server has gone away
Also, these errors.

Code:
Database error in vBulletin 3.8.4:

Invalid SQL:

            UPDATE datastore SET
                data = data - 1,
                data = IF(data < 0, 0, data)
            WHERE title = 'mailqueue';

Code:
Invalid SQL:

                    UPDATE session
                    SET lastactivity = 1268165777, location =
'/forum/admincp/email.php?do=dosendmail&do=dosendmail', inforum = 0, inthread =
0, incalendar = 0, badlocation = 0, useragent = 'Mozilla/5.0 (Windows; U;
Windows NT 6.0; en-US; rv:1.9.0.18) Gecko/2010020220 Firefox/3.0.18 (.NET CLR
3.5.30729)'
                    WHERE sessionhash = '56542e98237a161685411bbfa1c02463';

Code:
Invalid SQL:

            UPDATE datastore SET
                data = data - 1,
                data = IF(data < 0, 0, data)
            WHERE title = 'mailqueue';
I never use to get vBulletin errors...

Lynne 03-10-2010 03:26 AM
You didn't include the necessary part of the error we need to see for the last three you listed (we need to see the bottom portion that is under what you posted). But, the first one,
MySQL server has gone away, is a server issue. See this: http://www.vbulletin.com/docs/html/t...mysql_goneaway and this: http://www.vbulletin.com/forum/showt...265#post310265

jbizzle 03-11-2010 08:11 PM
Here is one of them i'll post the others once I get them

Code:
Database error in vBulletin 3.8.4:

Invalid SQL:

                    UPDATE session
                    SET lastactivity = 1268345339, location =
'/forum/admincp/email.php?do=dosendmail&do=dosendmail', inforum = 0, inthread =
0, incalendar = 0, badlocation = 0
                    WHERE sessionhash = '6eaea1d8673725d867f7f5aa36a14259';

MySQL Error  : MySQL server has gone away
Error Number  : 2006
Request Date  : Thursday, March 11th 2010 @ 04:08:59 PM
Error Date    : Thursday, March 11th 2010 @ 04:09:24 PM
Script        : http://www.mwcaraudio.net/forum/admincp/email.php?do=dosendmail
Referrer      : http://www.mwcaraudio.net/forum/admincp/email.php?do=start
IP Address    : xxxx
Username      : jbizzle
Classname    : vB_Database
MySQL Version :
--------------- Added [DATE]1268345549[/DATE] at [TIME]1268345549[/TIME] ---------------

Quote:
Database error in vBulletin 3.8.4:

Invalid SQL:

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

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Saturday, February 27th 2010 @ 08:28:14 AM
Error Date : Saturday, February 27th 2010 @ 08:28:37 AM
Script : http://mwcaraudio.net/forum/register.php?do=addmember
Referrer : http://mwcaraudio.net/forum/register.php?do=register
IP Address : xxxx
Username : GRMax09
Classname : vB_Database
MySQL Version :
Quote:
Database error in vBulletin 3.8.4:

Invalid SQL:

UPDATE session
SET lastactivity = 1268165777, location =
'/forum/admincp/email.php?do=dosendmail&do=dosendmail', inforum = 0, inthread =
0, incalendar = 0, badlocation = 0, useragent = 'Mozilla/5.0 (Windows; U;
Windows NT 6.0; en-US; rv:1.9.0.18) Gecko/2010020220 Firefox/3.0.18 (.NET CLR
3.5.30729)'
WHERE sessionhash = '56542e98237a161685411bbfa1c02463';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, March 9th 2010 @ 02:16:17 PM
Error Date : Tuesday, March 9th 2010 @ 02:18:07 PM
Script : http://mwcaraudio.net/forum/admincp/...?do=dosendmail
Referrer : http://mwcaraudio.net/forum/admincp/email.php?do=start
IP Address : xxxx
Username : jbizzle
Classname : vB_Database
MySQL Version :
Quote:
Database error in vBulletin 3.8.4:

Invalid SQL:

UPDATE datastore SET
data = data - 1,
data = IF(data < 0, 0, data)
WHERE title = 'mailqueue';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, March 9th 2010 @ 02:20:14 PM
Error Date : Tuesday, March 9th 2010 @ 02:21:02 PM
Script : http://mwcaraudio.net/forum/index.php
Referrer : http://mwcaraudio.net/forum/index.php
IP Address : xxxx
Username : jbizzle
Classname : vB_Database
MySQL Version :
^^^

Lynne 03-12-2010 09:45 PM
This is a server issue. See this: http://www.vbulletin.com/docs/html/t...mysql_goneaway and this: http://www.vbulletin.com/forum/showt...265#post310265

jbizzle 03-13-2010 08:52 PM
I switched hosts, I am now with a company who specializes in hosting vBulletin forums. Hopefully I have no issues anymore.


All times are GMT. The time now is 06:31 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.01704 seconds
  • Memory Usage 1,734KB
  • 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
  • (5)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete