Hi @Kanoberson ,
There are dozen things that can go off the rails when upgrading from 4.2.2. There are a lot of questions I have about the upgrade path that you took.
Did you install v6 on a new server first, then brought in v4 db by doing a mysql openemr < my4.2.2.sql?
Or did you manually create the 4.2.2 DB and then pointed the code at the database for upgrade?
There are small differences I have found on how to get from 4.2.2 up to v6 that can make all the difference on the final result.
More details is what is needed to help troubleshoot the issue. It is not straight forward.