PDA

View Full Version : listing_browse.php problem



Clement
06-15-2003, 08:13 PM
Hello,

When I try to acces listing_browse.php file, an error occure anytime....

Also, after that I receive this error message trought email:


June 16, 2003, 2:42:08 am -- CREATE TEMPORARY TABLE temp SELECT listingsDB.ID, listingsDB.Title, listingsDBElements.field_name, listingsDBElements.field_value FROM listingsDB, listingsDBElements WHERE (listingsDBElements.listing_id = listingsDB.ID) AND (listingsDB.expiration > '2003-06-16') AND (listingsDB.active = 'yes')

I use the last version of open-realty ....


Can you help me, PLEASE?


Thank you for your time,
Clement

RealtyOne
06-16-2003, 07:59 PM
Hi this should be fixed if you open the file and remove the word TEMPORARY from the line.
So its like this

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.expiration > '2003-06-16') AND (listingsDB.active = 'yes')

Clement
06-17-2003, 08:45 AM
Hello,

Thank you for this GOOD solution!!