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

SQL Error


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
psewolf
Junior Member
Join Date: Aug 2015
Old 08-19-2015 , 00:07   SQL Error
Reply With Quote #1

I keep getting this error:

Code:
L 08/18/2015 - 22:58:10: [SM] Native "SetFailState" reported: Database failure: Could not find Database conf "sourcebans"
Here's my databases.cfg file

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"				"XX"
		"database"			"XX"
		"user"				"XX"
		"pass"				"XX"
		//"timeout"			"0"
		"port"	     		        "3306"
	}
	
	"storage-local"
	{
		"driver"			"sqlite"
		"database"			"sourcemod-local"
	}

	"clientprefs"
	{
		"driver"			"sqlite"
		"host"				"localhost"
		"database"			"clientprefs-sqlite"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
}
psewolf is offline
ddhoward
Veteran Member
Join Date: May 2012
Location: California
Old 08-19-2015 , 00:15   Re: SQL Error
Reply With Quote #2

What version of Sourcebans are you running?
__________________
ddhoward is offline
psewolf
Junior Member
Join Date: Aug 2015
Old 08-19-2015 , 00:26   Re: SQL Error
Reply With Quote #3

Version 1.4.11
psewolf is offline
ddhoward
Veteran Member
Join Date: May 2012
Location: California
Old 08-19-2015 , 00:30   Re: SQL Error
Reply With Quote #4

Where is the information for Sourcebans in your databases.cfg? All I see are default, storage-local, and clientprefs.
__________________
ddhoward is offline
psewolf
Junior Member
Join Date: Aug 2015
Old 08-19-2015 , 00:35   Re: SQL Error
Reply With Quote #5

What do you mean, I put my info into the default entry. I just replaced it with XX's for the forum post.
psewolf is offline
samsah
AlliedModders Donor
Join Date: Mar 2008
Location: Finland
Old 08-19-2015 , 00:44   Re: SQL Error
Reply With Quote #6

Create new entry called "sourcebans". You can't use "default".
__________________

Last edited by samsah; 08-19-2015 at 00:45.
samsah is offline
psewolf
Junior Member
Join Date: Aug 2015
Old 08-19-2015 , 00:48   Re: SQL Error
Reply With Quote #7

Like this? I still got the same error.
Code:
"Databases"
{
	"driver_default"		"mysql"
	
	// When specifying "host", you may use an IP address, a hostname, or a socket file path
	
	"sourcebans"
	{
		"driver"			"default"
		"host"				"XX"
		"database"			"XX"
		"user"				"XX"
		"pass"				"XX"
		//"timeout"			"0"
		"port"	     		        "3306"
	}
	
	"storage-local"
	{
		"driver"			"sqlite"
		"database"			"sourcemod-local"
	}

	"clientprefs"
	{
		"driver"			"sqlite"
		"host"				"localhost"
		"database"			"clientprefs-sqlite"
		"user"				"root"
		"pass"				""
		//"timeout"			"0"
		//"port"			"0"
	}
}

Last edited by psewolf; 08-19-2015 at 00:49.
psewolf is offline
samsah
AlliedModders Donor
Join Date: Mar 2008
Location: Finland
Old 08-19-2015 , 01:15   Re: SQL Error
Reply With Quote #8

Yes
__________________
samsah is offline
asdfxD
Veteran Member
Join Date: Apr 2011
Old 08-22-2015 , 10:43   Re: SQL Error
Reply With Quote #9

"sourcebans"
{
"driver" "mysql"

instead of default.


Last edited by asdfxD; 08-22-2015 at 10:43.
asdfxD is offline
WildCard65
Veteran Member
Join Date: Aug 2013
Location: Canada
Old 08-22-2015 , 12:14   Re: SQL Error
Reply With Quote #10

Quote:
Originally Posted by asdfxD View Post
"sourcebans"
{
"driver" "mysql"

instead of default.

That isn't required as the default driver(unless you changed it in databases.cfg) is mysql
__________________
WildCard65 is offline
Reply


Thread Tools
Display Modes

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 11:51.


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