forum follies

[rainboy]

Be carefull using the above my.cnf example as the first part [mysqld] does contain some errors, at some of the configuration items a space was placed.

See here the incorrect part, taking the above example without fixing this will crash you mysql (so as said in the text, make a backup of your original one!):

[mysqld]
max_connections = 400
key_buffer = 64M
myisam_sort_buffer_s ize = 32M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 286
interactive_timeout = 25
wait_timeout = 1000
connect_timeout = 10
max_heap_table_size = 128M
max_allowed_packet = 16M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_s ize = 16M
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_si ze = 32768
tmp_table_size = 32M
skip-innodb

[JPC-Greg]

[mysqld]
max_connections = 400
key_buffer = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 286
interactive_timeout = 25
wait_timeout = 1000
connect_timeout = 10
max_heap_table_size = 128M
max_allowed_packet = 16M
max_connect_errors = 10
read_rnd_buffer_size = 524288
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
query_prealloc_size = 163840
tmp_table_size = 32M
myisam_sort_buffer_size = 32M
query_alloc_block_size = 32768
bulk_insert_buffer_size = 16M
skip-innodb

I dont know why, but for some reason vbulletin is displaying spaces that dont exist in the source.

myisam_sort_buffer_size
query_alloc_block_size
bulk_insert_buffer_size

those should each be one statement with no spaces

[Ron]

The extra spaces have been occuring since the skin change, and has been mentioned a couple of times (I don't expect you to read all of the "jibber jabbery posts that are made! ) They nearly always occur in long urls...

EDIT: In doing some quick testing, it seems it's after the 20th contiguous non-whitespace character in every case that I tested.

123456789012345678901234567890
1234567890123456789012345678901234567890 12345678901234567890

It was probably designed in that way to prevent very long strings from distorting the forum width. If so, maybe if it was upped to 40 or 50 most problems could be avoided?

[JPC-Greg]

didnt know that was a feature , found and fixed.