I created a website using Drupal 6 and the web host Network Solutions. The other day I noticed I could not login to the website. Here is the message I get:
Warning: UPDATE command denied to user 'jfornash'@'205.178.145.68' for table 'cache' query: UPDATE cache SET data = 'a:366:{s:13:\"theme_default\";s:14:\"adomhealthplan\";s:13:\"filter_html_1\";i:1;s:18:\"node_options_forum\";a:1:{i:0;s:6:\"status\";}s:18:\"drupal_private_key\";s:64:\"28c0ce8ac87e302f7f464ee562c330c8499839d479277d6d8a5cf96f2409b162\";s:10:\"menu_masks\";a:27:{i:0;i:127;i:1;i:63;i:2;i:62;i:3;i:61;i:4;i:59;i:5;i:58;i:6;i:57;i:7;i:56;i:8;i:45;i:9;i:31;i:10;i:30;i:11;i:29;i:12;i:28;i:13;i:24;i:14;i:22;i:15;i:21;i:16;i:15;i:17;i:14;i:18;i:11;i:19;i:10;i:20;i:8;i:21;i:7;i:22;i:6;i:23;i:5;i:24;i:3;i:25;i:2;i:26;i:1;}s:12:\"install_task\";s:4:\"done\";s:13:\"menu_expanded\";a:0:{}s:9:\"site_name\";s:22:\"www.adomhealthplan.org\";s:9:\"site_mail\";s:21:\"info@adambadlotto.com\";s:21:\"date_default_timezone\";i:-14400;s in /data/17/1/9/54/1661217/user/1791485/htdocs/includes/database.mysqli.inc on line 128
After doing some research, I realized that the problem is that my database is full. Network solutions allows only 300 megs per database and mine is about 314 megs. I tried emptying the cache tables and the watchdog tables using phpmyadmin, but this did not resolve the issue.
I thought that maybe my database user did not have the ALL permissions for the database, but Network Solutions only allows one master user for database management and the master user automatically gets ALL permissions.
Please help, I have no idea what to do next and I am not a database programmer, so this is getting above my head.
Comments
Look like you have
Look like you have Permissions issue. If you believe you have ALL permissions then try to re-create your database user then re-assign all permissions again.
Also try to use PHPMyadmin to check if UPDATE command works properly. On some hosting you need to wait 2-5 minutes before empty database will decrease your space.
Problem solved! Last night I
Problem solved! Last night I emptied all the cache tables and the watchdog table in the database. This didn't immediately resolve the problem, but I just checked the website now and it's working fine! I checked the database and it is now a little over 3mb large (as opposed to 314mb from last night).
If you have reached the size
If you have reached the size limit that your host allows, and you need more space, you will need to either:
1) Upgrade plans with your host to get more database space
2) Change hosts to one that offers more DB space
3) Delete stuff from your database.
If you decide to go with number 3, you can safely delete everything in the cache tables. But these will fill up again quickly, and you will likely run into the same problem. So you are probably best going with number 1 or number 2.
Jaypan We build websites
Problem solved! Last night I
Problem solved! Last night I emptied all the cache tables and the watchdog table in the database. This didn't immediately resolve the problem, but I just checked the website now and it's working fine! I checked the database and it is now a little over 3mb large (as opposed to 314mb from last night).
My next question: How can I prevent this from happening again? Is there a way for the database to clear the cache tables every once in a while automatically?
Thanks!