[killjoy64]

Originally Posted by jpwanabe If your database is called cccm why did you put myuser_cccm in your database.cfg for the database name? Change it to just cccm.

all my databases have web username infront of the database

so if i made a database called killjoy it would be myuser_killjoy

[jpwanabe]

Humor me and try it please.

[killjoy64]

Nope, nothing..and it wouldnt make sense because i can connect with sourcebans just fine, and it has myuser_sourcebans for both the database name and the username.the only database error i have is this

L 07/23/2014 - 20:13:35: [SM] Native "SetFailState" reported: ConErr: [2003]: Can't connect to MySQL server on 'localhost' (10061)
L 07/23/2014 - 20:13:35: [SM] Displaying call stack trace for plugin "calladmin_mysql.smx":
L 07/23/2014 - 20:13:35: [SM]   [0]  Line 391, C:\Users\witch_000\Documents\Github\CallAdmin\gameserver\calladmin_mysql.sp::SQLT_ConnectCallback()

but see that doesnt make sense because in my database.cfg i direct it to its database, yet it tries to connect locally (if this has something to do with the menu plugin)

this is my logs when i restart the server

Spoiler

L 07/23/2014 - 20:23:25: -------- Mapchange to achievement_tiny-huge_3_narv --------
L 07/23/2014 - 20:23:25: [TF2ITEMS] "GiveNamedItem" offset = 471
L 07/23/2014 - 20:23:25: [GEOIP] GeoIP database info: GEO-106FREE 20091001 Build 1 Copyright (c) 2009 MaxMind Inc All Rights Reserved
L 07/23/2014 - 20:23:25: [free_duels.smx] Loading : Enabled		 			[0/5]
L 07/23/2014 - 20:23:25: [free_duels.smx] Loading : Initialisation 				[1/5]
L 07/23/2014 - 20:23:25: [free_duels.smx] Loading : Connected to SQLite Database		[2/5]
L 07/23/2014 - 20:23:25: [free_duels.smx] Loading : Tables Created 				[3/5]
L 07/23/2014 - 20:23:25: [funcommandsX.smx] Game detected as Team Fortress 2: Source (GAME_TF2)
L 07/23/2014 - 20:23:25: [simple-chatprocessor.smx] [SCP] Recognized mod [Team Fortress 2].
L 07/23/2014 - 20:23:25: [simple-chatprocessor.smx] [SCP] Loading translation file [scp.tf.phrases].
L 07/23/2014 - 20:23:31: [tf2items_giveweapon.smx] [TF2Items GiveWeapon] TF2ItemsInfo loaded 327 items.
L 07/23/2014 - 20:23:31: [tfforceholidays.smx] Loaded/Updated Halloween map list
L 07/23/2014 - 20:23:38: [basechat.smx] "Console<0><Console><Console>" triggered sm_msay (text If you are in the server, and you see this message, please rejoin, as achievements were quickly disabled and enabled.)
L 07/23/2014 - 20:23:38: [basechat.smx] "Console<0><Console><Console>" triggered sm_csay (text If you are in the server, and you see this message, please rejoin, as achievements were quickly disabled and enabled.)
L 07/23/2014 - 20:23:38: [basechat.smx] "Console<0><Console><Console>" triggered sm_say (text If you are in the server, and you see this message, please rejoin, as achievements were quickly disabled and enabled.)
L 07/23/2014 - 20:23:49: [tf2items_giveweapon.smx] [TF2Items GiveWeapon] TF2ItemsInfo loaded 327 items.
L 07/23/2014 - 20:23:52: [tf2items_giveweapon.smx] [TF2Items GiveWeapon] TF2ItemsInfo loaded 327 items.
L 07/23/2014 - 20:23:52: [tf2items_giveweapon.smx] [TF2Items GiveWeapon]2041: Preparing models/weapons/c_models/c_v_ludmila/c_v_ludmila.mdl
L 07/23/2014 - 20:23:52: [tf2items_giveweapon.smx] [TF2Items GiveWeapon]2058: cannot find valid model models/custom/weapons/antehgen/urinejar.mdl, skipping
L 07/23/2014 - 20:23:52: [tf2items_giveweapon.smx] [TF2Items GiveWeapon]2058: cannot find valid model models/custom/weapons/antehgen/urinejar.mdl, skipping
L 07/23/2014 - 20:23:52: [tf2items_giveweapon.smx] [TF2Items GiveWeapon]2171: cannot find valid model models/advancedweaponiser/w_sickle_sniper.mdl, skipping
L 07/23/2014 - 20:23:52: [tf2items_giveweapon.smx] [TF2Items GiveWeapon]2171: cannot find valid model models/advancedweaponiser/w_sickle_sniper.mdl, skipping
L 07/23/2014 - 20:23:52: [tf2items_giveweapon.smx] [TF2Items GiveWeapon]2197: cannot find valid model models/custom/weapons/rebelscurse/c_wrench_v2.mdl, skipping
L 07/23/2014 - 20:23:52: [tf2items_giveweapon.smx] [TF2Items GiveWeapon]2197: cannot find valid model models/custom/weapons/rebelscurse/c_wrench_v2.mdl, skipping
L 07/23/2014 - 20:23:52: [tf2items_giveweapon.smx] [TF2Items GiveWeapon]2228: cannot find valid model models/advancedweaponiser/fbomb/c_fbomb.mdl, skipping
L 07/23/2014 - 20:23:52: [tf2items_giveweapon.smx] [TF2Items GiveWeapon]2228: cannot find valid model models/advancedweaponiser/fbomb/c_fbomb.mdl, skipping
L 07/23/2014 - 20:23:52: [tf2items_giveweapon.smx] [TF2Items GiveWeapon]5142: cannot find valid model models/custom/weapons/goldslinger/c_engineer_gunslinger.mdl, skipping
L 07/23/2014 - 20:23:53: [bossspawner.smx] Map: achievement_tiny-huge_3_narv, Enabled: Yes, Position:16.000000, -26.000000, 135.000000
L 07/23/2014 - 20:23:53: [bossspawner.smx] Loaded Map configs successfully.
L 07/23/2014 - 20:23:53: [buildinghats.smx] [Building Hats] Executing configuration file addons\sourcemod\configs\buildinghats.cfg
L 07/23/2014 - 20:23:53: [custom-chatcolors-menu.smx] Loaded 156 colors from configuration file addons\sourcemod\configs\custom-chatcolors-menu.cfg.
L 07/23/2014 - 20:23:53: [free_duels.smx] Loading : Configs Executed 				[4/5]
L 07/23/2014 - 20:23:53: [free_duels.smx] Loading : Finished 					[5/5]

