SA-MP Forums Archive
[REP]Hello,i need help with SQL please help me - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [REP]Hello,i need help with SQL please help me (/showthread.php?tid=529795)


[REP]Hello,i need help with SQL please help me - IbeatS - 04.08.2014

hello ,i need help with mysql ,i put my sql details in gamemode but it say that it cant connect ,please help me ,how to connect the server to sql [note:i host the sql from triangle.gs ,its phpmyadmin]

here is the SQL Details that i put
pawn Код:
#define mysql_host          "37.59.28.180/phpmyadmin"
#define mysql_user          "Ryan_7945"
#define mysql_password      "cantpost"
#define mysql_database      "Ryan_7945"
here is the debug
pawn Код:
[11:54:25]  

[11:54:25] ---------------------------

[11:54:25] MySQL Debugging activated (07/31/14)

[11:54:25] ---------------------------

[11:54:25]  

[11:54:25] >> mysql_connect( )

[11:54:25] CMySQLHandler::CMySQLHandler() - constructor called.

[11:54:25] CMySQLHandler::CMySQLHandler() - Connecting to "37.59.28.180/phpmyadmin" | DB: "Ryan_7945" | Username: "Ryan_7945" ...

[11:54:25] CMySQLHandler::Connect() - Unknown MySQL server host '37.59.28.180/phpmyadmin' (11004) (Error ID: 2005)

[11:54:25] >> mysql_query( Connection handle: 1 )

[11:54:25] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[11:54:25] >> mysql_store_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[11:54:25] >> mysql_num_rows( Connection handle: 1 )

[11:54:25] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[11:54:25] >> mysql_free_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[11:54:25] >> mysql_query( Connection handle: 1 )

[11:54:25] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[11:54:25] >> mysql_store_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[11:54:25] >> mysql_num_rows( Connection handle: 1 )

[11:54:25] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[11:54:25] >> mysql_free_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[11:54:25] >> mysql_query( Connection handle: 1 )

[11:54:25] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[11:54:25] >> mysql_store_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[11:54:25] >> mysql_num_rows( Connection handle: 1 )

[11:54:25] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[11:54:25] >> mysql_free_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[11:54:25] >> mysql_query( Connection handle: 1 )

[11:54:25] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[11:54:25] >> mysql_store_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[11:54:25] >> mysql_num_rows( Connection handle: 1 )

[11:54:25] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[11:54:25] >> mysql_free_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[11:54:25] >> mysql_query( Connection handle: 1 )

[11:54:25] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[11:54:25] >> mysql_store_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[11:54:25] >> mysql_num_rows( Connection handle: 1 )

[11:54:25] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[11:54:25] >> mysql_free_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[11:54:25] >> mysql_query( Connection handle: 1 )

[11:54:25] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[11:54:25] >> mysql_store_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[11:54:25] >> mysql_num_rows( Connection handle: 1 )

[11:54:25] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[11:54:25] >> mysql_free_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[11:54:25] >> mysql_query( Connection handle: 1 )

[11:54:25] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[11:54:25] >> mysql_store_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[11:54:25] >> mysql_num_rows( Connection handle: 1 )

[11:54:25] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[11:54:25] >> mysql_free_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[11:54:25] >> mysql_query( Connection handle: 1 )

[11:54:25] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[11:54:25] >> mysql_store_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[11:54:25] >> mysql_num_rows( Connection handle: 1 )

[11:54:25] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[11:54:25] >> mysql_free_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[11:54:25] >> mysql_query( Connection handle: 1 )

[11:54:25] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[11:54:25] >> mysql_store_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[11:54:25] >> mysql_num_rows( Connection handle: 1 )

[11:54:25] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[11:54:25] >> mysql_free_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[11:54:25] >> mysql_query( Connection handle: 1 )

[11:54:25] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[11:54:25] >> mysql_store_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[11:54:25] >> mysql_num_rows( Connection handle: 1 )

[11:54:25] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[11:54:25] >> mysql_free_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[11:54:25] >> mysql_query( Connection handle: 1 )

[11:54:25] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[11:54:25] >> mysql_store_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[11:54:25] >> mysql_num_rows( Connection handle: 1 )

[11:54:25] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[11:54:25] >> mysql_free_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[11:54:25] >> mysql_query( Connection handle: 1 )

[11:54:25] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[11:54:25] >> mysql_store_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[11:54:25] >> mysql_num_rows( Connection handle: 1 )

[11:54:25] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[11:54:25] >> mysql_free_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)

[11:54:25] >> mysql_query( Connection handle: 1 )

[11:54:25] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)

[11:54:25] >> mysql_store_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)

[11:54:25] >> mysql_num_rows( Connection handle: 1 )

[11:54:25] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[11:54:25] >> mysql_free_result( Connection handle: 1 )

[11:54:25] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)


Re: [REP]Hello,i need help with SQL please help me - McBan - 04.08.2014

Try remove the /phpmyadmin

Also it may be outdated. ( Triangle.gs sql version)

Re: [REP]Hello,i need help with SQL please help me - IbeatS - 04.08.2014

Thanks alot ,all works good