SEBLOD counts are wrong

[kimbare]

Whatever is counting the number of results from a search in SEBLOD is giving the wrong answer. For example, when one enters a search, it says there are 5 items that match that search. Yet, the list only shows 3 items. It another case, it says there are 8 items that match the search criteria, yet only 7 items are displayed. It says there is a total of 1076 total number of items in our system (for which we have SEBLOD forms and it is being saved as it's own item), yet in the database (cck_store_form_nnnnn), yet there are 980 records. So how can there be 1076 total of that item?

This is just one of many issues with SEBLOD since moving to Joomla 4 and Seblod 4.XXX

[kimbare]

This problem STILL EXISTS! Here is a screen shot showing SEBLOD says there are 1168 Index Entries Yet, when one looks in the database, there are only 1082 Index Entry records. See the following screen shot: So where are the other 86 records?
Here is another example of the counts being wrong Here is a screenshot showing SEBLOD stating there are 2 results when clearly there is only 1 We should not have to pay for help from SEBLOD to get the product to work as advertised. When will this be fixed?

[sebastienheraud]

Hello,

Is there any join table on the query? A join table would indeed change the count... and a GROUP BY (manually applied) is required in that case (using the Search Query plug-in). This may be the issue you're facing... and it was already the case in Joomla! 3 / SEBLOD 3. Joining on users? (with multiple relations found)? In that case you cannot compare the query with the one found on PhpMyAdmin.

Without join table the count is expected to be right. Feel free to confirm, but if this is the case it's a specific one. Then yes we may see if there is a way to improve it, but adding it by default may not be the best.

Saba

[Giuse69]

@kimbare pls have a look at this https://github.com/Octopoos/SEBLOD/issues/644: I noticed an issue in Seblod COUNT when using group by and also proposed a possible solution (I am using it) but in 18 months no feedback on this by Octopoos

[kimbare]

There is no join table. There are a number of items called Index Entries. It has the wrong number of them listed. The total number does not match the number in the database. And many queries bring up the wrong count. The counts are wrong EVERYWHERE

---

From: Sebastien Heraud @.> Sent: Wednesday, January 17, 2024 11:47 AM To: Octopoos/SEBLOD @.> Cc: Kim Bare @.>; Author @.> Subject: Re: [Octopoos/SEBLOD] SEBLOD counts are wrong (Issue #787)

Hello,

Is there any join table on the query? A join table would indeed change the count... and a GROUP BY (manually applied) is required in that case (using the Search Query plug-in). This may be the issue you're facing... and it was already the case in Joomla! 3 / SEBLOD 3. Joining on users? (with multiple relations found)? In that case you cannot compare the query with the one found on PhpMyAdmin.

Without join table the count is expected to be right. Feel free to confirm, but if this is the case it's a specific one. Then yes we may see if there is a way to improve it, but adding it by default may not be the best.

Saba

— Reply to this email directly, view it on GitHubhttps://github.com/Octopoos/SEBLOD/issues/787#issuecomment-1896435514, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AFYYOQUNN2IIOCDKRZ45333YPAMEBAVCNFSM6AAAAAA747AKN2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQOJWGQZTKNJRGQ. You are receiving this because you authored the thread.Message ID: @.***>

[kimbare]

There is no join table. I have a list and search type, and in the configuration I said show Items Number: Show.

The numbers for the item we call Index Entries is wrong everywhere. The total number is wrong and many, many queries show the wrong number. For example, we search for one that says school. It says there are 12 results but only 10 display in the list. (there is no limit on the number to display). Another query says the results are 5 but show only 4. Another says the results are 44 and only 40 display. The counts are wrong EVERYWHERE for this object. And the database shows 86 less that the total that shows in the list.

[kimbare]

@kimbare pls have a look at this #644: I noticed an issue in Seblod COUNT when using group by and also proposed a possible solution (I am using it) but in 18 months no feedback on this by Octopoos

Thanks for responding - at least someone finally did! But I haven't used a group by. This is just a regular count as to how many items there are and it's off by up to 86.

[kimbare]

There is no join table. There are a number of items called Index Entries. It has the wrong number of them listed. The total number does not match the number in the database. And many queries bring up the wrong count. The counts are wrong EVERYWHERE

There is no join table. There are a number of items called Index Entries. It has the wrong number of them listed. The total number does not match the number in the database. And many queries bring up the wrong count. The counts are wrong EVERYWHERE

Hello,

Is there any join table on the query? A join table would indeed change the count... and a GROUP BY (manually applied) is required in that case (using the Search Query plug-in). This may be the issue you're facing... and it was already the case in Joomla! 3 / SEBLOD 3. Joining on users? (with multiple relations found)? In that case you cannot compare the query with the one found on PhpMyAdmin.

Without join table the count is expected to be right. Feel free to confirm, but if this is the case it's a specific one. Then yes we may see if there is a way to improve it, but adding it by default may not be the best.

Saba

There is no join table. I have an item called Index Entry. I have a list and search type set up to display the Index Entries. In the configuration for the list and search I set the "Show Items Number" to "Show". The total number does not match the number in the database. And many queries bring up the wrong count. Examples are the results say 5 but only 4 display, the results say 2 and only 1 displays, the results say 44 and only 40 display. The counts are wrong EVERYWHERE for the Index Entries. As shown above, the total number of them for all statuses (unpublished, published, archived, trashed) says 1168. Yet there are only 1082 entries in the database. The counts are wrong EVERYWHERE!!!!! and this is a simple count supplied by SEBLOD for all list and search types.

[sebastienheraud]

Hi @kimbare,

We will let you know our findings by tomorrow, but we may send you an email to get some additional details or access.

Thanks,
Sebastien

[kimbare]

I purchased an hour of consulting and we have a few issues. We don't feel like the count issue should count for that one hour because that should work out of the box

Get Outlook for Androidhttps://aka.ms/AAb9ysg

---

From: Sebastien Heraud @.> Sent: Monday, January 22, 2024 3:04:15 AM To: Octopoos/SEBLOD @.> Cc: Kim Bare @.>; Mention @.> Subject: Re: [Octopoos/SEBLOD] SEBLOD counts are wrong (Issue #787)

Hi @kimbarehttps://github.com/kimbare,

We will let you know our findings by tomorrow, but we may send you an email to get some additional details or access.

Thanks, Sebastien

— Reply to this email directly, view it on GitHubhttps://github.com/Octopoos/SEBLOD/issues/787#issuecomment-1903646915, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AFYYOQTWTWSNA5D5MKNS56LYPY2R7AVCNFSM6AAAAAA747AKN2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMBTGY2DMOJRGU. You are receiving this because you were mentioned.Message ID: @.***>

[sebastienheraud]

I purchased an hour of consulting and we have a few issues. We don't feel like the count issue should count for that one hour because that should work out of the box

Hi @kimbare,

About the count, feel free to share the SQL query (from the debug).

And about the support hour, if you have any other issue in mind (your top priority), please let us know.

Sebastien

[kimbare]

When you say feel free to share the SQL query (from the debug) what do you mean?

When I go to the page the lists all of the Index Entries, it says there are 1176 of them.

Yet, in the database, there are only 1090 Index Entries.

If I turn on debug system, and I go to the management page that lists all of them, it looks exactly the same as before (see photo 1 that was taken with debug on), so I don't know what to share.

If I turn on "inspect" it looks like this:

Is this what you wanted me to share?

In addition to all of the above, when I export all of the instances of the Index Entries, it says there are 1191 Index Entries, EXCEPT that there are MANY DUPLICATES in that list! Here is an example showing the MANY duplicates in the export

When I remove all the duplicates, there are 1095 records. NONE OF THE COUNTS MATCH!!!!!

When will this mess be fixed? My client doesn't trust the website anymore .....

[kimbare]

I discovered that there is yet another place to say debug SEBLOD (I had previously said debug in the joomla settings, not the SEBLOD settings). Here is a screenshot of the page with the SEBLOD debug on

I want to once again emphasize - this is OUT OF THE BOX!!!! It should work, but it does not. There are only 1090 database records for Index Entries, and once I remove the duplicates in the export (and there were a LOT of duplicates) there are 1095 exported items. NONE of the counts match or are correct!!!!

[sebastienlapoux]

Thanks Kim. Please copy and paste here the query.

[sebastienheraud]

Hi @kimbare,

And if you search for cck = kb_index_entry within #__cck_core, do you have 1176 entries?

Thanks,
Sebastien