[TheOne]

Hi,

I think i have found my problem with the amx vs mysql.

If i set log_details 1 in my server.cfg, i can see the modules that the server is loading during the startup.
But no matter what i do, i can't see mysql_amx_i386.so. (and yes, i have enabled it, in the modulescfg's)

I really don't know why, and so fare i have tried everything.
I have even tried to switch my entire system. (from Mandrake to RedHat)

Is there anyone else, that have this problem, or maybe a solution.

Cause i can't get the amx to work with mysql. :-(

[ 1] AMX Mod X RUN - amxx_mm_i386.so v0.16 ini ANY ANY [ 2] Fun RUN - fun_amx_i386.so v0.16 cmd ANY ANY [ 3] ENGINE RUN - engine_amx_i386. v0.16 cmd ANY ANY [ 4] Counter-Strike RUN - cstrike_amx_i386 v0.16 ST cmd Pause Pause [ 5] CS Stats RUN - csstats_amx_i386 v0.16 cmd ANY ANY

[PM]

the mysql module isnt loaded by metamod. You are showing us metamod output. Start the server (= start a map) and type "amxx modules" (without quotes)

[BAILOPAN]

all the modules there are hooked by metamod. I'm guessing you're typing "meta list", instead "amxx modules", which shows the modules AMXx controls rather than the ones Metamod is hooking.

Sorry ;] that's a lot of fustration over something that simple


[EDIT] ahh PM you beat me too it =P

[TheOne]

Thx for the quick reply.

I will now show you my files, so you can see, that i am not doing anything wrong. (perhaps )

This is my plugins.ini:
/home/halflife/hlds_l/czero/addons/metamod

linux addons/amxx/dlls/amxx_mm_i386.so

This is my modules.ini
/home/halflife/hlds_l/czero/addons/amxx

; AMX Mod X Modules; You can specify both linux & win32 modules here ; Fun - This has extra functions ;fun_amx.dll fun_amx_i386.so ; Engine - This has engine functions core to half-life ;engine_amx.dll engine_amx_i386.so ; MySQL - This adds MySQL connection support ;mysql_amx.dll mysql_amx_i386.so ; Counter-Strike - This adds functions specific to Counter-Strike ;cstrike_amx.dll cstrike_amx_i386.so ; CS Stats - This adds functionality for CS statistical information ;csstats_amx.dll csstats_amx_i386.so

This is my plugins.ini
/home/halflife/hlds_l/czero/addons/amxx

;admin.amx ; admin base (required for any admin-related)^M amxbans.amx admin_mysql.amx ; admin base - MySQL version (comment admin.amx)^M admincmd.amx ; basic admin console commands^M adminhelp.amx ; help command for admin console commands^M adminslots.amx ; slot reservation^M menufront.amx ; front-end for admin menus^M cmdmenu.amx ; command menu (speech, settings)^M plmenu.amx ; players menu (kick, ban, client cmds.)^M ;restmenu.amx ; restrict weapons menu^M ;telemenu.amx ; teleport menu (Fun Module required!)^M mapsmenu.amx ; maps menu (vote, changelevel)^M antiflood.amx ; prevent clients from chat-flooding the server^M adminchat.amx ; console chat commands^M adminvote.amx ; vote commands^M nextmap.amx ; displays next map in mapcycle^M timeleft.amx ; displays time left on map^M mapchooser.amx ; allows to vote for next map^M scrollmsg.amx ; displays a scrolling message^M ;imessage.amx ; displays information messages^M welcomemsg.amx ; displays motd @ client connection^M pausecfg.amx ; allows to pause and unpause some plugins^M stats.amx ; stats on death or round end (CSStats Module required!)^M stats_logging.amx ; weapons stats logging (CSStats Module required!)^M miscstats.amx ; bunch of events announcement for Counter-Strike^M statscfg.amx ; allows to manage stats plugins via menu and commands^M warcraft3FT.amx ; Wacraft 3 Frozen Throne

