CMS Made Simple Forums

I have been running cmsms since 1.x
Couple of month upgraded to 2.x OK
Today upgraded to 2.2.3.1 with some glitches.

Upgrade would not accept empty db_prefix, which was OK before.
OK, myPhpAdmin, I prefixed all tables with mysite_,
Upgrade went OK, but, nav menus are missing.

cache/debug.log shows the code refers explicitely to mysite_index_ in sql query.

I can rename that specific index but I would like to fix other as well without manually renaming each.

I would like to
1. dump data w/o meta
2. create new database
3. load data from 1)

Q: How do I create newly initialized database ?

Did you try to clear the CMS cache?
this can probably solve the problem of the menu not working.

on how to do the export of your DB and the creating of your DB:

• 1:export you can do with phpMyadmin https://youtu.be/ffmCGVse8yg
• 2: check with your hosting povider
• 3: importing with phpmyadmin: https://youtu.be/jW5lrS6EUPM

> Did you try to clear the CMS cache?
> this can probably solve the problem of the menu not working.

the menu problem was caused by php code sql query referencing new index name whereas my db had old index name.

that was a quick reply . i added some video's on the exporting and importing of your DB.

So problem solved?

> So problem solved?

viewtopic.php?f=3&t=77270