Raised This Month: $51 Target: $400
 12% 

[CS:S/CS:GO/TF2] shavit's bhoptimer (v2.5.5a 08/August/2019)


Post New Thread Reply   
 
Thread Tools Display Modes
SpiZe
Junior Member
Join Date: Jul 2016
Old 07-25-2016 , 22:16   Re: [CS:S/CS:GO] shavit's simple bhop timer (1.4b 21/September/2015)
Reply With Quote #721

Hi shavit,

I'm really confused here, I had my own server up and running fine with your timer and everything so I decided to help a friend set up his. After everything was installed we tried running the server but the plugin crashed with "unknown database : 'shavit'. I thought it was a problem with his database.cfg but everything was fine, I even sent him my own databases.cfg to make sure. So I thought it might be a problem with his MySQL install, so we wiped everything on his end, and I did the same on mine. Now we both get the same error with a fresh install of MySQL and I don't really know what's causing it. Have any ideas ?

Code:
L 07/25/2016 - 22:12:00: [SM] Exception reported: Plugin not runnable
L 07/25/2016 - 22:12:00: [SM] Blaming: shavit-core.smx()
L 07/25/2016 - 22:12:00: [SM] Call stack trace:
L 07/25/2016 - 22:12:00: [SM]   [0] SetFailState
L 07/25/2016 - 22:12:00: [SM]   [1] Line 848, D:\ServerCSGO\csgosl\server\csgo\addons\sourcemod\scripting\shavit-core.sp::SQL_DBConnect()
L 07/25/2016 - 22:12:00: [SM]   [2] Line 172, D:\ServerCSGO\csgosl\server\csgo\addons\sourcemod\scripting\shavit-core.sp::OnPluginStart()
L 07/25/2016 - 22:12:00: [SM] Exception reported: Timer startup failed. Reason: [1049]: Unknown database 'shavit'
L 07/25/2016 - 22:12:00: [SM] Blaming: shavit-core.smx()
L 07/25/2016 - 22:12:00: [SM] Call stack trace:
L 07/25/2016 - 22:12:00: [SM]   [0] SetFailState
L 07/25/2016 - 22:12:00: [SM]   [1] Line 848, D:\ServerCSGO\csgosl\server\csgo\addons\sourcemod\scripting\shavit-core.sp::SQL_DBConnect()
L 07/25/2016 - 22:12:00: [SM]   [2] Line 172, D:\ServerCSGO\csgosl\server\csgo\addons\sourcemod\scripting\shavit-core.sp::OnPluginStart()
Code:
"Databases"
{
	"driver_default"		"mysql"
	
	// When specifying "host", you may use an IP address, a hostname, or a socket file path
	
	"default"
	{
		"driver"			"default"
		"host"				"localhost"
		"database"			"sourcemod"
		"user"				"root"
		"pass"				"root"
		//"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"
	}
	
	"shavit"
	{
		"driver"         "mysql"
		"host"           "localhost"
		"database"       "shavit"
		"user"           "root"
		"pass"           "root"
	}
}
SpiZe is offline
shavit
AlliedModders Donor
Join Date: Dec 2011
Location: Israel
Old 07-25-2016 , 23:13   Re: [CS:S/CS:GO] shavit's simple bhop timer (1.4b 21/September/2015)
Reply With Quote #722

Quote:
Originally Posted by SpiZe View Post
Hi shavit,

I'm really confused here, I had my own server up and running fine with your timer and everything so I decided to help a friend set up his. After everything was installed we tried running the server but the plugin crashed with "unknown database : 'shavit'. I thought it was a problem with his database.cfg but everything was fine, I even sent him my own databases.cfg to make sure. So I thought it might be a problem with his MySQL install, so we wiped everything on his end, and I did the same on mine. Now we both get the same error with a fresh install of MySQL and I don't really know what's causing it. Have any ideas ?

