User tests: Successful: Unsuccessful:
joomla.sql
line 111
SELECT 38,1,103,104,1,'com_postinstall','com_postinstall','{}';
SELECT 38,1,103,104,1,'com_postinstall','com_postinstall','{}'
line 665
SELECT 11, 'Banner', 'com_banners.banner', '{"special":{"dbtable":"#banners","key":"id","type":"Banner","prefix":"BannersTable","config":"array()"},"common":{"dbtable":"#ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"name","core_state":"published","core_alias":"alias","core_created_time":"created","core_modified_time":"modified","core_body":"description", "core_hits":"null","core_publish_up":"publish_up","core_publish_down":"publish_down","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"link", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "core_xreference":"null", "asset_id":"null"}, "special":{"imptotal":"imptotal", "impmade":"impmade", "clicks":"clicks", "clickurl":"clickurl", "custombannercode":"custombannercode", "cid":"cid", "purchase_type":"purchase_type", "track_impressions":"track_impressions", "track_clicks":"track_clicks"}}', '', ''
SELECT 11, 'Banner', 'com_banners.banner', '{"special":{"dbtable":"#banners","key":"id","type":"Banner","prefix":"BannersTable","config":"array()"},"common":{"dbtable":"#ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}', '', '{"common":{"core_content_item_id":"id","core_title":"name","core_state":"published","core_alias":"alias","core_created_time":"created","core_modified_time":"modified","core_body":"description", "core_hits":"null","core_publish_up":"publish_up","core_publish_down":"publish_down","core_access":"access", "core_params":"params", "core_featured":"null", "core_metadata":"metadata", "core_language":"language", "core_images":"images", "core_urls":"link", "core_version":"version", "core_ordering":"ordering", "core_metakey":"metakey", "core_metadesc":"metadesc", "core_catid":"catid", "core_xreference":"null", "asset_id":"null"}, "special":{"imptotal":"imptotal", "impmade":"impmade", "clicks":"clicks", "clickurl":"clickurl", "custombannercode":"custombannercode", "cid":"cid", "purchase_type":"purchase_type", "track_impressions":"track_impressions", "track_clicks":"track_clicks"}}', ''
sample_data
line 46
INSERT INTO#__assets VALUES (37, 1, 71, 72, 1, 'com_ajax', 'com_ajax', '{}'
INSERT INTO#__assets VALUES (37, 1, 71, 72, 1, 'com_ajax', 'com_ajax', '{}');
line 47
INSERT INTO#__assets VALUES (28, 1, 73, 74, 1, 'com_postinstall', 'com_postinstall','{}');
INSERT INTO#__assets VALUES (38, 1, 73, 74, 1, 'com_postinstall', 'com_postinstall','{}');
sample_testing
line 170
INSERT INTO#__assets VALUES ('174', '1', '424', '425', '1', 'com_ajax', 'com_ajax', '{}'
INSERT INTO#__assets VALUES ('174', '1', '424', '425', '1', 'com_ajax', 'com_ajax', '{}');
remove
TRUNCATE TABLE [#template_styles] ;
TRUNCATE TABLE [#modules];
sample_brochure
line 47
INSERT INTO#__assets VALUES ('42', '1', '81', '82', '1', 'com_ajax', 'com_ajax', '{}'
INSERT INTO#__assets VALUES ('42', '1', '81', '82', '1', 'com_ajax', 'com_ajax', '{}');
This is awesome, thanks so much!