Do you need more info? Please tell me.

[TheOne]

Hmmmmm, sorry for the doublepost.

I have now tried the amxx modules command, and it seem like i have mysql running.

meta list Currently loaded plugins: description stat pend file vers src load unlod [ 1] AMX Mod X RUN - amxx_mm_i386.so v0.16 ini ANY ANY [ 2] Fun RUN - fun_amx_i386.so v0.16 cmd ANY ANY [ 3] ENGINE RUN - engine_amx_i386. v0.16 cmd ANY ANY [ 4] Counter-Strike RUN - cstrike_amx_i386 v0.16 ST cmd Pause Pause [ 5] CS Stats RUN - csstats_amx_i386 v0.16 cmd ANY ANY 5 plugins, 5 running amxx modules Currently loaded modules: name type version author status [ 1] CS Stats amx&mm 0.16 AMX Mod X Dev Team running [ 2] Counter-Strike amx&mm 0.16 ST AMX Mod X Dev Team running [ 3] ENGINE amx&mm 0.16 AMX Mod X Dev Team running [ 4] Fun amx&mm 0.16 AMX Mod X Dev Team running [ 5] MySQL amx 0.1 AMX Mod X Dev Team running 5 modules, 5 correct

So now i'm really lost. I have tried to get help from YoMama, but he can't solve my problem. I have also tried another person, but couldn't either.

The problem MUST be in amxbans.amx then. (amxbans 2.0)

This is what it says in the logfiles:

[AMXX] Loaded 0 admins from database L 04/29/2004 - 17:17:43: "[TheOne] Ivan<13><BOT><>" joined team "CT" L 04/29/2004 - 17:17:43: "[TheOne] Xander<12><BOT><>" entered the game L 04/29/2004 - 17:17:43: World triggered "Game_Commencing" L 04/29/2004 - 17:17:43: World triggered "Game_Commencing" (CT "0") (T "0") L 04/29/2004 - 17:17:43: World triggered "Round_End" L 04/29/2004 - 17:17:43: "[TheOne] Chet<14><BOT><>" joined team "CT" L 04/29/2004 - 17:17:43: "[TheOne] Chet<14><BOT><>" entered the game L 04/29/2004 - 17:17:43: "[TheOne] Hank<15><BOT><>" joined team "TERRORIST" L 04/29/2004 - 17:17:43: "[TheOne] Hank<15><BOT><>" entered the game L 04/29/2004 - 17:17:43: "[TheOne] Chad<16><BOT><>" joined team "TERRORIST" L 04/29/2004 - 17:17:43: "[TheOne] Chad<16><BOT><>" entered the game L 04/29/2004 - 17:17:44: "[TheOne] Tony<17><BOT><>" joined team "CT" L 04/29/2004 - 17:17:44: "[TheOne] Tony<17><BOT><>" entered the game L 04/29/2004 - 17:17:44: "[TheOne] Wade<18><BOT><>" joined team "TERRORIST" L 04/29/2004 - 17:17:44: "[TheOne] Wade<18><BOT><>" entered the game L 04/29/2004 - 17:17:44: "[TheOne] Vinny<19><BOT><>" joined team "CT" L 04/29/2004 - 17:17:44: "[TheOne] Vinny<19><BOT><>" entered the game [AMXX] MYSQL error: You have an error in your SQL sy

[AMXX] MYSQL error: You have an error in your SQL sy <---- This is the line that i don't like. I have tried the automated setup.php that ships with the plugin, but still the same.

I'm have almost given up now. sorry!

Just odd though, cause i have installed a thousand of databases in my life, but never a problem like this.

[BAILOPAN]

mysql module is CRAP (which I'm not surprised, as dJeyL programmed it - sorry dJeyL, but it's crap)

I'm rewriting it from scratch for 0.20...

[TheOne]

Do you have any ideas of, when you will be releasing 0.2?

And if version 0.2 solves my problem, i owe you beer's. (Carlsberg)