mysql not connecting
#1

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.
Reply
#2

(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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)