AlliedModders - Server crashes on every Mapchange

AlliedModders (https://forums.alliedmods.net/index.php)

- Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)

- - Server crashes on every Mapchange (https://forums.alliedmods.net/showthread.php?t=164792)

Server crashes on every Mapchange

Hi,

i got a very annoying problem here. We installed AMXBans GM Version on our Server, because with the old AMXBans, the people we're able to unban their own. After we installed it, the server crashed every time the map was changed. We tried to fix this with installing the old AMXBans Plugin with the new GM Website - and it worked. Today we updated AMXModX to fix some exploits, but now the problem came back. We tried it with the old and the new AMXBans plugins, but the problem is on both versions now. I think it is because the new MySQL module. Before we updated AMXModX, we never got an errormessage until today.

PHP Code:


		
			
L 08/15/2011 - 21:04:59: [MySQL] Thread worker was unable to start.
L 08/15/2011 - 21:04:59: [AMXX] Displaying debug trace (plugin "amxbans_main.amxx")
L 08/15/2011 - 21:04:59: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery")
L 08/15/2011 - 21:04:59: [AMXX]    [0] check_flag.inl::check_flagged (line 36)
L 08/15/2011 - 21:04:59: [AMXX]    [1] check_player.inl::check_player_ (line 100)

This error came alot of times, till we installed the AMXBans GM plugin again. After we did it, we received another errors, this time the errors came from my plugins:

PHP Code:


		
			
L 08/15/2011 - 23:42:10: [MySQL] Invalid database handle: 9
L 08/15/2011 - 23:42:10: [AMXX] Run time error 10 (plugin "verbote_main.amxx") (native "SQL_QuoteString") - debug not enabled!
L 08/15/2011 - 23:42:10: [AMXX] To enable debug mode, add "debug" after the plugin name in plugins.ini (without quotes).
L 08/15/2011 - 23:42:10: [MySQL] Invalid database handle: 1
L 08/15/2011 - 23:42:10: [AMXX] Displaying debug trace (plugin "furienmod.amxx")
L 08/15/2011 - 23:42:10: [AMXX] Run time error 10: native error (native "SQL_QuoteString")
L 08/15/2011 - 23:42:10: [AMXX]    [0] furienmod.sma::register_client (line 4783)
L 08/15/2011 - 23:42:10: [MySQL] Invalid database handle: 9
L 08/15/2011 - 23:42:10: [AMXX] Run time error 10 (plugin "verbote_main.amxx") (native "SQL_QuoteString") - debug not enabled!
L 08/15/2011 - 23:42:10: [AMXX] To enable debug mode, add "debug" after the plugin name in plugins.ini (without quotes).
L 08/15/2011 - 23:42:10: [MySQL] Invalid database handle: 1
L 08/15/2011 - 23:42:10: [AMXX] Displaying debug trace (plugin "furienmod.amxx")
L 08/15/2011 - 23:42:10: [AMXX] Run time error 10: native error (native "SQL_QuoteString")
L 08/15/2011 - 23:42:10: [AMXX]    [0] furienmod.sma::register_client (line 4783)

Line 4783 on furien.sma is:

PHP Code:


		
			
new szSteamId[32], szName[32], szQuotedName[64]
get_user_authid(id, szSteamId, charsmax(szSteamId))
get_user_name(id, szName, 31)
SQL_QuoteString(g_SqlConnection, szQuotedName, 63, szName) // <- 4783

The Serverhoster said they have no idea and the uptime is > days.

Someone know that problem already and can help me?

Re: Server crashes on every Mapchange

Turn on debug on verbote_main.amxx and post the logs.

Re: Server crashes on every Mapchange

It seems that the source code's MySQL isn't dated the same as your MySQL.

Re: Server crashes on every Mapchange

Quote:

Originally Posted by ARES[ro] (Post 1533461)

Turn on debug on verbote_main.amxx and post the logs.

Woul'nt change much, because there are no errormessages again.

Quote:

Originally Posted by APPLESAUCE (Post 1533464)

It seems that the source code's MySQL isn't dated the same as your MySQL.

I know, but how to fix it?

Re: Server crashes on every Mapchange

Did you update recently?

Re: Server crashes on every Mapchange

Well I actually see invalid connection handle error, to me all that says is that, it didnt succeed to make a connection and the mod is still acting like it actually did.

Apart from that what else can I say to help you with the given information?

I could even make sure the host does not have any kind of restrictions blocking your mysql ports, or something, some do so you dont do additional hosting that should be illegal...

Uhhh other then that somebody bring a priest?

Re: Server crashes on every Mapchange

All I can think of to do is, use the same MySQL version that everything else has that you are using.

Re: Server crashes on every Mapchange

I hope your talking about the module and not the mysql server. You should set up a listen server with it see if you get the same problems.

Re: Server crashes on every Mapchange

PHP Code:


		
			
MySQL

    Server: * via TCP/IP
    Server Version: 5.1.43-nmm4-log
    Protokoll-Version: 10
    Benutzer: *
    MySQL-Zeichensatz: UTF-8 Unicode (utf8)

Webserver

    Apache
    MySQL-Client-Version: 5.1.43
    PHP Erweiterung: mysql Dokumentation

phpMyAdmin

    Versionsinformationen: 3.4.3.2

PHP Code:


		
			
AMX Mod X 1.8.1.3711 (http://www.amxmodx.org)

PHP Code:


		
			
Metamod v1.19p32  2007/08/12 (5:13)

Re: Server crashes on every Mapchange

Show the full code.

Also, you don't have to use SQL_QuoteString().
If you know the format of the queries, you can replace the escape characters easily.