database error many messages,needed help. (realy need help)

[geevest.com]

hello,

i get many error from my database :
its the sample :


Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/zhazha/public_html/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Monday, June 16th 2008 @ 03:17:01 AM
Error Date : Monday, June 16th 2008 @ 03:17:02 AM
Script : http://www.anakayam.us/forum/showthread.php?t=12887
Referrer : http://www.anakayam.us/forum/forumdisplay.php?f=19&order=desc&page=3
IP Address : 125.162.207.54
Username :
Classname : vB_Database
MySQL Version :
=================================
Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT `userid`, `username`, `vbbank`, `vbbux`,
(`vbbank` + `vbbux`) AS totalpoints
FROM user
WHERE ((usergroupid != '5') AND (usergroupid != '7')) AND ((`vbbank` + `vbbux`) > 0)
ORDER BY totalpoints DESC
LIMIT 10;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, June 16th 2008 @ 03:16:50 AM
Error Date : Monday, June 16th 2008 @ 03:16:55 AM
Script : http://www.anakayam.us/forum/vbplaza.php
Referrer :
IP Address : 125.161.179.206
Username : jakarta
Classname : vB_Database
MySQL Version :
========================
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/zhazha/public_html/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Monday, June 16th 2008 @ 03:17:03 AM
Error Date : Monday, June 16th 2008 @ 03:17:03 AM
Script : http://anakayam.us/forum/login.php?do=lostpw
Referrer : http://anakayam.us/forum/register.php?do=addmember
IP Address : 66.249.90.136
Username :
Classname : vB_Database
MySQL Version :
==============================

[Dismounted]

The error means that the MySQL daemon was down while a connection was trying to be established.

[geevest.com]

thats because my host or my vbulletin?

[Dismounted]

Your server.

[geevest.com]

i get this error message again :

Database error in vBulletin 3.7.0:

Invalid SQL:

UPDATE session
SET lastactivity = 1213782551, location = '/forum/forumdisplay.php?f=120', inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '67396536c9a4cb42a379df8ac799ec7b';

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, June 18th 2008 @ 05:49:11 AM
Error Date : Wednesday, June 18th 2008 @ 05:49:14 AM
Script : http://www.anakayam.us/forum/forumdisplay.php?f=120
Referrer : http://www.anakayam.us/forum/forumdisplay.php?f=2
IP Address : 125.163.91.150
Username : asbun
Classname : vB_Database
MySQL Version :
==========
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/zhazha/public_html/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Wednesday, June 18th 2008 @ 05:49:17 AM
Error Date : Wednesday, June 18th 2008 @ 05:49:17 AM
Script : http://anakayam.us/forum/archive/index.php/f-91.html
Referrer : http://www.foolfind.com/search/cerita-sex-sesama-pria-gay
IP Address : 125.163.7.202
Username :
Classname : vB_Database
MySQL Version :
=============
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/zhazha/public_html/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Wednesday, June 18th 2008 @ 05:49:18 AM
Error Date : Wednesday, June 18th 2008 @ 05:49:18 AM
Script : http://www.anakayam.us/forum/register.php?do=register
Referrer : http://www.anakayam.us/forum/register.php?do=checkdate
IP Address : 125.164.205.207
Username :
Classname : vB_Database
MySQL Version :
==========
Database error in vBulletin 3.7.0:

Invalid SQL:
SELECT COUNT(*) AS total FROM post_thanks WHERE userid = 21753 AND date > 1213696153;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, June 18th 2008 @ 05:49:13 AM
Error Date : Wednesday, June 18th 2008 @ 05:49:14 AM
Script : http://www.anakayam.us/forum/showthread.php?t=5350
Referrer : http://www.anakayam.us/forum/forumdisplay.php?f=18&order=desc&page=125
IP Address : 125.162.57.251
Username : randang_darek
Classname : vB_Database
MySQL Version :
=========
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/zhazha/public_html/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Wednesday, June 18th 2008 @ 05:49:16 AM
Error Date : Wednesday, June 18th 2008 @ 05:49:16 AM
Script : http://anakayam.us/forum/showthread.php?t=1686&page=2
Referrer : http://anakayam.us/forum/showthread.php?t=1686
IP Address : 210.245.52.35
Username :
Classname : vB_Database
MySQL Version :
=========

