TorabRamin 0 Posted November 10, 2020 Unable to complete incremental updates: Unable to import the 8.0.0 Alpha1 database file. Unable to import /home/******/public_html/resources/sql/upgrade800alpha1.sql: SQLSTATE[42000]: Syntax error or access violation: 1142 INDEX command denied to user '******'@'localhost' for table 'tblactivitylog' 0 Quote Share this post Link to post Share on other sites
brian! 3433 Posted November 10, 2020 I would think that the db user doesn't have sufficient privileges to perform the desired task, e.g it needs to be able to use INDEX. https://docs.whmcs.com/Further_Security_Steps#Restrict_Database_Privileges Quote Most tasks only require the following database privileges: DELETE INSERT SELECT UPDATE LOCK TABLES Installation, upgrades, and activating and deactivating modules require the following additional privileges: ALTER CREATE DROP INDEX 0 Quote Share this post Link to post Share on other sites
TorabRamin 0 Posted November 10, 2020 you was right. Thank you 35 minutes ago, brian! said: I would think that the db user doesn't have sufficient privileges to perform the desired task, e.g it needs to be able to use INDEX. https://docs.whmcs.com/Further_Security_Steps#Restrict_Database_Privileges 0 Quote Share this post Link to post Share on other sites
ahwaznoname 1 Posted February 25 how we can solve this problem ? can you help me please 0 Quote Share this post Link to post Share on other sites
pRieStaKos 37 Posted February 25 On 11/10/2020 at 4:39 PM, brian! said: I would think that the db user doesn't have sufficient privileges to perform the desired task, e.g it needs to be able to use INDEX. https://docs.whmcs.com/Further_Security_Steps#Restrict_Database_Privileges 🤓 0 Quote Share this post Link to post Share on other sites
ahwaznoname 1 Posted February 26 can you please explain more ? 0 Quote Share this post Link to post Share on other sites
ahwaznoname 1 Posted February 26 17 hours ago, pRieStaKos said: 🤓 can you please explain more ? 0 Quote Share this post Link to post Share on other sites
leemahoney3 33 Posted February 26 6 hours ago, ahwaznoname said: can you please explain more ? Check that your database user has the required permissions. 0 Quote Share this post Link to post Share on other sites
twhiting9275 52 Posted February 26 On 2/25/2023 at 6:32 AM, ahwaznoname said: how we can solve this problem ? can you help me please This thread is over 2 years old now. You need to start your own, as this is not likely the same issue. Hijacking threads, not cool. 0 Quote Share this post Link to post Share on other sites
bear 213 Posted February 27 12 hours ago, twhiting9275 said: Hijacking threads, not cool. It's not a hijack if it's the same issue. Many "support" channels have something like "I have this problem too", so it's understandable. As for starting his own, I've seen threads ignored here (lack of interest, lack of user participation?), so he may have thought he stood a better chance adding his to a similar/same thread and not get yelled at by the "community police" that there were already threads about this...only to be yelled at for not starting one. Irony. 0 Quote Share this post Link to post Share on other sites
