vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   [Help] MySQL Error (https://vborg.vbsupport.ru/showthread.php?t=156595)

tminus 08-30-2007 05:32 AM

[Help] MySQL Error
 
I am getting a number of mysql error messages related to /includes/class_core.php on line 274. One is "Too many connections" and the other is "Can't connect to MySQL server on 'remotemysqlhost' (4)" Can anyone help me with this? Although my test users are getting errors, nothing seems to be messing up permanently. Could this just be a common error with hosted databases? Any help would be appreciated. Thank you. :)

TTG 08-30-2007 05:42 AM

Common error on shared hosting packages. If it continues, contact your host. If it gets worse, find a new host :D

tminus 08-30-2007 07:47 AM

Quote:

Originally Posted by TTG (Post 1328619)
Common error on shared hosting packages. If it continues, contact your host. If it gets worse, find a new host :D

Thanks, I had a feeling it would be like that. <sigh> I will post any results I get from support to help anyone else who may have the same error.

My other problem with my host is that the php.ini is above my permission level, so vB can only handle up to 10MB uploads! I found out the default is 2MB, so I had it bumped to 10MB, but the barely matters for video uploading. There has to be a work around for that but I haven't found one yet. I had to deal with this testing Links & Download Manger for vB, but I just decided to go with Any Media and limit local videos to ftp (also the tech's suggestion after the bump!)

KenDude 09-20-2007 07:41 PM

Actually I just started getting this error today, and would receive about 20 emails at exactly 14 minutes past the hour each hour for the last 8 hours or so. I just closed my site, ran a database repair and re-opened the site to see if that fixes it. It doesn't have anything to do wiht my site, and I didn't change any config on my site, this just started happening.

Dismounted 09-21-2007 05:32 AM

This is caused by the MySQL process locking up because of too many connections. I suggest you talk with your host.

setubal 09-23-2007 01:14 AM

...And what about these errors please ?

Quote:

Invalid SQL:

INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid,
languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent,
bypass, profileupdate)
VALUES
('f96df3473fc09a67b3c372e25558bd6a', 1379, '86.218.130.217',
'e111986dac8e7b3ff744fe8a3193a287', 1189501531,
'/www/showthread.php?p=22609, 0, 2, 1, 0,
0, 0, 0, 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
1.1.4322)', 0, 0);

MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Tuesday, September 11th 2007 @ 09:06:49 AM
Script :
*********************************

Quote:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2,
1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar,
customavatar.dateline AS avatardateline,customavatar.width AS
avwidth,customavatar.height AS avheight,

editlog.userid AS edit_userid, editlog.username AS edit_username,
editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS
sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
infractiongroupid


FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN
customavatar AS customavatar ON(customavatar.userid = user.userid)

LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND
postparsed.styleid = 22 AND postparsed.languageid = 2)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND
sigparsed.styleid = 22 AND sigparsed.languageid = 2)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)

WHERE post.postid IN (0,19593,19597,19605,22607,22608,22609)
ORDER BY post.dateline;

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Wednesday, September 12th 2007 @ 12:19:15 PM
Script :
******************

Quote:

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Lost
connection to MySQL server during query
/www/class_core.php
on line 271

MySQL Error :
Error Number :
Date : Wednesday, September 12th 2007 @ 12:19:26 PM
Script :
Thank's you.

Server error or vbulletin mysql tables ? ...

Dismounted 09-23-2007 06:15 AM

This is a MySQL problem, so talk with your host.

Marco van Herwaarden 09-23-2007 10:04 AM

The mysql connection times out before that query can be executed. First try as suggested to have this solved by your host by increasing the mysql timeout.

If that does not work, try adding the following line to your config.php:
PHP Code:

define('NOSHUTDOWNFUNC'true); 


setubal 09-23-2007 10:29 AM

Nice support,

Thanks you so much.

Viva Vbulletin ! ;)


All times are GMT. The time now is 08:25 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.01217 seconds
  • Memory Usage 1,738KB
  • 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)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)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