and my host support say : its because my vbulletin script.not my host.
what should i do to fixed this?

--------------- Added 1213783750 at 1213783750 ---------------

my support say like this :


Hello,

It appears we were disconnected from our phone call.

Everything is running on your server. The error messages are normal and
indications that the server is continuing to run even though it is being taxed
severely by the software.

Thank you, I am still monitoring it.


but problem never solved.

[Dismounted]

It means your server cannot handle the load you are putting on it.

[Marco van Herwaarden]

When this happens, check the uptime of the mysql server.

[geevest.com]

im realy tired about this for 3months.my issue never fixed :(
my host support say :

Hello again,


Thank you for verifying.


Your my.cnf file, which controls a lot of optimization settings for MySQL,
seems to match all but one of our recommended settings, for your type of
hardware. Originally, one of our monitoring techs lowered your max_connections
from 1500 to 500, but I've just noticed that wait_timeout is 28800 rather than
the suggested 30. You're welcome to have any settings you'd like, but this
difference will keep a lot of MySQL connections open if VB isn't coded to
close connections once it's finished with it's query.


I found that some of your forum tables are damaged which can cause extra
resources needed by MySQL to process the request. I'd like to stop MySQL, back
up the DB, and run a repair. The process shouldn't take more than 20 minutes.
When would be a good time to do this?


Aside from these minor corrections, I'm seeing no reasons why the server would
be responsible for the high load you're experiencing. In the midst of typing
this response, several php procs for user 'zhazha' were spawned from
/home/zhazha/public_html/forum/showtread.php and forumdisplay.php. After
killing the procs, your load went from 23 down to 4.15.


A majority of your HTTP connections are from Indonesian IPs, but none of them
have an odd number of connections. This leads me to believe your current
hardware and/or VBulletin isn't capable of handling your load demands. Because
I don't believe the above mentioned fixes won't make a large difference, you
may want to consider adding more memory, at the very least. Thanks!


Hello again,


I'm afraid that's something I can't promise. The problem is that your server
isn't handling the load very well, the load is either from the number of
connections, VB not handling so many requests at once, or a combination of the
two. It's possible you may need a better hardware upgrade if you want to
continue to handle this amount of traffic, or adding another GB or two may be
all you need. I'd recommend addressing my earlier suggestions before making
any hardware-related changes, however.

Thanks!

i take dedicated server for this.
so until now my issue never fixed.what should i do for this friend?
i really need ur help for this.
well thank you very much,i hope my problem solved in here.

[Dismounted]

vBulletin can handle many, many users at once. It is most likely that your server is being hammered with requests. Run the command top in SSH and see which process is the first.

[geevest.com]

until now i get database error in my site :

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)
/home/zhazha/public_html/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Friday, June 20th 2008 @ 04:22:52 AM
Error Date : Friday, June 20th 2008 @ 04:23:01 AM
Script : http://www.anakayam.us/forum/showthread.php?t=3504
Referrer : http://www.anakayam.us/forum/forumdisplay.php?f=19
IP Address : 125.162.244.38
Username :
Classname : vB_Database
MySQL Version :

i dont know about my hosting never solved my issue.

[Dismounted]

Please stop posting the same error over and over again - WE GET THE POINT. Furthermore, please read replies posted.

[geevest.com]

im very sorry bout this sir,but i dont know what should i do to make my forum normal again.
until now my host support never solved my problem.im stressfull about this.

[Videx]

It sounds like your host is offering a lot of help, but the problem appears to be in your software. Maybe a corrupt modification.

You can try disabling all your mods and adding them back one by one.

But, like Dismounted just said, there's no point in asking for help here if you're going to ignore the replies. You've been given three suggestions now and you need to try all of them and report back.

If you're not familiar with vbulletin I believe paid help is available somewhere around here.

[geevest.com]

okay no problem,i can pay for this but it must make my vbulletin normal again and not have an issue like this.
but my support host say i must upgrade the RAM.
before this my ram is 2GB.i take dedicated server.

--------------- Added 1214028670 at 1214028670 ---------------

