SOLVED Empty categories - localhost to live server

[treat2day]

I cannot not find a solution to the empty category issue mentioned in the bug section -  see image. I tried restoring several backups without success. Reinstalling did not work either. The problem occured after uploading the site from localhost to server. I had several installs withou this issue.
Any new suggestions would be appreciated.

[ColinM]

Hi
Was everything OK on the local server?
How did to transfer from your local server (XAMPP?) to your site

My first reaction is that the database did not transfer properly - is the collation the same?

Colin

[treat2day]

Always use Xampp.

Just downloaded entire site backup copy to Xampp from the live server and all the files appear.

The collation on the live server is the same as Xampp.

Have four client domains using the same procedure without issue on same live server. All upgraded from Joomla 3 to Joomla 4 with current version 4.3.3.

[ColinM]

Hmm!!
Does sound strange.  Will send you a Private Message (PM).
Colin

[Arno]

Hi,
seems that I do not understand what you mean with your first post. 

I cannot not find a solution to the empty category issue mentioned in the bug section -  see image.

It is on the attached pic nothing to see about empty categories?
Just an indication of a successful DB table correction.

[treat2day]

Empty categories, meaning files not shown.
Does not mean files cannot be downloaded if link is available on your side.

SOLVED

No shortcuts. It will be a waste of time for anyone with a similar problem.

Doing a clean install on Joomla 4 and rescan all files and trying to restore backup did not fix the issue.

Part #1 - Clean install to Joomla 3 to easily migrate with stellar results.

1. Joomla 3 clean install (no third party extentions)
2. Scan all JD 3.9 files
3. Restore "live site backup" for JD 3.9
4. Upgrade Joomla 3 migration to Joomla 4. (be sure to follow migration suggestion to disable JD system plugin.)
5. Install JD 4 latest version
6. Create backup JD 4 for Part #2

Part #2 - "Live site backup" Extract to Xampp

1. Uninstall JD4 and database tables
2. Match Part #1 database collation to "live site backup" database
3. Install latest version JD 4 to "live site backup"
4. Full scan JD 4 "live site backup"
5. Import Part #1 layouts and options
6. IMPORTANT: Verify and Match Part #1 database collation if different than NEW JD 4 latest version on "live site backup"
7. Restore Part #1 JD 4 to NEW JD 4 latest version to "live site backup"

A fresh install to fix any migration issues was successful.

I repeated this process for all client JD 4 sites with stellar results.

Thank you Colin for your help and suggestion to start over with a clean install!!!