?
avatar ChristianGrieger
ChristianGrieger
25 Apr 2017

Steps to reproduce the issue

Upgrade Joomla 3.6.5 to Joomla 7 from Joomla-Backend

Expected result

Normal working access to categories.

Actual result

404 - Category not found
500 - Wrong category ID

(i checked the ids and they are right)
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

System information (as much as possible)

PHP erstellt für Linux dd38604 4.4.0-71-generic #92-Ubuntu SMP Fri Mar 24 12:59:01 UTC 2017 x86_64
Datenbankversion 5.7.15-nmm5-log
Datenbankzeichensatz utf8_general_ci
Datenbankverbindungszeichensatz utf8mb4_general_ci
PHP-Version 7.1.1-nmm1
Webserver Apache
PHP-Interface für den Webserver fpm-fcgi
Joomla!-Version Joomla! 3.7.0 Stable [ Amani ] 25-April-2017 15:36 GMT
Joomla!-Plattform-Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

Additional comments

I just upgraded my joomla and tried to access the menu items to check if all is working well.
All content is working just all categorie menu items and direct access tries end in 404. I already tried to to recreate the categories and to rebuild the menu entries but get the same result. Also a new install of the core files did not help.

Can anyone provide me with a fix for the problem please? I need to finish the website :(

error1
error2
category

avatar ChristianGrieger ChristianGrieger - open - 25 Apr 2017
avatar joomla-cms-bot joomla-cms-bot - change - 25 Apr 2017
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 25 Apr 2017
avatar zero-24
zero-24 - comment - 25 Apr 2017

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/

avatar ChristianGrieger
ChristianGrieger - comment - 25 Apr 2017

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.

avatar ot2sen
ot2sen - comment - 25 Apr 2017

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

avatar ChristianGrieger
ChristianGrieger - comment - 25 Apr 2017

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

avatar ChristianGrieger ChristianGrieger - edited - 25 Apr 2017
avatar ChristianGrieger ChristianGrieger - change - 25 Apr 2017
The description was changed
avatar ChristianGrieger ChristianGrieger - edited - 25 Apr 2017
avatar ChristianGrieger ChristianGrieger - edited - 25 Apr 2017
avatar zero-24
zero-24 - comment - 25 Apr 2017

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

avatar ChristianGrieger
ChristianGrieger - comment - 25 Apr 2017

I disabled it but the same result stays.

avatar zero-24
zero-24 - comment - 25 Apr 2017

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

image

avatar ChristianGrieger
ChristianGrieger - comment - 25 Apr 2017

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

bildschirmfoto 2017-04-25 um 23 09 13

avatar ot2sen
ot2sen - comment - 25 Apr 2017

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

avatar ChristianGrieger
ChristianGrieger - comment - 25 Apr 2017

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

avatar GFLP
GFLP - comment - 25 Apr 2017

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

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.

avatar ChristianGrieger
ChristianGrieger - comment - 25 Apr 2017

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

avatar BastianWie
BastianWie - comment - 25 Apr 2017

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?


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/15545.

avatar csthomas
csthomas - comment - 26 Apr 2017

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

avatar joomla-cms-bot joomla-cms-bot - change - 26 Apr 2017
Title
404 - Category not found after upgrade to 3.7
404 - Category not found and 500 - Wrong category ID after upgrade to 3.7
avatar joomla-cms-bot joomla-cms-bot - edited - 26 Apr 2017
avatar franz-wohlkoenig franz-wohlkoenig - change - 26 Apr 2017
Status New Confirmed
Build staging 3.7.0
avatar joomla-cms-bot joomla-cms-bot - change - 26 Apr 2017
The description was changed
avatar joomla-cms-bot joomla-cms-bot - edited - 26 Apr 2017
avatar joomla-cms-bot joomla-cms-bot - change - 26 Apr 2017
Title
404 - Category not found and 500 - Wrong category ID after upgrade to 3.7
404 - Category not found after upgrade to 3.7
avatar joomla-cms-bot joomla-cms-bot - edited - 26 Apr 2017
avatar joomla-cms-bot joomla-cms-bot - change - 26 Apr 2017
The description was changed
avatar joomla-cms-bot joomla-cms-bot - edited - 26 Apr 2017
avatar franz-wohlkoenig franz-wohlkoenig - change - 26 Apr 2017
Category com_categories
avatar ChristianGrieger
ChristianGrieger - comment - 26 Apr 2017

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.

avatar csthomas
csthomas - comment - 26 Apr 2017

@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.

avatar ChristianGrieger
ChristianGrieger - comment - 26 Apr 2017

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.

bildschirmfoto 2017-04-26 um 09 07 20
bildschirmfoto 2017-04-26 um 09 07 52
bildschirmfoto 2017-04-26 um 09 19 58

Result:

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

This is really frustrating...

avatar ChristianGrieger
ChristianGrieger - comment - 26 Apr 2017

@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!

avatar ChristianGrieger ChristianGrieger - change - 26 Apr 2017
Title
404 - Category not found after upgrade to 3.7
404 - Category not found and 500 - Wrong category ID after upgrade to 3.7
avatar ChristianGrieger ChristianGrieger - edited - 26 Apr 2017
avatar brianteeman
brianteeman - comment - 26 Apr 2017

Closed as not a joomla core issue

avatar brianteeman brianteeman - change - 26 Apr 2017
The description was changed
Title
404 - Category not found and 500 - Wrong category ID after upgrade to 3.7
(SOLVED) 404 - Category not found and 500 - Wrong category ID after upgrade to 3.7
Status Confirmed Closed
Closed_Date 0000-00-00 00:00:00 2017-04-26 07:54:35
Closed_By brianteeman
avatar brianteeman brianteeman - close - 26 Apr 2017
avatar jmcameron
jmcameron - comment - 28 Apr 2017

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)


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/15545.

Add a Comment

Login with GitHub to post a comment