Blogger and Total Item Count

[ccto]

One of our customer is using the blogger for some (Chinese) real estate advertisment..

She has created around 30 blog categories, for different location, buy pricing, rental pricing, size, etc.

However, in the published site, she found that in some blog category, the Total Item Count is working fine (i.e. at the bottom of the blog page). However, in some categories, it does not work and show 0, and there are no "1 2 3 4 5 ... 11 " page at the bottom-right corner.

In the Site Builder 4.5 editor, the categories count is correct.

I tried to browse the published site sqlite database,
in the table modules_xxxxx_categories, modules_xxxxx_category_post , and modules_xxxxx_post , all 3 tables has the corresponding records.

--

The URL with the working-fine counter
http://www.dpp.com.hk/page14.php?category=3

The URL with the problematic counter
http://www.dpp.com.hk/page14.php?category=17
http://www.dpp.com.hk/page14.php?category=11

Please help.

Thank you very much for your kind attention.
Regards,
George.
Website Solution Limited.
http://www.website-solution.net

 

[ccto]

may I ask for any help?

Thank you for your kind attention.

 

[ccto]

may I ask for any update(s)?

Thank you for your kind attention.

 

[ccto]

may I ask for any update(s)?

Thank you very much for your kind attention.

 

[ccto]

I tried to copy the customer site to another test domain, and then turn on the DEBUG = 1 in config.php , haha.
there is a SQL lite sql log file in data/tmp/sqlite.sql

Then, I tried to visit the test domain, and it will record the sqlite sql in the data/tmp/sqlite.sql

--

If I visit http://www.xxxx.com/page14.php?category=8

It will generate the following SQL -

---------------- Start select -------------------

Open connection to sqlite database

Result: true

Execute time: 2.50339508057E-5



Try execute query...

Result: true

Execute time: 0.0460779666901

SELECT
COUNT(*)

FROM modules_4zdosk1xsu0_post

LEFT JOIN modules_4zdosk1xsu0_category_post ON ( post_id = modules_4zdosk1xsu0_post.id AND modules_4zdosk1xsu0_category_post.storage_state<3)

WHERE
(category_id = '8')

AND (modules_4zdosk1xsu0_post.storage_state<3)



---------------- End select -------------------

It seems everything correct for category=8

=============================================================

Then, if I visit http://www.xxxx.com/page14.php?category=11
(note it is category = 11)

It will generate another SQL -

---------------- Start select -------------------

Open connection to sqlite database

Result: true

Execute time: 2.21729278564E-5



Try execute query...

Result: true

Execute time: 0.0412631034851

SELECT
COUNT(*)

FROM modules_4zdosk1xsu0_post

LEFT JOIN modules_4zdosk1xsu0_category_post ON ( post_id = modules_4zdosk1xsu0_post.id AND modules_4zdosk1xsu0_category_post.storage_state<3)

WHERE
(category_id = '1')

AND (modules_4zdosk1xsu0_post.storage_state<3)



---------------- End select -------------------

Note the category_id SHOULD BE 11, instead of 1
(It seems SB4.5 has trimed incorrectly in the id field.)

Please Please help to fix/patch it.

 

[ccto]

may I ask for any update(s)?

Thank you very much for your kind attention.

 

[ccto]

Same bug re-produced in your demo site -

Ref.: http://sitebuilder4.demo.parallels....c29115b72596d/__preview/page8.php?category=11
(I hope your demo site will not auto-delete it so quickly)

In the demo site, I created the Category1, Category2, Category3, ... , Category11, Category12
and then inserted -
2 posts in Category1
1 posts in Category11

However, if we goto Category 11, at the bottom, it shows "2 items total", where I only have 1 post in Category11.

Please help, reply, and fix it.

Thank you for your kind attention.
Regards,
George

 

[Denis Sirochenko]

Hello George,

Thank you for educing this defect. It is reported to development.

Regards,
Denis.

 

[ccto]

any tentative fix release date? or any simple fix available?