By insomoz on
I had this error in version of 4.5 and when I updated to 4.6, I get the same error.
I've been searching for a solution, But I have had no luck so far.
This are the type of errors I get
http://www.footballclips.net/images/error_drupal.jpg
/taxonomy_menu/6/14/taxonomy/term/37/all/taxonomy/term/feed/all/taxonomy/term/feed/all/taxonomy/term/feed/all/taxonomy/term/feed
Message Duplicate entry '%s' for key 1 query: INSERT INTO cache (cid, data, created, expire, headers) VALUES ('http://www.footballclips.net/taxonomy_menu/6/14/taxonomy/term/37/all/tax... in /home/football/public_html/includes/database.mysql.inc on line 66.
Comments
fush the cache
flush the cache table and check and check it.
I don't know how to flush the cache, just search this site.
Sunny
www.gleez.com
go and download the db
go and download the db module and then you will be able to access the cache through that module.
MySQL
From command line (ssh) do:
mysql -uusername -ppassword dbname
> DELETE FROM cache;
Or just enter the DELETE command from PHPMyAdmin, or select TRUNCATE for that table.
That will solve the problem short term, but I guess it may recurr.
--
Drupal development and customization: 2bits.com
Personal: Baheyeldin.com
--
Drupal performance tuning and optimization, hosting, development, and consulting: 2bits.com, Inc. and Twitter at: @2bits
Personal blog: Ba
I have deleted the cache by
I have deleted the cache by running
DELETE FROM cache;
Query OK, 287 rows affected (0.03 sec)
and ran it a few more times
mysql> DELETE FROM cache;
Query OK, 85 rows affected (0.00 sec)
mysql> DELETE FROM cache;
Query OK, 0 rows affected (0.00 sec)
But I'm still getting lots of these errors, per minute
Duplicate entry '%s' for key 1 query: INSERT INTO cache (cid, data, created, expire, headers) VALUES ('http://www.footballclips.net/taxonomy_menu/6/14/taxonomy/term/37/all/tax... in /home/football/public_html/includes/database.mysql.inc on line 66.
Same situation
It slowed down yesterday since deleting cache, but now its back to pretty much 1000 of these errors a day.
please help, I search
"Unknown column feed" on google but I find nothing, however carefully examing the code it says
FROM node n INNER JOIN term_node
So that must mean that the node table is corrupt,
then it says Inner Join - term node, so basically its the feed terms that are corrupt, I have no idea how I can fix this though...
Disable caching
have you tried disabling the cache? Depending on your load, you may not even need caching.
Disabling caching
This is terrible for the website If i do this, I've disabled the cache twice before and both times my traffic dropped by 50%
solved
I simply deleted all the categories, no more of these errors might have to start again, but ill be backing up alot more and monitoring the logs
Im still getting flooded
Im still getting flooded with errors 3 months on, deleting from the cache does nothing, the errors look like this
User Anonymous
Location /taxonomy_menu/1/1/taxonomy/term/6/all/taxonomy/term/feed/all/taxonomy/term/feed/all/taxonomy/term/feed/all/taxonomy/term/feed/a
Message Unknown column 'feed' in 'where clause' query: SELECT COUNT(DISTINCT(n.nid)) FROM node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE tn.tid IN (feed) AND n.status = 1 in /home/football/public_html/includes/database.mysql.inc on line 66.
User Anonymous
Location /taxonomy_menu/1/1/taxonomy/term/6/all/taxonomy/term/feed/all/taxonomy/term/feed/all/taxonomy/term/feed/all/taxonomy/term/feed/a
Message Unknown column 'feed' in 'where clause' query: SELECT DISTINCT(n.nid), n.sticky, n.title, n.created FROM node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE tn.tid IN (feed) AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10 in /home/football/public_html/includes/database.mysql.inc on line 66.
User Anonymous
Location /taxonomy_menu/1/1/taxonomy/term/6/all/taxonomy/term/feed/all/taxonomy/term/feed/all/taxonomy/term/feed/all/taxonomy/term/feed/a
Message Duplicate entry '%s' for key 1 query: INSERT INTO cache (cid, data, created, expire, headers) VALUES ('http://www.domain.net/taxonomy_menu/1/1/taxonomy/term/6/all/taxonomy/ter... in /home/football/public_html/includes/database.mysql.inc on line 66.
I'm just constantly gettin these errors,
help!
Two problems
This one may be caused by a spammer flooding you with requests for redirection.
This one is different and indicates that you have a module that has a programming error in it (feed should be a numeric value).
--
Drupal development and customization: 2bits.com
Personal: Baheyeldin.com
--
Drupal performance tuning and optimization, hosting, development, and consulting: 2bits.com, Inc. and Twitter at: @2bits
Personal blog: Ba
unkown column 'feed'
"This one is different and indicates that you have a module that has a programming error in it (feed should be a numeric value).
Unknown column 'feed' in 'where clause' query"
How can I find out which modules are causing the problems, because I have only these modules installed, from a fresh install.
-> taxonomy module, excerpt, pathauto, nodewords & gsitemap, with the default modules.
It was a spammer, same ip,
It was a spammer, same ip, solution block the ip
cant believe it took me so long to think of it, theyve been doing it for months
I suspect not a spammer...
But perhaps it was someone with a faulty news aggregator. I've had a very similar problem with someone using Google Desktop 2. It's 'feed discovery' mechanism was ignoring Drupal's use of the tag, and this sents GD into some sort of relative-link cascade, with Drupal's dynamic rewriting not recognizing what was going on (treating the continually growing url as valid url query parameters, not really Drupal's fault).
I.e. In my case, GD was seeing '
'
When autosensing at /forum/80
So it would try to request:
/forum/80/taxonomy/term/80/0/feed (because it wasn't recognizing the base href of "http://www.example.com" and requesting "http://www.example.com/taxonomy/term/80/0/feed")
But requesting /forum/80/taxonomy/term/80/0/feed actually returns the SAME content as /forum/80, so GD would then note that there was an RSS link in the returned page and would try and use it, desperately searching for a valid rss feed to use, appending this relative rss-url to the current location of /forum/80/taxonomy/term/80/0/feed... and so on and so on... Until the URL got so long it would finally make Drupal return a Page Not Found error, which incidentally didn't have a rss link on it.
Anyways, I don't get the problem anymore, so either whoever it was notice that the feed was never getting any items and unsubscribed, or GD has been updated to respect base href tags. Who knows.
I suspect this is the same problem for you, based on the 'feed' items in your repeated url parts.
The same problem will occur if a not-supporting-base-href-spider tries to index your site.
My original post about my problems: http://drupal.org/node/30519
And the bug to get drupal to stop using the base href'd relative urls:
http://drupal.org/node/13148
A feed aggregator would definitly come from nearly the same ip, and if it's check frequency was pretty short, you'd see the same error over and over.
---
http://blog.apathyant.com | http://www.brentc.com
I think you've hit the nail
I think you've hit the nail on the head, im still getting slaughtered, and turning off the aggregator has stopped giving me these errors, but just wondering if theres a fix for it?
I think...
I think the answer lies in getting the patch submitted to this bug committed to HEAD:
http://drupal.org/node/13148
---
http://blog.apathyant.com | http://www.brentc.com
If you'd like to help get it
If you'd like to help get it committed, apply the patch from that bug report to your installation and report your findings on that bug trail.
Treehouse