[KeLcO]

Hi Nican,

I use the mysql manager and bank plugin, but i get the following error msg in my sourcemod logs..

sm_db_manager "4.2" smbank_sql_version "3.0"

L 12/26/2008 - 23:58:22: [SM] [0] Line 189, /home/groups/alliedmodders/forums/files/9/4/4/3/32612.attach::T_NewClientConnected() L 12/26/2008 - 23:597: [bank.smx] Query failed! Unknown column 'money' in 'field list' L 12/26/2008 - 23:597: [SM] Native "SQL_FetchRow" reported: Invalid query Handle 0 (error: 4) L 12/26/2008 - 23:597: [SM] Displaying call stack trace for plugin "bank.smx":

thats my databases.cfg

"Databases" { "driver_default" "mysql" "default" { "driver" "mysql" "host" "lanparty-wmk.de" "database" "sm" "user" "xx" "pass" "xx" "timeout" "60" "port" "3306" } "storage-local" { "driver" "sqlite" "database" "sourcemod-local" } }

what should i have to do?

There are two clomuns on my msql server which called:

sm_users -id -steam sm_info_i -key -value

But no entries!
Best regards

KeLcO

[bzz0]

same here

[foenetik]

Hello,

I have the same problem as Kelco...

pls help..

[SWAT_88]

I have found a bug.
On line 107.

LogMessage("[SM Bank] DB configuration '%s' does not exist, using default.");

You forgot to add the parameter for %s.

[DrToT]

Hallo

I have this error logs and I don't know what I can do to fix it

[bank.smx] Database failure: [2013]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111
 [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
 [SM] Displaying call stack trace for plugin "bank.smx":
 [SM] [0] Line 158, bank.sp::OnClientPostAdminCheck()
 [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
 [SM] Displaying call stack trace for plugin "bank.smx":
 [SM] [0] Line 158, bank.sp::OnClientPostAdminCheck()
 [SM] Native "SQL_FastQuery" reported: Invalid database Handle 0 (error: 4)
 [SM] Displaying call stack trace for plugin "bank.smx":
 [SM] [0] Line 211, bank.sp::SaveClientInfo()
 [SM] [1] Line 313, bank.sp::EventRoundStart()

The database will found but there are no information in it
ther will don´t create table or anythng there

here my database.cfg

"Databases"
{
"driver_default" "mysql"
"default"
{
"driver" "default"
"host" "87.106.***.***"
"database" "CSS"
"user" "***"
"pass" "***"
"timeout" "60"
"port" "3306"
}
 
"bank"
{
"driver" "default"
"host" "87.106.***.***"
"database" "CSS"
"user" "***"
"pass" "***"
"timeout" "60"
"port" "3306"
}
"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}
"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}
}

I use for dthe plugin the block with the name "bank"

Thx for help i don´t what I have to do

[Nican]

That seems to be a MySQL error. Not a plugin error.

I did some search on google about 'reading initial communication packet' and apparently it is caused by bad connection between the MySQL server and the MySQL client, but I am not exactly sure how to fix it.

[DrToT]

Thank you for your fast answer.

I will look waht I can do for this at last I know for what I have to concentrate.

[KeLcO]

Hey Nican,

do you continue your work on this plugin? I can do what i want but theres no way to keep this bank and mysql manager plugin running!

Best regards

[Nican]

I don't understand your question.
I removed the requirement of the mysql manager a long time ago.

[oidani]

Hi Nican and all others,

nice Plugin you have posted here. I have installed it and it works fine. Now i want that the Money is saved into a mysql database.

My databases.cfg

"Databases" { "driver_default" "mysql" "default" { "driver" "default" "host" "localhost" "database" "sourcemod" "user" "xxx" "pass" "xxx" //"timeout" "0" //"port" "0" }

mysql shows me four tables:
sm_cookie_cache
sm_info_i
sm_cookies
sm_users

No error.log under /addons/sourcemod/logs

I hope someone can help me
Thanks!