[mattman]

Have been trying to set this up for days, I can't figure out why it is failing:

Load Errors:
SimpleCSGORanks: Error detected in plugin startup (see error logs)

(error logs)
[SM] [0] Line 338, simplecsgoranks.sp::newDB()
[SM] [1] Line 523, simplecsgoranks.sp::OnPluginStart()

My setup:
simplecsgoranks0.1.9 (also tried older versions).
SM 1.7.3
Windows
CS:GO
MYSQL database hosted on remote web server. Note: other plugins connect to databases fine.

My Database file looks like this:

"steam" { "driver" "default" "host" "MYWEBSITE.com" "database" "db_ranks" "user" "usr_ranks" "pass" "PASSWORD" //"timeout" "0" "port" "3306" } }

And here's what my tables look like in PHPmyAdmin:

Table...........Type.............Collation
steam..........InnoDB......latin1_swedish_ci
steamname...InnoDB......latin1_swedish_ci

MyISAM latin1_swedish_ci

[Puppetmaster]

Originally Posted by mattman Have been trying to set this up for days, I can't figure out why it is failing: Load Errors: SimpleCSGORanks: Error detected in plugin startup (see error logs) (error logs) [SM] [0] Line 338, simplecsgoranks.sp::newDB() [SM] [1] Line 523, simplecsgoranks.sp::OnPluginStart() My setup: simplecsgoranks0.1.9 (also tried older versions). SM 1.7.3 Windows CS:GO MYSQL database hosted on remote web server. Note: other plugins connect to databases fine. My Database file looks like this: And here's what my tables look like in PHPmyAdmin: Table...........Type.............Collation steam..........InnoDB......latin1_swedish_ci steamname...InnoDB......latin1_swedish_ci MyISAM latin1_swedish_ci

Unless you have recompiled the plugin the databases.cfg you have will not work.
I posted about this issue a few days ago: In your case you have used the keyword "steam" instead of "default". I will probably make this a convar in the next release since this appears to be a recurring issue for people.

Originally Posted by Puppetmaster To change the database used in the databases.cfg file you will need to recompile the plugin. One of the global vars controls the database used: PHP Code: new String:databaseName[128] = "default";  By default it is set to default but in your case you will want to compile with: PHP Code: new String:databaseName[128] = "SimpleRanks";  Recompilation requires [INC] Multi Colors includes.

[mattman]

Thanks, I changed my Databases.cfg section from "steam" to "default" as you said but it still failed.

Line 338, simplecsgoranks.sp::newDB() Line 523, simplecsgoranks.sp::OnPluginStart()

Is there anything else I should be checking?

Can't wait to get this working, looks like a great plugin!

[juss]

Originally Posted by mattman Thanks, I changed my Databases.cfg section from "steam" to "default" as you said but it still failed. Is there anything else I should be checking? Can't wait to get this working, looks like a great plugin!

what sm exts list in server terminal says tho this command ?

[Puppetmaster]

Originally Posted by mattman Thanks, I changed my Databases.cfg section from "steam" to "default" as you said but it still failed. Is there anything else I should be checking? Can't wait to get this working, looks like a great plugin!

Have you added the MySQL database and tables?

CREATE DATABASE IF NOT EXISTS steam;
CREATE TABLE `steam` (`steamId` char(65) CHARACTER SET utf8 COLLATE  utf8_bin NOT NULL DEFAULT '', `rank` char(65) DEFAULT NULL, `age`  char(65) DEFAULT NULL, PRIMARY KEY (`steamId`)) ENGINE=InnoDB DEFAULT  CHARSET=latin1;
CREATE TABLE `steamname` (`steamId` char(65) CHARACTER SET utf8 COLLATE  utf8_bin NOT NULL DEFAULT '', `name` char(255) DEFAULT NULL, PRIMARY KEY  (`steamId`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;

You will also want to change this line in databases.cfg:

"database"            "steam"

[mattman]

Originally Posted by Puppetmaster You will also want to change this line in databases.cfg: "database" "steam"

Thank you! It's working now!

I am on a shared webhost, so I do not have root access to MYSQL. Any database I create automatically has a prefix before it, e.g "myaccount_steam".

I recompiled the plugin to replace "steam" with "myaccount_steam" and now the plugin is working perfectly!

[Puppetmaster]

Do you guy know how much we could get done on this project if we were full time?
Anyway version 0.2.0 is up!

Changelog:
0.2.0: Cleaned up some server side message clutter. Added convars. Made suggested change to allow larger player kills during warmup rounds. New !top commands added.
New Top Commands: !top !top10 !top25
New Console Variables:
sm_simplecsgoranks_database: Allows changing of the database used from databases.cfg
sm_simplecsgoranks_debug: Enable or disable advanced error messages. (0 or 1)

[juss]

Puppetmaster: You should also make SimpleCSGOBans =) with mysql and one web page of all banned permamently or so .. with simple emplementation to sourcemod admins .. so if any admin use admin panel in game (!admin) and ban some one, it will store the bans in mysql .. just a simple csgo bans =)

[Puppetmaster]

Originally Posted by juss Puppetmaster: You should also make SimpleCSGOBans =) with mysql and one web page of all banned permamently or so .. with simple emplementation to sourcemod admins .. so if any admin use admin panel in game (!admin) and ban some one, it will store the bans in mysql .. just a simple csgo bans =)

Interestingly enough I already have this functionality on my severs. Ive never released it since sourcemod admins has been out since forever.

Spoiler

Spoiler

[juss]

Puppetmaster looks legit ^ ^