1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
[REP]Hello,i need help with SQL please help me
IbeatS
Banned
Posts: 62
Threads: 20
Joined: Nov 2013
#1

04.08.2014, 01:54
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)
Find
Reply
McBan
Huge Clucker
***
Posts: 237
Threads: 38
Joined: Apr 2012
Reputation: 0
#2

04.08.2014, 01:56
Try remove the /phpmyadmin

Also it may be outdated. ( Triangle.gs sql version)
Find
Reply
IbeatS
Banned
Posts: 62
Threads: 20
Joined: Nov 2013
#3

04.08.2014, 02:09
Thanks alot ,all works good
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help