in my plugin/product i just install simple mod :
Cyb - Advanced Forum Statistics
Cyb - Login To User Account
elmati - ADS inside postbit
Enhanced Image Captcha
Force Users to Read a Thread : Disable
Full Quick Reply
Invitation System
Members Who Registered Today
nCode Image Resizer
Personal Notepad
Post Thank You Hack
Quick Register
Tag Cloud - Forum Home
Usergroup Legend - J2Gaming.com
vB Ad Management
vB Ad Management English language
vB.Sponsors
vbBux / vbPlaza : Disable
vBCode table
Watermark Attachments
Welcome Headers

[Dismounted]

Again, please read replies and run the top command.

[geevest.com]

okay,my support say :

Well the reason I ask is because there is a set number of mysql connections
that can happen at once, when it hits this limit it can appear that the mysql
server is down because you can not make a connection to mysql.

[Dismounted]

Please post my.cnf from /etc.

[geevest.com]

Okay this is my.cnf :

[mysqld]
max_connections = 650
safe-show-database
skip-locking
key_buffer = 128M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 64M
thread_concurrency = 8
wait_timeout = 30

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

log-slow-queries = /var/log/mysql-slow.log
long_query_time = 3

[Dismounted]

Try increasing max_connections.

[geevest.com]

how i can set for max_connection?
do u have suggestion sir?

--------------- Added 1214151094 at 1214151094 ---------------

btw my support say :


Hello,

The settings you set it back to (650 for max_connections) will need at the
least 4 gigs of ram, you have 2 currently. If you insist on these settings you
will need to upgrade
I am confused, I actually lowered max_connections yesterday, so far everything
looks stable still. If this is set to high it will when it gets busy go beyond
what is possible. This is when your site goes down, over and over again. Since
I made these changes have you had problems?

now im using dedicated server for 2GB ram.
but my host told me to upgrade my ram in to 4GB ram.
but the problem is that my members was online each day it is just for 5k uniq visitors.
is 2gb is not enough?

[Dismounted]

Again - run the top command and post the result.

[geevest.com]

okay here the result :


top - 12:48:37 up 3 days, 24 min, 2 users, load average: 20.79, 22.28, 20.00
Tasks: 357 total, 8 running, 336 sleeping, 0 stopped, 13 zombie Cpu(s): 78.1%
us, 14.7% sy, 0.0% ni, 7.1% id, 0.0% wa, 0.2% hi, 0.0% si Mem: 2073872k total,
1492364k used, 581508k free, 55936k buffers Swap: 2040244k total, 208k used,
2040036k free, 893324k cached

PID USER PR NI %CPU TIME+ %MEM VIRT RES SHR S COMMAND
25011 zhazha 17 0 14 0:00.44 0.0 0 0 0 Z php <defunct>
25010 zhazha 20 0 14 0:00.43 0.0 0 0 0 Z php <defunct>
25016 zhazha 20 0 13 0:00.39 0.0 0 0 0 Z php <defunct>
25012 zhazha 21 0 12 0:00.38 0.0 0 0 0 Z php <defunct>
25017 zhazha 19 0 12 0:00.38 0.0 0 0 0 Z php <defunct>
25020 zhazha 21 0 12 0:00.38 0.0 0 0 0 Z php <defunct>
25024 zhazha 21 0 11 0:00.34 0.7 25536 13m 5244 R php
25018 zhazha 18 0 10 0:00.32 0.0 0 0 0 Z php <defunct>
10100 mysql 15 0 8 150:26.57 6.1 329m 124m 4288 S mysqld
25025 zhazha 20 0 8 0:00.25 0.6 26156 13m 5120 R php
25027 zhazha 19 0 7 0:00.22 0.6 25892 12m 5160 R php
25028 zhazha 19 0 7 0:00.21 0.6 25784 12m 5108 R php
25030 zhazha 18 0 3 0:00.09 0.4 21780 9036 4652 R php
25029 zhazha 18 0 1 0:00.04 0.2 19888 4840 2896 R php
24903 root 16 0 1 0:00.28 0.1 3388 1216 780 R top
10658 root 17 0 1 5:36.59 0.1 3764 1284 780 S top
16150 nobody 15 0 1 0:00.37 0.2 11316 3936 1460 S httpd
11916 nobody 15 0 0 0:00.50 0.2 11328 3952 1452 S httpd
14076 nobody 16 0 0 0:00.52 0.2 11348 3980 1468 S httpd
17868 nobody 15 0 0 0:00.37 0.2 11348 3980 1464 S httpd
18104 nobody 15 0 0 0:00.34 0.2 11332 3972 1464 S httpd
18739 nobody 16 0 0 0:00.27 0.2 11332 3972 1460 S httpd
18853 nobody 15 0 0 0:00.30 0.2 11324 3976 1484 S httpd
19589 nobody 16 0 0 0:00.23 0.2 11348 3996 1464 S httpd
20153 nobody 15 0 0 0:00.19 0.2 11196 3884 1456 S httpd
20156 nobody 16 0 0 0:00.27 0.2 11188 3884 1460 S httpd
20461 nobody 16 0 0 0:00.18 0.2 11212 3952 1488 S httpd
22137 nobody 16 0 0 0:00.07 0.2 11188 3860 1444 S httpd
22987 nobody 16 0 0 0:00.12 0.2 11188 3892 1460 S httpd
23536 nobody 16 0 0 0:00.02 0.2 11188 3844 1436 S httpd
23595 nobody 16 0 0 0:00.06 0.2 11188 3868 1448 S httpd
23760 nobody 16 0 0 0:00.09 0.2 11176 3844 1440 S httpd
23852 nobody 15 0 0 0:00.05 0.2 11176 3856 1444 S httpd


