problem with sql
i have a site on a server that keeps sending error reports to me sayingOctober 26, 2003, 10:46:56 pm -- CREATE TABLE temp SELECT listingsDB.ID, listingsDB.Title, listingsDBElements.field_name, listingsDBElements.field_value FROM listingsDB, listingsDBElements WHERE (listingsDBElements.listing_id = listingsDB.ID) AND (listingsDB.active = 'yes')
but i have looked every where and can not find the problem i have this site on my VPS and the site is also mine i have never had this problem on other servers what setting have i not dome correct
please help guys