So many errors and access denied!

Jboo - May 15, 2008 - 10:34

Hi,

I'm having a few problems with my site even though I haven't edited the site in any way for quite some time. I'm getting plenty of errors and also seeing "access denied" messages on many pages. For examples see a few of my pages at:

http://qwikezine.com/node?page=26
http://qwikezine.com/computing-technology
http://qwikezine.com/automotive

Does anyone know what these errors are and why i'm having access denied errors?

Thanks for any help.

» Login or register to post comments

Check your watchdog table?

phonydream2 - May 15, 2008 - 11:01

Do you have cron set to periodically empty your watchdog table? It's hard to say what's wrong by just looking at these pages. Also, you can set apache to stop outputting those php error messages on the webpage, useful if the site is live but won't necessarily solve the problem.

Add this at the beginning of your .htaccess file:

php_flag display_errors off

As the errors say, the table

gpk - May 15, 2008 - 12:22

As the errors say, the table {watchdog} is marked as crashed so you need to run the Repair option on it. In phpMyAdmin go to the table, hit the Operations tab and Repair table is near the bottom under Table maintenance.

gpk
----
www.alexoria.co.uk

phonydream2, I don't have

Jboo - May 16, 2008 - 10:50

phonydream2, I don't have cron set up to empty the table, should it be?

gpk, I tried the repair option on the table yesterday but it doesn't seem to have altered anything. There wasn't an overhead on the table before I repaired it (don't know if this matters!).

Thanks for your replies. Any more suggestions would be appreciated.

...

phonydream2 - May 16, 2008 - 11:03

If you go to admin/settings/error-reporting you can set up Drupal to clear from the watchdog table...otherwise it gets very big and might be the reason for the crash.

At a guess, I'd say your PHP error messages are preventing sessions being passed. Did you try to suppress the php error messages like I suggested?

Have you looked at your apache log and the errors the watchdog log is giving?

If nothing is helping in that area, I'd make a copy of the watchdog table and all its values, then delete it, then create it from fresh without any data. First try and isolate the cause.

I'm guessing that the

Alan D. - May 16, 2008 - 12:45

I'm guessing that the watchdog table is going to be fairly full looking at the output. I'd try and get any meaningful messages out of it, then emptying it using "TRUNCATE watchdog;" or empty via phpmyadmin. If it is a storage issues, empty your temp directory as well. Space issues never give meaningful errors.

Alan Davison
www.caignwebs.com.au

I haven't tried to suppress

Jboo - May 16, 2008 - 15:41

I haven't tried to suppress the php error messages yet but I'll give it a go. I won't be able to get into the watchdog from the admin because unfortunately i'm getting "access denied" on the admin pages! So, looks like I might have to empty the table from phpmyadmin and see if that solves the problem.

Thanks for all your help, it's much appreciated.

Watchdog Crashe

Garden One - May 27, 2008 - 21:56

I have the same problem, using Drupal 5.7 and php 5.1.1A. As of yesterday, I'm getting a long php error stating Watchdog is crashed and needs repair. I do have cron set up and the option to empty watchdog every three (3) days. With that said, I don't think Watchdog ever got clean out.

If anyone finds an solution, please post it here. Thx

Use phpMyAdmin or whatever

gpk - May 27, 2008 - 22:16

Use phpMyAdmin or whatever to repair the table, or perhaps just empty it, as already described here. Either should fix the message about watchdog table being crashed.