as you can see this is an issue with the user (indeed your only user and
account it appears) zhazha, to much PHP use, before it was this AND too much
Mysql use, if you can have the makers of your forum software trouble shoot
that would be great, can you please let me know what they say?

--------------- Added 1214307185 at 1214307185 ---------------

my host support say :


Hi,


After reading through several tickets and other admin notes, the problems can
be summarized thusly:

1) The vbulletin software is a resource hog. The number of connections that it
is trying to handle and pass to the server is extremely large.

2) The memory usage required by php on the site is also using an overabundance
of memory.

3) we have tried to optimize the existing software configuration to the nth
degree all without success.

4) The hardware configuration of the server itself is inadequate for your
current needs.

To solve these problems I would recommend the following:

A: Upgrade the server to at least a 4 core processor or better yet, 8 cores
would be optimal. You currently have a single duo core processor.

B: Upgrade the ram to at least 4 Gigs, 8 Gigs would be better. You currently
have 2 Gigs.

C: Consider optimizing the php software you are using for the site itself. The
number of concurrent connections are causing 'out of memory' errors which
causes the failed or dropped mysql connections causing downtime for the site.

D: Consider changing the software you are using for the bulletin board. The
current problem is that the board is spawning over 1100
/usr/bin/php/home/zhazha/public_html/forum/showthread.php processes.

To put it simply, you are trying to toast 100 slices of bread on a 4 slice
toaster. The answer to this issue is you need a bigger toaster. This may be
oversimplifying the issue but it is accurate. This is my opinion, but the
final decision is yours to make. We can improve via upgrade or continue to see
the same issues reappear again and again. Please let me know how you would
like to proceed.

Let me also take this time to say thank you for your time and patience while
we try and resolve this issue. I know the frustration level is high, but there
is a solution to this if we continue to work together to find it.






Regards,
David Singer



Here is the my current plan :
DEDICATED SERVER.
Item: Webmaster Plan1
Processor: Pentium 4 3GHZ Hyperthreaded
Memory: 1GB DDR SDRAM
Hd1: 120GB 7200RPM SATA / 8MB Cache
Hd2: 120GB 7200RPM SATA / 8MB Cache
RemoteBackup: No Remote Backup Needed
OS: Linux - CentOS 4
ControlPanel: CPanel / Web Host Manager
(+ServerSecure)
(+Fantastico/XController)


You currently have a single duo core processor with 2 Gigs of ram.


but its not enough?
my uniq visitors / day just only 4k.
so i must upgrade my server or what sir?
thanks

[Dismounted]

To answer your host's comments:

1) vBulletin is NOT a resource hog. It only opens as many connections to the server as people visiting.
2) You still have ~500MB of free memory....
3-4) Your load average is high, very high in fact. So your processor would be dragging you down as well.

