[[-NM-] cal70d]

Originally Posted by ragnasin Attention pls....valve updated something cause the add-on unable to run... New version of sourcemod needded!! but unfortunately the developer went to vacation~ any other solution?

Check this thread:
http://forums.alliedmods.net/showthread.php?t=131893

That will fix sourcemod not working.

I'm having a problem with this plugin since MySQL was updated to 5.1 on my database server.
At first if I had this plugin on the server it would get stuck in a loop.
Since the update today and the above fix for sourcemod, I get this error:
[SM] Unable to load plugin "l4d_stats.smx": Native "SQL_CheckConfig" was not found

I'm able to remotely connect to the database using MySQL Workbench, so I know the database is set up for remote access. I have given the gameserver ip access to the database.
Any ideas?

_______________
[Edit]:
Seems to be a SourceMod problem, as all plugins that use MySQL are not loading since the last update to SM in response to Valve's last update.

_______________
[Edit]:
SourceMod update at the post linked above now fixes the SQL_CheckConfig error.

I'm back to having the plugin timeout accessing the database and causing the server to reset.
This started occuring when the webhost that the database is on updated MySQL from 4.4 to 5.1.
Using all the same info that I used before.
Web stats page connects with no problem, but it is a local connection. http://www.thenomercyclan.clanservers.com/L4D2Stats/
Can connect remotely to the database with MySQL Workbench, so I know that it will accept remote connections.

Anyone with any ideas on what the problem might be?

[ragnasin]

Originally Posted by [-NM-] cal70d Check this thread: http://forums.alliedmods.net/showthread.php?t=131893 That will fix sourcemod not working. I'm having a problem with this plugin since MySQL was updated to 5.1 on my database server. At first if I had this plugin on the server it would get stuck in a loop. Since the update today and the above fix for sourcemod, I get this error: [SM] Unable to load plugin "l4d_stats.smx": Native "SQL_CheckConfig" was not found I'm able to remotely connect to the database using MySQL Workbench, so I know the database is set up for remote access. I have given the gameserver ip access to the database. Any ideas? _______________ [Edit]: Seems to be a SourceMod problem, as all plugins that use MySQL are not loading since the last update to SM in response to Valve's last update. _______________ [Edit]: SourceMod update at the post linked above now fixes the SQL_CheckConfig error. I'm back to having the plugin timeout accessing the database and causing the server to reset. This started occuring when the webhost that the database is on updated MySQL from 4.4 to 5.1. Using all the same info that I used before. Web stats page connects with no problem, but it is a local connection. http://www.thenomercyclan.clanservers.com/L4D2Stats/ Can connect remotely to the database with MySQL Workbench, so I know that it will accept remote connections. Anyone with any ideas on what the problem might be?

ok,my problem solve. Just follow the step.
Does u enable access privilege at your Mysql?

[siangc]

I'm about to lose my fucking mind...
I had it working for a couple of days, then suddenly it didn't count points or new players anymore. I thought it might be the mysql host, so i bought a website, with mysql. Still same problem... I tried wiping out my (l4d2)server, re-installing everything.

I really have no clue at all... Its not the mysql db, cos i got perkmod connected to it fine, and my logs are empty... I tried renaming the plugin, deleting its .cfg, but same problem. When I try to vote shuffle the teams, I get a message saying the plugin is not loaded.

Using latest snapshots of dev sm and mm. Any ideas are highly appreciated..

[.=QUACK=.Major.pain]

Originally Posted by siangc I'm about to lose my fucking mind... I had it working for a couple of days, then suddenly it didn't count points or new players anymore. I thought it might be the mysql host, so i bought a website, with mysql. Still same problem... I tried wiping out my (l4d2)server, re-installing everything. I really have no clue at all... Its not the mysql db, cos i got perkmod connected to it fine, and my logs are empty... I tried renaming the plugin, deleting its .cfg, but same problem. When I try to vote shuffle the teams, I get a message saying the plugin is not loaded. Using latest snapshots of dev sm and mm. Any ideas are highly appreciated..

