Issue for postgress and mssql: #13981

I have tested this item ✅ successfully on be8f148

After the installation please clear the tables and do a complete reinstall

@zero-24 Clear all Tables in phpMyAdmin & reinstall of Joomla! 3.7.0-beta?

@zero-24 Clear all Tables in phpMyAdmin & reinstall of Joomla! 3.7.0-beta?

Yes but the reinstall should be based on my changes so a new install with different sample data of https://github.com/zero-24/joomla-cms/archive/fix_broken_menus.zip

First install

Test on "English (GB) Sample Data"

All Front End Views

404: index.php/single-news-feed

Modules

Feed not found: index.php/feed-display

Second Install

Test on "Blog English (GB) Sample Data"
All works.

@franz-wohlkoenig
Looks like your fail test is rather using sample_testing.sql and not basic sample_data.sql

We indeed have an error in sample_testing.sql in the frontendview menutype, as we have no Newsfeed with id4
(254, 'frontendviews', 'Single News Feed', 'single-news-feed', '', 'single-news-feed', 'index.php?option=com_newsfeeds&view=newsfeed&id=4', 'component', 1, 1, 1, 17, 0, '0000-00-00 00:00:00', 0, 1, '', 0, '{"show_feed_image":"","show_feed_description":"","show_item_description":"","feed_character_count":"0","menu-anchor_title":"","menu-anchor_css":"","menu_image":"","show_page_heading":0,"page_title":"","page_heading":"","pageclass_sfx":"","menu-meta_description":"","menu-meta_keywords":"","robots":"","secure":0}', 165, 166, 0, '*', 0),
see

INSERT IGNORE INTO `#__newsfeeds` (`catid`, `id`, `name`, `alias`, `link`, `published`, `numarticles`, `cache_time`, `checked_out`, `checked_out_time`, `ordering`, `rtl`, `access`, `language`, `params`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `metakey`, `metadesc`, `metadata`, `xreference`, `publish_up`, `publish_down`, `description`, `version`, `hits`, `images`) VALUES
(17, 1, 'Joomla! Announcements', 'joomla-announcements', 'http://feeds.joomla.org/JoomlaAnnouncements', 1, 5, 3600, 0, '0000-00-00 00:00:00', 1, 1, 1, 'en-GB', '{"show_feed_image":"","show_feed_description":"","show_item_description":"","feed_character_count":"0","newsfeed_layout":"","feed_display_order":""}', '2011-01-01 00:00:01', 42, 'Joomla', '0000-00-00 00:00:00', 0, '', '', '{"robots":"","rights":""}', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 1, 0, ''),
(17, 2, 'New Joomla! Extensions', 'new-joomla-extensions', 'http://feeds.joomla.org/JoomlaExtensions', 1, 5, 3600, 0, '0000-00-00 00:00:00', 4, 1, 1, 'en-GB', '{"show_feed_image":"","show_feed_description":"","show_item_description":"","feed_character_count":"0","newsfeed_layout":"","feed_display_order":""}', '2011-01-01 00:00:01', 42, 'Joomla', '0000-00-00 00:00:00', 0, '', '', '{"robots":"","rights":""}', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 1, 0, ''),
(17, 3, 'Joomla! Security News', 'joomla-security-news', 'http://feeds.joomla.org/JoomlaSecurityNews', 1, 5, 3600, 0, '0000-00-00 00:00:00', 2, 1, 1, 'en-GB', '{"show_feed_image":"","show_feed_description":"","show_item_description":"","feed_character_count":"0","newsfeed_layout":"","feed_display_order":""}', '2011-01-01 00:00:01', 42, 'Joomla', '0000-00-00 00:00:00', 0, '', '', '{"robots":"","rights":""}', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 1, 0, '');

For the module we have
`https://community.joomla.org/blogs/community.feed?type=rss as feed display.
This is not a real feed, thus the error.

@zero-24
The first error should be easy to solve by just changing the id to an existing one.
The second error: I have no idea what is the rss feed for community
We do have it here, normally
https://www.joomla.org/rss-news-feeds.html

but it just does not give a real feed.
It may be replaced by
http://feeds.joomla.org/JoomlaMagazine which does work

@franz-wohlkoenig
We can do a different PR for the issues above.
If the other menu items do work for you with each sample data, then please mark this as tested OK

@infograf768 tested using "English (GB) Sample Data" – isn't this all parts of sampedata? Tested also "Blog English (GB) Sample Data" too.

English (GB) Sample Data does not contain frontend views menutype. ONly English Testing sample data does

@infograf768 testing "English Testing sample" without error is enough for "successfull"?

to test, you have to test each sample data proposed.
easy way is to use the same test site instance and then delete the configuration.php and reinstall with a different sample data.

I have tested this item ✅ successfully on be8f148

Same 2 Failures like reported

rtc. thanks

@franz-wohlkoenig @infograf768 see: #14032 for the newsfeeds fixes