[geevest.com]

but now im already upgrade in to 4GB ram. :)

[SEOvB]

turn persistant connectons off in the config.php file if its on.

[geevest.com]

turn persistant connectons off in the config.php file if its on.

may i know about persistant connections its for what? thx

--------------- Added 1214413338 at 1214413338 ---------------

btw im already upgrade in to 4GB ram.but my issue never solved.
my host just say :

Hello again,


There's nothing further we can do for you, regarding your vbulletin issues. As
Ian and myself have stated before, we've optimized your server's services and
have reviewed it's overall setup several times. We've gone above and beyond
our realm of support trying to keep your server stable, but your server is
flooded by connections and the demands from VB bring it offline.


I apologize for the inconvenience this has caused you, but everything we
provide support for is working as expected. If the VB support staff isn't able
to provide an additional step for you, I'd recommend trying either new forum
software or reinstalling VB. I'm not trying to push you away from that
software, but our Support staff isn't trained on the ins and outs of VB, only
identifying what's causing an issue and how best to resolve it. We don't
provide support for 3rd party applications (i.e. anything outside of cPanel,
not directly related to the Operating System).


Please let me know if there's anything else I can help you with. Though we
can't resolve the VB problems, I can assure you that we're always here for
questions or problems with anything pertaining to cPanel.



i think the problem its because vbulletin.not my host.because im already upgrade in to 4GB ram.
and my issue always getting from vbulletin.

[y2ksw]

I was suggesting to copy the vBulletin database to a fresh install just to be sure there is no vbulletin issue. The server hardware seems ok to me, since the site is pretty fast under normal conditions. Now with 4 GB it is slightly better.

If a fresh copy fails, I suggest to move hosting and run a dedicated server under own regime. Of course, excellent computer knowledge is required ;)

[legija]

Apache should be compiled with PHP, and PHP should not run as CGI. Thats why it eats so much resources.

As i can see, PHP runs as separate module here. I remember once my hoster did this to my server due to some obscure bug , and server was rendered unusable in just few visits.

[Dismounted]

Again, vBulletin is NOT a resource hog. It only opens as many connections to the server as people visiting.

Look at the output of top, you have too many PHP forks running - this is killing the server, not the amount of RAM, but the CPU power required.

[geevest.com]

I was suggesting to copy the vBulletin database to a fresh install just to be sure there is no vbulletin issue. The server hardware seems ok to me, since the site is pretty fast under normal conditions. Now with 4 GB it is slightly better.

If a fresh copy fails, I suggest to move hosting and run a dedicated server under own regime. Of course, excellent computer knowledge is required ;)

friend u mean i must backup the database forum and then create a new installation forum,
then upload my database in to a new forum. right?

and how about the plugin menu? thx

--------------- Added 1214486448 at 1214486448 ---------------

now my forum using vb.3.7.1 PL2.
its impossible if i create a new installation vb.3.7.2 and restore the database from vb.3.7.1 PL2 ?

[Dismounted]

Reinstalling vBulletin is not going to do anything. Just look at the output of the top command.

[Videx]

Reinstalling vBulletin is not going to do anything. Just look at the output of the top command.I think you're really trying to help, so I'll post this and hope you don't take it the wrong way.

Your responses are assuming way too much knowledge. "you have too many PHP forks running" describes the result of a problem, but doesn't tell the poor guy what to do about it.

He's at the point now where he'll do anything you say, but now you've got to give him some sort of action to take. What should he do next to try to solve the problem?

[y2ksw]

No, I mean to make a fresh installation and use IMPEX to transport the forum data on a new board, in order to get rid of all plugins, style changes and eventual errors.

Just backing up and restoring would not help. It would just reproduce the same problems on the new installation ;)

--------------- Added 1214496396 at 1214496396 ---------------

I think you're really trying to help, so I'll post this and hope you don't take it the wrong way.

Your responses are assuming way too much knowledge. "you have too many PHP forks running" describes the result of a problem, but doesn't tell the poor guy what to do about it.

He's at the point now where he'll do anything you say, but now you've got to give him some sort of action to take. What should he do next to try to solve the problem?
It seems his host is not very cooperative and just tries to guess where the problem lays.

