All content is working just all categorie menu items and direct access tries end in 404.

do you mean a URL like this?
https://www.joomla.org/announcements/release-news/

Yes something like the provided link but not category blog its a category list. The menu item directs to a category list and the category has 6 normal articles attached. It was working well before i updated.

Should your categories perhaps have gone unpublished? Just saw a user having that issue and they couldn´t publish them and menus not working. They fixed it by publishing categories directly in the database

No categories are published. Here are the two error i get when try to open that pages.

Can you please try to disable the 3rdparty extension attachments?

I disabled it but the same result stays.

it needs to be atleaset a different error message. As this was the plugin that was mention in the error message.

I disabled it on backend but the error stays but i have two different errors so i dont think it comes from it. See picture i added to first post and disabled plugin picture on this post.

Call stack

Function Location

1 JError::raise() JROOT/libraries/legacy/error/error.php:277
2 JError::raiseError() JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:813
3 AttachmentsPlugin_Com_Content->attachmentsHiddenForParent() JROOT/plugins/content/attachments/attachments.php:312
4 plgContentAttachments->onContentBeforeDisplay() JROOT/libraries/joomla/event/event.php:70
5 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
6 JEventDispatcher->trigger() JROOT/components/com_content/views/category/tmpl/blog.php:25
7 include() JROOT/libraries/legacy/view/legacy.php:694
8 JViewLegacy->loadTemplate() JROOT/libraries/legacy/view/legacy.php:229
9 JViewLegacy->display() JROOT/libraries/legacy/view/category.php:241
10 JViewCategory->display() JROOT/components/com_content/views/category/view.html.php:260
11 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:671
12 JControllerLegacy->display() JROOT/components/com_content/controller.php:113
13 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709
14 JControllerLegacy->execute() JROOT/components/com_content/content.php:39
15 require_once() JROOT/libraries/cms/component/helper.php:394
16 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369
17 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191
18 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230
19 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265
20 JApplicationCms->execute() JROOT/index.php:49

and

Call stack

Function Location

1 JError::raise() JROOT/libraries/legacy/error/error.php:277
2 JError::raiseError() JROOT/libraries/legacy/view/category.php:127
3 JViewCategory->commonCategoryDisplay() JROOT/components/com_content/views/category/view.html.php:72
4 ContentViewCategory->display() JROOT/libraries/legacy/controller/legacy.php:671
5 JControllerLegacy->display() JROOT/components/com_content/controller.php:113
6 ContentController->display() JROOT/libraries/legacy/controller/legacy.php:709
7 JControllerLegacy->execute() JROOT/components/com_content/content.php:39
8 require_once() JROOT/libraries/cms/component/helper.php:394
9 JComponentHelper::executeComponent() JROOT/libraries/cms/component/helper.php:369
10 JComponentHelper::renderComponent() JROOT/libraries/cms/application/site.php:191
11 JApplicationSite->dispatch() JROOT/libraries/cms/application/site.php:230
12 JApplicationSite->doExecute() JROOT/libraries/cms/application/cms.php:265
13 JApplicationCms->execute() JROOT/index.php:49

Have a site using attachments and it did upgrade from 3.6.5 to 3.7 with no issues

So looks like i have to switch back to 3.6.5 (backup) tomorrow because i need to finish the project ;(

I just upgraded to 3.7 as well and am now getting a 404 Article Not Found error as well.

I used the search field here and was able to find my site and link to all of the pages and links. Everything seems normal except the 404 error on the home page.

Normal article are working well for me just all categories are broken.

I failed also to reproduce that. I already upgraded multiple joomla installations to the latest version and none of them allowed me to reproduce the issue. Did you use some special plugins or a special template? Can you reproduce the issue with one of the default templates?

If website on joomla 3.6.5 has category table in db corrupted (incorrect value for columns lft, rgt) then after update to 3.7 all or part of categories may be unpublished or trashed.

Similar things may occur with menu items.

Solution could be to delete trashed categories and move unpublished to other place before upgrade to 3.7. Then category table should be repaired.

On joomla 3.7 published column (for menus and categories) is recalculated by query:
https://github.com/joomla/joomla-cms/blob/staging/administrator/components/com_admin/sql/updates/mysql/3.7.0-2017-03-09.sql

I get this error when i try to run the query on database:

`Fehler
SQL-Befehl: Dokumentation

UPDATE #__categories AS c INNER JOIN (

SELECT c2.id,
CASE WHEN MIN( p.published ) >0
THEN MAX( p.published )
ELSE MIN( p.published )
END AS newPublished
FROM #__categories AS c2
INNER JOIN #__categories AS p ON p.lft <= c2.lft
AND c2.rgt <= p.rgt
GROUP BY c2.id
)c2 ON c.id = c2.id
SET published = c2.newPublished;

**MySQL meldet: Dokumentation

#1146 - Table 'd024caf4.#__categories' doesn't exist `**

I checked the database and the table f6p8s_categories exist and also my categories are in the table and published.

@ChristianGrieger This above query won't repair your website but only unpublish/trash subcategories in unpublished/trashed category. It is run for security reason and I'm almost sure that it was run on joomla upgrade.

Similar query was run for #__menus. Please check you menu list, check trashed menu items too.

Menu checked and all is activated and selected the right way published. It was working before the update so wrong selected categorie or not published should not be the problem.

I attached also the database entry so you can see its also the right id on the database.

Result:

500 - Fehler: Falsche Artikel ID (33)! (ERR 410)

This is really frustrating...

@zero-24 , your idea to disable attachments plugin was a good idea but as it looks like to disable the plugin did not help to delete the problem.

I found this article here: http://www.joomlaportal.de/joomla-3-x-allgemeine-fragen/323076-error-invalid-article-parent-id-kategorieblog.html

The solution to solve my problem was to change one line in attachment files:

Datei: plugins/attachments/attachments_for_content/attachments_for_content.php (Zeile: 812)
if ($db->getErrorNum() || count($attachments) == 0)
geändert in:
if ($db->getErrorNum() || count($attachments) === false)

Thank you to all that tried to help me and i really hope it will help someone else!

Closed as not a joomla core issue

Regarding the issue with the Attachments extension: The fix by ChristianGrieger above does seem to work. I'm working with someone to verify that. I noticed one other issue with Attachments on 3.7.0 that I need to fix before a release. But in the meantime if anyone wants a version with Attachments with the fix above (and a few other fixes), please contact me at jmcameron/jmcameron/net.
-Jonathan (author of the Attachments extension)