I've been getting these database errors by the hundreds. I cant figure out what to do.
Any help would be great. Here is my MySQL Variables if this helps.
Code:
Database error in vBulletin 3.5.8: Invalid SQL: SELECT moderatorid, permissions FROM moderator WHERE userid = 21038; MySQL Error : Lost connection to MySQL server during query Error Number : 2013 Date : Wednesday, June 13th 2007 @ 02:45:05 PM Script : [URL]http://www.siccness.net/vb/member.php?u=3666[/URL] Referrer : [URL]http://www.siccness.net/vb/login.php[/URL] IP Address : 69.233.39.84 Username : ************ Classname : vb_database
Code:
[FONT=Consolas][SIZE=3]Database error in vBulletin 3.5.8:[/SIZE][/FONT] [FONT=Consolas][/FONT] [FONT=Consolas][SIZE=3]Invalid SQL:[/SIZE][/FONT] [FONT=Consolas][/FONT] [SIZE=3][FONT=Consolas] SELECT *[/FONT][/SIZE] [SIZE=3][FONT=Consolas] FROM session[/FONT][/SIZE] [SIZE=3][FONT=Consolas] WHERE sessionhash = '70add391f5190bddcf3f429817d1842b'[/FONT][/SIZE] [SIZE=3][FONT=Consolas] AND lastactivity > 1181766624[/FONT][/SIZE] [SIZE=3][FONT=Consolas] AND host = '71.135.177.226'[/FONT][/SIZE] [SIZE=3][FONT=Consolas] AND idhash = 'b04474d45a0e4e1191bbc26139334bba';[/FONT][/SIZE] [FONT=Consolas][/FONT] [FONT=Consolas][SIZE=3]MySQL Error : Lost connection to MySQL server during query Error Number : 2013[/SIZE][/FONT] [FONT=Consolas][SIZE=3]Date : Wednesday, June 13th 2007 @ 02:45:05 PM[/SIZE][/FONT] [FONT=Consolas][SIZE=3]Script : [/SIZE][/FONT][URL="http://www.siccness.net/vb/"][FONT=Consolas][SIZE=3][COLOR=#800080]http://www.siccness.net/vb/[/COLOR][/SIZE][/FONT][/URL] [FONT=Consolas][SIZE=3]Referrer : [/SIZE][/FONT] [FONT=Consolas][SIZE=3]IP Address : 71.135.177.226[/SIZE][/FONT] [FONT=Consolas][SIZE=3]Username : [/SIZE][/FONT] [FONT=Consolas][SIZE=3]Classname : vb_database[/SIZE][/FONT]
Code:
back_log75basedir/binlog_cache_size32768bulk_insert_buffer_size8388608character_set_clientlatin1character_set_connectionlatin1character_set_databaselatin1character_set_resultslatin1character_set_serverlatin1character_set_systemutf8character_sets_dir/usr/share/mysql/charsets/collation_connectionlatin1_swedish_cicollation_databaselatin1_swedish_cicollation_serverlatin1_swedish_ciconcurrent_insertONconnect_timeout10datadir/var/lib/mysql/date_format%Y-%m-%ddatetime_format%Y-%m-%d %H:%i:%sdefault_week_format0delay_key_writeONdelayed_insert_limit100delayed_insert_timeout300delayed_queue_size1000expire_logs_days0flushOFFflush_time0ft_boolean_syntax+ -><()~*:""&|ft_max_word_len84ft_min_word_len4ft_query_expansion_limit20ft_stopword_file(built-in)group_concat_max_len1024have_archiveNOhave_bdbNOhave_blackhole_engineNOhave_compressYEShave_cryptYEShave_csvNOhave_example_engineNOhave_geometryYEShave_innodbDISABLEDhave_isamNOhave_merge_engineYEShave_ndbclusterNOhave_opensslNOhave_query_cacheYEShave_raidNOhave_rtree_keysYEShave_symlinkYESinit_connect init_file init_slave innodb_additional_mem_pool_size1048576innodb_autoextend_increment8innodb_buffer_pool_awe_mem_mb0innodb_buffer_pool_size8388608innodb_data_file_path innodb_data_home_dir innodb_fast_shutdownONinnodb_file_io_threads4innodb_file_per_tableOFFinnodb_flush_log_at_trx_commit1innodb_flush_method innodb_force_recovery0innodb_lock_wait_timeout50innodb_locks_unsafe_for_binlogOFFinnodb_log_arch_dir innodb_log_archiveOFFinnodb_log_buffer_size1048576innodb_log_file_size5242880innodb_log_files_in_group2innodb_log_group_home_dir innodb_max_dirty_pages_pct90innodb_max_purge_lag0innodb_mirrored_log_groups1innodb_open_files300innodb_table_locksONinnodb_thread_concurrency8interactive_timeout28800join_buffer_size1044480key_buffer_size67108864key_cache_age_threshold300key_cache_block_size1024key_cache_division_limit100language/usr/share/mysql/english/large_files_supportONlc_time_namesen_USlicenseGPLlocal_infileONlocked_in_memoryOFFlogOFFlog_binOFFlog_error log_slave_updatesOFFlog_slow_queriesOFFlog_updateOFFlog_warnings1long_query_time10low_priority_updatesOFFlower_case_file_systemOFFlower_case_table_names0max_allowed_packet67107840max_binlog_cache_size4294967295max_binlog_size1073741824max_connect_errors10max_connections500max_delayed_threads20max_error_count64max_heap_table_size67107840max_insert_delayed_threads20max_join_size4294967295max_length_for_sort_data1024max_prepared_stmt_count16382max_relay_log_size0max_seeks_for_key4294967295max_sort_length1024max_tmp_tables32max_user_connections0max_write_lock_count4294967295myisam_data_pointer_size4myisam_max_extra_sort_file_size2147483648myisam_max_sort_file_size2147483647myisam_recover_optionsOFFmyisam_repair_threads1myisam_sort_buffer_size67108864myisam_stats_methodnulls_unequalnet_buffer_length16384net_read_timeout30net_retry_count10net_write_timeout60newOFFold_passwordsOFFopen_files_limit4510pid_file/var/lib/mysql/server2.siccness.net.pidport3306preload_buffer_size32768prepared_stmt_count0protocol_version10query_alloc_block_size32768query_cache_limit3145728query_cache_min_res_unit4096query_cache_size67108864query_cache_typeONquery_cache_wlock_invalidateOFFquery_prealloc_size163840range_alloc_block_size2048read_buffer_size1044480read_onlyOFFread_rnd_buffer_size520192relay_log_purgeONrelay_log_space_limit0rpl_recovery_rank0secure_authOFFserver_id0skip_external_lockingONskip_networkingOFFskip_show_databaseOFFslave_net_timeout3600slave_transaction_retries0slow_launch_time2socket/var/lib/mysql/mysql.socksort_buffer_size2097144sql_mode sql_notesONsql_warningsONstorage_engineMyISAMsync_binlog0sync_frmONsync_replication0sync_replication_slave_id0sync_replication_timeout0system_time_zoneMDTtable_cache2000table_typeMyISAMthread_cache_size384thread_stack196608time_format%H:%i:%stime_zoneSYSTEMtmp_table_size67108864tmpdir transaction_alloc_block_size8192transaction_prealloc_size4096tx_isolationREPEATABLE-READversion4.1.22-standardversion_commentMySQL Community Edition - Standard (GPL)version_compile_machinei686version_compile_ospc-linux-gnuwait_timeout35
Comment