Raised This Month: $51 Target: $400
 12% 

Error with SQL


Post New Thread Closed Thread   
 
Thread Tools Display Modes
Author Message
HLM
Senior Member
Join Date: Apr 2008
Location: C:\WINDOWS\System32
Old 05-22-2011 , 00:57   Error with SQL
#1

Hi, I run multiple servers with similar setups (but drastically different mod setups) and I noticed that sometimes the /servers command would not function on my servers, so I enabled debug mode on one of my servers to attempt to get to the bottom of this, here is the information that I believe is required:

error.log
PHP Code:
L 05/21/2011 03:06:42Start of error session.
L 05/21/2011 03:06:42Info (map "badlands") (file "addons/amxmodx/logs/error_20110521.log")
L 05/21/2011 03:06:42: [MySQLInvalid database handle0
L 05
/21/2011 03:06:42: [AMXXDisplaying debug trace (plugin "xredirect-beta.amxx")
L 05/21/2011 03:06:42: [AMXXRun time error 10native error (native "SQL_PrepareQuery")
L 05/21/2011 03:06:42: [AMXX]    [0xredirect-beta.sma::load_servers_sql (line 1136)
L 05/21/2011 03:06:42: [AMXX]    [1xredirect-beta.sma::plugin_init (line 823)
L 05/21/2011 03:28:45: [MySQLInvalid handle0
L 05
/21/2011 03:28:45: [AMXXDisplaying debug trace (plugin "xredirect-beta.amxx")
L 05/21/2011 03:28:45: [AMXXRun time error 10native error (native "SQL_FreeHandle")
L 05/21/2011 03:28:45: [AMXX]    [0xredirect-beta.sma::sql_disconnect (line 3422)
L 05/21/2011 03:28:45: [AMXX]    [1xredirect-beta.sma::plugin_end (line 956
plugins.ini
PHP Code:
;advanced_bans.amxx
advanced_bans_sql
.amxx
AMX Mod X plugins
amxwho
.amxx
Admin Base Always one has to be activated
;admin.amxx        admin base (required for any admin-related)
admin_sql.amxx        admin base SQL version (comment admin.amxx)

Basic
admincmd
.amxx        basic admin console commands
adminhelp
.amxx        help command for admin console commands
adminslots
.amxx        slot reservation
multilingual
.amxx    Multi-Lingual management

Menus
menufront
.amxx        front-end for admin menus
cmdmenu
.amxx        command menu (speechsettings)
plmenu.amxx        players menu (kickbanclient cmds.)
telemenu.amxx        teleport menu (Fun Module required!)
mapsmenu.amxx        maps menu (votechangelevel)
pluginmenu.amxx        Menus for commands/cvars organized by plugin

Chat Messages
adminchat
.amxx        console chat commands
antiflood
.amxx        prevent clients from chat-flooding the server
scrollmsg
.amxx        displays a scrolling message
imessage
.amxx        displays information messages
adminvote
.amxx        vote commands

Map related
;nextmap.amxx        displays next map in mapcycle
;mapchooser.amxx        allows to vote for next map
deagsmapmanager
.amxx    ;chooses the nextmap
timeleft
.amxx        displays time left on map

Configuration
pausecfg
.amxx        allows to pause and unpause some plugins
statscfg
.amxx        allows to manage stats plugins via menu and commands

Team Fortress Classic
;rank.amxx
;stats.amxx        stats on death (TFC Module required!)
;
statssounds.amxx    precache plugin for stats plugins
;stats_logging.amxx    weapons stats logging (TFC Module required!)

utsounds.amxx

Enable to use AMX Mod plugins
;amxmod_compat.amxx    AMX Mod backwards compatibility layer

Custom Add 3rd party plugins here

xredirect
-beta.amxx debug
jr_touchmgmenu
.amxx
custom
-msc.amxx
hook_beam
.amxx
amx_ejl_searchmaps
.amxx
amx_customvotes
.amxx
GHW_connect
.amxx
sank_sounds
.amxx
;restrictnames.amxx
infectmanage
.amxx
sank_sounds
.amxx
skynet
.amxx debug
task_scheduler
.amxx
micrest
.amxx
hlstatsx_commands_tfc
.amxx 
xredirect.cfg
PHP Code:
redirect_active 1
redirect_auto 1
redirect_manual 1
redirect_follow 1
redirect_check_method 2
redirect_announce 60
redirect_announce_mode 3
redirect_show 1
redirect_adminslots 1
redirect_retry 1
redirect_hideown 2
redirect_countbots 0 
rcon meta list
PHP Code:
00:53:02 Currently loaded plugins:
               
description      stat pend  file              vers      src   load  unlod
          
1Adminmod         RUN   -    admin_MM_i386.so  v2.50.60  ini   Start ANY  
          
2Hook Mod         RUN   -    HookMod_i386.so   v5        ini   Start Start
          
3FoxBot           RUN   -    foxbot_MM_i586.s  v0.69     ini   Start Start
          
4Ent Mod          RUN   -    EntMod_i386.so    v3        ini   Start Start
          
[  5dproto_EFv0.9.872010-10-26by Crocksee 
          
6AMX Mod X        RUN   -    amxmodx_mm_i386.  v1.8.1.3  ini   Start ANY  
          
7Fun              RUN   -    fun_amxx_i386.so  v1.8.1.3  pl6   ANY   ANY  
          
8TfcX             RUN   -    tfcx_amxx_i386.s  v1.8.1.3  pl6   ANY   ANY  
          
9Engine           RUN   -    engine_amxx_i386  v1.8.1.3  pl6   ANY   ANY  
          
10MySQL            RUN   -    mysql_amxx_i386.  v1.8.1.3  pl6   ANY   ANY  
          
[11FakeMeta         RUN   -    fakemeta_amxx_i3  v1.8.1.3  pl6   ANY   ANY  
         11 plugins
11 running 
status
PHP Code:
00:54:31 status
00
:54:31 hostname:  -[EVIL]- Low Grav -Get Your Float On!!-
         
version :  48/1.1.2.2/Stdio 4883 secure  (20)
         
tcp/ip  :  68.232.169.247:27015
         map     
:  freefall4 at0 x0 y0 z
         players 
:  7 active (16 max)
         
         
#      name userid uniqueid frag time ping loss adr
         # 1 "[Evil]Pepper" 136 BOT  29  3:03:35    0    0
         # 2 "SiLeNcE" 137 BOT   5  3:03:35    0    0
         # 3 "[EVIL]Saleen[Bot]" 138 BOT  28  3:03:35    0    0
         # 4 "OptimusPrime-rib" 139 BOT  25  3:03:35    0    0
         # 5 "-[ES]-ShAdOw" 140 BOT  41  3:03:35    0    0
         # 6   "TlNY" 129 STEAM_0:0:3771998  25 29:57  102    0 75.25.7.165:27005
         # 7 "ExitDemon[MSI]" 141 BOT  26  3:03:35    0    0
         
7 users 
__________________
+|- KARMA Respectively


Last edited by Mordekay; 05-22-2011 at 02:31. Reason: fixed your meta list
HLM is offline
Mordekay
Squirrel of Fortune
Join Date: Apr 2006
Location: Germany
Old 05-22-2011 , 02:31   Re: Error with SQL
#2

non-steam = no support
__________________

Mordekay is offline
Closed Thread



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 04:13.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode