miniBB ® miniBB®
miniBB Support Forums
 | Forums | Register | Reply | Search | Statistics | Manual |
FAQ miniBB Support Forums / FAQ /   

Database / configuration error when forums are active and already running

Page  Page 1 of 2:  1  2  Next »  
Author Polar
Guest
#1 | Posted: 29 Jan 2004 15:55 
Does anybody suffers from periodical temporary "database/configuration error" - some kind of database cache overflow, which makes forum anavailable for few (1-15) minutes??

Author 4days
Champi0n
#2 | Posted: 29 Jan 2004 17:23 
sounds like a server issue, do you know if your database exists in the same physical location as your webserver (the same machine) or if it has to talk across a network?

Author Polar
Guest
#3 | Posted: 29 Jan 2004 19:43 
Same machine.

Author Team
8-)
#4 | Posted: 29 Jan 2004 21:28 
Polar
in any way it's database problem not miniBB problem. database becomes unavailable for 1-15 minutes on your server.. you can turn on error reporting by adding error_reporting(E_ALL); line into setup_options.php file and add echo mysql_error(); line right after mysql_connect lines on top of the setup_mysql.php file to see what kind of error message does php return when connecting to the database

Author Polar
Guest
#5 | Posted: 30 Jan 2004 01:11 
Ok, i`ll try it.

And this is mysql settings. Possible it will give some key:

back_log: 50
binlog_cache_size: 32768
character_set: cp1251
concurrent_insert: ON
connect_timeout: 5
delay_key_write: ON
delayed_insert_limit: 100
delayed_insert_timeout: 300
delayed_queue_size: 1000
have_isam: YES
interactive_timeout: 28800
join_buffer_size: 131072
key_buffer_size: 268431360
large_files_support: ON
long_query_time: 10
max_allowed_packet: 1047552
max_binlog_cache_size: 4294967295
max_binlog_size: 1073741824
max_connections: 200
max_connect_errors: 10
max_delayed_threads: 20
max_heap_table_size: 16777216
max_join_size: 4294967295
max_sort_length: 1024
max_user_connections: 10
max_tmp_tables: 32
max_write_lock_count: 4294967295
myisam_max_extra_sort_file_size: 256
myisam_max_sort_file_size: 2047
myisam_recover_options: 6
myisam_sort_buffer_size: 67108864
net_buffer_length: 16384
net_read_timeout: 30
net_retry_count: 1000000
net_write_timeout: 60
port: 3306
protocol_version: 10
record_buffer: 2093056
record_rnd_buffer: 2093056
query_buffer_size: 0
safe_show_database: ON
sort_buffer: 2097144
sql_mode: 0
table_cache: 256
table_type: MYISAM
thread_cache_size: 8
thread_stack: 65536
timezone: MSK
tmp_table_size: 209715200
version: 3.23.54
wait_timeout: 60

Author Polar
Guest
#6 | Posted: 30 Jan 2004 01:54 
maybe this line?

max_tmp_tables: 32

Author Polar
Guest
#7 | Posted: 30 Jan 2004 02:42 
Team, after turning on errors - they are almost on every page.
I had to turn it off...

Author Team
8-)
#8 | Posted: 30 Jan 2004 10:02 
Polar
What kind of errors?

Author Polar
Guest
#9 | Posted: 30 Jan 2004 10:22 
For example: on the statistic page...

Notice: Undefined variable: days in /home/public_html/forum/bb_func_stats.php on line 17

Notice: Undefined variable: top in /home/public_html/forum/bb_func_stats.php on line 25

Notice: Undefined variable: xtr in /home/public_html/forum/setup_mysql.php on line 401

Notice: Undefined variable: list_stats_popular in /home/public_html/forum/bb_func_stats.php on line 55

Notice: Undefined variable: xtr in /home/public_html/forum/setup_mysql.php on line 378

Notice: Undefined variable: list_stats_viewed in /home/public_html/forum/bb_func_stats.php on line 74

Notice: Undefined variable: list_stats_aUsers in /home/public_html/forum/bb_func_stats.php on line 93


On the search page...

Notice: Undefined variable: searchWhere in /home/public_html/forum/bb_func_search.php on line 42

Notice: Undefined variable: searchHow in /home/public_html/forum/bb_func_search.php on line 42

Notice: Undefined variable: searchFor in /home/public_html/forum/bb_func_search.php on line 43

Notice: Undefined variable: days in /home/public_html/forum/bb_func_search.php on line 49

e.t.c...

But, Team, what you can say about mysql settings posted above??

Author FerRory
Registered
#10 | Posted: 30 Jan 2004 11:50 
I have set error_reporting(E_ALL); on.
But I don't get errors only if my search has one character.

Author Team
8-)
#11 | Posted: 2 Feb 2004 10:14 
Polar
Which version of miniBB do you have? 1.7b should work WITHOUT these errors (and as for example, it is working with all errors turned on like on this server).

Author Polar
Guest
#12 | Posted: 2 Feb 2004 14:06 
Team, this is 1.5 and soon i will upgrade it (with your help) to 1.7+
:)

But now i`m very exited with database/configuration. PLEEEEAAASE, check mysql settings posted above!!!

Author Team
8-)
#13 | Posted: 2 Feb 2004 14:38 
Polar
All I can say - upgrade to 1.7 first, then you will get off of these errors. Second, this error with database, as I might know, could appear when your hosting provider has more than one database, and some of databases (not obligately yours) has very active overload. Try to use command FLUSH HOSTS on mysql.

Author Polar
Guest
#14 | Posted: 2 Feb 2004 18:50 
How to use this command?

Author Team
8-)
#15 | Posted: 3 Feb 2004 10:22 
Via Mysql Front, for example, PHP My Admin, direct command shell etc.

Page  Page 1 of 2:  1  2  Next » 
FAQ miniBB Support Forums / FAQ / Database / configuration error when forums are active and already running Top

Your Reply Click this icon to move up to the quoted message

 Short link for this topic:

 ?
Only registered users are allowed to post here. Please, enter your username/password details upon posting a message, or register first.


Before posting, make sure your message is compliant with our forum posting rules. If not, it may be locked or deleted with no explanation.
 
 
miniBB Support Forums Powered by Forum Software miniBB ® Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contacts
Proceed with the Captcha add-on: protect your miniBB-forums from the automated spam and flood.
Captcha Addon for miniBB