|
Jareth
|
 |
« on: August 14, 2010, 09:40:57 AM » |
|
[SM] Detected parse error(s) in file "/home/kd10069/server/v2_27090/orangebox/cstrike/addons/sourcemod/configs/databases.cfg" [War3Source.smx] [War3Source] ERROR: DBIDB invalid handle, Check SourceMod database config, could not connect. It creates itself a database table `? My Config : "Databases"
{
"driver_default" "mysql"
{
"driver" "sqlite"
"host" "85.10.205.232"
"database" "jareth_server_1"
"user" "jareth_user"
"pass" "****"
//"timeout" "0"
//"port" "0"
}
"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}
"war3"
{
"driver" "sqlite"
"host" "85.10.205.232"
"database" "jareth_server_1"
"user" "jareth_user"
"pass" "*****"
}
}
08/14/2010 - 17:52:46: [war3source_convertDB_useONCE.smx] [War3Source] ERROR: DBIDB invalid handle, Check SourceMod database config, could not connect.
L 08/14/2010 - 17:52:46: [war3source_convertDB_useONCE.smx] ERRMSG:(Configuration "default" not found)
L 08/14/2010 - 17:52:46: [SM] Native "SQL_Query" reported: Invalid database Handle 0 (error: 4)
L 08/14/2010 - 17:52:46: [SM] Displaying call stack trace for plugin "war3source_convertDB_useONCE.smx":
L 08/14/2010 - 17:52:46: [SM] [0] Line 93, war3source_convertDB.sp::next1()
L 08/14/2010 - 17:52:46: [SM] [1] Line 79, war3source_convertDB.sp::convert() |
|
|
|
« Last Edit: August 14, 2010, 09:54:16 AM by Jareth »
|
Logged
|
|
|
|
|
Ownz
|
|
« Reply #1 on: August 14, 2010, 11:58:57 AM » |
|
"default"
{
"driver" "sqlite"
"host" "localhost"
"database" "war3"
"user" "none"
"pass" "none"
//"timeout" "0"
//"port" "0"
}
|
|
|
|
|
Logged
|
 DarkEnergy |
|
|
|
Jareth
|
|
« Reply #2 on: August 14, 2010, 12:14:32 PM » |
|
Okay i have  [War3Source] Plugin loading...
[War3Source] Game set: Counter-Strike Source g_Game 1
--------------------------OnPluginStart----------------------
[War3Source] SQL connection successful, driver sqlite
[War3Source] Plugin finished loading.
-------------------END OnPluginStart---- ---------------------------------------------- this is new Problem : nAllPluginsLoaded
War3Source_SQLTable war3source table check handling
[War3Source] Dropping war3sourceraces and recreating it (normal)
L 08/14/2010 - 20:06:05: [War3Source.smx] SQLFastQuery DROP TABLE war3sourceraces failed, Error: no such table: war3sourceraces
[War3Source] Table: war3sourceraces didnt exist or failed to drop it
[War3Source] Dropping war3source main table and recreating it!!!
L 08/14/2010 - 20:06:05: [War3Source.smx] SQLFastQuery DROP TABLE war3source failed, Error: no such table: war3source |
|
|
|
|
Logged
|
|
|
|
|
Ownz
|
|
« Reply #3 on: August 14, 2010, 12:20:12 PM » |
|
normal first load
|
|
|
|
|
Logged
|
DarkEnergy |
|
|
|
Jareth
|
|
« Reply #4 on: August 14, 2010, 12:34:54 PM » |
|
The sever hasn't created a table at the database. It's created after a mapchange look here http://kd10069-web.os.gs/ |
|
|
|
« Last Edit: August 14, 2010, 04:43:56 PM by Jareth »
|
Logged
|
|
|
|
|
Ownz
|
|
« Reply #5 on: August 15, 2010, 09:08:31 PM » |
|
its still not created?
|
|
|
|
|
Logged
|
DarkEnergy |
|
|
|
Jareth
|
|
« Reply #6 on: August 16, 2010, 01:37:25 AM » |
|
yes i no createt table.. OnAllPluginsLoaded
War3Source_SQLTable war3source table check handling
[War3Source] Dropping war3sourceraces and recreating it (normal)
L 08/16/2010 - 09:48:10: [admin-flatfile.smx] Error(s) detected parsing addons/sourcemod/configs/admins.cfg
L 08/16/2010 - 09:48:10: [admin-flatfile.smx] (line 78) Section ending without a matching section beginning
ConVarRef room_type doesn't point to an existing ConVar
Executing dedicated server config file |
|
|
|
« Last Edit: August 16, 2010, 01:49:46 AM by Jareth »
|
Logged
|
|
|
|
|
Ownz
|
|
« Reply #7 on: August 16, 2010, 08:37:44 AM » |
|
error logs?
|
|
|
|
|
Logged
|
DarkEnergy |
|
|
|
Jareth
|
|
« Reply #8 on: August 16, 2010, 09:23:00 AM » |
|
VAC secure mode is activated.
[War3Source] SQL connection successful, driver sqlite
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_undead
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_human
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_orc
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_mage
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_nightelf
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_dr
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_tbr
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_druidt
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_bmaster
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_hunter
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_warden
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_crypt
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_cd
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_succubus
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_sr
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_bh
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_naix
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_headcrab
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_clockwerk
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_gtinker
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_lich
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_keeper
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_taurenc
L 08/16/2010 - 09:53:11: [war3source_convertDB_useONCE.smx] ERR Could not select: SELECT * from war3source_necro |
|
|
|
|
Logged
|
|
|
|
|
Ownz
|
|
« Reply #9 on: August 16, 2010, 09:27:21 AM » |
|
its connecting to sqlite not mysql
[War3Source] SQL connection successful, driver sqlite
|
|
|
|
|
Logged
|
DarkEnergy |
|
|
|
Jareth
|
|
« Reply #10 on: August 16, 2010, 09:31:30 AM » |
|
"Databases"
{
"driver_default" "mysql"
"default"
{
"driver" "sqlite"
"host" "78.46.76.120"
"database" "server1_wa3"
"user" "Jareth"
"pass" "*****"
"timeout" "5"
"port" "3306"
}
"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}
} |
|
|
|
|
Logged
|
|
|
|
|
Ownz
|
|
« Reply #11 on: August 16, 2010, 09:33:54 AM » |
|
"driver" "mysql"
"host" "78.46.76.120"
|
|
|
|
|
Logged
|
DarkEnergy |
|
|
|
Jareth
|
|
« Reply #12 on: August 16, 2010, 09:43:49 AM » |
|
it is right? "Databases"
{
"driver_default" "mysql"
"default"
{
"driver" "sqlite"
"host" "78.46.76.120"
"database" "server1_wa3"
"user" "Jareth"
"pass" "*****"
"timeout" "5"
"port" "3306"
}
"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}
"war3stats"
{
"driver" "mysql"
"host" "78.46.76.120"
"database" "server1_wa3"
"user" "Jareth"
"pass" "*****"
"timeout" "5"
"port" "3306"
}
} |
|
|
|
|
Logged
|
|
|
|
|
Ownz
|
|
« Reply #13 on: August 16, 2010, 09:45:21 AM » |
|
delete "war3stats"
edit
"default"
{
"driver" "sqlite"
"host" "78.46.76.120"
to
"default"
{
"driver" "mysql"
"host" "78.46.76.120"
|
|
|
|
|
Logged
|
DarkEnergy |
|
|
|
Jareth
|
|
« Reply #14 on: August 16, 2010, 09:49:49 AM » |
|
it is rigth ? "Databases"
{
"driver_default" "mysql"
"default"
{
"driver" "mysql"
"host" "78.46.76.120"
"database" "server1_wa3"
"user" "Jareth"
"pass" "*****"
"timeout" "5"
"port" "3306"
}
"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}
|
|
|
|
|
Logged
|
|
|
|
|
Ownz
|
|
« Reply #15 on: August 16, 2010, 09:50:38 AM » |
|
should work now with the correct hostname user and password
|
|
|
|
|
Logged
|
DarkEnergy |
|
|
|
Jareth
|
|
« Reply #16 on: August 16, 2010, 10:16:16 AM » |
|
|
|
|
|
|
Logged
|
|
|
|
|
Poll
