By sharique on

I'm getting this error today on my site.

Warning: Table 'watchdog' was not locked with LOCK TABLES query:
INSERT INTO watchdog (uid, type, message, severity, link, location,
referer, hostname, timestamp) VALUES (1, 'php', '<em>Incorrect key
file for table &amp;#039;./db/cache_filter.MYI&amp;#039;; try to
repair it\nquery: UPDATE cache_filter SET data =
&amp;#039;&amp;lt;p&amp;gt;&amp;lt;center&amp;gt;&amp;lt;/p&amp;gt;\\n&amp;lt;script
type=\\&amp;quot;text/javascript\\&amp;quot;&amp;gt;&amp;lt;!--\\ngoogle_ad_client
= \\&amp;quot;pub-1546960418249054\\&amp;quot;;\\ngoogle_ad_width =
468;\\ngoogle_ad_height = 15;\\ngoogle_ad_format =
\\&amp;quot;468x15_0ads_al\\&amp;quot;;\\n//2007-04-29:
IMI_top\\ngoogle_ad_channel =
\\&amp;quot;5056570434\\&amp;quot;;\\n//--&amp;gt;\\n&amp;lt;/script&amp;gt;&amp;lt;/p&amp;gt;\\n&amp;lt;script
type=\\&amp;quot;text/javascript\\&amp;quot;\\n
src=\\&amp;quot;http://pagead2.g in
/www/includes/database.mysqli.inc
on line 151

I don't understand what has gone wrong.
-------
Sharique

⋅ Categories: Drupal 5.x

Comments

dellis’s picture

dellis commented

I just tried adding the google analytics module and this is what I get when I edit the user roles that should be tracked. this was with the 5.2 official release of the analytics module.

sharique’s picture

sharique commented

This is not the case with me. This site is working fine till 9 jun. I really doesn't understand what's wrong.
--
Sharique uddin Ahmed Farooqui
IT head, Managefolio.com

Sharique Ahmed Farooqui

gtaylor’s picture

gtaylor commented

I had the same thing happening on my 5.1 site. I noticed most of the errors coming from links on my recent comments block.

I don't have google analytics installed.
I don't have cache on since I want to show the number of concurrent users.

I ran a check MySql Database on my install and found a ton of errors.
I then ran a Repair and the database and subsequent check again. All errors cleaned up.
Now the errors on my site appear to be gone. I'm assuming my check/repair fixed things. But will keep an eye out.

I do encourage you to try this.