I cant, login to wordpress admin

Hello @franks123

I am sorry about the issue you are experiencing, however, this is not related to W3 Total Cache.
As the error suggests, the problem is with the permissions or the database size. In any case, you should reach out to yoru hosting provider and check the permissions and/or check the database size.
Thank you!

yes it is database size issue.

View post on imgur.com

can you guide me how to reduce the size of database. I have done R&D on google and found this link

https://redearthdesign.com/help-center/troubleshooting-cant-log-in-to-wordpress-admin/

please guide me how to remove transient from options table according to this guide link

Hello @franks123

Please understand that this is out of W3TC scope and the below is just a suggestion and you should reach out to your hosting support.

You can check to see how many transients are being stored in your options database table by using phpMyAdmin and then searching for the following option name from the options database table;

_transient_%

This will return all of the options that are transients which will give you an idea of the number of transients currently being stored on your site database.

You could also delete all existing transients using the following MySQL query in phpMyAdmin;

DELETE FROM wp_options WHERE option_name LIKE (‘%\_transient\_%’)

Once again, the best thing is to reach out to your hosting support as they should help you to fix this issue since the problem is in the database size.

Thanks!

hi @vmarko
if i do this in database, then there will issue or not

DELETE FROM wp_options WHERE option_name LIKE (‘%\_transient\_%’)

please guide me about this thing

Hello @franks123

As I’ve mentioned you should reach out to your hosting support.
There should be no issues, you are just clearing the transients from the database table.
Thanks!

ok i am reaching to hosting support