The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
every visitors that visited to my forum for example :
500members and 800guest and sometimes in a very short time the member and the guest will be come to 0. maybe its because my server always do the restarted to my site. if my server didnot do the restart it im always getting error message in my email. vBulletin Database Error! Database error in vBulletin : Quote:
Quote:
i have been call my support hosting to not do the restarted ever for my site because every time they restarted then my visitors always back to 0. how i can bypass this error message? If i dont do anything with this issue.will be my database crush? |
#2
|
||||
|
||||
![]()
You keep writing about this.... if it is a dedicated server, I strongly suggest to find out where you mysql errors logs are and check them out yourself. Or, open a shell and find out how long mysql has been 'up' so you can find out if it has recently been restarted. If it is restarting itself, it is because of a setting somewhere that is triggering the restart. It may be in your my.cnf file. However, you need to read your mysql error logs in order to find out if it really is restarting itself and what the reason is. If you don't know that, then you can't fix it.
|
#3
|
|||
|
|||
![]()
Im sorry about this Lynne,because my problem never solved until now.and im always getting any error messages.
btw may i know how i can check my.cnf file? its mean.how i can get the file? im not familiar with vbulletin and dedicated server.thx |
#4
|
||||
|
||||
![]()
my.cnf is the mysql configuration file. I think it is in different places on different servers. I have a separate server that runs mysql and the file is in the /etc directory.
You may want to post in the Server Configuration forum on vb.com to get your server configured correctly. Or, since you are new to servers and may not know how to modify the php/mysql config files, you may want to look into hiring someone to deal with your server. |
#5
|
|||
|
|||
![]()
[mysqld]
max_connections = 500 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 is anything wrong? |
#6
|
||||
|
||||
![]()
I don't know. Without knowing for sure if mysql is restarting itself, and without seeing the error, no one can tell you what is wrong. Also, the my.cnf file will be different for every server. Every board is unique and needs tweeking in different ways.
|
#7
|
|||
|
|||
![]()
and now,what should i do Lynne to solved my problem?
because until now my guest and my members always kickout from my site. like i said before : Quote:
|
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|