Apex domains cannot have CNAME records.
Question and response
Question
dig upallnighthosting.ca. NS
Answer
upallnighthosting.ca. 4 NS vps207601.vps.ovh.ca.
upallnighthosting.ca. 4 NS ns2.upallnighthosting.ca.
upallnighthosting.ca. 4 NS ns1.upallnighthosting.ca.
upallnighthosting.ca. 4 NS vps-56bd6f9f.vps.ovh.ca.
Authority
The response has no authority records.
Additional
ns1.upallnighthosting.ca. 4 A 198.245.55.13
ns2.upallnighthosting.ca. 4 A 158.69.207.187
. 0 OPT ; payload 1232, xrcode 0, version 0, flags 0