[killjoy64]

Any new ideas? i also tried everything iv done so far for my first server on my second server to see if it was a plugin or something and it still nothing.

EDIT so i changed mysql to sqlite and L 07/23/2014 - 21:05:58: [custom-chatcolors-menu.smx] SQlite server configured. Variable saving enabled.

i changed the sqlite back to mysql and i got the table user with no columns so far.

[jpwanabe]

I'll just post what I have for you.

	"cccm"
	{
		"driver"			"default"
		"host"				"server"
		"database"          "cccm"
		"user"              "user"
		"pass"              "pass"
		"port"            "3306"
	}

And the database in mysql is called cccm. So I don't know why yours inn't working. Try updating sourcemod? I really would like to know where you saw to add the user name to the front of the database name. I have never heard of that before.

[killjoy64]

Originally Posted by jpwanabe I'll just post what I have for you. "cccm" { "driver" "default" "host" "server" "database" "cccm" "user" "user" "pass" "pass" "port" "3306" } And the database in mysql is called cccm. So I don't know why yours inn't working. Try updating sourcemod? I really would like to know where you saw to add the user name to the front of the database name. I have never heard of that before.

Thank you for all your help! I dont know what i did to make it work, i did have my ip wrong by 1 number for my host, but that was a while back and even after i changed it, it didnt work but all i can say is that when i changed mysql to sqlite, it said it connected in the logs! i changed it back to mysql and there were tables! and i joined the servers to test and it connects on all of my servers. with the username in front of the database name, i think thats just how my host works. when i create a database name it says myuser_[ ] where [] are is a space where i can put the name i would like to create, i think its just how cpanel works but if no one else has it, i guess i cant complain, so when i create my databases they always have my account name infront of it.

this is kinda what mine looks like. (this is from a random tutorial)http://www.wpwhitesecurity.com/wp-co...a-Database.png

[LiMaaa]

Ok, I noticed a bug that doesn't seem to be posted here. When using the custom chatcolor menu, if you reload admins via sourcemod, all tags disappear, players must rejoin the server to get their tags back. Any way to fix this?

Regards,

[jpwanabe]

I can say that I don't have that bug.

[LiMaaa]

Hmm, that's weird, but it must be the menu, because when i unload the menu and try it, tags stay. Only happens when i reload admins on tf2 while menu is loaded, tags disappear, people still have their color, but no tags until they rejoin server.

any ideas?

[Donski]

Yea I have that same bug. Solution is to never reload admins. Lol.