Problem with database migrating Drupal 8 site from local to web host (multiple databases)
Okay I figured it out. It was the database prefix value in the settings.php file that was the problem. 

I set up the site on another web host and got it to work there, then I compared the two settings.php files and noticed that the working one had the database prefix blank. The problem occurred with InMotion Hosting but it worked fine on Bluehost.

Thanks for the help.