mysql - can't read tables
#1

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)
what is the problem with that?..
thank's a lot
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)