You don't mention adding a newly created .vdf file.
Did you create one and upload it?
It not, go here: http://www.sourcemm.net/vdf

[siangc]

Originally Posted by .=QUACK=.Major.pain You don't mention adding a newly created .vdf file. Did you create one and upload it? It not, go here: http://www.sourcemm.net/vdf

Yea I got that, got everything working except this one plugin, which did work for a few days tho.

[.=QUACK=.Major.pain]

Guessing you set up remote sql also since you said other plugin was connecting.
Just a suggestion, I think you are trying to connect to a old db.
Try creating a new database to test, and see if it connects to it and creates tables.
Not sure if the plugin has changed, but with our bfbc2 server and stats, it was the only way for use to get it working. We later found out that one of the tables spelling had been changed causing no connection.

Just a long shot. lol

[siangc]

Originally Posted by .=QUACK=.Major.pain Guessing you set up remote sql also since you said other plugin was connecting. Just a suggestion, I think you are trying to connect to a old db. Try creating a new database to test, and see if it connects to it and creates tables. Not sure if the plugin has changed, but with our bfbc2 server and stats, it was the only way for use to get it working. We later found out that one of the tables spelling had been changed causing no connection. Just a long shot. lol

But it wont create tables itself will it? I created them with the install.php webpage. I also tried importing the mysql dump. I'm totally out of ideas, perkmod is using the exact same database, and working fine.

[Danny_l4d]

Hello Muukis,

I have checked the DB and it this is the count "129,763" so strange that it doesnt show up :/


but if I want to have the google working do I need to put in my DB?

1. ip2country_blocks;
2. ip2country_locations;

becasue my website is limited with 100mb gameservers... how big is the ip2country_blocks when you extact it to the DB?

Danny

[Mentol]

I was confused after download latest GeoIPCountryCSV.zip, GeoLiteCity_YYYYMMDD.zip latest, latest GeoLiteCity_YYYYMMDD.zip and where would be placed all ? because I do not know where updatetabel.php there?

I tried to put in "D:\WAMP\ www", but the results

No database selected No database selected No database selected No database selected No database selected No database selected No database selected

[muukis]

Originally Posted by siangc I'm about to lose my fucking mind... I had it working for a couple of days, then suddenly it didn't count points or new players anymore. I thought it might be the mysql host, so i bought a website, with mysql. Still same problem... I tried wiping out my (l4d2)server, re-installing everything. I really have no clue at all... Its not the mysql db, cos i got perkmod connected to it fine, and my logs are empty... I tried renaming the plugin, deleting its .cfg, but same problem. When I try to vote shuffle the teams, I get a message saying the plugin is not loaded. Using latest snapshots of dev sm and mm. Any ideas are highly appreciated..

List your plugins using the server console: sm plugins list
If custom player stats is listed, unload it: sm plugins unload l4d_stats
Load the custom player stats: sm plugins load l4d_stats
Do you get any errors to the console? What does the plugins list say now?

Originally Posted by Danny_l4d Hello Muukis, I have checked the DB and it this is the count "129,763" so strange that it doesnt show up :/ but if I want to have the google working do I need to put in my DB? ip2country_blocks; ip2country_locations; becasue my website is limited with 100mb gameservers... how big is the ip2country_blocks when you extact it to the DB? Danny

You can't fit in the location info, which takes more than 100MB, by far, if I remember correctly.

Originally Posted by Mentol I was confused after download latest GeoIPCountryCSV.zip, GeoLiteCity_YYYYMMDD.zip latest, latest GeoLiteCity_YYYYMMDD.zip and where would be placed all ? because I do not know where updatetabel.php there? I tried to put in "D:\WAMP\ www", but the results

Check that your config.php is set up correctly. Particularly the database configurations.

The updatetables.php was removed some time ago, and was replaced with install.php. Put the unzipped CSV files to the folder of install.php file and try again.