How to change default sort method to Featured

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Author

Posts
December 2, 2015 at 9:42 pm #62333

Paolo
Site Admin

Post count: 31211

Hi,

quick question, have you tried quickly disabling all non gd plugins to see if the problem persist?

Because on all my test websites it works correctly.

I’ve alerted the developers about this.

They’ll let you know asap.

Thanks

December 3, 2015 at 3:36 pm #62429

Stiofan O’Connor
Site Admin

Post count: 22956

The queries seem right but the results seem wrong, it’s like there is some broken caching going on? Can you give me DB access so i can run the queries direct on the DB to check?

Thanks,

Stiofan

December 3, 2015 at 5:56 pm #62448

travaggie
Expired Member

Post count: 23

Yes plz privately send me an email address, I have to set you up as a user for our WPEngine account to give you access.

December 3, 2015 at 5:58 pm #62450

Stiofan O’Connor
Site Admin

Post count: 22956

This reply has been marked as private.

December 4, 2015 at 8:22 am #62528

travaggie
Expired Member

Post count: 23

Ok added, it should have sent login info or instructions to that email.

December 5, 2015 at 12:48 pm #62668
Stiofan O’Connor
Site Admin

Post count: 22956
OK the problem seemed to be that some of the is_featured values were blank or NULL when they can only be 0 or 1, this probably happened in an import?

I ran this query on the DB to fix it (for future reference)
```
UPDATE
```
wp_geodir_gd_place_detail
```
SET
```
is_featured
```
='0' WHERE
```
is_featured
```
='' OR
```
is_featured
```
IS NULL
```
I think there was also some caching issues (i cleared from settings) and i think you might want to used descending not ascending for date.

Thanks,

Stiofan
Author

Posts