playgron Posted October 28, 2018 Group: Members Topic Count: 8 Topics Per Day: 0.00 Content Count: 24 Reputation: 2 Joined: 11/19/16 Last Seen: July 6, 2024 Share Posted October 28, 2018 (edited) So im using this kinda script to truncate my mvp_rank table on every sunday , this is the example of the script: brasilis,223,189,3 script testtt 900,{ query_sql "truncate table mvp_rank"; end; } but when I tried it , it gave me errors [SQL]: DB error - DROP command denied to user 'asda'@'localhost' for table 'mvp_rank' [Debug]: at script.cpp:16557 - truncate table mvp_rank Anyone know how to make this possible ? Edited October 28, 2018 by playgron Quote Link to comment Share on other sites More sharing options...
0 playgron Posted October 28, 2018 Group: Members Topic Count: 8 Topics Per Day: 0.00 Content Count: 24 Reputation: 2 Joined: 11/19/16 Last Seen: July 6, 2024 Author Share Posted October 28, 2018 SOLVED I forgot to give access to my other sql user for drop , closed. Quote Link to comment Share on other sites More sharing options...
Question
playgron
So im using this kinda script to truncate my mvp_rank table on every sunday , this is the example of the script:
brasilis,223,189,3 script testtt 900,{ query_sql "truncate table mvp_rank"; end; }
but when I tried it , it gave me errors
[SQL]: DB error - DROP command denied to user 'asda'@'localhost' for table 'mvp_rank' [Debug]: at script.cpp:16557 - truncate table mvp_rank
Anyone know how to make this possible ?
Edited by playgronLink to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.