Drupal Drealty How to fix Active Properties Set to 'active=0'
Created on 2014-Nov-15
Updated on 2014-Nov-15
Sometimes drealty doesn't properly set RETS status properties marked as "Active", "Pending Sale", or "Backup Offer" as 'active=1'. Any property marked as 'active=0' will NOT display, no matter what 'rets_status' is marked as.
We can fix that by running this SQL query in phpMyAdmin:
UPDATE `drealty_listing` SET `active`='1' WHERE `rets_status`='Active' or `rets_status`='Pending Sale' or `rets_status`='Backup Offer' ;