Code:
L 07/25/2016 - 22:12:00: [SM] Exception reported: Plugin not runnable
L 07/25/2016 - 22:12:00: [SM] Blaming: shavit-core.smx()
L 07/25/2016 - 22:12:00: [SM] Call stack trace:
L 07/25/2016 - 22:12:00: [SM]   [0] SetFailState
L 07/25/2016 - 22:12:00: [SM]   [1] Line 848, D:\ServerCSGO\csgosl\server\csgo\addons\sourcemod\scripting\shavit-core.sp::SQL_DBConnect()
L 07/25/2016 - 22:12:00: [SM]   [2] Line 172, D:\ServerCSGO\csgosl\server\csgo\addons\sourcemod\scripting\shavit-core.sp::OnPluginStart()
L 07/25/2016 - 22:12:00: [SM] Exception reported: Timer startup failed. Reason: [1049]: Unknown database 'shavit'
L 07/25/2016 - 22:12:00: [SM] Blaming: shavit-core.smx()
L 07/25/2016 - 22:12:00: [SM] Call stack trace:
L 07/25/2016 - 22:12:00: [SM]   [0] SetFailState
L 07/25/2016 - 22:12:00: [SM]   [1] Line 848, D:\ServerCSGO\csgosl\server\csgo\addons\sourcemod\scripting\shavit-core.sp::SQL_DBConnect()
L 07/25/2016 - 22:12:00: [SM]   [2] Line 172, D:\ServerCSGO\csgosl\server\csgo\addons\sourcemod\scripting\shavit-core.sp::OnPluginStart()
Code:
"Databases"
{
	"driver_default"		"mysql"
	
	// When specifying "host", you may use an IP address, a hostname, or a socket file path
	
	"default"
	{
		"driver"			"default"
		"host"				"localhost"
		"database"			"sourcemod"
		"user"				"root"
		"pass"				"root"
		//"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"
	}
	
	"shavit"
	{
		"driver"         "mysql"
		"host"           "localhost"
		"database"       "shavit"
		"user"           "root"
		"pass"           "root"
	}
}
This is.. confusing..
Could you *attach* the file? It might have some invisible characters that mess up with everything!

By the way: get the newest files, I fixed a serious issue where the plugin wouldn't load at all. It's different than what you experience, but it'll save you some headache
__________________
retired
shavit is offline
tuan206
Member
Join Date: May 2016
Old 07-25-2016 , 23:15   Re: [CS:S/CS:GO] shavit's simple bhop timer (1.4b 21/September/2015)
Reply With Quote #723

Quote:
Originally Posted by Technoblazed View Post
In your sourcemod/logs folder, you should have error_DATE.log files
http://pastebin.com/TPH3AY3r
tuan206 is offline
SpiZe
Junior Member
Join Date: Jul 2016
Old 07-25-2016 , 23:34   Re: [CS:S/CS:GO] shavit's simple bhop timer (1.4b 21/September/2015)
Reply With Quote #724

Quote:
Originally Posted by shavit View Post
This is.. confusing..
Could you *attach* the file? It might have some invisible characters that mess up with everything!

By the way: get the newest files, I fixed a serious issue where the plugin wouldn't load at all. It's different than what you experience, but it'll save you some headache
I have some old files (I updated like last week) that are working (or were I guess xd) my friend has some from like 4 hours ago so I think he's fine on that one, unless that by new file you mean really new xd
Attached Files
File Type: cfg databases.cfg (756 Bytes, 323 views)

Last edited by SpiZe; 07-26-2016 at 00:00.
SpiZe is offline
weeeishy
Senior Member
Join Date: Jul 2015
Location: Kuwait
Old 07-26-2016 , 03:44   Re: [CS:S/CS:GO] shavit's simple bhop timer (1.4b 21/September/2015)
Reply With Quote #725

Quote:
Originally Posted by tuan206 View Post
[SM] Unable to load plugin "shavit-chat.smx": Could not find required plugin "dynamic"


It's required to be able to run shavit-chat


https://forums.alliedmods.net/showthread.php?t=270519
__________________
weeeishy is offline
shavit
AlliedModders Donor
Join Date: Dec 2011
Location: Israel
Old 07-26-2016 , 09:09   Re: [CS:S/CS:GO] shavit's simple bhop timer (1.4b 21/September/2015)
Reply With Quote #726

Quote:
Originally Posted by SpiZe View Post
I have some old files (I updated like last week) that are working (or were I guess xd) my friend has some from like 4 hours ago so I think he's fine on that one, unless that by new file you mean really new xd
Okay this is quite confusing.. try updating both MetaMod: Source, SourceMod and use 127.0.0.1 instead of localhost in the databases.cfg file, make sure it has proper permissions (go with 777 if you own the machine)
__________________
retired
shavit is offline
SpiZe
Junior Member
Join Date: Jul 2016
Old 07-26-2016 , 12:01   Re: [CS:S/CS:GO] shavit's simple bhop timer (1.4b 21/September/2015)
Reply With Quote #727

