Magento Design Change Error
If you are here, chances are you were in your Magento admin System>Design and decided you wanted to see what the various changes look like. So you applied the cnage. Then you wanted to see what the next one looked like, but when you went to apply the change to Magento, you got this error:
Find out where your website ranks with your chosen keywords in Google, Yahoo and Bing.
14 day free trial. No credit card required.
“Your design change for the specified store intersects with another one, please specify another date range”
This is a buggy issue with Magento that requires that you go into phpMyAdmin and select the database you have configured to your store and then scroll down the tables until you find the one called design_change. If you set up a table prefix during installation, it will be called prefix_design_change where prefix is the actual name you gave during the Magento installation. Click on that link and open that table up. There you will see a record created showing the name of the design you had added to Magento. In that record you will see something that says “delete”, a little red circle with a line going through it. Click that. A confirmation box comes up and you click yes to verify. Your Magento design problem is now solved.
Note: Do not drop the entire table!. Only delete the record within the table.