1 step solution for magento “Your design change for the specified store intersects with another one, please specify another date range” error

Magento is becoming more and more popular day by day with it’s super flexible e-commerce system. But it’s having a lot of issues with it’s skin. And one of most common issues regarding skin or theme change is, “Your design change for the specified store intersects with another one, please specify another date range” error. While setting a new theme or to switch back to the previous one, people use to find this error very often. Today I’m telling you a very simple one step solution to shoot this error.

Steps to fix it:

Go to your phpMyAdmin

Open the phpMyAdmin portal from your hosting panel.

Select the database

Select the database where you’ve stored your magento data.

Find the table

Find out the table named “design_change”. If you set any prefix while installing magento then the name of the table will be “yourprefix_design_change”.

Delete the records

Just delete everything from the table (DO NOT DROP the table. JUST DELETE the RECORDS). You either can delete the records manually or you can go to the SQL tab, copy and paste the following querry, and click on the “Go” button.

DELETE FROM yourprefix_design_change

After a successful deletion you will be able to change your design (skin or theme) from your magento admin portal.

** Each and every time before doing a design change you have to perform this deletion.

Still having issues?

If you still have issues understanding the above article, please leave a comment below and we will try to address that. In case you need help in your projects or understanding anything related to Programming; contact me, Paul Shan for assistance. Thank you for being a reader of VoidCanvas.

About This Author

Hello! I am Paul Shan, a JavaScript Expert, Full Stack and DevOps Engineer cum Consultant based out of Bengaluru, India.

  • Irfan Khan

    Nice paul shan thanks

  • Joe

    Its a shame this issue still exists; it would be nice to resolve it without having to delete the records.

    • metalshan

      yaa.. As an organization they must fix their bugs… It’s really unfortunate

  • hempfestival

    great, thanks, I was racking my brain why I couldn’t change the design, as I had change it through System > Design (instead of from System > Configuration)

  • Imran Sayyed

    Thanks Paul.
    worked like a charm 🙂

  • vicky

    no record in design chnge

  • Laxmi priya

    thanks a lot