I've just moved a Prestashop website from another server.
It is showing: "Bad SubDomain SQL query." for both the frontpage and the admin page.
I've tried the SQL query fix suggested in some places, no dice.
I can give you mySql and FTP access only.