[Scope]

Where does the sql lite make the database at when you do the local database thing ?

Ive looked through all my files and cant find the database it has created

[Nican]

/sourcemod/data/sqlite/sourcemod-local.sq3

[tkaway69]

Ok.. What exactly does it take to get this to store locally. When we try to transfer money we get "no one connected". and this error is showing up.

L 10/21/2007 - 21:42:03: [SM] Native "SQL_FetchRow" reported: Invalid query Handle 0 (error: 4)
L 10/21/2007 - 21:42:03: [SM] Debug mode is not enabled for "a_mysql.smx"

We were using a data base but until we upgrade it is no good. So I am trying to store bank info locally. I just want to make sure I have it correct. We have this at start of log but obviously something is not right.

L 10/21/2007 - 20:11:01: [a_mysql.smx] DB MANAGER SAYS:
L 10/21/2007 - 20:11:01: [a_mysql.smx] Unable to connect to default configuration
L 10/21/2007 - 20:11:01: [a_mysql.smx] Using SQLite instead...

Added

sm_db_config storage-local

to server.cfg. Hopefully this fixes it.

Well I am lost. Still getting errors even after adding the storage local line. Still cannot transfer money between players.

L 10/22/2007 - 18:39:16: Info (map "de_dust2") (file "errors_20071022.log")
L 10/22/2007 - 18:39:16: [SM] Native "SQL_FetchRow" reported: Invalid query Handle 0 (error: 4)
L 10/22/2007 - 18:39:16: [SM] Displaying call stack trace for plugin "a_mysql.smx":
L 10/22/2007 - 18:39:16: [SM]   [0]  Line 270, a_mysql.sp::GetClientConnectInfo()
L 10/22/2007 - 18:39:17: [SM] Native "SQL_FetchRow" reported: Invalid query Handle 0 (error: 4)

[Nican]

Can you tell me what Version of this plugin are you using (type "sm plugin list" in console) and can you attach the DB you were using? (/sourcemod/data/sqlite/sourcemod-local.sq3)


I am sorry for the late response, I am having a horrible time lately

[tkaway69]

Sorry to hear that. Hopefully things will loosen up for you.

metamod_version "1.4.2.414"
sourcemod_version "1.0.0.1644"
07 "Database manager" (3.1) by Nican132
08 "SM Bank" (2.2) by MaTTe, edit by Nican

Hope this helps.

[sessus]

hey Nican,

any chance you'd be able to implement an option to creat all the tables based on the date? For example: when no new information has been recorded for a cetrain steam_ID that then all those table entries are deleted. This would help to keep the database small.

[tkaway69]

What exactly does this "There is not one connected" message mean? That may be a start in finding out what is going on. With the bank and transfering money.
This error is filling my logs.

L 10/26/2007 - 22:37:05: [SM] Native "SQL_FetchRow" reported: Invalid query Handle 0 (error: 4)
L 10/26/2007 - 22:37:05: [SM] Debug mode is not enabled for "a_mysql.smx"

[sessus]

just realised sm_db_mapload is not even defined in the .sp file. Is it still working?

[Nican]

Ops... my bad

I removed it after I discovered that all players are disconnected and reconnected when map changes, so client_disconnect is taking care of it

[Nican]

I am back on-line.

I updated this plugin, and tested on saving string, float and integer values, and they are all working.

I am now working to add:
- Key / Value table
- Allow plugins to force the MySQL to update / select information from the database.
- Added cvars to allow more frequent UPDATE queries.