We have a website running on Open Realty (open source) and have been receiving the following errors via email. They are automaticaly generated by the Open Realty script. We are not sure what is causing the problem.
[login to view URL] -- March 28, 2006, 5:43:18 pm -- CREATE TABLE default_temp SELECT [login to view URL], [login to view URL], default_listingsDB.user_ID, default_listingsDBElements.field_name, default_listingsDBElements.field_value FROM default_listingsDB, default_listingsDBElements WHERE (default_listingsDBElements.listing_id = [login to view URL]) AND ([login to view URL] = 'yes')
-----
[login to view URL] -- March 28, 2006, 5:48:13 pm -- SELECT ID FROM default_temp WHERE ( (field_name='status') AND (field_value = 'For Rent'))
-----
[login to view URL] -- March 28, 2006, 5:42:41 pm -- SELECT ID FROM default_temp WHERE ( (field_name='neighborhood') AND (field_value = 'Williamsburg'))
Please give us an estimate and tell us what you will need to fix the problem.