TorabRamin Posted November 10, 2020 Share 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 Link to comment Share on other sites More sharing options...
brian! Posted November 10, 2020 Share 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 Link to comment Share on other sites More sharing options...
TorabRamin Posted November 10, 2020 Author Share 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 Link to comment Share on other sites More sharing options...
ahwaznoname Posted February 25, 2023 Share Posted February 25, 2023 how we can solve this problem ? can you help me please 0 Quote Link to comment Share on other sites More sharing options...
pRieStaKos Posted February 25, 2023 Share Posted February 25, 2023 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 Link to comment Share on other sites More sharing options...
ahwaznoname Posted February 26, 2023 Share Posted February 26, 2023 can you please explain more ? 0 Quote Link to comment Share on other sites More sharing options...
ahwaznoname Posted February 26, 2023 Share Posted February 26, 2023 17 hours ago, pRieStaKos said: 🤓 can you please explain more ? 0 Quote Link to comment Share on other sites More sharing options...
leemahoney3 Posted February 26, 2023 Share Posted February 26, 2023 6 hours ago, ahwaznoname said: can you please explain more ? Check that your database user has the required permissions. 0 Quote Link to comment Share on other sites More sharing options...
twhiting9275 Posted February 26, 2023 Share Posted February 26, 2023 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 Link to comment Share on other sites More sharing options...
bear Posted February 27, 2023 Share Posted February 27, 2023 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 Link to comment Share on other sites More sharing options...
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.