Sql error on cache cleaning (I think)
Ibn al-Hazardous - January 16, 2008 - 10:36
| Project: | Media Manager |
| Version: | 5.x-0.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
Every time the site does something that triggers what I believe is a cache cleaning, I get a load of sql-errors that look like this:
user warning: Duplicate entry '5' for key 1 query: INSERT INTO gft_menu (mid, pid, path, title, description, weight, type) VALUES (5, 54, 'admin/settings/media/settings', 'Settings', '', 0, 22) in /home/filip/tmp/drupal/includes/database.mysql.inc on line 172.It's one error for each menu entry of mmedia.
Seeing that this is one of the "local" tables, and that the error isn't occurring on the main site (using exclusively global tables) indicates that this problem is limited to my kind of whacky installation.
#1
I've never had this error before, so what you say about the "local" tables, I'm not sure of.
If you can locate why it would be trying to add multiple cache settings, I'd be interested to find out what the cause is.
#2
The kind of setup I have is described here. I share exactly the same tables as described in that handbook.
I made a little sanity check on my database, and came up with an interesting idea: The inserts set a value for mid - only those values are already taken by other menu items. The error is for inserting menu elements with mids between 17 and 28. That gives an error since I already have other menu items there. I suppose the error would go away if we don't provide the mid in the INSERT.
Could it be that you're storing the mids somewhere in another table?
#3
What I don't get, is why it's trying to do the menu items again.
It doesn't have anything really to do with storing tables, or menu items (the only MID that I use, is that for the media files), and I don't understand why that apply to the menu table.
Anyway, I'll try to look at this later, since I'm trying to finish the media_gallery, cleanup the problems I'm having with a clean download, installed onto a new site.... etc....
#4
A weird thing is that the menu items are visible in the menu, in spite of these error messages. Maybe it refers to a variable that is only set for one of the sites?
I'm going to make a clean reinstall on the php4-server later today. Will get back if it yields anything important. (One thing I'm going to try, in order to work around lokal-global errors - is to install all modules first, and then clone the tables for the local sites.)
#5
Did you end up getting any results on this? I've not had the problem at all, nor can I seem to replicate it, with the tiny setup I have. I'm moving to get a stable version on the web, so I'd be happy to hear of how it's going.
#6
I don't have a conclusive result on this. After banging my head against the wall for a while, I adopted another way of dealing with multiple domains and their data - the multi-domain module. Haven't tried media manager since the migration, so I can't tell if it's working now.
I will try within a week, if I don't report back a failure within two weeks - feel free to close the bug as fixed.
#7
No more reports, closing issue.
#8
Automatically closed -- issue fixed for two weeks with no activity.