[Quimbo]

Originally Posted by 9mmMAG Ok so here is the error I got. I installed the plugin with the updated "ps_" fix that tripleplay905 compiled. [psychostats_threaded_uni_1.smx] MySQL Error: Table 'stats.ps__config' doesn't exist Is this a database issue or a plugin issue?

There are 2 "_" after ps... I remember you can specify your own prefix for the tables so maybe you specified "ps_" instead of just "ps"?

Just guessing...

[9mmMAG]

well maybe tripleplay905 added the extra underscore on accident. I will have to update the plugin and see. Thanks.

ok so i went and compiled the plugin myself and made sure it was just ps_ since that is the prefix for my stats(3.1) and i still go the same error.

[psychostats_threaded_uni.smx] MySQL Error: Table 'stats.ps__config' doesn't exist

Is this a database issue or a plugin issue?

[Quimbo]

Are you sure the prefix isn't only "ps" while the table is called "_config"? Combined this would be "ps_config" as expected.

[gH0sTy]

The database config prefix is "ps_" + "config" but the plugin uses the prefix "ps" + "_config"

[Unrealomega]

Still having a hard time setting up. I'm getting this error now.

L 07/25/2008 - 11:13:15: [SM] Native "GetClientName" reported: Client 1 is not connected
L 07/25/2008 - 11:13:15: [SM] Debug mode is not enabled for "psychostats_threaded_uni.smx"
L 07/25/2008 - 11:13:15: [SM] To enable debug mode, edit plugin_settings.cfg, or type: sm plugins debug 17 on

 "psychostats"
 {
  "driver"   "mysql"
  "host"    "74.52.165.18"
  "database"   "suphomed_psychostats"
  "user"    "suphomed_Psychos"
  "pass"    "@@@@"
  //"timeout"   "0"
  //"port"   "0"
 }
 
 "psstats"
 {
  "driver"   "mysql"
  "host"    "74.52.165.18"
  "database"   "suphomed_psychostats"
  "user"    "suphomed_Psychos"
  "pass"    "@@@@"
  //"timeout"   "0"
  //"port"   "0"
 }

[9mmMAG]

Your port should be 3306 for default SQL port. Also, there should be another } at the bottom.

[9mmMAG]

make sure you have the game server IP as an approved address for your mysql database.

[Unrealomega]

PS3 is on a webserver, on a different machine. It either gives me this error, being denied access, or something about it can't find something in the database.

I think I have my game server IP approved.

Also, this is just a snippet of the database. This is the whole cfg.

"Databases"
{
 "driver_default"  "mysql"
 
 "default"
 {
  "driver"   "default"
  "host"    "localhost"
  "database"   "sourcemod"
  "user"    "root"
  "pass"    "@@@@"
  //"timeout"   "0"
  //"port"   "0"
 }
 
 "storage-local"
 {
  "driver"   "sqlite"
  "database"   "sourcemod-local"
 }
 
 "Bank"
 {
  "driver"   "mysql"
  "host"    "74.52.165.18"
  "database"   "suphomed_bank"
  "user"    "suphomed_bank"
  "pass"    "@@@@"
  //"timeout"   "0"
  //"port"   "0"
 }
 
 "psychostats"
 {
  "driver"   "mysql"
  "host"    "74.52.165.18" // My webserver.
  "database"   "suphomed_psychostats"
  "user"    "suphomed_CSSstat"
  "pass"    "@@@@"
  //"timeout"   "0"
  //"port"   "0"
 }
 
 "psstats"
 {
  "driver"   "mysql"
  "host"    "74.52.165.18"
  "database"   "suphomed_psychostats"
  "user"    "suphomed_CSSstat"
  "pass"    "@@@@"
  //"timeout"   "0"
  //"port"   "0"
 }
}

[Unrealomega]

Still having this problem. I have another plugin that's using MySQL fine.

EDIT: Nevermind. Seems I've somehow resolved this problem.

[9mmMAG]

This is what I am getting now after the most recent update to DoD:S and metamod and sourcemod. What might be the problem? Thanks.
L 08/01/2008 - 03:43:42: [SM] Displaying call stack trace for plugin "psychostats_threaded_uni.smx":
L 08/01/2008 - 03:43:42: [SM] [0] Line 252, /home/groups/sourcemod/upload_tmp/phpdRuNAl.sp::top10pnl()
L 08/01/2008 - 03:43:42: [SM] [1] Line 95, /home/groups/sourcemod/upload_tmp/phpdRuNAl.sp::Command_Say()