I try to fix the problem without touching the hardware and server settings, since this would require to change host.

There are some errors on style basis which cause the pages not to load correctly and may have side effects on certain scripts. These errors are present with and without plugins. It may also be, some of the plugins are outdated, but I doubt the problem is there.

After he upgraded to 4 GB RAM the problem continued. With permanent connections, the problem was less frequent, which points my finger to the MySQL settings.

I'm not sure if PHP run as CGI makes the big difference, since it should just run shortly an instance of PHP for each client. Of course it would show a long list of instances, if the operating system doesn't unload them quickly. At most there could be a short delay between connections. MySQL errors could occur, if the PHP instances don't unload quick enough while other client connections are incoming. I've no idea how Linux handles CGI, and how applications are scheduled.

PHP run as CGI is the usual way to keep processes apart and avoid to crash or block the whole server if one client instance crashes or blocks. However it is useful only in shared virtual servers.

[geevest.com]

until now for 2days.im not getting the many error message in my mail.
just error database in attachment.its because im using watermark attachment for vb.3.6.8 version..im running vbulletin vb.3.7.1 version. i need watermark attachment for my image.because this the watermark attachment not uninstall in my plugin.i really need it.

i hope it will be okay for the next time.
because im really tired about this issue.

[y2ksw]

Can you provide me the link to the watermark plugin please?

[geevest.com]

Host support :
Hello,

Again, you need something more powerful. You are receiving 1000's of hits per
hour, and the server is unable to process it. Our support department has
worked with you extensively on optimizing and keeping your site up.

u must login with Paid member :
userid : testing
pass : 123456

Invalid SQL:
INSERT INTO attachmentviews (attachmentid)
VALUES (1162);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, June 26th 2008 @ 11:36:30 PM
Error Date : Thursday, June 26th 2008 @ 11:37:20 PM
Script : http://www.anakayam.us/forum/attachment.php?attachmentid=1162&d=1213042014
Referrer : http://www.anakayam.us/forum/showthread.php?t=12398&page=2
IP Address : xxxxx
Username : ankurdiok
Classname : vB_Database
MySQL Version :

Database error in vBulletin 3.7.1:

Invalid SQL:
INSERT INTO attachmentviews (attachmentid)
VALUES (1393);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, June 26th 2008 @ 11:17:41 PM
Error Date : Thursday, June 26th 2008 @ 11:18:12 PM
Script : http://www.anakayam.us/forum/attachment.php?attachmentid=1393&d=1213286649
Referrer : http://www.anakayam.us/forum/showthread.php?t=12827
IP Address : xxxxxxx
Username : ankurdiok
Classname : vB_Database
MySQL Version :

Database error in vBulletin 3.7.1:

Invalid SQL:
INSERT INTO attachmentviews (attachmentid)
VALUES (1756);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, June 26th 2008 @ 10:41:35 PM
Error Date : Thursday, June 26th 2008 @ 10:42:06 PM
Script : http://www.anakayam.us/forum/attachment.php?attachmentid=1756&d=1214455833
Referrer : http://www.anakayam.us/forum/showthread.php?t=14405
IP Address : xxxxx
Username : ankurdiok
Classname : vB_Database
MySQL Version :


Invalid SQL:
INSERT INTO attachmentviews (attachmentid)
VALUES (783);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, June 26th 2008 @ 07:35:39 AM
Error Date : Thursday, June 26th 2008 @ 07:37:12 AM
Script : http://anakayam.us/forum/attachment.php?attachmentid=783&d=1209057072
Referrer : http://www.anakayam.us/forum/showthread.php?t=7763&page=2
IP Address : xxxx
Username : pandamesum
Classname : vB_Database
MySQL Version :

that's example link for attachment.

today i get 3message database error :
Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/zhazha/public_html/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Tuesday, June 24th 2008 @ 03:36:41 PM
Error Date : Tuesday, June 24th 2008 @ 03:36:42 PM
Script : http://www.anakayam.us/forum/image.php?u=1538&dateline=1213793980
Referrer : http://www.anakayam.us/forum/showthread.php?t=13153
IP Address : xxxx
Username :
Classname : vB_Database
MySQL Version :

just 3message not more.
before im upgrade in to 4GB. everyday i get more than 100 error database message in my inbox.

