Page 1 of 1

Menu items missing after upgrade

Posted: Tue Sep 12, 2017 11:40 am
by booo9
For a long time I have been running 1.x.
Couple of month ago upgraded to 2.1.x

Recently started having problems with nav menus not displaying correctly on pages. Today upgraded to 2.2.3.1 (I had to add db_prefix to all my tables using MyPhpAdmin else would not upgrade)

Now see only single "Home page" item on horiz menu navigation bar.
How to I restore nav menu to include all sub/pages ?

All pages have CCSMenu Top + 2 columns layout.

template has

Code: Select all

{* stylesheet  "Navigation: CSSMenu - Horizontal" *}
        <h2 class="accessibility">Navigation</h2>
        {menu loadprops=0 template='cssmenu.tpl'}
        <hr class="accessibility" />
      </div>
{* End Navigation *}

Re: Menu items missing after upgrade

Posted: Tue Sep 12, 2017 6:58 pm
by booo9
This is caused by renaming tables but not renaming indices.
Some php code explicitely uses 'FORCE index' to name specific index.

Re: Menu items missing after upgrade

Posted: Thu Oct 05, 2017 12:43 am
by DIGI3
I was able to recreate this issue, and have filed a bug report: http://dev.cmsmadesimple.org/bug/view/11594

Were you able to come up with a workaround or did you just revert to your backup?

Re: Menu items missing after upgrade

Posted: Thu Oct 05, 2017 8:27 am
by booo9
I used myphpadmin to rename indices using fresh cmsms installation as the base, not all indices are prefixed by db_prefix though.

"menu" module (deprecated on the way out) had some problems so had to switch to "navigator"