[Lebson506th]

I've been getting that since 1.4.8 too.

I filed it as a bug. It's causing wrong 5 minute bans on a player who's ban is expired for some reason...

[sinblaster]

getting what? What part? Whats your error say?

[Lebson506th]

....the same thing yours does...

[Fujiwara]

Originally Posted by Peace-Maker If you want to delete everything including the submissions and protests run these queries directly into the database and remove all files from the /demos folder. TRUNCATE TABLE sb_bans; TRUNCATE TABLE sb_banlog; TRUNCATE TABLE sb_demos; TRUNCATE TABLE sb_comments; TRUNCATE TABLE sb_protests; TRUNCATE TABLE sb_submissions;

I don't understand where to submit this... I have tried both locations in the screenshots provided, how am I suppose 'query into the database'?

[IMG]http://img6.**************/img6/9564/92702285.png[/IMG]

[IMG]http://img6.**************/img6/9564/92702285.png[/IMG]

[SmackDaddy]

One of the issues I am having is if there is a momentary disconnect with my sourcebans database (db and game servers are *not* on the same box), or if I add or remove an admin (which I use for donors/reserved slots), then until the server is restarted, admins will lose their powers.

I hear this may have been a pre-1.48 issue, but I am using Sourcbans 1.48 and latest 1.4 SM snapshot.....any thoughts/ideas?

Thanks in advance.

[Adjo]

Originally Posted by Fujiwara I don't understand where to submit this... I have tried both locations in the screenshots provided, how am I suppose 'query into the database'?

Click "SQL" in the top menu, then copy/paste that SQL code that Peace-Maker provided.

[Fujiwara]

Originally Posted by Adjo Click "SQL" in the top menu, then copy/paste that SQL code that Peace-Maker provided.

Thanks

[mgunnett]

Originally Posted by sinblaster File is present Owner = Read/Write Public & Group = Read Only New error: L 04/30/2011 - 06:13:25: SourceMod error session started L 04/30/2011 - 06:13:25: Info (map "gg_mcdonaldzz") (file "errors_20110430.log") L 04/30/2011 - 06:13:25: [SM] Native "SQL_FetchString" reported: Current result set has no fetched rows L 04/30/2011 - 06:13:25: [SM] Displaying call stack trace for plugin "sourcebans.smx": L 04/30/2011 - 06:13:25: [SM] [0] Line 1366, D:\htdocs\sourcebans\trunk\game_upload\addons\sourcemod\scripting\sourcebans.sp: :rocessQueueCallback() L 04/30/2011 - 06:27:37: Error log file session closed. Database corrupted maybe?

Possibly... You could try running that command (Can't think of it atm) to check all your tables. I mean the error does say it's not getting any result set's back. So maybe it's a problem with the query string. I also love how they misspelled process as 'rocess'.

[sinblaster]

Ive reloaded the database as I think it was corrupt. Ill post back here re that.

re "rocess" That was me I deleted a smiley face caused by the coding

EDIT:

As far as I can tell my database was corrupt as after deleting it and re setting up it seems to of corrected all errors. I think it may have something to do with importing sql tables from a previous 1.4.8 set-up on a different server. After re setting up and importing SQL bans only all seems good.

Thanks for the suggestions anyway.

[Ard Choille]

Originally Posted by nhsice ok I just move the hosting to my game servers hoster. Now I have been searching and working with the host about this error "L 04/23/2011 - 01:25:29: [sourcebans.smx] Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2). See FAQ: http://www.sourcebans.net/node/20" everything is working, i can see the server on my sourceban web. I can kick or ban players. However, the sourceban log keep giving me those error. Anyone know why? I have read to node/20 and the hosting company also did but we still getting the same error

Your host running ubuntu linux?
missing file '/tmp/mysql.sock' is a common 'bug' in ubuntu

If so
sudo ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock