'Table already exists' error

1 reply [Last post]
ptocco
Offline
Last seen: 2 years 28 weeks ago
Joined: 2014-10-09

I'm currently in Advanced Site Building. Around lesson 61 of 246, I installed Panels. However Panels was not working so I reverted to a previous backup and began retracing my steps. (Either Panels or something I did seems to have prevented the display of the sidebar 2nd and the image. I may have selected "Full Content" display instead of Default display, which was set up for 3 columns etc.) In any case, retracing my steps did restore the columns and the image, but when I tried to install Panels again I got this message:

DatabaseSchemaObjectExistsException: Table panels_display already exists. in DatabaseSchema->createTable() (line 657 of /Users/MacBookPro/Sites/acquia-drupal/includes/database/schema.inc).

It seems this opens a whole can of worms: The vast majority of modules do not have an uninstall option and there is no clear, systematic way to uninstall them. This post reveals some of the nuances:

https://www.drupal.org/node/1551132

It would seem that removing some modules requires locating its entry in the MySQL table and deleting it. I'm wondering how so important a procedure could have so little space in the Drupal forums or BAM.

Is Drush the key? I know Drush installs but haven't used it for uninstall.

Any and all insights are greatly appreciated.

Peter

Chris Shattuck
Offline
Last seen: 7 weeks 1 day ago
Joined: 2009-08-16
Hi Peter, It does look like a

Hi Peter,

It does look like a bit of a can of worms, but you can keep it simple for now. If you are comfortable using PHPMyAdmin or another database admin tool, I believe you can remove any tables that cause this error to get the backup to restore properly. Of course, long term it would be great if there's a patch that resolves this without requiring mucking around with the database directly.

I don't know of anything that would cause Drush to work any differently than restoring a backup through the interface, so I'm not sure that's a solution, though if someone else has a different experience, that would be great to hear.

I hope that helps!

Cheers,
Chris

Add to playlist

Add to , or

Add to new playlist:

Add to playlist
This is a member-only feature
But, it's easy to become a member

Add to cart:


Loading...
Contact us

Below are the supported keyboard shortcuts for our video player.

space
Start / stop video
shift
Go to next video
shift
Go to previous video
Increase or decrease player speed by 20%
Skip ahead or go back by 15 seconds
1...9
Jump to a percentage (2 is 20%, for example)
f
Toggle full screen
Videos Pricing More Search
BuildAModule Logo Icon BuildAModule Logo Icon
Become a member!
$29
1 month
$156
6 months
10% off
$276
12 months
20% off
All memberships come with the following:
24 / 7 access to the entire 1800+ video library
An innovative video player with a rolling transcript
Extensive Drupal and cross-platform training
A thorough and thoughtful training style
Progress tracking
Take notes on specific video sections
Intuitive multi-user management
How many users?
user
Go solo with a single user, or give multiple team members access through one account and get discounts by bundling multiple users into a single membership.