Missing layout_boxes configuration for responsive_classic on upgrade

[lat9]

I'm upgrading a site from Zen Cart 1.5.4, with the anticipation of upgrading to the responsive_classic template that's built in. When attempting to clone that template, it's not in the "Clone a Template" dropdown list.

Turns out that it's not in the list because there aren't any entries in the layout_boxes database table for the responsive_classic template. Shouldn't those have been inserted as part of the upgrade from Zen Cart 1.5.4 to 1.5.5a?

[lat9]

Here's the SQL patch to introduce the responsive_classic's layout_boxes settings into the database on an upgrade:

INSERT INTO `layout_boxes` (`layout_template`, `layout_box_name`, `layout_box_status`, `layout_box_location`, `layout_box_sort_order`, `layout_box_sort_order_single`, `layout_box_status_single`) VALUES
('responsive_classic', 'banner_box.php', 1, 0, 300, 1, 127),
('responsive_classic', 'banner_box2.php', 1, 1, 15, 1, 15),
('responsive_classic', 'banner_box_all.php', 1, 1, 5, 0, 0),
('responsive_classic', 'best_sellers.php', 1, 1, 30, 70, 1),
('responsive_classic', 'categories.php', 1, 0, 10, 10, 1),
('responsive_classic', 'currencies.php', 0, 1, 80, 60, 0),
('responsive_classic', 'document_categories.php', 1, 0, 0, 0, 0),
('responsive_classic', 'ezpages.php', 1, 1, -1, 2, 1),
('responsive_classic', 'featured.php', 1, 0, 45, 0, 0),
('responsive_classic', 'information.php', 1, 0, 50, 40, 1),
('responsive_classic', 'languages.php', 0, 1, 70, 50, 0),
('responsive_classic', 'manufacturers.php', 1, 0, 30, 20, 1),
('responsive_classic', 'manufacturer_info.php', 1, 1, 35, 95, 1),
('responsive_classic', 'more_information.php', 1, 0, 200, 200, 1),
('responsive_classic', 'music_genres.php', 1, 1, 0, 0, 0),
('responsive_classic', 'order_history.php', 1, 1, 0, 0, 0),
('responsive_classic', 'product_notifications.php', 1, 1, 55, 85, 1),
('responsive_classic', 'record_companies.php', 1, 1, 0, 0, 0),
('responsive_classic', 'reviews.php', 1, 0, 40, 0, 0),
('responsive_classic', 'search.php', 1, 1, 10, 0, 0),
('responsive_classic', 'search_header.php', 0, 0, 0, 0, 1),
('responsive_classic', 'shopping_cart.php', 1, 1, 20, 30, 1),
('responsive_classic', 'specials.php', 1, 1, 45, 0, 0),
('responsive_classic', 'whats_new.php', 1, 0, 20, 0, 0),
('responsive_classic', 'whos_online.php', 1, 1, 200, 200, 1);

... just in case anyone else has also run into this issue.

P.S. Don't just willy-nilly apply this patch, since it will insert multiple records for the responsive_classic template if those records already exist!