Raised This Month: $51 Target: $400
 12% 

SQL_FastQuery causing rollback


Post New Thread Reply   
 
Thread Tools Display Modes
notMe2
Member
Join Date: Feb 2014
Old 03-01-2015 , 22:15   Re: SQL_FastQuery causing rollback
Reply With Quote #11

anyone?
notMe2 is offline
Neuro Toxin
Veteran Member
Join Date: Oct 2013
Location: { closing the void; }
Old 03-02-2015 , 01:04   Re: SQL_FastQuery causing rollback
Reply With Quote #12

You buying flowers for me?
__________________
Neuro Toxin is offline
Peace-Maker
SourceMod Plugin Approver
Join Date: Aug 2008
Location: Germany
Old 03-03-2015 , 10:14   Re: SQL_FastQuery causing rollback
Reply With Quote #13

Quote:
Originally Posted by notMe2 View Post
Well, when the server has 5+ players the client still crashes, even with this method
The client crashes? Do you use any other non-threaded queries elsewhere in your plugin?
__________________
Peace-Maker is offline
notMe2
Member
Join Date: Feb 2014
Old 03-03-2015 , 15:43   Re: SQL_FastQuery causing rollback
Reply With Quote #14

Quote:
Originally Posted by Peace-Maker View Post
The client crashes? Do you use any other non-threaded queries elsewhere in your plugin?
Yes, only the client (not all clients, just a few). No, i removed all non-threaded querys
notMe2 is offline
KissLick
Veteran Member
Join Date: Nov 2012
Location: void
Old 03-03-2015 , 17:18   Re: SQL_FastQuery causing rollback
Reply With Quote #15

Do you use some custom content like materials? eg sprites with not downloaded material likes to crash a clients game.
KissLick is offline
notMe2
Member
Join Date: Feb 2014
Old 03-03-2015 , 19:05   Re: SQL_FastQuery causing rollback
Reply With Quote #16

Quote:
Originally Posted by KissLick View Post
Do you use some custom content like materials? eg sprites with not downloaded material likes to crash a clients game.
No, just fetching the kills for each weapon, only plugin
notMe2 is offline
h3bus
AlliedModders Donor
Join Date: Nov 2013
Old 03-04-2015 , 03:31   Re: SQL_FastQuery causing rollback
Reply With Quote #17

What would be the like between SQL server-side and client crash?
h3bus is offline
Neuro Toxin
Veteran Member
Join Date: Oct 2013
Location: { closing the void; }
Old 03-04-2015 , 06:32   Re: SQL_FastQuery causing rollback
Reply With Quote #18

Your crashes could relate to you passing the direct client indices via the callback methods.

Always convert client indices to userid's and back again through threaded callbacks.

GetClientUserId
GetClientOfUserId
__________________

Last edited by Neuro Toxin; 03-04-2015 at 06:32.
Neuro Toxin is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 13:32.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode