mysql - can't read tables - 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 - can't read tables (/showthread.php?tid=362179)
+- 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 - can't read tables (/showthread.php?tid=362179)
mysql - can't read tables - EviLpRo - 23.07.2012
hey,
I managed to fix this problem: https://sampforum.blast.hk/showthread.php?tid=362171
but have more problem....
the connection to database is fine.
but is not found any table...
mysql_debug:
Код:
[12:56:27] >> mysql_connect( ) [12:56:27] CMySQLHandler::CMySQLHandler() - constructor called. [12:56:27] CMySQLHandler::CMySQLHandler() - Connecting to "gtazone.co.il" | DB: "gtazone_dm" | Username: "gtazone_dm" ... [12:56:28] CMySQLHandler::Connect() - Connection was successful. [12:56:28] CMySQLHandler::Connect() - Auto-Reconnect has been enabled. [12:56:28] >> mysql_query( Connection handle: 1 ) [12:56:28] CMySQLHandler::Query(ALTER TABLE `Users` ADD `Minigun` INT DEFAULT 0) - An error has occured. (Error ID: 1146, Table 'gtazone_dm.Users' doesn't exist) [12:56:28] >> mysql_query( Connection handle: 1 ) [12:56:28] CMySQLHandler::Query(ALTER TABLE `Users` ADD `Karting` INT DEFAULT 0) - An error has occured. (Error ID: 1146, Table 'gtazone_dm.Users' doesn't exist) [12:56:28] >> mysql_query( Connection handle: 1 ) [12:56:28] CMySQLHandler::Query(ALTER TABLE `Users` ADD `SandKings` INT DEFAULT 0) - An error has occured. (Error ID: 1146, Table 'gtazone_dm.Users' doesn't exist) [12:56:28] >> mysql_query( Connection handle: 1 ) [12:56:28] CMySQLHandler::Query(ALTER TABLE `Users` ADD `WAR` INT DEFAULT 0) - An error has occured. (Error ID: 1146, Table 'gtazone_dm.Users' doesn't exist) [12:56:28] >> mysql_query( Connection handle: 1 ) [12:56:28] CMySQLHandler::Query(ALTER TABLE `Users` ADD `Gunz` INT DEFAULT 0) - An error has occured. (Error ID: 1146, Table 'gtazone_dm.Users' doesn't exist) [12:56:28] >> mysql_query( Connection handle: 1 ) [12:56:28] CMySQLHandler::Query(ALTER TABLE `Users` ADD `Dumpers` INT DEFAULT 0) - An error has occured. (Error ID: 1146, Table 'gtazone_dm.Users' doesn't exist) [12:56:28] >> mysql_query( Connection handle: 1 ) [12:56:28] CMySQLHandler::Query(ALTER TABLE `Users` ADD `RWar` INT DEFAULT 0) - An error has occured. (Error ID: 1146, Table 'gtazone_dm.Users' doesn't exist) [12:56:28] >> mysql_query( Connection handle: 1 ) [12:56:28] CMySQLHandler::Query(ALTER TABLE `Users` ADD `Sultans` INT DEFAULT 0) - An error has occured. (Error ID: 1146, Table 'gtazone_dm.Users' doesn't exist) [12:56:28] >> mysql_query( Connection handle: 1 ) [12:56:28] CMySQLHandler::Query(SELECT `StartServer` FROM `Server`) - An error has occured. (Error ID: 1146, Table 'gtazone_dm.Server' doesn't exist) [12:56:28] >> mysql_store_result( Connection handle: 1 ) [12:56:28] CMySQLHandler::StoreResult() - No data to store. [12:56:28] >> mysql_fetch_row_format( Connection handle: 1 ) [12:56:28] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result) [12:56:28] >> mysql_free_result( Connection handle: 1 ) [12:56:28] CMySQLHandler::FreeResult() - The result is already empty. [12:56:28] >> mysql_query( Connection handle: 1 ) [12:56:28] CMySQLHandler::Query(UPDATE `Server` SET `StartServer`='23.7.2012') - An error has occured. (Error ID: 1146, Table 'gtazone_dm.Server' doesn't exist) [12:56:28] >> mysql_query( Connection handle: 1 ) [12:56:28] CMySQLHandler::Query(SELECT `ID` FROM `Clans`) - An error has occured. (Error ID: 1146, Table 'gtazone_dm.Clans' doesn't exist) [12:56:28] >> mysql_store_result( Connection handle: 1 ) [12:56:28] CMySQLHandler::StoreResult() - No data to store. [12:56:28] >> mysql_retrieve_row( Connection handle: 1 ) [12:56:28] CMySQLHandler::RetrieveRow() - You cannot call this function now. (Reason: Empty Result)
thank's a lot
