Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : problem with sql

[supportmedia]

i have a site on a server that keeps sending error reports to me saying

October 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

[webworkz]

So, are you having problems with the SQL call, or tracking down the file that is making the calls?

The SQL call is trying to create a table and select from a table, in one call. That won't work.