Quote:
Originally Posted by shavit View Post
Okay this is quite confusing.. try updating both MetaMod: Source, SourceMod and use 127.0.0.1 instead of localhost in the databases.cfg file, make sure it has proper permissions (go with 777 if you own the machine)
Still nothing with Metamod:Source 1.10.6 or 1.10.7-dev and SourceMod 1.8.0.5919. Also made sure MySQL service was running and the whole tree of the server has full permissions, really don't know. Weird thing is it worked perfectly fine before I reinstalled MySQL, maybe I fucked up something there but I really don't know what it could be, it pretty straight foward :S

Code:
L 07/26/2016 - 11:57:16: SourceMod error session started
L 07/26/2016 - 11:57:16: Info (map "bhop_allison") (file "errors_20160726.log")
L 07/26/2016 - 11:57:16: [SM] Exception reported: Plugin not runnable
L 07/26/2016 - 11:57:16: [SM] Blaming: shavit-core.smx()
L 07/26/2016 - 11:57:16: [SM] Call stack trace:
L 07/26/2016 - 11:57:16: [SM]   [0] SetFailState
L 07/26/2016 - 11:57:16: [SM]   [1] Line 848, D:\ServerCSGO\csgosl\server\csgo\addons\sourcemod\scripting\shavit-core.sp::SQL_DBConnect()
L 07/26/2016 - 11:57:16: [SM]   [2] Line 172, D:\ServerCSGO\csgosl\server\csgo\addons\sourcemod\scripting\shavit-core.sp::OnPluginStart()
L 07/26/2016 - 11:57:16: [SM] Exception reported: Timer startup failed. Reason: [1049]: Unknown database 'shavit'
L 07/26/2016 - 11:57:16: [SM] Blaming: shavit-core.smx()
L 07/26/2016 - 11:57:16: [SM] Call stack trace:
L 07/26/2016 - 11:57:16: [SM]   [0] SetFailState
L 07/26/2016 - 11:57:16: [SM]   [1] Line 848, D:\ServerCSGO\csgosl\server\csgo\addons\sourcemod\scripting\shavit-core.sp::SQL_DBConnect()
L 07/26/2016 - 11:57:16: [SM]   [2] Line 172, D:\ServerCSGO\csgosl\server\csgo\addons\sourcemod\scripting\shavit-core.sp::OnPluginStart()
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-core.smx": Error detected in plugin startup (see error logs)
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-hud.smx": Could not find required plugin "shavit"
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-misc.smx": Could not find required plugin "shavit"
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-rankings.smx": Could not find required plugin "shavit"
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-replay.smx": Could not find required plugin "shavit"
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-sounds.smx": Could not find required plugin "shavit"
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-stats.smx": Could not find required plugin "shavit"
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-timelimit.smx": Could not find required plugin "shavit"
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-wr.smx": Could not find required plugin "shavit"
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-zones.smx": Could not find required plugin "shavit"
L 07/26/2016 - 11:57:16: [admin-sql-prefetch.smx] Could not connect to database "default": [1049]: Unknown database 'sourcemod'
L 07/26/2016 - 11:57:16: [admin-sql-prefetch.smx] Could not connect to database "default": [1049]: Unknown database 'sourcemod'
L 07/26/2016 - 11:57:16: [admin-sql-prefetch.smx] Could not connect to database "default": [1049]: Unknown database 'sourcemod'
L 07/26/2016 - 11:57:16: [SM] Exception reported: Plugin not runnable
L 07/26/2016 - 11:58:13: Error log file session closed.

Last edited by SpiZe; 07-26-2016 at 12:02.
SpiZe is offline
shavit
AlliedModders Donor
Join Date: Dec 2011
Location: Israel
Old 07-26-2016 , 18:04   Re: [CS:S/CS:GO] shavit's simple bhop timer (1.4b 21/September/2015)
Reply With Quote #728

Quote:
Originally Posted by SpiZe View Post
Still nothing with Metamod:Source 1.10.6 or 1.10.7-dev and SourceMod 1.8.0.5919. Also made sure MySQL service was running and the whole tree of the server has full permissions, really don't know. Weird thing is it worked perfectly fine before I reinstalled MySQL, maybe I fucked up something there but I really don't know what it could be, it pretty straight foward :S

