[FatalOE71]

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]

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.

[thresh0ld]

Originally Posted by FatalOE71 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.

[FatalOE71]

Originally Posted by thresh0ld 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.

[zaviier]

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)

[thresh0ld]

Originally Posted by zaviier .....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.

[zaviier]

Originally Posted by thresh0ld 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]

bump!

still need answer how to set the permission to access
because my host provider, just give me 4 option.. and i can't see permission option

[thresh0ld]

Originally Posted by zaviier bump! still need answer how to set the permission to access because my host provider, just give me 4 option.. and i can't see permission option

You should be able to configure it from phpmyadmin. Besides the privileges, you need to make sure all the database entities have been imported successfully. You should be able to see these from your database browser (phpMyAdmin).

• APPLY_MODIFIER
• STATS_PLAYERS
• STATS_SKILLS
• STATS_VW_PLAYER_RANKS
• STATS_VW_PLAYER_RANKS_EXTRAS

[zaviier]

Originally Posted by thresh0ld You should be able to configure it from phpmyadmin. Besides the privileges, you need to make sure all the database entities have been imported successfully. You should be able to see these from your database browser (phpMyAdmin). APPLY_MODIFIER STATS_PLAYERS STATS_SKILLS STATS_VW_PLAYER_RANKS STATS_VW_PLAYER_RANKS_EXTRAS

yeah, already import that all.
i'm very newbie about this, that why i need help
already contact my host provider and they still can't help me