SA-MP Forums Archive
mysql not connecting - 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: mysql not connecting (/showthread.php?tid=385627)


mysql not connecting - Crazyboobs - 16.10.2012

hello
i tried to connect the mysql but it is not connecting. here is the debug log

Quote:

[01:51:54] ---------------------------

[01:51:54] MySQL Debugging activated (10/17/12)

[01:51:54] ---------------------------

[01:51:54]

[01:52:06] >> mysql_query( Connection handle: 1 )

[01:52:06] CMySQLHandler::Query(SELECT IP FROM `data` WHERE user = 'Lifeguard' LIMIT 1) - An error has occured. (Error ID: 1146, Table 'vortex.data' doesn't exist)

[01:52:06] >> mysql_store_result( Connection handle: 1 )

[01:52:06] CMySQLHandler::StoreResult() - No data to store.

[01:52:06] >> mysql_num_rows( Connection handle: 1 )

[01:52:06] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[01:52:06] >> mysql_free_result( Connection handle: 1 )

[01:52:06] CMySQLHandler::FreeResult() - The result is already empty.

[01:52:06] >> mysql_query( Connection handle: 1 )

[01:52:06] CMySQLHandler::Query(SELECT IP FROM `data` WHERE user = 'SFPolice' LIMIT 1) - An error has occured. (Error ID: 1146, Table 'vortex.data' doesn't exist)

[01:52:06] >> mysql_store_result( Connection handle: 1 )

[01:52:06] CMySQLHandler::StoreResult() - No data to store.

[01:52:06] >> mysql_num_rows( Connection handle: 1 )

[01:52:06] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[01:52:06] >> mysql_free_result( Connection handle: 1 )

[01:52:06] CMySQLHandler::FreeResult() - The result is already empty.

[01:52:06] >> mysql_query( Connection handle: 1 )

[01:52:06] CMySQLHandler::Query(SELECT IP FROM `data` WHERE user = 'Rollerskater' LIMIT 1) - An error has occured. (Error ID: 1146, Table 'vortex.data' doesn't exist)

[01:52:06] >> mysql_store_result( Connection handle: 1 )

[01:52:06] CMySQLHandler::StoreResult() - No data to store.

[01:52:06] >> mysql_num_rows( Connection handle: 1 )

[01:52:06] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[01:52:06] >> mysql_free_result( Connection handle: 1 )

[01:52:06] CMySQLHandler::FreeResult() - The result is already empty.

[01:52:06] >> mysql_query( Connection handle: 1 )

[01:52:06] CMySQLHandler::Query(SELECT IP FROM `data` WHERE user = 'USTourist' LIMIT 1) - An error has occured. (Error ID: 1146, Table 'vortex.data' doesn't exist)

[01:52:06] >> mysql_store_result( Connection handle: 1 )

[01:52:06] CMySQLHandler::StoreResult() - No data to store.

[01:52:06] >> mysql_num_rows( Connection handle: 1 )

[01:52:06] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)

[01:52:06] >> mysql_free_result( Connection handle: 1 )

[01:52:06] CMySQLHandler::FreeResult() - The result is already empty.


Re: mysql not connecting - mastermax7777 - 16.10.2012

(Error ID: 1146, Table 'vortex.data' doesn't exist) means u need to create TABLE `DATA` (in vortex database) and all the columns (ip) befor writing to it