I apologize for the lame request in my title but I have for the last couple of weeks if not months trying really really hard and cracking my head over this problem i keep on having with panels 2 when i check my tables in phpmyadmin and i get phpmyadmin telling me after i do a table check this error:

Problems with indexes of table `panels_mini`
The following indexes appear to be equal and one of them should be removed: name, name_2
Problems with indexes of table `panels_object_cache`
The following indexes appear to be equal and one of them should be removed: sid, panels_object_cache_idx
Problems with indexes of table `panels_page`
The following indexes appear to be equal and one of them should be removed: name, name_2

I just cant understand what im doing wrong..I seem to end up with this error on every occation even on a new install of drupal 5.7. Im using php version 5.2.5 and mysql version 5.0.45.

This problem eventually leads to my drupal webpage to just pack up, im assuming due to the overload caused due to the indexes name collisions in the tables?

Please help someone, please.

Adam.

Comments

memento_mori’s picture

memento_mori commented
Assigned: memento_mori » Unassigned
sdboyer’s picture

sdboyer commented
Assigned: Unassigned » sdboyer
Status: Active » Postponed (maintainer needs more info)

What's really odd is that this problem is persisting through new drupal installs. However, simply reinstalling drupal doesn't necessarily guarantee you a 'clean' install - between these drupal installs, are you dropping all the tables in your database (or at least the panels tables that are giving you problems)? If you're not, then the indices persist across installations and could be the cause of this error. It sounds like you skipped running update.php after getting a new version of panels somewhere along the line.

I need you to open up the 'system' table on one of the installs where you're getting this error, find the record where name = panels, and tell me what the value is in the 'schema_version' field.

You're sure you're using the most recent panels2 installer?

sdboyer’s picture

sdboyer commented
Priority: Critical » Normal
memento_mori’s picture

memento_mori commented

Hi sdboyer, thank you so much for trying to help me out...i really appreciate it.

Yes, as far as i can tell I am using the most recent panels 2 install.

Regarding what you asked me to do about going into the systems table and going to the record where name = panels, and checking what the schema version field is:

Field Type Function Null Value

filename varchar(255) sites/all/modules/panels/panels.module
name varchar(255) panels
type varchar(255) module
description varchar(255) Core Panels display functions
status int(11) 1
throttle tinyint(4) 0
bootstrap int(11) 0
schema_version smallint(6) 5214
weight int(11) 10

Sorry for the ghetto write up details...i hope that was what you were asking for... 5214?

cheers,
adam.

memento_mori’s picture

memento_mori commented

Sorry sdboyer, I formatted that last post nicely so that everything was in line as a table with the values but once i posted it, it just got unformatted and looks a mess...

sdboyer’s picture

sdboyer commented

No problem on the formatting. Yep, 5214 is the number that it should be; it's the most recent db schema number.

Have you tried removing the old panels tables (or simply flushing all the tables in the database) and then reinstalling drupal?

sdboyer’s picture

sdboyer commented

Scratch my initial line of questioning. Turns out you're actually describing something that's a direct result of the way the beta2 code is set up - it DOES produce these duplicate indexes.

It's not a critical problem, however, as it's not actually causing anyone else's panels2 to fold up and die - and that includes people operating on both older and newer versions of mysql. I'm fixing this for beta3 so that there are no more duplicate indexes, but unless your webhost has unnecessarily high error sensitivity on its mysql setup, this shouldn't be the cause of any permanent problems for you.

memento_mori’s picture

memento_mori commented

Finally..someone said it..thank god...I have been thinking im going insane over the last couple of months now with this issue and installing and reinstalling again and again thinking i have been doing something wrong since no one else has ever mentioned having this issue as well (not to my knowledge despite my many searches).

Firstly I would like to say thank you to you personally Sdboyer for taking the time to reply to my help request. Secondly, I would just like to say that panels 2 totally rocks and I strongly believe its gonna change drupal for the better =). I admire your work with the panels 2 module and you along with anyone else involved with panels 2 deserves much praise.

Thanks Sdboyer =)

Cheers

Adam Nicholson.

sdboyer’s picture

sdboyer commented
Status: Postponed (maintainer needs more info) » Fixed

Thanks Adam, that's very kind of you. I'm glad I could help. Hopefully the upcoming beta3 release will ease that headache :)

cheers

sam

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.