OS Property support center

Incorrect Category Count in 2.7.1

  • Jim
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
9 years 7 months ago #48891 by Jim
There seems to be a bug in Version 2.7.1 with categories

Example: There is 1 property in the category flooring.
if you goto the property and change the category to something else it still shows as 1 in flooring in the category “list”, but is correct as “0” on the thumbnails. (see attached image).

I have had a look in the database and this is what seems to be happening.

when you change a property to a different category it updates the osrs_property_categories table correctly (which is read by the main thumbnails correctly) see image attached.
but it doesn’t update or write the new category id to the osrs_properties table, which is where the category “list” reads from.

I added a new property and the field Category_id in the osrs_properties table is NULL

This is also happening to the province field in the osrs_properties table and is always NULL

Is there a fix please?
Attachments:

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago #48909 by Mr. Dam
Replied by Mr. Dam on topic Incorrect Category Count in 2.7.1
Hi Jim,
From version 2.7.1, OS Property doesn't use field : category_id in MySQL Table: #__osrs_properties to store Categories of Property anymore. The new MySQL table is #__osrs_property_categories.
To solve your mentioned issue, please click on My downloads at the top. You will see the link to download OS Property 2.7.1 (Updated 3 days ago), please download it and install into your site to solve the issue in "Number properties" count on Categories listing page.
Thanks
Dam

Please Log in or Create an account to join the conversation.

  • Jim
  • Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
9 years 7 months ago #48913 by Jim
Replied by Jim on topic Incorrect Category Count in 2.7.1
The update worked perfectly, thanks for your help Dam.

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago #48914 by Mr. Dam
Replied by Mr. Dam on topic Incorrect Category Count in 2.7.1
You are welcome, Dam :)

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago - 9 years 7 months ago #48947 by Fabio
Replied by Fabio on topic Incorrect Category Count in 2.7.1
I have a problem with the module OS Content Slider, do not display the ads for some categories, but only displays one.
Maybe I understand the problem, reads the categories of the old mysql table

how can I fix it?
Last edit: 9 years 7 months ago by Fabio.

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago #48948 by Fabio

Please Log in or Create an account to join the conversation.

More
9 years 7 months ago #48954 by Mr. Dam
Replied by Mr. Dam on topic Incorrect Category Count in 2.7.1
OK Fabio :)

Please Log in or Create an account to join the conversation.

Moderators: Mr. DamNguyen Phu Quan