Osclass Support Forums

General osclass questions => General discussion => Topic started by: amisco on November 10, 2020, 08:46:17 PM

Title: Listings Disappeared
Post by: amisco on November 10, 2020, 08:46:17 PM

Hi Osclasspoint,

I ran into an error. All listings on Beta theme not showing except one.

When I deactivate Beta and switch to Blender or Sigma, all listings appear.
When I switch back to Beta, only one listing showing.

I deactivated and reactivated plugins one by one, no success.

I tried restoring to previous state and the problem remains.

Kindly advise.

Thank you

Title: Re: Listings Disappeared
Post by: MB Themes on November 10, 2020, 09:01:05 PM

That could be related to t_item_bts table, nmake sure for every listing you have record there.
Copy is made when theme is installed for first time.

Title: Re: Listings Disappeared
Post by: amisco on November 11, 2020, 10:11:11 PM

Quote from: MB Themes on November 10, 2020, 09:01:05 PM

That could be related to t_item_bts table, nmake sure for every listing you have record there.
Copy is made when theme is installed for first time.

I noticed Attributes Osclass Plugin v2.2.0 was the plugin causing this error.

I had to go back to the older version and all listings appeared.

Please have a look at the updated version to fix error.

Title: Re: Listings Disappeared
Post by: MB Themes on November 12, 2020, 10:43:28 AM

@amisco
Attributes plugin does inner join on t_item_attribute table, if filter contains attributes.
You may also try to change in functions.php word INNER to LEFT OUTER (should be twice there), but results should be same.

Title: Re: Listings Disappeared
Post by: amisco on January 13, 2021, 08:12:01 PM

I changed INNER to LEFT OUTER (two instances).

It didn't work. Only one ad now shows in each category.

Please advise.

Title: Re: Listings Disappeared
Post by: MB Themes on January 13, 2021, 08:18:02 PM

Reactivate theme, reinstall plugins, enable db debug, check queries.