[#15749] - Update to 3.7 moved all menu items to trash
- Closed
- 3 May 2017
- Medium
- Build: 3.7.0
- # 15749
As the subject says. Updated to 3.7 and the site broke with 404. Upon more research all menu items were moved to trash status.
Restored the site from a backup, repeated install, same results.
cPanel hosting environment.
Database Version 5.5.5-10.0.30-MariaDB
Database Collation latin1_swedish_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 5.6.30
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.6.5 Stable [ Noether ] 1-December-2016 22:46 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 10.0; WOW64; rv:53.0) Gecko/20100101 Firefox/53.0
Votes
Check the published column in a table #__menu (replace #_ to your prefix) for the first row with id=1 and alias='root'.
This column (published) should have a value equal to 1.
| Status | New | ⇒ | Discussion |
| Build | 13.1 | ⇒ | 3.7.0 |
| Category | Administration | ⇒ | com_joomlaupdate com_menus |
Can we close this it does not look like a joomla bug?
| Status | Discussion | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2017-05-03 06:55:20 |
| Closed_By | ⇒ | franz-wohlkoenig |
| Closed_By | franz-wohlkoenig | ⇒ | joomla-cms-bot |
closed as no Core issue.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/15749.
Set to "closed" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/15749
So reset that column to "1" and re-update? I'm not sure how it became -2, something off there, but as you say problem not related to the core.. Thx
So reset that column to "1" and re-update?
Yes.
I wonder If we can add to joomla update sql files below sql
UPDATE `#__menu` SET published=1 WHERE id = 1to change this value to 1.
FYI, this worked. Updated table above to id = 1. Then updated to 3.7 and all worked fine.
This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/15749.
@euoceo Which version of Joomla! do you upgrade?