I'm wondering if the table or column name is different on the new server. That may be the first part of an error message saying that query is invalid. Please test it on the new server using phpmyadmin to be sure the SQL statement itself isn't wrong.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.