Previous template made database alterations - is there a way to get defaults back ?

[PatF]

Bear with me on this as it's slightly complicated. We have an existing site running a patched 1.3.8a and using a template RI007 from rubik integration.

I am caught in a bit of a circle here. From what I can see the template is not compatible with 1.3.9 as copying the template files across from the current site is breaking the cart. Support for this contribution has been withdrawn so we may have to look at a template change to upgrade.

The issue is that the template install for this RI007 has a SQL statement which makes changes to the database. If we install a new template etc the moment we import the old database the layout etc gets screwed up as the database is configured for a different template.

So my question is this - is there anywhere with a set list of default values for the database that I could compare with the SQL statement for the current template. (I know one solution would be to install another store in a different directory from scratch and compare the two databases manually but I am wondering is there a quicker / easier way to do this)

The statement that has been ran on our current database is ...

/** install single listing **/
delete from configuration where configuration_key in('PRODUCT_LISTING_LAYOUT_STYLE','PRODUCT_LISTING_COLUMNS_PER_ROW');

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product Listing - Layout Style', 'PRODUCT_LISTING_LAYOUT_STYLE', 'rows', 'Select the layout style:<br />Each product can be listed in its own row (rows option) or products can be listed in multiple columns per row (columns option)', '8', '40', NULL, now(), NULL, 'zen_cfg_select_option(array("rows", "columns"),');

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product Listing - Columns Per Row', 'PRODUCT_LISTING_COLUMNS_PER_ROW', '3', 'Select the number of columns of products to show in each row in the product listing. The default setting is 3.', '8', '41', NULL, now(), NULL, NULL);

INSERT INTO `configuration` (`configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES
('Index New Listing Template', 'INDEX_NEW_USE_PRODUCT_LISTING', '1', 'Set to 1 to use the original listing template, 2 to use the shared listing template, 3 to use the product listing template.', 24, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''1'', ''2'', ''3''),'),
('Index Special Listing Template', 'INDEX_SPECIAL_USE_PRODUCT_LISTING', '1', 'Set to 1 to use the original listing template, 2 to use the shared listing template, 3 to use the product listing template.', 24, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''1'', ''2'', ''3''),'),
('Index Featured Listing Template', 'INDEX_FEATURED_USE_PRODUCT_LISTING', '1', 'Set to 1 to use the original listing template, 2 to use the shared listing template, 3 to use the product listing template.', 24, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''1'', ''2'', ''3''),');

/** CJ Loader **/

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'CSS/JS Loader';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

INSERT INTO configuration_group VALUES ('', 'CSS/JS Loader', 'Set CSS/JS Loader Options', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'CSS/JS Loader';

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('Enable Minify', 'MINIFY_STATUS', 'true', 'Minifying will speed up your site\'s loading speed by combining and compressing css/js files.', @t4, 1, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
('Max URL Lenght', 'MINIFY_MAX_URL_LENGHT', '2083', 'On some server the maximum lenght of any POST/GET request URL is limited. If this is the case for your server, you can change the setting here', @t4, 2, NOW(), NOW(), NULL, NULL),
('Minify Cache Time', 'MINIFY_CACHE_TIME_LENGHT', '31536000', 'Set minify cache time (in second). Default is 1 year (31536000)', @t4, 3, NOW(), NOW(), NULL, NULL),
('Latest Cache Time', 'MINIFY_CACHE_TIME_LATEST', '0', 'Normally you don\'t have to set this, but if you have just made changes to your js/css files and want to make sure they are reloaded right away, you can reset this to 0.', @t4, 4, NOW(), NOW(), NULL, NULL);

/** update configuration **/

UPDATE configuration SET configuration_value = '4' WHERE configuration_key = 'MAX_DISPLAY_NEW_PRODUCTS';
UPDATE configuration SET configuration_value = '1' WHERE configuration_key = 'MAX_MANUFACTURERS_LIST';
UPDATE configuration SET configuration_value = '250' WHERE configuration_key = 'MEDIUM_IMAGE_WIDTH';
UPDATE configuration SET configuration_value = '250' WHERE configuration_key = 'MEDIUM_IMAGE_HEIGHT';
UPDATE configuration SET configuration_value = '125' WHERE configuration_key = 'IMAGE_PRODUCT_LISTING_WIDTH';
UPDATE configuration SET configuration_value = '125' WHERE configuration_key = 'IMAGE_PRODUCT_LISTING_HEIGHT';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'IMAGE_PRODUCT_ALL_LISTING_WIDTH';
UPDATE configuration SET configuration_value = '160' WHERE configuration_key = 'IMAGE_PRODUCT_ALL_LISTING_HEIGHT';
UPDATE configuration SET configuration_value = '1' WHERE configuration_key = 'PRODUCT_LIST_IMAGE';
UPDATE configuration SET configuration_value = '2' WHERE configuration_key = 'PRODUCT_LIST_NAME';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'PRODUCT_LISTING_MULTIPLE_ADD_TO_CART';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'PRODUCT_LIST_DESCRIPTION';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'OTHER_IMAGE_PRICE_IS_FREE_ON';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'PRODUCT_INFO_PREVIOUS_NEXT';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'PRODUCT_INFO_CATEGORIES';
UPDATE configuration SET configuration_value = '220px' WHERE configuration_key = 'BOX_WIDTH_LEFT';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'COLUMN_RIGHT_STATUS';
UPDATE configuration SET configuration_value = '220px' WHERE configuration_key = 'COLUMN_WIDTH_LEFT';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'SHOW_CUSTOMER_GREETING';
UPDATE configuration SET configuration_value = '' WHERE configuration_key = 'SHOW_BANNERS_GROUP_SET6';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'SHOW_FOOTER_IP';
UPDATE configuration SET configuration_value = 'No' WHERE configuration_key = 'IMAGE_USE_CSS_BUTTONS';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'PRODUCT_NEW_LIST_IMAGE';
UPDATE configuration SET configuration_value = '2101' WHERE configuration_key = 'PRODUCT_NEW_LIST_NAME';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'PRODUCT_NEW_LISTING_MULTIPLE_ADD_TO_CART';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'PRODUCT_FEATURED_LIST_IMAGE';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'PRODUCT_ALL_LIST_IMAGE';
UPDATE configuration SET configuration_value = '1101' WHERE configuration_key = 'PRODUCT_ALL_LIST_NAME';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'PRODUCT_ALL_LISTING_MULTIPLE_ADD_TO_CART';
UPDATE configuration SET configuration_value = '1' WHERE configuration_key = 'SHOW_PRODUCT_INFO_MAIN_FEATURED_PRODUCTS';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'SHOW_PRODUCT_INFO_MAIN_SPECIALS_PRODUCTS';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'SHOW_PRODUCT_INFO_MAIN_UPCOMING';
UPDATE configuration SET configuration_value = '0' WHERE configuration_key = 'DEFINE_MAIN_PAGE_STATUS';
UPDATE configuration SET configuration_value = '1' WHERE configuration_key = 'EZPAGES_STATUS_FOOTER';
UPDATE configuration SET configuration_value = '3' WHERE configuration_key = 'INDEX_NEW_USE_PRODUCT_LISTING';
UPDATE configuration SET configuration_value = '3' WHERE configuration_key = 'INDEX_SPECIAL_USE_PRODUCT_LISTING';
UPDATE configuration SET configuration_value = '3' WHERE configuration_key = 'INDEX_FEATURED_USE_PRODUCT_LISTING';
UPDATE configuration SET configuration_value = 'columns' WHERE configuration_key = 'PRODUCT_LISTING_LAYOUT_STYLE';
UPDATE configuration SET configuration_value = '4' WHERE configuration_key = 'PRODUCT_LISTING_COLUMNS_PER_ROW';

Thanks for any advice or help.

[PatF]

Just a quick update to say that I tracked down the source of the cart breakage so this is not as critical as before.

That said for reference purposes I would be interested in finding a source for default database configurations.

[PatF]

Bah ! I spoke too soon.

Looks like the includes/templates/template_default/templates/tpl_modules_create_account.php has been significantly changed for 1.3.9.

Trying to create an account on the new site caused a half page load - error logs showed

C:\Inetpub\vhosts\*****\httpdocs\******\includes\templates\RI_TEMPLATE_07\templa tes\tpl_modules_create_account.php on line 231

Our current file has 515 lines where as the newer template default version has only 196. I can only assume significant restructuring was done here (can't see a template adding 300 lines to the code ) but since our current template has made modifications to a file which again I assume has been split up or moved to other locations for the 1.3.9 series this template is not compatible.


Which brings me back to my first post in the thread. How can I get my database back to the defaults.