[ad_1]
Hi @rakesh535 !
I would be more than happy to assist you today.
What the update is failing for is the count.
In this link I attach the documentation for you to optimize the database, please follow the instructions to see that your database is optimized with the changes that we recommend in this document.
If after following the instructions in this document it still does not work, then you will need to add an index to the user earnings meta table.
This index can be added manually using your database manager (commonly, PHPMyAdmin):
ALTER TABLE gamipress_user_earnings_meta ADD INDEX user_earning_id(user_earning_id);
Note: In your site, the table is not named “gamipress_user_earnings_meta”, WordPress adds a random prefix to prevent hackers to access to your database, so if your prefix is “mywp_” the database table is named “mywp_gamipress_user_earnings_meta” which is a combination of the random prefix + the database table name.
Hope it helps!