Code:
L 07/26/2016 - 11:57:16: SourceMod error session started
L 07/26/2016 - 11:57:16: Info (map "bhop_allison") (file "errors_20160726.log")
L 07/26/2016 - 11:57:16: [SM] Exception reported: Plugin not runnable
L 07/26/2016 - 11:57:16: [SM] Blaming: shavit-core.smx()
L 07/26/2016 - 11:57:16: [SM] Call stack trace:
L 07/26/2016 - 11:57:16: [SM]   [0] SetFailState
L 07/26/2016 - 11:57:16: [SM]   [1] Line 848, D:\ServerCSGO\csgosl\server\csgo\addons\sourcemod\scripting\shavit-core.sp::SQL_DBConnect()
L 07/26/2016 - 11:57:16: [SM]   [2] Line 172, D:\ServerCSGO\csgosl\server\csgo\addons\sourcemod\scripting\shavit-core.sp::OnPluginStart()
L 07/26/2016 - 11:57:16: [SM] Exception reported: Timer startup failed. Reason: [1049]: Unknown database 'shavit'
L 07/26/2016 - 11:57:16: [SM] Blaming: shavit-core.smx()
L 07/26/2016 - 11:57:16: [SM] Call stack trace:
L 07/26/2016 - 11:57:16: [SM]   [0] SetFailState
L 07/26/2016 - 11:57:16: [SM]   [1] Line 848, D:\ServerCSGO\csgosl\server\csgo\addons\sourcemod\scripting\shavit-core.sp::SQL_DBConnect()
L 07/26/2016 - 11:57:16: [SM]   [2] Line 172, D:\ServerCSGO\csgosl\server\csgo\addons\sourcemod\scripting\shavit-core.sp::OnPluginStart()
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-core.smx": Error detected in plugin startup (see error logs)
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-hud.smx": Could not find required plugin "shavit"
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-misc.smx": Could not find required plugin "shavit"
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-rankings.smx": Could not find required plugin "shavit"
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-replay.smx": Could not find required plugin "shavit"
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-sounds.smx": Could not find required plugin "shavit"
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-stats.smx": Could not find required plugin "shavit"
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-timelimit.smx": Could not find required plugin "shavit"
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-wr.smx": Could not find required plugin "shavit"
L 07/26/2016 - 11:57:16: [SM] Unable to load plugin "shavit-zones.smx": Could not find required plugin "shavit"
L 07/26/2016 - 11:57:16: [admin-sql-prefetch.smx] Could not connect to database "default": [1049]: Unknown database 'sourcemod'
L 07/26/2016 - 11:57:16: [admin-sql-prefetch.smx] Could not connect to database "default": [1049]: Unknown database 'sourcemod'
L 07/26/2016 - 11:57:16: [admin-sql-prefetch.smx] Could not connect to database "default": [1049]: Unknown database 'sourcemod'
L 07/26/2016 - 11:57:16: [SM] Exception reported: Plugin not runnable
L 07/26/2016 - 11:58:13: Error log file session closed.
Code:
Timer startup failed. Reason: [1049]: Unknown database 'shavit'
oh..
i think you're missing the 'shavit' database in your mysql server
__________________
retired
shavit is offline
SpiZe
Junior Member
Join Date: Jul 2016
Old 07-26-2016 , 19:14   Re: [CS:S/CS:GO] shavit's simple bhop timer (1.4b 21/September/2015)
Reply With Quote #729

Quote:
Originally Posted by shavit View Post
Code:
Timer startup failed. Reason: [1049]: Unknown database 'shavit'
oh..
i think you're missing the 'shavit' database in your mysql server
Well that makes a lot of sense now does it... Thanks for your help Shavit, appreciate it
SpiZe is offline
Kruzi
Senior Member
Join Date: Dec 2014
Location: Kyiv, Ukraine
Old 07-28-2016 , 21:25   Re: [CS:S/CS:GO] shavit's simple bhop timer (1.4b 21/September/2015)
Reply With Quote #730

L 07/29/2016 - 04:01:55: [SM] Blaming: shavit-stats.smx()
L 07/29/2016 - 04:01:55: [SM] Call stack trace:
L 07/29/2016 - 04:01:55: [SM] [0] Database.Query
L 07/29/2016 - 04:01:55: [SM] [1] Line 237, C:\SM\addons\sourcemod\scripting\shavit-stats.sp::UpdateMVPs()
L 07/29/2016 - 04:01:55: [SM] [2] Line 171, C:\SM\addons\sourcemod\scripting\shavit-stats.sp:layer_Event()
L 07/29/2016 - 04:01:59: [SM] Exception reported: Invalid database Handle 23f0233 (error: 1)

And all custom sprites what i founded works like this on screenshot:

Last edited by Kruzi; 07-28-2016 at 21:33.
Kruzi is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 00:41.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode