Christ. I'm helping this knucklehead move a site to a new host. I've transferred all of the files and database and the site shows on the test URL they give you (www.hostingcompany.com/~thesitehere) and I've also switched the DNS to the DNS they gave. However, when we pull up the site 6 hours later, we get a cannot find the site error. Everything is in the right folder as the test URL works fine.

WTF am I missing or is this a server config issue?