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

Server crashes on every Mapchange


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Schwabba
Senior Member
Join Date: Apr 2008
Old 08-15-2011 , 19:57   Server crashes on every Mapchange
Reply With Quote #1

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: [MySQLThread worker was unable to start.
L 08/15/2011 21:04:59: [AMXXDisplaying debug trace (plugin "amxbans_main.amxx")
L 08/15/2011 21:04:59: [AMXXRun time error 10native error (native "SQL_ThreadQuery")
L 08/15/2011 21:04:59: [AMXX]    [0check_flag.inl::check_flagged (line 36)
L 08/15/2011 21:04:59: [AMXX]    [1check_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: [MySQLInvalid database handle9
L 08
/15/2011 23:42:10: [AMXXRun time error 10 (plugin "verbote_main.amxx") (native "SQL_QuoteString") - debug not enabled!
L 08/15/2011 23:42:10: [AMXXTo enable debug modeadd "debug" after the plugin name in plugins.ini (without quotes).
L 08/15/2011 23:42:10: [MySQLInvalid database handle1
L 08
/15/2011 23:42:10: [AMXXDisplaying debug trace (plugin "furienmod.amxx")
L 08/15/2011 23:42:10: [AMXXRun time error 10native error (native "SQL_QuoteString")
L 08/15/2011 23:42:10: [AMXX]    [0furienmod.sma::register_client (line 4783)
L 08/15/2011 23:42:10: [MySQLInvalid database handle9
L 08
/15/2011 23:42:10: [AMXXRun time error 10 (plugin "verbote_main.amxx") (native "SQL_QuoteString") - debug not enabled!
L 08/15/2011 23:42:10: [AMXXTo enable debug modeadd "debug" after the plugin name in plugins.ini (without quotes).
L 08/15/2011 23:42:10: [MySQLInvalid database handle1
L 08
/15/2011 23:42:10: [AMXXDisplaying debug trace (plugin "furienmod.amxx")
L 08/15/2011 23:42:10: [AMXXRun time error 10native error (native "SQL_QuoteString")
L 08/15/2011 23:42:10: [AMXX]    [0furienmod.sma::register_client (line 4783
Line 4783 on furien.sma is:

PHP Code:
new szSteamId[32], szName[32], szQuotedName[64]
get_user_authid(idszSteamIdcharsmax(szSteamId))
get_user_name(idszName31)
SQL_QuoteString(g_SqlConnectionszQuotedName63szName// <- 4783 
The Serverhoster said they have no idea and the uptime is > days.

Someone know that problem already and can help me?
Schwabba is offline
ARES[ro]
Senior Member
Join Date: Apr 2010
Old 08-15-2011 , 20:23   Re: Server crashes on every Mapchange
Reply With Quote #2

Turn on debug on verbote_main.amxx and post the logs.
__________________
okay
ARES[ro] is offline
APPLESAUCE
Junior Member
Join Date: Aug 2011
Old 08-15-2011 , 20:25   Re: Server crashes on every Mapchange
Reply With Quote #3

It seems that the source code's MySQL isn't dated the same as your MySQL.
APPLESAUCE is offline
Schwabba
Senior Member
Join Date: Apr 2008
Old 08-15-2011 , 20:35   Re: Server crashes on every Mapchange
Reply With Quote #4

Quote:
Originally Posted by ARES[ro] View Post
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 View Post
It seems that the source code's MySQL isn't dated the same as your MySQL.
I know, but how to fix it?
Schwabba is offline
APPLESAUCE
Junior Member
Join Date: Aug 2011
Old 08-15-2011 , 20:48   Re: Server crashes on every Mapchange
Reply With Quote #5

Did you update recently?
APPLESAUCE is offline
ARES[ro]
Senior Member
Join Date: Apr 2010
Old 08-15-2011 , 20:50   Re: Server crashes on every Mapchange
Reply With Quote #6

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?
__________________
okay
ARES[ro] is offline
APPLESAUCE
Junior Member
Join Date: Aug 2011
Old 08-15-2011 , 23:25   Re: Server crashes on every Mapchange
Reply With Quote #7

All I can think of to do is, use the same MySQL version that everything else has that you are using.
APPLESAUCE is offline
ARES[ro]
Senior Member
Join Date: Apr 2010
Old 08-16-2011 , 00:26   Re: Server crashes on every Mapchange
Reply With Quote #8

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.
__________________
okay
ARES[ro] is offline
Schwabba
Senior Member
Join Date: Apr 2008
Old 08-16-2011 , 13:56   Re: Server crashes on every Mapchange
Reply With Quote #9

PHP Code:
MySQL

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

Webserver

    Apache
    MySQL
-Client-Version5.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
Schwabba is offline
Exolent[jNr]
Veteran Member
Join Date: Feb 2007
Location: Tennessee
Old 08-16-2011 , 13:58   Re: Server crashes on every Mapchange
Reply With Quote #10

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.
__________________
No private work or selling mods.
Quote:
Originally Posted by xPaw View Post
I love you exolent!
Exolent[jNr] is offline
Reply


Thread Tools
Display Modes

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 22:08.


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