[OvidiuS]

#include < amxmodx >
#include < sqlx >

new Handle:MYSQL_Tuple      = Empty_Handle;
new Handle:MYSQL_Connect    = Empty_Handle;

public plugin_init( ) 
{
    register_plugin( "New Plug-In", "1.0", "Author" );
    MYSQL_Load( );
}

public plugin_end( )
{
    MYSQL_Close( );
}

public MYSQL_Load( )
{
    MYSQL_Tuple = SQL_MakeDbTuple( "hostname", "username", "password", "database" );

    if( MYSQL_Tuple == Empty_Handle ) 
        return;

    new sError[ 512 ], iError;
    MYSQL_Connect = SQL_Connect( MYSQL_Tuple, iError, sError, charsmax( sError ) );

    if( MYSQL_Connect == Empty_Handle )
        set_fail_state( sError );
}

public MYSQL_Close( )
{
    if( MYSQL_Connect != Empty_Handle )
        SQL_FreeHandle( MYSQL_Connect );

    if( MYSQL_Tuple != Empty_Handle )
        SQL_FreeHandle( MYSQL_Tuple );
}

This code is crashing my server on mapchange. I have no idea what is the problem. There is no error logs.
It's remote database.

[aron9forever]

switch to threaded sql

[OvidiuS]

Originally Posted by aron9forever switch to threaded sql

That does not explain why is server crashing.

[YamiKaitou]

What testing have you done that makes you believe it is a problem with that plugin?

[OvidiuS]

#include < amxmodx >
#include < sqlx >

new Handle:MYSQL_Tuple      = Empty_Handle
new Handle:MYSQL_Connect    = Empty_Handle

public plugin_init( ) 
{
    register_plugin( "New Plug-In", "1.0", "Author" );
    MYSQL_Load( );
}

public plugin_end( )
{
    MYSQL_Close( )
}

public MYSQL_Load( )
{
    log_to_file( "sql_test.log", "Calling SQL_MakeDbTuple." );

    MYSQL_Tuple = SQL_MakeDbTuple( "hostname", "username", "password", "database" );

    log_to_file( "sql_test.log", "Called SQL_MakeDbTuple." );

    if( MYSQL_Tuple == Empty_Handle )
    {
        log_to_file( "sql_test.log", "Failed to create SQL Tuple" );
        return;
    }

    log_to_file( "sql_test.log", "Created SQL Tuple." );

    new sError[ 512 ], iError;

    log_to_file( "sql_test.log", "Calling SQL_Connect." );

    MYSQL_Connect = SQL_Connect( MYSQL_Tuple, iError, sError, charsmax( sError ) );

    log_to_file( "sql_test.log", "Called SQL_Connect." );

    if( MYSQL_Connect == Empty_Handle )
    {
        log_to_file( "sql_test.log", "Failed to connect: %s", sError );
        return;
    }

    log_to_file( "sql_test.log", "Successfully connected." );
    SQL_FreeHandle( MYSQL_Connect );
}

public MYSQL_Close( )
{
    if( MYSQL_Connect != Empty_Handle )
        SQL_FreeHandle( MYSQL_Connect );

    if( MYSQL_Tuple != Empty_Handle )
        SQL_FreeHandle( MYSQL_Tuple );
}

My log was stuck on "Calling SQL_Connect." I disabled all third party plugins and enabled default amxx plugins. Amxx version i used is 1.8.2.
When using threaded queries log says that connection to database failed. When using plugin posted above, server is crashed.

Maybe there is problem with database i'm using, but still, should whole server crash if sql can't connect to database?

[^SmileY]

You have added your address in remote host to allow external conections?