thanks

--------------- Added 1214554100 at 1214554100 ---------------

yesterday my support host ask i must upgrade the ram for fixed my issue.
and now they need me to an upgrade my Host in to proffessional dedicated server. *Sigh

Without knowing how much traffic and server spec other people have, I can't
comment on why it doesn't happen to them.

If you can't get vbulletin to optimize the forum, I'm afraid you will need to
upgrade to more powerful server, not just upgrade the ram. Giving your past
ticket issues, I don't think I can do anything else to help the situation.

[Marco van Herwaarden]

In order to fix the attachmentviews problem, you can try to add the following line to your config.php and see if this makes any difference:
define('NOSHUTDOWNFUNC', true);

[geevest.com]

In order to fix the attachmentviews problem, you can try to add the following line to your config.php and see if this makes any difference:
define('NOSHUTDOWNFUNC', true);

i put the code in bottom of config.php
but thats not work.
im always get database error :

Database error in vBulletin 3.7.1:

Invalid SQL:
INSERT INTO attachmentviews (attachmentid)
VALUES (1422);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, June 27th 2008 @ 02:22:43 PM
Error Date : Friday, June 27th 2008 @ 02:23:32 PM
Script : http://www.anakayam.us/forum/attachment.php?attachmentid=1422&d=1213289277
Referrer : http://www.anakayam.us/forum/showthread.php?t=12827
IP Address : xxxx
Username : wela
Classname : vB_Database
MySQL Version :

[y2ksw]

Well I don't know. My smallest server gets ten's of thousands hits per hour and still doesn't give up. The MySQL gone away error is usually a record size problem, and the server should time out at most = no reply = white or error page. For me it's a server setting issue. But of course, if you are on a shared environment - as it seems -changing the settings may be done only within certain limits.

I don't know if you solve the problems you have now switching to a "professional" solution of the same host. If I was you I'd look to get the best for my money, which isn't necessarily the cheapest. I would buy a good computer, giving the most attention to the hard disk quality, add some RAM, install an operating system, the latest Apache, MySQL and PHP and would go housing after a home test session. This way, you know what you have and if something doesn't work, you know how to fix it. It has a relatively high cost because of the computer, the OS and preliminary work, but pays off after a year, because the expense of housing is very small.

[R1lover]

That server should be more then fine for your traffic depending on your site and what add ons you have. If this is just for one vbulletin forum then your server or software configuration is way off.

[geevest.com]

Problem solved :) by host.thx

[obetyance]

Problem solved :) by host.thx

How was it solved, sir?

I have thousands of same ERROR everyday.

I'm sick and tired of reading the same suggestions.

[Speysider]

How was it solved, sir?

I have thousands of same ERROR everyday.

I'm sick and tired of reading the same suggestions.

And you needed to bump a two year thread to say this?
What is it with members necromancing threads to make no sense or contribution to the site??

[Videx]

And you needed to bump a two year thread to say this?
What is it with members necromancing threads to make no sense or contribution to the site??Where were you when the last post failed to give the solution and instead simply said the host had fixed it? I'll agree he probably should have just PM'd geevest, but that doesn't absolve you of responsibility to see that solutions are published for the benefit of future searchers.

Myself, whenever I see a problem that ends with less than a solution, I always ask the poster to tell us about the problem, what they did to figure it out, and how they solved it. Usually they do, and I like to think it helps more in the future than just yelling at people for doing what we expect them to do - search before starting a new thread.

[obetyance]

I did PM the author but no response.

[Videx]

The OP actually listed several different errors, but it was all from an old vb3 install. You really should search over at vb.com and if you don't find anything, start a new thread with your specific error.

[obetyance]

I'm using 3.8.4 patch 2
Server Type Linux
Web Server Apache v2.0.63 (cgi)
PHP 5.2.8
MySQL Version 5.0.89-community
MySQL Packet Size 1.00 MB

I'm doing some test right now. I do believed it has something with the new PLUG-INS/ ADD-ONS I just recently installed. Conflict maybe, I don't know.

I just disabled them for now for further observation.

Thanks for your assistance.

[Marco van Herwaarden]

Better to start your own new thread with the details of the issues you get.