photo

Michael Evans

shared this problem
6 years ago

Employees Involved

photo

PIV Support

Admin

Statistics

6
Comments
679
Views

Relates to

Share

1
votes

problem with duplicate listings in transparent rets 2x

We're using Transparent Rets version 2x (yeah, we're upgrading but still using it for now) and have noticed all of a sudden we have a ton of duplicate listings that weren't there before. Some of them sans pictures and in some cases the listing is showing 3 or 4 or more times with pictures on some of them but not others. How can we clean up the database to remove all the duplicates and any idea what might have happened and anything we might need to do in order to make sure it doesn't continue to happen? We haven't touched anything so not sure what cuased this.

Add Comment

Comments (6)

photo Employee
1

What version of OR exactly and what version of TRETS exactly?

photo
1

OR 2.5.7 and Rets v1.2.13 (not 2x as mentioned earilier- was mistaken its OR version 2x)

photo Employee
1

Unfortunately TRETS v1.2.13 is not compatible with OR v3.x. You are going to need to upgrade TRETS if you upgrade to OR v3. The current version of TRETS is v2.1.2

Your duplicate listing problem could possibly be import tasks are overlapping and/or not being allowed to complete. Assuming it was working before and "all of a sudden" started doing this, tends to lead to a server change or other upgrade/modification made by the host without notice. Hosts are upgrading PHP and other things regularly that render the old 2.x versions of OR incompatible.

Support for TRETS can be obtained Via Transparent Tech's support desk assuming your support and upgrade period is active.

https://www.transparent-support.com/billing/contactsupport.php

photo
1

Aware of the non compatibility. That's not my issue. Let me explain it agian perhaps with more clarity. We have OR version 2.5.7 We have rets version 1.2.3. All of a sudden we have a ton of duplicate listings. In some cases a listing is duplicated 5 or 6 times some of them with pictures, some without. We haven't touched anything but all of a sudden have all of these duplicates. So wondering what we can do to remove them and also why this might have occurred.

As to the upgrade, in fact we have already purchased an upgrade to both OR and Rets and have it installed on a new server that is not yet in production (not live). We're still fiddling with setting everything up so for now are still using the older versions as indicated above until we are ready to take the new one live so for now we need it to work correctly and can't understand why we have all of these hundreds of duplicates all of a sudden or what we need to do to correct that.

photo Employee
1

Please re-read my above above response, specifically the "all of a sudden" part. Other than what was offered as probable causes above, we cannot assist you here with an old version of the OR 2.x software. Support for TRETS is handled specifically at the support link I posted above.

photo
1

Strange. when I came to the post the fist time the part after "The current version of rets..." and before "Support for rets..." was NOT there. Very weird or maybe I was momentarily blinded. Which is why I answered as I did. And I understand the part about lack of assistance other than probable causes as offered here and I do appreciate your response(s) thereof. Maybe there was an overlapped import then because of a server situation, that would make sense. My question would be then, in the hopes this might be a simple answer for someone of your experience that wouldn't require need for further support is would you be aware of some specific commands we can easily run that would either clean the tables of the existing import data and import everything fresh and anew and/or (more preferably) remove all duplicate listings?

Leave Comment

photo

Attach files...

The file must be a jpg, gif, png, bmp, ico, pdf, doc, rtf, txt, zip or rar no more than 20M