Raised This Month: $62 Target: $400
 15% 

[L4D2] Simple In-Game Player Statistics


Post New Thread Reply   
 
Thread Tools Display Modes
FatalOE71
Member
Join Date: Jun 2018
Old 06-09-2019 , 23:08   Re: [L4D2] Simple In-Game Player Statistics
Reply With Quote #11

Crasher_3637 - Huge thanks man, your answers fixed both issues I had and I finally got it compiled.

Many thanks for all you do.
FatalOE71 is offline
FatalOE71
Member
Join Date: Jun 2018
Old 06-10-2019 , 19:31   Re: [L4D2] Simple In-Game Player Statistics
Reply With Quote #12

Once again I have an issue. So me being a novice at databases wasn't sure it was me that was missing something in the process to get this going. So I spoke to Tech support at my host, they sent the reply below.

Looking at the .sql script the plugin comes with, it doesn’t look like it includes that table. I tried recreating the database using the .sql script it comes with, but am being met with this error:

SQL Error (1349): View’s SELECT contains a subquery in the FROM clause



This causes the script to not apply fully. You may need to report this issue to the plugin developer to see if they can offer a workaround.

Now this is what I see in game as an error:
[ERROR] TQ_PlayerConnectAnnounce :: Query failed (Reason: Table 'playerstats.stats_vw_player_ranks' doesn't exist)
[ERROR] TQ_ShowPlayerRankPanel :: Query failed (Reason: Table 'playerstats.stats_vw_player_ranks' doesn't exist)



So I hope this helps and once again thanks for all the previous help Crasher_3637.

Last edited by FatalOE71; 06-10-2019 at 20:17.
FatalOE71 is offline
thresh0ld
Senior Member
Join Date: Sep 2009
Location: Hell
Old 06-11-2019 , 05:24   Re: [L4D2] Simple In-Game Player Statistics
Reply With Quote #13

Quote:
Originally Posted by FatalOE71 View Post

SQL Error (1349): View’s SELECT contains a subquery in the FROM clause
What version of mysql/mariadb are you using? From the looks of it your current version does not seem support sub-queries in the select statement. Sub-queries are supported from 5.7.7 and above.

Last edited by thresh0ld; 06-11-2019 at 05:25.
thresh0ld is online now
FatalOE71
Member
Join Date: Jun 2018
Old 06-11-2019 , 14:52   Re: [L4D2] Simple In-Game Player Statistics
Reply With Quote #14

Quote:
Originally Posted by thresh0ld View Post
What version of mysql/mariadb are you using? From the looks of it your current version does not seem support sub-queries in the select statement. Sub-queries are supported from 5.7.7 and above.

I will check with our host on that question as I don't know. Thanks it be nice if it a simple upgrade to the software.



So "thresh0ld" you were 100% correct, the software was out of date. They upgraded the software works like a charm now. Thanks much appreciated.

Last edited by FatalOE71; 06-11-2019 at 20:39.
FatalOE71 is offline
zaviier
Junior Member
Join Date: Aug 2017
Old 06-15-2019 , 16:44   Re: [L4D2] Simple In-Game Player Statistics
Reply With Quote #15

can someone help me?
i got this error


[ERROR] TQ_PlayerConnectAnnounce :: Query failed (Reason: View 'db32213.stats_vw_player_ranks' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them)
#Cstrike_TitlesTXT_Game_connected
Receiving uncompressed update from server
[INFO] Player 'ZaviieR' is viewing his own rank
[ERROR] TQ_ShowPlayerRankPanel :: Query failed (Reason: View 'db32213.stats_vw_player_ranks' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them)
zaviier is offline
thresh0ld
Senior Member
Join Date: Sep 2009
Location: Hell
Old 06-16-2019 , 03:50   Re: [L4D2] Simple In-Game Player Statistics
Reply With Quote #16

Quote:
Originally Posted by zaviier View Post
.....or definer/invoker of view lack rights to use them...

Make sure the database user used by the plugin have the right set of permissions to access the view.
thresh0ld is online now
zaviier
Junior Member
Join Date: Aug 2017
Old 06-16-2019 , 07:01   Re: [L4D2] Simple In-Game Player Statistics
Reply With Quote #17

Quote:
Originally Posted by thresh0ld View Post
Make sure the database user used by the plugin have the right set of permissions to access the view.
how to do that bro?
zaviier is offline
Reply


Thread Tools
Display Modes

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 07:56.


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