Raised This Month: $ Target: $400
 0% 

[L4D & L4D2] Custom Player Stats v1.4B121


Post New Thread Reply   
 
Thread Tools Display Modes
muukis
Veteran Member
Join Date: Apr 2009
Old 10-04-2011 , 08:49   Re: [L4D & L4D2] Custom Player Stats v1.4B105
Reply With Quote #1381

Quote:
Originally Posted by morpha View Post
Hi
Ive tried install this plugin but i have so many problems and i dont have knowledge in DBs..
I still havent a webstas but have a dedicated game server and a host with DB. Ive follow those steps en page 1, from quick installation guide, but still have some problems

My databases.cfg:

"Databases"
{
"l4dstats"
{
"driver" "mysql"
"host" "46.105.17x.xxx"
"database" "stats"
"user" "morpha"
"pass" "*****"

}

}

User and Pass are the same then i use for login in PhpMyAdmin
This is my log error
Any idea how fix this problem?

Sorry my bad english..
You have other database related issues as well:
Quote:
L 10/03/2011 - 212:10: [pouncerecord.smx] The database configuration name PounceDB was not present in the databases.cfg file.
L 10/03/2011 - 212:12: [sm_adsmysql.smx] Database failure: [2013]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111
L 10/03/2011 - 212:12: [l4d_stats.smx] Failed to connect to database: [1045]: Access denied for user 'eriton'@'server07.rajuviservers.com' (using password: YES)
Try Google and use words like mysql remote access.
__________________
Monster Hunter

Though certainly not superhuman, the man's prowess inspires an excess of whispered rumors. But those rumors remain in the realm of speculation.
muukis is offline
morpha
Junior Member
Join Date: Sep 2011
Old 10-04-2011 , 13:49   Re: [L4D & L4D2] Custom Player Stats v1.4B105
Reply With Quote #1382

I no longer use both plugins:pounceredrecord.smx and sm_adsmysql.smx and no have DB for both then this issues are not important
So the problem is a remote access?
morpha is offline
muukis
Veteran Member
Join Date: Apr 2009
Old 10-05-2011 , 04:14   Re: [L4D & L4D2] Custom Player Stats v1.4B105
Reply With Quote #1383

Quote:
Originally Posted by morpha View Post
So the problem is a remote access?
Not sure, but likely yes.
__________________
Monster Hunter

Though certainly not superhuman, the man's prowess inspires an excess of whispered rumors. But those rumors remain in the realm of speculation.
muukis is offline
Chronic1
SourceMod Donor
Join Date: Jun 2011
Old 10-14-2011 , 02:22   Re: [L4D & L4D2] Custom Player Stats v1.4B105
Reply With Quote #1384

I'm getting this error.

Code:
L 10/13/2011 - 22:23:33: SourceMod error session started
L 10/13/2011 - 22:23:33: Info (map "c3m4_plantation") (file "errors_20111013.log")
L 10/13/2011 - 22:23:33: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=  - 35 WHERE steamid = 'STEAM_1:1:23311177'' at line 1 (Query: "UPDATE players SET  =  - 35 WHERE steamid = 'STEAM_1:1:23311177'")
L 10/13/2011 - 22:23:57: Error log file session closed.
__________________
Chronic1 is offline
Chronic1
SourceMod Donor
Join Date: Jun 2011
Old 10-14-2011 , 13:17   Re: [L4D & L4D2] Custom Player Stats v1.4B105
Reply With Quote #1385

And these errors...

Code:
L 10/14/2011 - 03:33:01: SourceMod error session started
L 10/14/2011 - 03:33:01: Info (map "c5m5_bridge") (file "errors_20111014.log")
L 10/14/2011 - 03:33:01: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'points_mutations  = ET points_mutations  - 30 WHERE steamid = 'STEAM_1:1:33158' at line 1 (Query: "UPDATE players SET ET points_mutations  = ET points_mutations  - 30 WHERE steamid = 'STEAM_1:1:33158968'")
L 10/14/2011 - 03:35:09: Error log file session closed.
L 10/14/2011 - 07:02:15: SourceMod error session started
L 10/14/2011 - 07:02:15: Info (map "c10m5_houseboat") (file "errors_20111014.log")
L 10/14/2011 - 07:02:15: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' = ints_mut - 5 WHERE steamid = 'STEAM_1:0:22285686'' at line 1 (Query: "UPDATE players SET ints_mut = ints_mut - 5 WHERE steamid = 'STEAM_1:0:22285686'")
L 10/14/2011 - 07:05:28: Error log file session closed.
L 10/14/2011 - 08:35:13: SourceMod error session started
L 10/14/2011 - 08:35:13: Info (map "c1m1_hotel") (file "errors_20111014.log")
L 10/14/2011 - 08:35:13: [SM] Native "DispatchKeyValue" reported: Entity 2 (2) is invalid
L 10/14/2011 - 08:35:13: [SM] Displaying call stack trace for plugin "l4d_climb.smx":
L 10/14/2011 - 08:35:13: [SM]   [0]  Line 1214, l4d_climb.sp::DisplayInstructorHint()
L 10/14/2011 - 08:35:13: [SM]   [1]  Line 1204, l4d_climb.sp::DelayDisplayHint()
L 10/14/2011 - 08:43:48: Error log file session closed.
L 10/14/2011 - 09:18:14: SourceMod error session started
L 10/14/2011 - 09:18:14: Info (map "c1m4_atrium") (file "errors_20111014.log")
L 10/14/2011 - 09:18:14: [l4d_stats.smx] SQL Error: Unknown column 'ted_tank_damage' in 'field list' (Query: "UPDATE players SET ted_tank_damage = infected_tank_points_mutations = ted_tank_damage = infected_tank_points_mutations - 24 WHERE steamid = 'STEAM_1:0:44550943'")
L 10/14/2011 - 09:24:53: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=  - 24 WHERE steamid = 'STEAM_1:0:42300033'' at line 1 (Query: "UPDATE players SET  =  - 24 WHERE steamid = 'STEAM_1:0:42300033'")
L 10/14/2011 - 09:24:53: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=  - 24 WHERE steamid = 'STEAM_1:1:33891376'' at line 1 (Query: "UPDATE players SET  =  - 24 WHERE steamid = 'STEAM_1:1:33891376'")
L 10/14/2011 - 09:25:18: Error log file session closed.
L 10/14/2011 - 10:00:13: SourceMod error session started
L 10/14/2011 - 10:00:13: Info (map "c13m4_cutthroatcreek") (file "errors_20111014.log")
L 10/14/2011 - 10:00:13: [l4d_stats.smx] SQL Error: Unknown column 'ted_tank_damage' in 'field list' (Query: "UPDATE players SET ted_tank_damage = infected_tank_points_mutations = ted_tank_damage = infected_tank_points_mutations - 40 WHERE steamid = 'STEAM_1:0:22285686'")
L 10/14/2011 - 10:02:18: Error log file session closed.
__________________
Chronic1 is offline
muukis
Veteran Member
Join Date: Apr 2009
Old 10-15-2011 , 04:03   Re: [L4D & L4D2] Custom Player Stats v1.4B105
Reply With Quote #1386

Quote:
Originally Posted by Chronic1 View Post
I'm getting this error.

Code:
L 10/13/2011 - 22:23:33: SourceMod error session started
L 10/13/2011 - 22:23:33: Info (map "c3m4_plantation") (file "errors_20111013.log")
L 10/13/2011 - 22:23:33: [l4d_stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=  - 35 WHERE steamid = 'STEAM_1:1:23311177'' at line 1 (Query: "UPDATE players SET  =  - 35 WHERE steamid = 'STEAM_1:1:23311177'")
L 10/13/2011 - 22:23:57: Error log file session closed.
That looks like something I've never seen before. It is missing a table field name? You are using the first post version (1.4B105) of this plugin and not some old or modified version of it? What version of MetaMod and SourceMod you are using?
__________________
Monster Hunter

Though certainly not superhuman, the man's prowess inspires an excess of whispered rumors. But those rumors remain in the realm of speculation.
muukis is offline
morpha
Junior Member
Join Date: Sep 2011
Old 10-15-2011 , 05:56   Re: [L4D & L4D2] Custom Player Stats v1.4B105
Reply With Quote #1387

Quote:
Originally Posted by muukis View Post
Not sure, but likely yes.
Yes, it was
Problem solved!
Plugin works perfectly
Thanks for you help
morpha is offline
mentor
Member
Join Date: Apr 2011
Old 10-18-2011 , 03:57   Re: [L4D & L4D2] Custom Player Stats v1.4B105
Reply With Quote #1388

this stat dont have weapon stats ? o.o

Last edited by mentor; 10-21-2011 at 05:10.
mentor is offline
Chronic1
SourceMod Donor
Join Date: Jun 2011
Old 10-20-2011 , 02:23   Re: [L4D & L4D2] Custom Player Stats v1.4B105
Reply With Quote #1389

Quote:
Originally Posted by muukis View Post
That looks like something I've never seen before. It is missing a table field name? You are using the first post version (1.4B105) of this plugin and not some old or modified version of it? What version of MetaMod and SourceMod you are using?
Yes I am using the plugin from post #1. I am using sourcemod 1.4 (3390) and Metamod 1.87
__________________
Chronic1 is offline
morpha
Junior Member
Join Date: Sep 2011
Old 10-24-2011 , 08:33   Re: [L4D & L4D2] Custom Player Stats v1.4B105
Reply With Quote #1390

Hi again
i have a problem with the installation of GeoLiteCity-Blocks.csv
I get the message:
Reading GeoLiteCity-Blocks.csv - PLEASE WAIT!
but the browser stops run before end process. In the DB the file ip2country_blocks only have 69,4 Mb
My db not have limit size (quota)
How should fix that?

sorry my bad english :S
morpha 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 13:35.


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